View Full Version : Modules & VBA



  1. Code help please
  2. VBA+SQL: Help for beginner
  3. Stumped - DSUM Error
  4. Count records in the recordset
  5. Date/Timestamp Sync
  6. Query must have at least one destination field
  7. MkDir
  8. Change the Type of a Table Column from Autonumber to Number ?
  9. Update Table before going to another table
  10. Unresponsive form
  11. ReDim an array
  12. Memo field limitations
  13. Send info directly to a table
  14. Import text file into Memo field
  15. Merging Records Having Common Field
  16. Code Help Needed - VBA
  17. nubie question using Left() and Right()
  18. Link to website.
  19. calculate business days based on a table
  20. Variable name in DLookup
  21. How to detect an empty text box with VB?
  22. Emailing PDF Report
  23. Export tables
  24. Sharing CPU time
  25. Link a table in DAO database object in Excel
  26. Update Null Record with Previous Record's Field Value
  27. Have an 3349 error while exporting data
  28. Moving records to tables based on criteria
  29. Creating a record for a related table
  30. MkDir
  31. concatenate form name for rowsource
  32. Diagram Title
  33. Update Subform Record from a Textbox Value
  34. Cycle through all TEXTbox controls
  35. Limit listbox to records not in subform
  36. Save to csv text file
  37. VBA to open/save excel file to hard drive
  38. HOw to add a module to code
  39. Parsing To A Character Type
  40. Trying to use variable as part of field name
  41. DateDiff function
  42. File Object
  43. filtering child record in mother table
  44. Missing something obvious
  45. Programmatically change the caption of a label
  46. Looping through tables in access database
  47. Outlook Warning Setfocus
  48. Referencing a previous record
  49. Simple if statement not evaluating
  50. Chart form error
  51. Date difference - working hours only
  52. does not equal works but equals doesn't.
  53. Do While Loops
  54. Recordset and Workgroup question.
  55. Date parameter for Reports
  56. Public var not works in 2000 not 2003
  57. Removing Duplicate Records.
  58. Runtime error '2465'
  59. Access 2003 - Simple Matching Module
  60. Split a string
  61. Open form from another database
  62. Internet Transfer Control Trouble - DRIVING ME POTTY!
  63. Sending meeting request to Multiple Email Addresses
  64. OutputTo and Date Formats
  65. Is it possible to change a property for all text boxes on a form at once?
  66. Can use an array in an query?
  67. Incomplete Query Clause
  68. Using Returned Results from a SQL Vba Query
  69. Using a form to change a query value
  70. Populate table from multi-dimension array
  71. If / Then code help. Please
  72. Sending email from VB
  73. Null testing
  74. Unwanted Message box when applying filter
  75. How to add a signature to a template
  76. Make Table from variable fields
  77. Can you execute Access VBA from a mainframe?
  78. HELP! passig values from one form to another with VBA
  79. Capitalization of memo field
  80. Module/Macro to copy paste from one field in form to another
  81. Copy OLEBound tiff file from database
  82. By-pass dialog w/print to .pdf
  83. extract data from web site
  84. Creating a string builder
  85. Trouble with null files
  86. VBA Query from a string returns adjacent cells
  87. DoCmd.Quit vs Application.Quit
  88. Run Function Every 2 hours
  89. Checking for Null values.
  90. Google Calendar with Access
  91. Recordset
  92. Keyboard Short Cuts
  93. unbound ADO and 'Object Required'
  94. Access 2003 - Modifying Excel sheets
  95. TransferDatabase - Creating a DB to Transfer info from 1 DB into another
  96. Create DSN with server alias and port number?
  97. export form to Excel help
  98. REPLACE function
  99. Not setting focus
  100. Shell error #5 with Vista 64 bit
  101. Refreshing cmbbox lists
  102. ADO Recordset SQL WHERE clause not working
  103. Delete leading text in text file
  104. Save Database
  105. Save MSaccess report as PDF
  106. Access 2003 - Creating a Word Doc
  107. Chart Object VBA
  108. Button to open Linked Table Manager?
  109. criteria type mismatch on xml append
  110. Specifying Open File location
  111. VB6 or VB.NET with access
  112. Launch associated app
  113. Click Button to Exit Access
  114. filtering help
  115. Need help importing Spreadsheet
  116. Any aussies in this forum?
  117. Escaping Special Characters in Access
  118. Help needed stripping numbers from name fields
  119. Trouble shooting login scrip MS Access 2007
  120. How do I get the code to look at a table for the e-mail addresses?
  121. INSERT INTO query not working
  122. Auto update in other PC
  123. Auto convert to Uppercase letter
  124. how do i create restrictions in textboxes ?
  125. Get values of an internal variable of a function
  126. DLOOKUP with IIF Statements
  127. Exporting Reports To MS Word
  128. Cannot find start up form option
  129. VB Select Statment Help needed.
  130. Syntax Error In Join Operation VBA SQL
  131. Getting Error 13 - Type Mismatch
  132. ShellExecute - Word.doc Read Only
  133. How to Suppress a keystroke in VBA
  134. Problem with export code
  135. Importing Excel Spreadsheet
  136. Column Count in Recordset
  137. date time stamp and email problem.
  138. Textbox curser move in Office 2007
  139. Runtime error 2001, query In Statement
  140. Delete Excel Records from Access
  141. Replacing in text access
  142. Creating a Multi Line message box.
  143. Open folder from form
  144. Create Structure
  145. Refreshlink to multilingual Excell-sheet
  146. VBA Error
  147. Importing Multiple XML Files
  148. enter data in table using VBA
  149. Error 3021: How do I handle this multiple times?
  150. Backing Up a database
  151. Pesky Parameter boxes on SQL Append queries in VBA
  152. Copy a database
  153. Exporting Forms and Reports from One db to another
  154. Hold foregrounud colour
  155. DoCmd.Save? What is being saved?
  156. Operator Between
  157. Opening IE in Microsoft Web Browser Control
  158. Access Statements & VBA
  159. Coding XML import via VBA
  160. Disable Shortcut key
  161. Date Function Doesn't Exist
  162. system time update
  163. Defining DATE variable
  164. SQL on Load
  165. customizing menus
  166. Access 03- SQL 2005 Direct Connection
  167. Hide/disable menu options thru vb code
  168. Attach Picture to automated email
  169. Multiple DLookup vs Recordset
  170. Can 2007 be trusted to run a 2k .mde?
  171. DoCmd.TransferSpreadSheet
  172. Conditionally halt an append query from working
  173. Could someone help me modify this code?
  174. Making a count record function work
  175. OrderDetails Form Failing to get ListPrice from tblProduct
  176. List box AddItem bogs down
  177. sending emails from access
  178. Planning
  179. Error number
  180. Listbox selection
  181. Project Explorer - new project?
  182. Help with query value replacement through Event Procedure
  183. date restriction
  184. disable keyboard shortcut in access using vb code
  185. compile error on docmd.open table
  186. how to add e-mail feature in access 2003
  187. how to add e-mail feature in access 2003
  188. search function and update function
  189. command button
  190. Create relationship between tables
  191. The empty (null) listbox selection
  192. Recordset Find problem. Help much appreciated
  193. VBA Pop-up window
  194. Auto Export Table and extract into Archive Table
  195. DoCmd.DoMenuItem
  196. Date variable
  197. loop dlookup
  198. find and replace across multiple projects?
  199. Refer to multiple fields in VBA
  200. Error: "Unknown Function Name"
  201. Search a string
  202. user level secrity using vb code in an access application
  203. How to set a validation rule using DLookUp?
  204. How to save record from before_update event
  205. Replace / with ~ if date found in string
  206. Open Form and Filter the Subform
  207. Outlook signature - Edit before sending?
  208. Using Sendkeys for a game
  209. unhiding menus
  210. ADODB Connection Execute ...
  211. AutoFill Numbers Till Null
  212. Compact and Repair database with VBA without Closing the Database?
  213. form won't open in datasheet view.
  214. help with dates
  215. Importing huge text files
  216. Excess commas in CSV
  217. Document scanning
  218. Using Drop Down box to populate SQL
  219. Auto Update
  220. How to make a line in a sub run before another
  221. Clearing a drop down list
  222. fCboSearch
  223. Export from Access to Excel Runtime Error 462
  224. bounding
  225. Converting Sub to Function
  226. How do you pull records from a table?
  227. Open Report from SQL Query
  228. Linking to an external XML file over the network.
  229. Calling a Function from VBA Code
  230. use of workspace and openconnection in access 2007
  231. Apostrophe error
  232. Inserting data from SQL query to Access Table
  233. New to the forum, need some recordset help
  234. Insert Into error with ' in strings.
  235. how to notify people that the tabledefs are updateing
  236. Would like my save button to display Record has been saved
  237. Trim but using an expression / identifier ??
  238. DLookup not getting new data
  239. Function for combining several records into 1
  240. input mask and validation
  241. Date Inserted as 30-Dec-1899
  242. VBA Code for Exit Command Button
  243. Code for Default text Value, Help?
  244. Run an Excel Macro from Access
  245. something is wrong with my criteria
  246. combo box lookups in datasheet VBA
  247. Using 1 form to feed another
  248. Query minus Query
  249. Emailin (outlook) query results
  250. ctl array and left() function