View Full Version : Modules & VBA



  1. Best way to create 2 separate reports?
  2. Subtracting adjacent rows
  3. import and update excel spreadsheet
  4. Perhaps you guys can point me in the right direction
  5. Convert Qbasic Programme To Vba
  6. How to check that Adobe Application is running
  7. Exporting 100 Tables
  8. Changing Table Definitions
  9. Using VBA to change the datatype of a column
  10. How to place the windows user name into a form field?
  11. Accessing OLE object programatically
  12. Replacing a small batch file with code...Show Dir contents
  13. Help with Record Locking
  14. Get a recordset in a form
  15. How to set running number code?
  16. problems with SQL connection string
  17. Set a value sequentially
  18. Recordset is not updateable - Shared Network Drive
  19. Run-Time Error 5 ... Invalid Procedure Call
  20. Using VBA to Open Form to Specific Record??
  21. automatically run an action query at a specified time
  22. "drop down" help works occasionally
  23. Setting the Ribbon Name, and Show Navigation Pane in VBA
  24. How to use Access VBA for modifying tables
  25. Dlookup with comma in field
  26. losing a field in my QueryDef
  27. strSQL altered by QueryDef
  28. using VBA to write information into an embedded word document in an access field.
  29. Need some help with an if statement
  30. print jpg files from vba
  31. Exporting table data from a form to xml
  32. Word crashes when creating mail merge from Access
  33. Excel code in VBA
  34. Word MailMerge from Access
  35. Update record via event procedure
  36. Compact & Repair in access07
  37. DoCmd Output To doesnt output textbox value
  38. VBA Code Error
  39. Test 2 combos for data
  40. VBA Code explantion
  41. How to have a string longer than 255 chars
  42. Updating table problem
  43. VBA Requery in a subform
  44. Call stored query in VB
  45. you must use the same number of fields when you set the LinkChildsFields...
  46. Go to Last Record Entered
  47. Email PDF from Access 2007 using VBA
  48. excel automation
  49. Autoexpand, autocomplete using code instead of combo box
  50. VB Code to update table
  51. Error 3061 - Too few parameters - expected 1.
  52. Email to multiple recipients
  53. Dlookup with string variable
  54. Help with conditional statement
  55. End of Month Message
  56. Required entry based on cirteria from another field
  57. Record Sets to update a table
  58. Finding a record in one form from another
  59. I need your help
  60. Using DLookup
  61. Expert Advice needed please :):)
  62. Shell() Function
  63. Help with some SUMIF-type work
  64. Error trapping
  65. Invalid use of NULL (?!!)
  66. Invalid use of NULL (?!!)
  67. Null date errors
  68. Code for checking table fields
  69. print query in Access
  70. Can't save changes made to conditional formatting in textbox
  71. Filter preview report code
  72. Filling two combo boxes
  73. open up access using vba
  74. Find Missing Record - Is this possible?
  75. Determining height of text box after data is placed in it
  76. Defining fields using TransferSpreadsheet
  77. Problem with my audit trail utility
  78. MsgBox with options
  79. Retrieving data in certain cells in Excel to MS Access using VBA
  80. Check if table exists in a closed database
  81. Help with VB code with form
  82. [date field] minus constant....
  83. Export to Excel button, hide access windows
  84. opening external database form problem
  85. Opening a Dailog box from VB Code
  86. Access 2007 Report Timer Event
  87. super- and sub- script via VBA?
  88. Is LastUpdated property of TableDef the last update after INSERT only?
  89. [ERROR MSG] File in Use : Filename.xls is locked for editing
  90. Decimal Places in my Date Module
  91. Return of a Function as Scripting.Dictionary Object
  92. Setting CallID to TechID
  93. VBA SQL Autofill Table Records?
  94. Send Enter Press to Web Page using API
  95. Problem with Weekdays function
  96. Public Variable question
  97. Add date to filename
  98. Export MS Access data to MS Excel and insert several blank rows above data
  99. Saving to a folder
  100. Report Extract
  101. Basic String manipulation question
  102. Modify stored query in Access 2007
  103. displaying relationships
  104. Splitting up a string
  105. .recordcount returning odd values...?
  106. Multiple compacting database VBA
  107. Creating a new table from a recordset in vba
  108. How to read amount of users in ldb file
  109. Table Update Help
  110. Modifying a controls LostFocus event at runtime
  111. Query with VBA to get a table from several diferent tables
  112. Minor Error with Code for Attaching Images to Forms
  113. Error Trap Not Working - 'Object Required'
  114. Is it possible to Control an Intranet Page using VBA
  115. Passing variables between two forms
  116. How to attach a report with specific data?
  117. Trouble with File Dialog
  118. DLookup in VB
  119. Combining If Statements
  120. Error on running automation function
  121. nth character
  122. Avoiding Outlook Excessive Security Warnings
  123. How to use current record in VBA
  124. Is it possible to add checkboxes inside a list box?
  125. Code for multiple textboxes
  126. help with link from query to outlook
  127. Charactersand Values on different forms
  128. add row to child table depending on a value...
  129. Get Url address from Internet explorer
  130. How to split recordsets and export
  131. Openquery() error
  132. barcode and dvd searching
  133. Default value via expression
  134. Extracting characters in a string with VBA
  135. Question: Want to color dates
  136. Check each filename in an array to see if file exists
  137. SQL Help
  138. A Function that returns a Recordset
  139. Password accessible in code?
  140. Change the mouse cursor when roll over
  141. execute insert into statement not working
  142. Saving variable after close?
  143. How to include "Like" in a SQL Statement
  144. relative link to .txt & CSV files
  145. Show All Records
  146. onhold-rpt_ImportErrors
  147. Lists/rowsource/primary key
  148. Refresh Jet
  149. Convert Text to Number
  150. Frustrated beyond belief with Time conversion
  151. character counter
  152. Loop Problem
  153. MS Access VBA to format MS Excel export Problem
  154. Help: Problem AFTER Search
  155. Basic Question
  156. Cancel Detail Section depending upon data
  157. Simple VBA Question Here
  158. searching another database
  159. Delayed Visible on VBA code
  160. How to reffer a certain field by VBA code
  161. Checking a TextString's Format
  162. VBA, Message Boxes and Locks Query
  163. How do I detect a blank field ?
  164. Using modules to reset data
  165. ODBC or OLEDB
  166. selecting records
  167. Problem Deleting Records with ADO
  168. Accessing a specific record
  169. scheduled task for access code?
  170. How to handle and/or get rid of ODBC Call Failed?
  171. Suppress message when using DoCmd.OutputTo
  172. find and enter true/false data cell
  173. Appointment Planner Assistance
  174. Ranking Problem
  175. Emailing contents of folder
  176. What's the difference between Val() and CDbl()?
  177. Access to Word then Format
  178. Command Button filter
  179. Access problem
  180. select last item of list box with code...
  181. Invalid use of Null
  182. Automation to Outlook
  183. Email with no Client
  184. Create ID3v2 tags with Access?
  185. Combo Box Code Find Record
  186. Query base off Excel Parameter??
  187. DLOOKUP with multiple date criteria one of which is function
  188. doCmd.TransferSpreadsheet won't compile
  189. VBA ClearContents problem
  190. using this formula to autosave and update
  191. Help with code very much needed. Please
  192. Reffering to one cell in table
  193. Compile Error Expected: end of statement
  194. Directory Creations
  195. exportXML
  196. Get file size for big files
  197. help to disable field editing and then enable
  198. Changing to late binding
  199. Passing a value from a variable to an update query
  200. How to create Excel Graph using Access VBA?
  201. Run Access Query from Excel
  202. Using Wildcard with stDocName
  203. Trying to Call Module and getting compiling error
  204. Creating a Folder in Medium date Format
  205. Global Text Change via VBA?
  206. Query web data source in Access 2002 or 2000
  207. compare val, rem all but 1, save as new table *OR* convert XL vba to Access
  208. applyfilter problem
  209. How to UNDO all changes made a record with subrecords
  210. How to LOOP a function to all forms?
  211. how to do a cumulative count
  212. HELP! Excel changes field properties
  213. Date Variable Time Comparison
  214. Application Name in connection string
  215. ODBC to OLEDB - VFoxPro
  216. Delete records on subform
  217. Help w/Median
  218. TransferText- Importing a CSV file
  219. DoCmd.OpenReport Code Error
  220. Exporting to Word and Remote Server Unavailable Error
  221. Retrieve string from an SQL query within VBA.
  222. How to set startupproperties
  223. SQL Problem Delete Query
  224. xlDown function in Access
  225. Need help locking records
  226. Combo Enable/Disable button
  227. Duplicate Records Adding the new Key
  228. Avoid repeating code
  229. Help Required on Query Building in VBA
  230. DSNless linked tables
  231. Runtime 3061 Error
  232. For Loops
  233. Sheet exists using Ms Access
  234. Cycle through records on a form
  235. Help with Opening Query
  236. Transfer spreadsheet question
  237. what is: CursorLocation Parameter?
  238. Passing a single string for multiple function arguments
  239. Sql Update Syntax Error
  240. Help needed to import a txt file
  241. Winzip encription from Access VBA
  242. In a report -Using a calculated field in Select Case causes error
  243. Db Corruption Problem - CommitTrans
  244. Code to close a db?
  245. code to create a list for combobox from filter
  246. displaying array values in a form list
  247. path not found for dll.
  248. Renumber a List
  249. Install self-signed certificate for all users?
  250. Edit data on table with VBA