View Full Version : Modules & VBA



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