View Full Version : Modules & VBA



  1. Query by Form (w/Date & Memo fields)
  2. Access security - VBA password forgotten
  3. expression that has no value error
  4. Loop through controls on form
  5. Ado Vs. Dao Question
  6. lookup date AND time problems
  7. Update data on subform
  8. DoCmd.Close problems
  9. FileSearch Problems
  10. Email multiple recipients from a table
  11. Bitwise Comparisons
  12. MSACCESS.exe Error
  13. Listing Forms In Listbox
  14. Iteration in code rather than queries?
  15. Building SQL Statement
  16. CurrentDb.OpenRecordset Failing
  17. Change Default ODBC timout to 0
  18. export form
  19. Problem with referring to Query in VBA
  20. Access 2000 and Access 2003 inconsistencies
  21. Name of control by double clicking control
  22. Multiselecting
  23. Multi Select List Box into VBA Array
  24. REALLY Simple Question...
  25. select file name
  26. object variable or with block variable not set
  27. Code problem with subforms & tab controls
  28. OpenDatabase Method
  29. Code
  30. Last Record and New Record in recordset
  31. F5 key
  32. Groupwise Automation from VBA
  33. Modify Table Data
  34. DCount problems
  35. Execute series of Queries in VBA
  36. Record already exists
  37. Mousepointer question
  38. Encryption Algoritm
  39. Building SQL from Filter Form
  40. scan picture and store file name automatically
  41. display pie chart, graph
  42. On Mouseover
  43. Populate ListBox or Combobox with list of available fonts
  44. ADO recordset without a connection object
  45. Create Table with ADO
  46. Setting Textbox Control Source
  47. Importing Between Tables
  48. Automatic Field Update
  49. Choosing the location of an outputted rtf file
  50. compile error: undefined variable : msoFileDialogFilePicker
  51. undefined variable: msoFileDialogFilePicker
  52. VB structure and looping through records
  53. Incomplete query clause/ Invalid bracketing of name
  54. Last user
  55. Date Ranges Between
  56. Select Statement
  57. Removing space using VBA
  58. Make a module or procedure report it's name
  59. Simple Delete Command and previous record view
  60. undefined variable: msoFileDialogFilePicker
  61. Finding a papertray
  62. Lookup Table For Logon Form
  63. check file existence
  64. Querydef Trouble
  65. Creating an Index for a table
  66. DLookup Syntax Error
  67. Make Access App display if other App is already displayed
  68. Wait Function
  69. Function with an array argument
  70. Data Validation Problem
  71. Help with command button
  72. The new BrowseForFolder with New Folder
  73. Small help in VB
  74. insert a water mark to Word doc using VB?
  75. Packaging Wizard
  76. What's wrong with my delete code?
  77. Day after date?
  78. Application Icon
  79. Passing value from one form to another
  80. Generate catalog numbers
  81. Automatic Email
  82. Combo box requery
  83. If statement and font color change
  84. Deleting Files using Kill
  85. Network Speed.... Can you test it
  86. subform textbox value
  87. DateAdd Function (continuation)
  88. conditional formatting
  89. Switching RecordsetsClone in multi-sourced form
  90. Calling the Shell command
  91. Splitting the Phone Number...
  92. Refresh image box
  93. password generating
  94. Changing table properties
  95. Treeview - imagelist and right click
  96. Moving data from one table to another
  97. code for 'GetFileOpen()'
  98. Execute 2nd Shell command if 1st is invalid (executing file paths)
  99. 'Expected Variable or Function'
  100. Visual Basic 6
  101. Coding so a report will use the correct addresses
  102. Problem - Duplicate Form and subform record
  103. Having trouble in ADO setting a recordset
  104. Get backend folder path
  105. Need Help; QueeryDef Method?
  106. My attempt with DAO
  107. How do I read DBF files in VB?
  108. Creating query in VBA
  109. sql in vba
  110. Coding Add-ins for Access 97?
  111. run query
  112. Create a billing file.
  113. Referencing a field that ends in #
  114. requery a form
  115. open excel
  116. Help: QueryDef, ADO, or DAO?
  117. parse phone numbers
  118. Moving Information
  119. VB help
  120. How do I go about this?
  121. Disabling the 'X' controlo on forms
  122. Export and assign number
  123. Dynamic Report RecordSource
  124. DLL & OCX link
  125. problems with . in the middle of filenames
  126. My diabolical code crashes my database into a tree at speed.
  127. Default value code using VB
  128. right-click menu
  129. Cancel Properties Dialog on right-click
  130. Compile Error: Object required
  131. question about declaring variables
  132. Creating a toolbar
  133. Pasting to Unbound Control
  134. Changing fonts of toolbars
  135. HTML Formatting for Text Box
  136. Email from query
  137. Cross-linked references. What's up with this?
  138. Looping through properties collection
  139. ADO vs DAO code for Database Properties
  140. default value
  141. Library Problem
  142. Defining controls to be enumerated
  143. Bold text in Vb
  144. opening new databases with button using VBA
  145. Vb Help
  146. Variables?
  147. references
  148. Help with SQL
  149. System information?
  150. Exporting selecting fields to excel
  151. Enabling function dont work
  152. Code to get around Outlooks Automation Security
  153. Help with code - Run time error 429
  154. Access/Word Automation and Option Group
  155. access 97 to a2k vb not working
  156. VB Script help
  157. Problem passing values from FORM to REPORT
  158. Best way to copy data from 1 table to another?
  159. Does not Equal Syntax
  160. Strange problem with DCount
  161. Shift Open Mdb in Code
  162. Adding days to calendar table
  163. Using Ado
  164. Need some simble VBA help
  165. Creating Invoice Number
  166. Using variable in referencing
  167. Ms Access 2000 VBA DAO query problem.
  168. Type mismatch error
  169. Phone Number Validation
  170. docmd.copyobject = runtime error 2501
  171. CreateField name using variable
  172. Active X controls
  173. After Update in Form
  174. Filtering Row Source Data
  175. Reset number back to 1
  176. sending data from pop up to main form
  177. Same folder same path, but ...
  178. Help with module format
  179. number Format
  180. Changing a data type
  181. Adding Data In ComboBox
  182. Syntax error on dynamic query.
  183. Minimized api call
  184. Concatenate Many values in one field
  185. Update table from form
  186. Internet
  187. GroupKeepTogether in code? I need some ideas
  188. Checking Checkbox Problem
  189. Code fix or OLE Automation
  190. Apostrophe in the Excel worksheet name
  191. Reset Field Value
  192. Filter on 2 Boolean feilds
  193. Automate an email send
  194. Selecting certain strings and pruning em'
  195. Listing forms and properties
  196. Menu
  197. Type mismatch
  198. Using a Variable as a field name??
  199. system information
  200. Assign Values to an ADODB parameter
  201. Pass range from form to transferspreadsheet cmd
  202. Is Set <variable-name> = Nothing compulsory to relase resources.
  203. Nearest Day
  204. Custom MsgBox Errors
  205. Names...
  206. Ignoring an empty field on form
  207. "Setfocus" not working
  208. Invalid procedure call or argument
  209. A2000-2002 incompatibility with Recordset property
  210. Recordset Update or Run Query...which is better?
  211. How to call a module from the form
  212. Set ADO recordset equal to subform recordset
  213. Unbound forms + vba
  214. Disable 'Shift Key'
  215. Zip and Mail a DB
  216. change value based on 2 different types of criteria?
  217. Verify network connection
  218. make exe file
  219. same error message for multiple textboxes
  220. Switchboard problem
  221. Table Def in SQL ??
  222. Set Index
  223. dynamic variable names
  224. Problem with NotInList Value
  225. Cannot Find Project or Library - dbOpenDynaset
  226. Currency rounding issues
  227. Excel Automation
  228. Trigger macro with Pivot Chart Field Button
  229. Access to Outlook
  230. Sending A Query Via VBA
  231. Contents of list box into an email
  232. Secure Location:Create Workspace
  233. count of records
  234. Format Excel output from Access
  235. Statements and lables invalid between Select case and first case?
  236. Table exists ??
  237. Capitalisation of Abbreviations
  238. Error numbers and descriptions
  239. VB Recordset Problem
  240. On Got Focus Event Procedure
  241. Execution of this application has stopped....
  242. Can't go to specified record
  243. "Func Not Avail" Error Message
  244. Declaring and using Public Functions
  245. Email Problem
  246. ADO & Readonly MDB/MDE
  247. lost printer settings
  248. Lookup like excel does Vlookup
  249. similar text
  250. Activating Calendar Control closes other form