View Full Version : Modules & VBA



  1. Customized demo counter module from MSDN
  2. Help with query
  3. Combining "and" and "or"
  4. Query with multiple selections from a listbox PROBLEM!!
  5. Create .Txt File With field data on command button event
  6. Select From Outlook Contacts
  7. Requery a sub form
  8. Alter Table Yes/No Formatted Field
  9. Public Function not accessible?
  10. Compare and replace from a table to another
  11. Printing to several files using a Function
  12. How to display Decimal places using VBA
  13. How to change a path in Access/VB?
  14. SQL query to text box
  15. The .execute method problem
  16. comment out multiple lines of code
  17. dbSeeChanges error
  18. Alter specific records in a continuous form
  19. Control Saved Format Of Merged Documents
  20. Access VBA-Export to Excel file
  21. Close Unwanted Access Application Acc2003
  22. pull all worksheets in a excel file into a table
  23. VBA debug I can't do
  24. Step Into to debug does not work
  25. Open a picture externally
  26. FileDialog problem with SaveAs and filters
  27. Error 3167
  28. Regular expression: I don't find right pattern
  29. simple question:using the output of a function into a sub procedure
  30. Can someone explain this line of code?
  31. Passing a string of 108 characters
  32. Type Mismatch with String for Report Filter
  33. Leave a function connected field blanket
  34. Append to a TXT File Rather than overwrite
  35. Field list coding, search form integration needed
  36. Moving Part Of A Record to The Previous Record
  37. Find Missing Numbers
  38. FileExists
  39. Running macros or VBA on specific time in Access
  40. Read Write
  41. Browsing and Opening Files from Access
  42. Formatting a numerical field
  43. FileCopy to two locations
  44. Using .UpdateBatch to update several records
  45. Importing multiple XML files into Access
  46. Only copy updated or changed files
  47. Invalid use of New keyword error???
  48. Returning several variables from function
  49. Running Excel Replace Function from Access
  50. Take a field from selected record in list box...
  51. File Upload and hyperlinking Help
  52. A code for selecting If any cell = then...
  53. CSV File import question
  54. Help with Script
  55. Delete lines from text file
  56. Passing variables to forms
  57. Selecting Records from a table
  58. How can I loop records from a datasheet and insert into another table?
  59. Corrupting Data from synching.
  60. popup menu (custom toolbar)
  61. Text Function
  62. VBA code problem
  63. Calling Public Function in a form
  64. Disabling a Button
  65. Creating a linked table
  66. File, Get/Put...Erase??
  67. Alternating FixedWidth export
  68. Deleting Relationships in VBA
  69. Replacing Sendkeys (at Last)
  70. Add and delete specific folders in Outlook from Access
  71. Zip/Unzip via VBA
  72. Help with Error in code
  73. Backup access file on startup
  74. Run a sub procedure
  75. Searching and Importing multiple text files
  76. Searching and Importing multiple text files
  77. Formatting text in outlook (Including signature)
  78. option group problem
  79. Annoying Problem with exporting text fields
  80. Length of an array after split?
  81. Access Linked Tables in VBA code
  82. Delete Objects based on a partial name
  83. Help Please (Buttons)
  84. RecordSave Coding
  85. "Like" operator
  86. Search form
  87. Combining ItemData and Column
  88. relationship between 2 forms
  89. mapping with auto route
  90. Can someone tell me if they spot an endless loop in this code:
  91. VB and SQL (List Box)
  92. 2 tables to 1 query - sort in date order
  93. Need help w/ function that opens Excel.
  94. using a cam to create images in a form
  95. vbcr into textbox - issues
  96. FIlter and copy records
  97. Include an Outlook signature in a new MailItem
  98. Compact and Repair Split Database
  99. Can someone explain what this code is doing?
  100. Back end, pictures, and more?
  101. do.cmdRunSQL Question
  102. Move current record to end of table based on text value in field
  103. To make executive file using access
  104. How to 'scrape' a window that pops up
  105. iterating a table
  106. Form Locking
  107. What is wrong with this code?
  108. auto link backend
  109. Filtering Problem with word (bos'n)
  110. How to checked whether the access database table is open by the user with vba?
  111. Problem with CopyFile
  112. FindWindow, GetWindow and Explorer
  113. Collection classes
  114. If isnull..... then.... else
  115. Removing a Carriage Return
  116. Need help with this expression
  117. recordset woes!
  118. using listbox criteria
  119. Data manipulation
  120. Detecting Change
  121. PopUp Property
  122. Inserting Option Button Group Values into SQL server
  123. Performing a spell check on the contents of a userform field
  124. multiple select list box entries to a sub form
  125. problem with MDE
  126. Access 2003 email format
  127. Two Database sets merge
  128. copying a table from DB1 to DB2
  129. open another dbase in access runtime mode
  130. Removing a Character from a table
  131. Importing from a text file
  132. Using .Net or Getting User folder
  133. adding records in vba
  134. color changing box on form.
  135. DAO RecordSet - selecting a specific record
  136. Check boxes
  137. System Tray Icon
  138. Collecting Data Using E-mail options in MS Access 2007
  139. Force field to update
  140. Overlapping Time intervals
  141. Opening and Closing Templates Differently
  142. MS Access SQL Server
  143. Search through an Access table
  144. Run a function without a different argument value
  145. Compacting / Repairing a Wordgrouped DB from another DB
  146. Debug.Print
  147. Cannot Requery a recordset
  148. Text formatting in Lotus Notes
  149. Correct Syntaxt for Data Access Pages
  150. Insert and update
  151. VBA + Comparing Dates+ Font Color
  152. Form References
  153. Search and linking problems
  154. Scheduling an Append Query to Run at Night
  155. Code for Prompt
  156. Shown a table in a form
  157. Access Automation Export to Powerpoint with Snapshot
  158. Event when records are moved on
  159. SQL Query is making me tear what little hair I have left out.
  160. Sendobject does not launch Lotus Notes
  161. Syntax Error - Spare pair of eyes
  162. List Box to a Table
  163. Continue conditionally...
  164. Possible to open form and specify a table to use?
  165. Export to Excel - Error 3061
  166. I want to delete fields
  167. Error-trapping Forms
  168. Field validating and Error-trapping?
  169. Lotus Notes to send email from Access
  170. Blocking display of VBA codes
  171. converting mdb to access project
  172. Calculating Work time by minutes
  173. scroll excel sheet from Access
  174. Suppress Access Error Message
  175. trying to run multiple queries(slightly different)
  176. need to add current time to exported excel file
  177. How to populate fields on a new record
  178. docmd.runsql not working
  179. Access Save to Excel File
  180. Delete record failing?
  181. UNC path problems
  182. Automate different document numberring for different depts?
  183. Copy data from one column to another bases on a specific id
  184. Use DAO for editing data
  185. USING BLOBS in Access
  186. Run Code Scheduler
  187. VBA Code to Sum field values
  188. Forum Project - All users contribute
  189. Start an Application from a Form
  190. subform reference in export function call (moved thread)
  191. After exit text box, the cursor comes at the beginning of text box
  192. Command Object
  193. Importiong an Excell Chart in to Access
  194. Help with VBA Code for Search Form
  195. Printing with Description
  196. Sorting with select distict
  197. Corrupt DB
  198. problem opening a record set on SQL back end
  199. Importing from DBF file not displaying German, French, Italian Characters
  200. Complicated Code?
  201. TransferSpreadsheet method
  202. Updating Master Table
  203. Importing Data from Excel PivottableCache
  204. Irritating beep
  205. DLookup Issues
  206. SendObject...acFormatHTML
  207. Microsoft Chart Object - How to assign the X-Axis to a column of data
  208. Warning when trying to send email using sendObject
  209. Run query on form open then display msg box
  210. Open internet explorer window from VBA..
  211. Text Box Value into a query
  212. Selection and Unselection of Subjects in a better way
  213. Read only records
  214. Strange issue with open form
  215. How do I open an external program from Access
  216. link tables window in code
  217. Problem Closing Visual Basic Help Window
  218. Warning Message in VBA...
  219. Simple Question, I hope!
  220. Basic(I'm guessing) VBA question
  221. IRR Calculations
  222. Code to select second column from Combo box
  223. Stop pop up messages...
  224. Access 2007 Form Button
  225. Converting
  226. Unhiding sheets
  227. Help passing right information to Table
  228. Import from Access/ Export from Excel
  229. MBD Not Availabe
  230. VB Login help
  231. Enabling Multiple Fields on a form
  232. Creating a new record
  233. Access 2007 property sheet not visible and status bar gone
  234. modify a command query with VBA
  235. Err.Number = 3022
  236. Is the a way for a user to abort code?
  237. Syncronising two Form drop downs and displaying the contents in a text box
  238. Checking which combo is choosen
  239. Null value not working
  240. Convert Access 97 database hitting 2GB limit in Access 2003
  241. Tab sequence
  242. Use code to link tables
  243. how to disable fields in a subform
  244. If loop - Pulling records for the same date
  245. listbox recordsets
  246. DAO Recordset - Edit and Update
  247. How to put ODBC data into a table?
  248. date error
  249. Test if control has focus
  250. search form