View Full Version : Modules & VBA



  1. Help with FileSystemObject and text files
  2. Regular Expressions
  3. Mail Merge To All Customers Using VBA Code
  4. Extract al values from a field in a table
  5. How to find the MAX value in one table and return the linked table results?
  6. Mousemove on ListView: What Col/Row??
  7. Subform - Select All
  8. Merge many test files?
  9. Moving in a recordset
  10. Error while opening file
  11. Subform Will Not Requery
  12. Access to Word Automation
  13. Access to Word Automation
  14. Invalid Use of Null
  15. Help With Stock Control Loop
  16. Programming a yes/no message box...
  17. ListBox and ComboBox for Report Criteria
  18. Q: Lookup a public variable defined in 1 form from another form
  19. Extrapolating VB to VBA
  20. Access minimises but does not close
  21. good MS ACESS VBA Books or Sites
  22. monitoring & update
  23. Case Upper / Lower
  24. Re-post: Help sending email in RTF
  25. Table Data Type
  26. Updating a field using select statement?
  27. Using VBA to open the Form Wizard
  28. Setting password to design view
  29. OpenReport Method, WHERE condition, and ORDER BY
  30. Using Environ with Dlookup
  31. Compile Access db or project file through VBA
  32. Help With Redemption
  33. Running a Delete Query on Prompt
  34. Writing to PDF Properties
  35. Simultaneous updating
  36. CRAXDRT help
  37. Passwords fields wont empty
  38. Visual Basic problem
  39. Cannot get form to show records added through ADO
  40. Log in Password using forms - Run-time error '2471'!!
  41. how to test if row from one recordset field value appears in another recordset
  42. VB code for backspace
  43. HELP I need to import a spreadsheet into Access
  44. tips on how to make unique key in treeview
  45. Error after a Successful Execution
  46. Application-defined or object-defined error
  47. Directory listing in access
  48. acCmdPaste error
  49. Question regarding VBA code displaying images in tabular form view
  50. Display Resolution - Hertz Problem
  51. Sloooowwwww FileSearch
  52. MemoryReferences
  53. Opening a MDB via VB
  54. Copying Folder and its Sub-directories
  55. Add record in subform using button on main form
  56. HELP with module/macro
  57. Show image after Mouse over
  58. Method or data member not found
  59. Cannot get GHudson's browse example transplanted to my DB
  60. Access Application Icon
  61. Keycodes with a form
  62. Auto saving procedure
  63. Probably a simple query (part II)
  64. Extract LastSavedBy information
  65. VERY SLOW process needs optimization
  66. Modal form doesn't work like I thought.....
  67. Correct Syntax for checking last Visit date and updating Status
  68. Populating Hierarchical SiteName Table
  69. Image on Access indow Backgroud
  70. Bulk Insert from Recordset to Table
  71. Reproducing Clicking a Form Button Via Code
  72. Help. Search form VBA coding issue
  73. runtime error 3501
  74. Chart question
  75. build photo webpage from Access
  76. INSERTING value from excel to access
  77. delete
  78. For Each..Next Loop not working
  79. Simple question: How to find a particular record?
  80. getting a strange error 2108
  81. SQL in VBA SELECT Problems
  82. new rec help
  83. Edit Record function in VBA
  84. Create Reference Number
  85. protect vba code
  86. Creating a unique booking number
  87. Problem with requerying form in one specific case
  88. Check to see if an item from a combobox has been selected
  89. Creating a table based on form criteria
  90. database name changes
  91. Break Lock on Table
  92. A very simple question
  93. Syntax error in append SQL string
  94. Built in functions
  95. OpenDatabase - Not a Valid Password
  96. display result query to a subreport....
  97. Feature challenge for a newby or a pro?
  98. use code to link external mdb table
  99. A lot going on and I'm lost.......DLookUp and Validate field entries
  100. combine runsql with transferspreadsheet
  101. Importing certain info from .csv file and appending it an existing database
  102. escalation process
  103. Simple question - Select/Edit Record with vba
  104. Calculating multiple strings based on Rst entries
  105. Determine Null Fields Tabbed Control
  106. Mismatch type error
  107. if statement not recognising null value
  108. Custom button
  109. insert an ole object in an ole field
  110. error 2115, can i get around it?
  111. Can't open a recordset of a subform
  112. IF statement
  113. Modify Query
  114. Custom Errors
  115. Not on list does not recognise '[' bracket
  116. Path question
  117. Timer event
  118. problem with access
  119. putting result of prompt in MsgBox
  120. open the same database on the computer
  121. Determining if a database connection already exists.
  122. Creation of a automated graph with VBA
  123. Count of incorrect password ??
  124. Converting to ADP with SQL Server
  125. Lost in code and need some help
  126. Placing Data in another Table
  127. Variables ?
  128. Questions about importing text data
  129. Open the invisble query
  130. Help with a Custom Menu Module
  131. Combining 2 dates to make 1 date
  132. To open a MS Access application in the design mode
  133. Display message box when nothing is found
  134. VBA & SQL syntax error...again...
  135. Cannot run parameterized query with a Recordset
  136. If... Then problems
  137. Save XML Page using WebBrowser Document Object
  138. When I add name of a new individual in a, form, it will not display in a second.
  139. Learner - SQL or DLookup?
  140. Learner - SQL or DLookup?
  141. Import Multiple Excel Files
  142. groupwise and vba
  143. E-mail in Access: small problem
  144. Link to Access Table ODBC
  145. Pulling data
  146. pulling data
  147. ListView back color accordance with criteria
  148. Filecopy
  149. Copying related records from one form to another
  150. Automating Backups
  151. Exporting to Excel / Runtime error 2465
  152. Problem with Date / Run-time error
  153. DELETE VBA...One works and the other doesn't
  154. basic advice needed...
  155. Test linked table connectivity?
  156. Filtering Subform
  157. Table with 1 record used as configuration
  158. Disable all menu except Right Click Mouse
  159. Get a number...
  160. Email specific plant
  161. Query Filter Expression
  162. check duplicates
  163. Remove combobox values
  164. Data type mismatch error
  165. How do I update appts in outlook?
  166. Active X error
  167. Application.quit
  168. Novice Question - Sub or Function Not Defined
  169. Need help with the format of a report
  170. Syntax Errors - Apostrophe in field value
  171. how do i create a on the fly query
  172. Using code to Lock only certain fields
  173. Trimming Characters!
  174. A Plug-In for Outlook?
  175. Function problems
  176. Can't send to worksheet(2) from Access
  177. Sub Form Properties
  178. Replace code
  179. Dazed and Confused....Query Criteria with VBA
  180. List Box HELP!!
  181. Assigning a number to a field using vb
  182. Change code from "=" to "Like"
  183. Why do I get an error?
  184. Code to print images on report
  185. AutoNumber Function not incrementing
  186. Inserting blank records by mistake
  187. Module connect to DB and recordset
  188. Exmptions list
  189. Do While Loop
  190. Linking Tables using ADOX
  191. MSCAL.Calendar.7 Wrong Dates
  192. Disable ALL Exits, & Close ability
  193. email with doc directly in body, not as an attachment
  194. Instant Access functionality, based on user groups
  195. Existing functions
  196. Inputmask - Control with two masks
  197. Multiple MsgBox Buttons / Styles
  198. email problem- global
  199. Recording Date using VBA
  200. Open Access instance in outlook
  201. Access to word Mail merge problem: Requested object is not available
  202. validation
  203. Help with logic to fill listbox
  204. arguments in a module
  205. Compact an MDE file through ADO
  206. Select / Where Code Error
  207. error message - 'number of query values and destination fields are not the same?'
  208. Export query to Excel without saving
  209. How do I cycle through folders?
  210. Word Template Q (Automation)
  211. Compile Error
  212. Concatenating values into date
  213. Need to deactivate timer function when access is minimised.
  214. Rounding to nearest half
  215. < date - not working
  216. select case
  217. Check Security Database
  218. CurrentUser - Reverse The Name...
  219. Helppppp (If Statement)
  220. VBA - error 2501 with opening next form
  221. ComboBox FieldNames and ComboBoxValues
  222. Display a message with mouse hover
  223. resultset and combo box
  224. Something is not right with my SQL string
  225. Curious recordset error
  226. ADO recordset to table
  227. No VBA code will work in form
  228. Scheduled task.
  229. Save a record in a popup form?
  230. Checkbox appear at certain values.
  231. Update entire record using VBA
  232. variable for object type
  233. Path
  234. Variable Lifespan
  235. Add filter in the shortcut
  236. Help with Expression [Forms]![Form46]![month]
  237. Item not Found in this Collection error
  238. Query result to listBox
  239. Custom List Box functions - how many rows are too much?
  240. insert query + DAO module
  241. Control Excel (horizontal alignment)
  242. WordApp.PrintOut function not working
  243. Module problem...
  244. Vb Problem
  245. Am/pm
  246. Select a table in Oracle from access ODBC
  247. Job: Fulltime VB/VBA Programmer in NY $$$
  248. get value from combo box
  249. Type Mismatch Error - Please help :(
  250. Making a varible value = to the result of a query