View Full Version : Modules & VBA



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