View Full Version : Modules & VBA



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