View Full Version : Modules & VBA



  1. Back up database using VBA code
  2. Help with login Code
  3. string == string?
  4. date
  5. Nearly there.
  6. run vba script as admin, logged as regular user
  7. AfterUpdate...I Think...
  8. VBA Access code cleaning tool
  9. Duplication of code problem
  10. all items
  11. help with e-mail
  12. Repeating Field In Subform
  13. How to Update Stock Levels when Ordering
  14. Lookup data in Real Time
  15. Enter ProductID from search form to order form
  16. Get rid of the "Update Messages"
  17. Check for updated Files
  18. Networking Days
  19. WHERE portion of Update statement not working
  20. adding new records to a table through a form
  21. Code to close a form IF it is open
  22. display multiple column using a combo box in vb
  23. 2 after updates
  24. Pivot Table Form - Display Null Values as "0" on Data Axis?
  25. Send html Outlook Email, options for signature, attach, embed image plus many more
  26. Need a field value before VB opens form
  27. user-define type not defined - Dim itemInfo As Info
  28. Formatting Problem
  29. New to VBA
  30. Using VBA to populate dynamic crosstab report
  31. Edit a record in a table.
  32. Code to set multiple check boxes in a query
  33. Code to print a report to a specific Printer
  34. Problem with Notinlist
  35. Breakpoints not working...
  36. Get rid of the MS Excel Object reference
  37. SQL problem
  38. FindFirst issue - "Operation is not supported etc"
  39. Compact backend (with password) using Application.CompactRepair
  40. Search Array to determine if MyName is last array value
  41. VBA Importing to/from Access + change table name
  42. Export Query Problem in Access. Advice Please
  43. Search Populating a list box.
  44. dynamic table name
  45. Change to DSN-less tables
  46. Limit Character length with combo
  47. Between two numbers?
  48. Queries SQL and VBA
  49. Read values from a report
  50. Messages
  51. how to check for a value???
  52. Check boxes to appear with Table Names
  53. Export Wizard cannot export Queries with Criteria?
  54. Programatically Update Table
  55. Need help with graph/chart solution please
  56. Check Email Address for validity in address book
  57. 2007 Data Collection help
  58. On the fly Search Query from Excel querying Access
  59. Subform-Form: Go to next record
  60. Between a listbox and two combo boxes
  61. Data Access Page - data entry on groups - the basics???
  62. VBA Code - Checkbox - Label problem
  63. Advantages of Module vs Macro?
  64. Access 2007 run time problem
  65. weird request (maybe)
  66. FindFirst Error
  67. capture/stop the access "Application" minimise event
  68. Create Check Boxes/Option buttons/Option Group using VBA
  69. Send email by looking up the address in a table
  70. milliseconds to hh:mm:ss
  71. Format text in an automatic email
  72. Next Hireno
  73. how to combine two SQL query's
  74. Help With Login Screen Code! 07'
  75. Sync Database
  76. Filtering a Multiple items form using VB!
  77. Help required : delete / update
  78. recordsource issue
  79. Access Word Automation Book marked Text dissapears when printing
  80. Noob VB question(s)
  81. Access 2007 VBA and Report Print Preview
  82. Access F1 programmatically
  83. For loop
  84. calling a module
  85. Help with select and update module
  86. Help With recordset
  87. Invalid Procedure call or arguement
  88. New Record - Multi Choice Combo Box
  89. Loop through a Table and return the value
  90. Annoying Hourglass problem!
  91. Excel to Access Import.
  92. Please help me
  93. Data Mismatch error
  94. Filtering help! 07'
  95. Error #3219
  96. OutputTo with variable
  97. Required fields on form gives Error 2105..
  98. QueryDefs/Recordsets/Expected parameters......so confused!
  99. Paste image from clipboard
  100. Divide string by a number
  101. Macro/ VBA to print report from updated sub form
  102. Saving a Filter as a Query?
  103. Deleting Worksheet
  104. Need to copy data from Tables
  105. Get last record and display in an Text Box
  106. Email Sending through Access
  107. Add a button with code into Excel
  108. inserting pics from scanner
  109. Need Help with Code
  110. Continue Statement
  111. Subform Requery
  112. Error 3197
  113. Pivot Tables
  114. Using a DLL without registering it
  115. Random Pick, but grab identical records
  116. DBPix help
  117. Help With replace Function
  118. Populating a table from a combobox
  119. another invlaid use of null
  120. object required
  121. hard drive serial number issue
  122. multiple network cards one mac address
  123. Populating a combobox with a textbox
  124. Browse records of subform from main form
  125. Exporting table as DBF
  126. On Click Unselect All items in Listbox
  127. Record Locking Form
  128. Delete
  129. detect "hidden" status of Access Object
  130. Linking button and text field?
  131. Input Mask Error
  132. type mismatch
  133. CurrentProject method for Access '97 ?
  134. displaying VB query in list box inside same form
  135. add new record form,subform
  136. Setting Criteria on a Query using VB
  137. Produce string of random/unique/sorted numbers
  138. How to hide MS Access window
  139. I think I'm getting close? Find next business day by skipping weekend and holidays
  140. Wrong respond from Shell
  141. Bypassing validations if focus shifts to previous control
  142. Export a Table into Word
  143. How to Exit a form with no update and no prompt avoiding the beforeupdate trigger
  144. Increment/Decrement
  145. highlight text after paste
  146. Create Manual Header Line For Exported Csv File
  147. Update Data Loop
  148. Help With Login attempts!
  149. Error Handling
  150. If statement won't run
  151. Reading from .txt file
  152. Building a query in code
  153. Directory Search Error
  154. Run Time error '424' Object required.
  155. Need Readonly query output
  156. data mismatch in criteria expression????
  157. Getting Fieldnames to also Export
  158. Help needed with age restriction code
  159. Using VBA to process web response.xml
  160. opneform action was cancelled
  161. Making my code smaller
  162. How to insert row and sort a datasheet using a vba
  163. which control triggered the MouseMove event?
  164. calling multiple shell command in CMD via VBA in access
  165. error in SqlStr so they tell no Current record
  166. Passing global variable to query
  167. Adding, Subtrating, Replacing
  168. Email Problem
  169. VBA SQL Query
  170. Last nth records in listbox
  171. Importing a delimited text file using VBA
  172. Need help to add a "schoolName" in a form when a user clicks on a list of schoolnames
  173. Report Opens behind Form
  174. Interacting with Word
  175. TransferSpreadSheet Method
  176. Referring to a VB variable in a query
  177. Insert values into a table
  178. Scope of a recordset
  179. Add XML tags to selected text in memo field located in a subform with command button
  180. Open excel Workbook code
  181. Grabbing LonLat from GoogleMaps (Very very Hard) !!!
  182. Transfer Text append file info to field
  183. Creating and linking table in Backend database
  184. Type Mismatch
  185. Edit "TableDef.Connect" vs Delete/Append new TableDef
  186. Error 3061: Too Few Parameters
  187. wild card error "*" in sql script
  188. Join Expression Not Supported. In SQL
  189. VBA problem with audit tables
  190. Get Excel cell reference
  191. Insert File Path
  192. Get Table window in front of form
  193. Issues With Vbnullstring And Vista
  194. VBA code to account for greater/less than>,< signs for my Report.
  195. Sending mail in HTML format
  196. Find specific Primary Key record number?
  197. Module not working
  198. code to overwrite query
  199. Scrollbar Positioning Question
  200. Confusion with module and ldb
  201. log in
  202. Form Variable into a Global
  203. DAO.Recordset
  204. Pass Variable to SQL parameter
  205. Counting the number of fields ticked "Yes"
  206. Compile error
  207. Updating recod
  208. Need to randomly allocate a resource based on a change in week value
  209. VBA code to manipulate grouping on Reports
  210. Avoid Interleaving Transactions
  211. Help on linking two tables vertically and horizontally
  212. Double Clicking subform wont work???
  213. Shell COMMAND.COM + multiple commands
  214. Adding a date
  215. Use a recordset from a table as arguments for a function
  216. Phone input mask
  217. SQL INSERT INTO "Enter Parameter Value" issue
  218. CurrentDB.OpenRecordSet Problem
  219. How to display query count before it's run?
  220. Using array containing Control Source
  221. Copy fields to next record
  222. Processing last record
  223. Enable Macros Requirement Question
  224. Wrong Number of Arguments or invalid property assignment
  225. Print Reports from VBA
  226. How get values from one table to feed a form bound to another table
  227. Calculating the worked time per person
  228. Error When Attempting Edit of Form Code (Random)
  229. Add customer function not working HELP
  230. Call ASP page from ms access
  231. Need help in form calling properties
  232. VBA to set Form properties when the form opens
  233. disguise letters in password
  234. nearest date in two tables -- help
  235. append questions in vba
  236. Update recordset problem and general question
  237. stLinkCriteria problem Access 2000
  238. Sendkeys Ctrl+Alt doesn't work
  239. Running Queries in VBA
  240. Set Printer Options From Access VBA
  241. Open Report & Set Recordsource
  242. Create query through code with 2 or more parameters.
  243. Record Number Function/Old FoxPro User
  244. transfer spreadsheet
  245. Need help in accessing second table data
  246. MySysObjects Table Type
  247. calculating every cell
  248. Add a Hyperlink and Delete Button to Form (Subform)
  249. Problem with SQL statement
  250. replacing data a subsheet