View Full Version : Modules & VBA



  1. Restricted Treeview
  2. Converting month to numeric
  3. Microsoft Access was unable to create an MDE database
  4. merging text lines
  5. Checking for Directory
  6. how to return preceding zeros
  7. update with preceeding zero's
  8. Re-running a field event on refresh?
  9. Opening a mail from Access
  10. Editing text files?
  11. Query Result in a ListBox
  12. Masking Pictures
  13. Newbie >> help
  14. Capture AutoNumber ID after Insert
  15. Trying to edit a field after the record has been selected
  16. Pretty simple...but I must be missing something
  17. Returning properties with 'FileSearch'
  18. Selecting An Item In A Combobox
  19. DefaultValue
  20. FileSearch takes a long time
  21. Setting up DAO
  22. Scheduling Tasks
  23. String function
  24. Exporting only new records (since last export)
  25. Problems passing values to a form.
  26. Editting borders in Excel through Access
  27. Sending an Access module into Excel using VBA
  28. Getting data from SQL Server Tables from Access
  29. Error 3061 HELP!
  30. Data range Question - Very easy
  31. Determining number of records in a subform
  32. Save variable from Dlookup to field?
  33. multiple listbox, selected items in array
  34. Checking controls on a form...
  35. Getting Data From Query
  36. passed value is wrong number!
  37. Optional Keyword
  38. dcount
  39. Urgent Code Help Needed!!! PLEASE HELP
  40. .ini files
  41. Difficult One
  42. Quick formatting to Excel question...
  43. Database distribution
  44. Export to Excel without opening File
  45. Invalid operaton while appending field property
  46. Changing the Description of a DAO
  47. TextBox problem
  48. Option Group Item Selected Based On Last Table Entry
  49. Old code = old date
  50. RECORD SOURCE (vinyl flavor)
  51. List box problem
  52. Mail Merge....code runs faster than computer?
  53. Word mail merge and attach to email
  54. Query Result in Variable
  55. Word Macro - Running one from Access?
  56. SQL code: UDATE..SET date values?
  57. Using Recordset on email
  58. Export table to Excel
  59. Do...Loop
  60. What's the problem?
  61. If Not IsLoaded?
  62. [Where Is My Cursor] Function
  63. Convolutions upon Convolutions
  64. Compile Error - Expected Expression
  65. Arrays Access 2000
  66. Importing web orders??
  67. Form_Timer Code
  68. Find Previous month
  69. simple command button code please
  70. Outlook Automation
  71. Solution: Spellcheck a single text box
  72. How to return a TableFieldValue as a Variable???
  73. Email
  74. 97 to 2000
  75. Sql Insert
  76. Null Problem....
  77. Can I call a sound file?
  78. SQL help
  79. NT & Me...
  80. Label Wizard
  81. File Dialog causes crash
  82. number problem
  83. multi-select search
  84. Record is deleted corruption problem
  85. Opening Excel file from Access
  86. lookup combo box not working
  87. HOW DO I?: Arrays - Assigning
  88. Lotus Domino Object Help
  89. New Record
  90. make filter off multiple entries
  91. NextRecordBtn setFocus
  92. "Object Required" error
  93. Send Object Report ???
  94. MsgBox bold font
  95. List Box Rowsource
  96. Has anyone else had this problem
  97. auto updating form values based on another table
  98. Group by in a Query
  99. Too Few Parameters
  100. Subform redraw problem
  101. Can't find matching fields
  102. adding days to a date
  103. Calling SubProcedure
  104. SendObject message text length
  105. Sending Confirmation emails
  106. debugging code
  107. VB Code using ADO (type Database)
  108. Last edited by userid / WNetGetUser function
  109. event procedure problems
  110. SetWarnings with OpenQuery or RunSQL command
  111. E-mailing Query Results
  112. Navigation Buttons Don't Work After Win2k/.net Upgrade
  113. If/Else or Loop Statement???
  114. How to edit a text file from vba
  115. Relating fields in a form
  116. Adding a Month
  117. Code for Report
  118. Edit a Table by VBA
  119. 'Expression too complex' message?
  120. Ok, Access Wizards!!!!
  121. Change a field name via code
  122. Alpha Paging
  123. Two dimensional array
  124. Search Field for my listbox
  125. DatePart() invalid argument???
  126. DSUM HEEEEELP!!!!Please!!!!
  127. Query descriptions created in code
  128. rowsource is missing?
  129. Renaming attachment & ignored signature
  130. Linking dialog box entries to actual data
  131. Exitting a Command Button's Sub Routine
  132. Before Update help
  133. Updating Data Between Form Controls
  134. Striping (mdb) Attachments Outlook!!
  135. need some guidence
  136. VB Coding Help Needed
  137. DoCmd.RunSQL
  138. Any one spot the mistake?
  139. Combo box - not in the list event
  140. Record locking problem using ADO
  141. Evaluating empty recordset
  142. OpenRecordset
  143. Transferring records from ACCESS to SQLSVR using ADO
  144. RecordSet.FindFirst Syntax problem
  145. TIP: Storing Images in Access
  146. OLE automation
  147. Deleting TempFiles/Cookies/History
  148. Maximizing Word - Compile Error
  149. Error 2001 operation cancelled by user
  150. Modules and Memory
  151. Need a proof read!!
  152. PDF Filename
  153. Ability to add something not in list on combo box for a DAP
  154. ListIndex manipulation
  155. Reference an object in a word document from Access
  156. Not saving to my table???
  157. RecordCount not working properly
  158. data conversion: string to number
  159. TransferSpreadsheet with Named Range
  160. If Query is empty
  161. Closing Excel files from VB
  162. VB Code for Excel and Access
  163. Sending info from a list to a report- Please help
  164. OutputTo eats up ALL my MEMORY
  165. Need help with creating files from templates
  166. Report Is Null, want Zero instead
  167. code for cutting strings
  168. NoData code
  169. well, it is because the number is like...
  170. Type mismatch
  171. Not saving to table using addNew
  172. How to Pass Variable to Query
  173. Opening Excel from Access
  174. OutputTo problem
  175. Vba Query --> Form?
  176. Processing HTML files
  177. Deleting Tables
  178. Open a secure database from command line
  179. Im having syntax problems!
  180. grouping
  181. Trouble with Code...can anyone help, please???
  182. Navigating Switchboard from VBA
  183. Need help with code for checkbox
  184. How can I get "Full Computer Name"
  185. Update foxpro tables
  186. Code to Update Combo Box Contents
  187. Multiple Send To's in Lotus Notes
  188. Display # of records added
  189. "Not a valid Bookmark" problem
  190. Updating the Database
  191. tabledef becomes invalid
  192. control references from array
  193. Subscript out of range??
  194. update yes/no
  195. pulling dates between dates
  196. Open a form from vba and wait for input
  197. I am posting again, no one seems to be able to help
  198. Checking an Oracle Password
  199. Relinking tables through code
  200. Working with an ini file
  201. Help saving a value after update using VBA
  202. Help saving Value with VBA in a query or form
  203. Copy Whole Database
  204. 2nd Word doc bookmarks won't set
  205. two dimensional array
  206. Sending mail via Lotus Notes R5 using VBA
  207. Finding Workgroup through code
  208. Set visible report property for SendObject module
  209. Help with code
  210. I need to identify current record to use in the VBA code
  211. Security issue
  212. I need to secure type of entry on forms
  213. Locking a subform using vb
  214. More than 20 options in a group
  215. MsgBox
  216. NotInList event
  217. Wrong tableSource value
  218. Append data to a table from an onclick property in a form
  219. SendObject Method: This is an easy question
  220. printing word form letter thru access
  221. Printer Setup Using Code
  222. sql query with parameters in a function
  223. check if query returns empty.
  224. Printing a string from VBA
  225. Procedure data type
  226. Can anyone help me how to do this in Access VBA
  227. Access Cookbook (Getz, Litwin & Baron) - Natigation Buttons
  228. Qbf
  229. Help with importing code
  230. SendKeys and Dos
  231. Editing records in code- Now this is a problem worth solving ;)
  232. Error handler
  233. Image linking problem
  234. Minor glitch with email
  235. Help - really stuck - still!!
  236. Code vs Query
  237. Automating a query
  238. Editing Menu Items
  239. automate printing multiple forms
  240. creating a matchcode
  241. help with functions plz
  242. Got to hyperlink
  243. Open a form with a filter (taken from a variable on a replicationID field)
  244. Delete Stantements in VBA
  245. Line Objects
  246. docmd sendobject email
  247. Case Select statement not working
  248. two subforms, that i only want visible after record on main form is saved...
  249. Using VB to parse a text file
  250. Select Case Question