View Full Version : Modules & VBA



  1. Export to CSV without rounding
  2. Selecting combobox value with code
  3. Importing .csv
  4. Audit Trail
  5. How to close a currently open Excel file?
  6. ADO connection
  7. SPLIT problem
  8. Easiest question on this forum...
  9. VBA Required to append different rows
  10. Syntax problem with Upsert function
  11. Run Time error 438 - Object doesnt support this property or method
  12. VBA Please HELP!
  13. Dlookup
  14. DoCmd.OpenReport problem
  15. Adding space to text, VBA, Access 07
  16. Changing standard error messages
  17. Default List
  18. Excell Cell referencing problem
  19. auto increment button
  20. Referencing a field in a form from a function
  21. Not sure on best method - advice needed
  22. Network or Internet up/down
  23. Last character of a string
  24. how do i...
  25. hardcore coders only...
  26. Common Dialog Question
  27. listbox selection
  28. delete query using inner join
  29. Syntax for passing parameters to procedure
  30. What is causing this error?
  31. Create ADO recordset w/param stored qry
  32. two functions into one?
  33. DateBucket Function
  34. I need to list the tables.
  35. Question about Variable scope
  36. DSN - Less Connection
  37. Could hex editing a microsoft access db pass as data manipulation ?
  38. Function Calls
  39. Dynamic object variables
  40. Right Function
  41. How to check if a form has a parent form
  42. Convert string to object ??
  43. Text Validation for a form written to two tables
  44. VBA Old Value > New Value
  45. vba - cascading combo boxes in a datasheet
  46. Can we programmatically set the default ribbon?
  47. how to copy 1 item from one table to another table?
  48. Cannot update fields
  49. name of combo box
  50. Display a warning if form field unchanged
  51. Why is 'Type Mismatch' ??
  52. Problem adding ( " ) at the end of the string
  53. calculation within a query?
  54. Updating a subform field (one table only) - Easy? Version: 2000 (9.0)
  55. Windows User Name
  56. MS Access vba Class For Label = 0 to 2 return RecordSet 0 to 2
  57. Use a collection to populate a listbox?
  58. Docmd.TransferSpreadsheet TYPES
  59. fso.deletefile problem
  60. calculating due dates in access
  61. Making the code read-only to the user.
  62. Accesing an Excel button while in MS Access
  63. Tab Indexing
  64. Automatic Requery
  65. lock cell in subform unless cell in form has data in it
  66. Syntax conundrum
  67. function vs private sub
  68. Find the Current Status of a Table / Recordset
  69. Run-time error '3001'
  70. Open a Excell file
  71. Removing Microsoft Office Access Class Objects
  72. Loop through records in a temp table before it loads into the form.
  73. Update record value= old value +1
  74. How to set un-editable column in Listview?
  75. does the check box cause double entry?
  76. Stuck with sql
  77. Suppress MsgBox using a checkbox??
  78. add new records to exported xml file
  79. rs.FindFirst
  80. Subform adds unwanted record
  81. Data Type Conversion Error
  82. SendObject / Automatic Email
  83. insert access data into web form
  84. Change Label Color on Focus or Enter
  85. InActivity Event - Does this exist?
  86. Reference problem? emailing with outlook
  87. How does Update differ from UpdateBatch?
  88. Finding Excel.exe
  89. Change picture on Command button with VBA
  90. compile error sub or function not defined
  91. Ascii
  92. modify a field in the record selected in combo box
  93. Use VBA To Automatically Insert Fields
  94. Send Invoice to Customer in Outlook using VBA
  95. MS Access Glitch?
  96. compile error: Method or data member not found
  97. help! dlookup
  98. compare data in a table and look for changes
  99. A trick for setting a primary key on a linked sql server view in microsoft access
  100. Problem looping through table
  101. Printing VBA Source Code for ACCDB
  102. Urgent help needed with recordset issue
  103. multiple values from a temp table
  104. Sql
  105. Application.Version in Access 2007 run time
  106. Opening select query as Dynaset (Inconsistent Updates)
  107. Using VBA to Append and add in an additional value
  108. Specific date range
  109. VDA and table design
  110. Refer to A Private sub
  111. Funny Listbox side effect when updating Form.RecordSource
  112. RecSet.RecordCount = -1. Why?
  113. Access VBA Duplex Printing
  114. vba emailing report & assigning file name
  115. Import spreadsheet using Filedialog and Listbox
  116. Search PDF for String.....
  117. Access 97 and Vista
  118. Group Date
  119. Set Focus Problems
  120. Remove primary key setting on backend table
  121. 'Select' parameter query help
  122. Where clause errors
  123. VBA Dates to SQL Server
  124. Afterupdate code to run query to populate field
  125. Site Home Page Broken
  126. "Run-time error 2501" is driving me crazy!
  127. Play DVD Titles and Chapters
  128. Auto Correct last names with "MAC"
  129. Update and Append Queries
  130. why is Access space-padding my column?
  131. Notify Tech If Serial Is Missing Numbers
  132. Help Me Please
  133. Trying to combine 2 codes
  134. MS Access TabCtrl
  135. Importing data from Word forms. Error: Field is too small to accept etc.BUT IT ISN'T!
  136. SQL PT QRY - how to select all records/ criteria?
  137. Building a search for user to find record faster
  138. Replacing Me. in a Global Function
  139. code to check if a report exists
  140. Object variable or with variable not set in ADP
  141. drop a DropDown with vba
  142. Assigning a Temp Id
  143. exiting a while wend loop?
  144. moody dlookups
  145. Access 2003 - Select a value in a subform and display it in Main form
  146. DoCmd.TransferSpreadsheet
  147. using global variables as form record source
  148. PLease help...Trying to compile a module
  149. Test for New Record
  150. List of possible values
  151. Events on Navigation Buttons
  152. Time Bomb
  153. Swapping data between records
  154. Opening and saving Excel from Access
  155. import data from excel
  156. vb script for <> access
  157. Concatenate returned query records into single field
  158. Sum of a queryfield in a formfield
  159. VBA Importing Data
  160. Problem with "ww" edits
  161. file I/O
  162. Outputting 2D arrays
  163. Using VBA to save PDF as Text
  164. Execute Append Query?
  165. Update Query Syntax Error
  166. How to change Outlook "From" and Signatures
  167. Query criteria based on returned value not working
  168. Capturing and saving images using WIA
  169. Array to transfer field data from linked table?
  170. To do list in lotus notes
  171. Save Filter as a Query
  172. Retain value from unbound comboboxes
  173. From Subform: Delete record after Requery and Save
  174. Variable entry for Form Filter
  175. Opening External database on Shared drive
  176. Macro to copy and paste field name using button
  177. Code for calculating golf scores
  178. Open Excel File - Not Found Message
  179. 'Run-time error 13: Type mismatch' occurs for CreateObject("Outlook.Application")
  180. Checking Records
  181. Multiple Lookup & format change code
  182. Timestamp validation on Exit
  183. Refreshing a subquery after adding a new item
  184. Convert a string value in a Query to a hyperlink
  185. Update a date field
  186. Export To Excel losing macro's
  187. Right click in windows explorer => folder ?
  188. Pause event untill certain condition is met
  189. unhide Access that is running in the background
  190. Something wrong with MS sample code (VB) Access 2007
  191. An Observation Regarding Microsoft Access Security That Might Interest You
  192. Excel Opens in Read Only
  193. how to jump directly to a recordset row
  194. DataSheet Form Based on Query
  195. import multiple xls files
  196. If then does not compute
  197. User activity
  198. Text field autofill event not working
  199. Dmin with module-variables?
  200. Combo Box and DoCmd.GoToRecord
  201. Task Manager *Applications*
  202. End of project
  203. Getting a List of Forms and Reports
  204. Secretery Trick
  205. Detect a number combination w_specific prefixes
  206. set query parameters with no prompt
  207. Make access open other programmes?
  208. Why isn't this query working???
  209. Folder name & location
  210. Open a FormByFilter Using Command Button
  211. Serious Problem with Data Import
  212. Module doesnt run, or even attempt to
  213. How do I update a list (whose source is another table) on a form
  214. Debugger bugging me!
  215. creating a recurring outlook appointment?
  216. public instead of dim not working
  217. Coding an Excel line chart
  218. DLookup_LastSortedControlNameHere
  219. Rename most controls in all forms in a database
  220. Using VBA to add records
  221. Reading a listbox
  222. ...missing or broken reference to...msado15.dll & msadox.dll
  223. If Then Else problem
  224. Delete a Column in Excel File.
  225. Efficient/Correct Use Of FindLast
  226. Check if Excel file is read-only
  227. Two dimensional array challenge
  228. Decipher please
  229. Checking for value in field
  230. SQL in VBA (syntax)
  231. Exporting Data to Word and Formatting Tables
  232. Code help please
  233. VBA+SQL: Help for beginner
  234. Stumped - DSUM Error
  235. Count records in the recordset
  236. Date/Timestamp Sync
  237. Query must have at least one destination field
  238. MkDir
  239. Change the Type of a Table Column from Autonumber to Number ?
  240. Update Table before going to another table
  241. Unresponsive form
  242. ReDim an array
  243. Memo field limitations
  244. Send info directly to a table
  245. Import text file into Memo field
  246. Merging Records Having Common Field
  247. Code Help Needed - VBA
  248. nubie question using Left() and Right()
  249. Link to website.
  250. calculate business days based on a table