View Full Version : Modules & VBA



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