View Full Version : Modules & VBA



  1. Fault 3021 when closing form
  2. Code to Create New Report
  3. tabledef, is this correct
  4. Struggling: A Complicated Question
  5. multi-column list box copy from one to another
  6. Trying to move to a new record. Continuous Form.
  7. Email attachemnts
  8. Multiple filter criteria null problem
  9. FindNext help
  10. Popup that selects record
  11. Error-trapping date control
  12. Creating a "wizard" for importing data
  13. Calling an event from the form
  14. Office.FileDialog :Dose it have an initial Directory ?
  15. How to send excel sheet to users via e-mail
  16. listbox,query...
  17. GisViewerX
  18. Filter function
  19. Three ms-access report in one excel file but in 3 different excel sheets
  20. Get Files To Print (VBA)
  21. Changing the Rank Order of Records
  22. Iterative code needed
  23. simple vba script? open different report depending on input
  24. Demo DB
  25. Zooming in and out of a picture
  26. Screen Updating in Access VBA
  27. Linking, testing links and removing links in VBA
  28. import crosstab excel-file
  29. Code to enable Price Modification
  30. Get list of available paper size
  31. Help With Looping
  32. Find a record
  33. Make a copy of DB and move it
  34. Subform data correct, but not visible
  35. VBA refence to a Field Name in a Table
  36. how can I stop a record being changed after it is changed to a certain value
  37. Hyperlink in Outlook Message
  38. Export to Excel - Error Code 1004 - going slowly mad!
  39. Activex component can't create object - Windows XP
  40. Global Methods
  41. Passing/Returning Function Names
  42. Embed Image in a VBA created email.
  43. fill missing values
  44. ON VB, How to call the result/value of a query
  45. Simple Msgbox problems
  46. New to access and vba, need help with writing a function
  47. access 2003 datagrid or similar
  48. AutoExec but using VBA
  49. sql cascade errors
  50. copy file from server to desktop
  51. connecting to another user's mailbox
  52. Is there a "Random" command?
  53. If there is no record to show
  54. Update query sytax help
  55. Outlook automation
  56. Import SELECTED text file
  57. Filtering on date problem
  58. Refer to user group in VBA
  59. Exact same Code works in Excel VBA but not Access VBA: Why is this?
  60. Reference unbound control in 2nd form thru VBA
  61. Printing of single and multiple records
  62. Toolbar access
  63. access to excel information passing
  64. Help!
  65. change screenresolution
  66. Physician & Patients
  67. Check Email Address
  68. Show/hide button depending on table data
  69. Convet to Short Date format
  70. Change Find Dialog settings to general
  71. help with loop
  72. More Visual FoxPro challenges
  73. Run-time error ‘3061’: Too few parameters.
  74. The timing of when code is run
  75. Adding Records to a Table
  76. Controls collection
  77. What does 'Dirty' refer to?
  78. Event - Next and Previous buttons
  79. What's wrong with my code?
  80. Me.Undo vs. DoCmd.RunCommand acCmdUndo
  81. Multiple Backends
  82. ByVal Argument
  83. Code only works every other time.
  84. running sql from a batch to update an MS Access dB
  85. Getting a filepath W/O Activex
  86. Copy Array
  87. Carry new autonumber from one form to the next
  88. Importing Excell cell numbers (e.g. $A$1) into a new column
  89. Getting Time
  90. Reference recordset field name with VBA
  91. Auto-populating form fields based on the selection in another field
  92. Messagebox Code
  93. Event Action upon keystroke with 2 keys
  94. ADO Library - Add 2.8 version
  95. Date() not found in Access designer
  96. Use listbox to decide order of records (question numbers)
  97. Transfer Text Issues !
  98. Syntax for Batch file workgroup string
  99. Translation of a piece of data during an import (TransferText).
  100. upload text file into access table
  101. Updating a reports record source
  102. Don't want to see query window
  103. Loop through lookup table and assign value
  104. Combo Box Error
  105. Export report to PDF and copy to LAN automatically
  106. Button
  107. A Simple Peice Of Code Wont Work, Please Tell Me Why.
  108. Which Evet Do I Need To Use?
  109. ADO connection string to Access 2007 not working
  110. referencing a field in a sub-form record
  111. How to change a database field description through code
  112. Module /script not working anymore! HELP
  113. Looping through a table's recordsets
  114. Order in which VBA is processed
  115. Playing animated gif
  116. Processing "Enter", adding a new line
  117. Error Handling
  118. Modify stored query using VBA
  119. Help with a report
  120. datediff change colure
  121. Module to remove noisewords
  122. Changing Tab Order behavior
  123. SQL - won't run
  124. Im trying to change a combo box's row source on focus. Dont know why it wont work!
  125. Code for bi-weekly payday periods
  126. PDF and Access
  127. Need VBA in a database - but cant think what for
  128. data from lookup field in vba
  129. timer event
  130. Form Criteria
  131. Secure Queries through running in VB code
  132. Select record by row number
  133. alias to refer to a field in a recordset
  134. Printing a PDF file out using VBA
  135. Field property binair!
  136. help with the following statement
  137. Error Handling: Ignore Access Error
  138. Need to change a box colour if chkbox = true
  139. Does anyone know what this code is about?
  140. Code Review - Looking for constructive feedback
  141. dbFailOnError in nested SQL transactions
  142. SendObject Problem
  143. Transferspreadsheet type mismatch
  144. Object Variable Not Set (I'm missing something)
  145. Help with Error-Trapping
  146. Can anyone tell me why a programmer would put this code in?
  147. Round a Value to Specified Number
  148. Access Project - Get SQL using VBA
  149. Exporting To XLS
  150. ADODB cascading updates problem..
  151. FTP Directory File Listing
  152. Using the Open Statement
  153. Closing a db instance
  154. SelLength in DblClick event not working
  155. Max of three variables
  156. Turning off warnings in ADO connection to Access db
  157. Calling a stored procedure and passing parameter
  158. Changing the default caption YES/NO to another language
  159. Rich's fnValidateForm Function
  160. Unexpected message with Applyfilter method using VBA
  161. How to Build expression in a query with multiple lines.
  162. Combo box filter reset or all option?
  163. Fixed Width Delim File problems
  164. Duplicating a Record
  165. Copy record and update one field
  166. SQL DELETE query problem!
  167. selecting in three values
  168. IF null THEN
  169. sql sub form problem in event
  170. Assigned Event Actions Dynamically
  171. Save As event not firing in Office 2007
  172. Need Advice...
  173. Combo Box After update
  174. Error while creating a chart with SQL
  175. Inserting text in a Word doc
  176. Linking Tables
  177. Importing .XLS files
  178. Query and SQL?
  179. VBA And Error Routines
  180. How to update sequential number?
  181. Procedure too large--help!! VB Novice
  182. Specify relative path for OpenDatabase method?
  183. Access Email
  184. Asigning Files names to imported tables
  185. How to define wheter a table is part of a database via code
  186. simple TransferText acExportFixed problem
  187. Blank Picture Display
  188. Blank Picture Display
  189. Finding a file and displaying its full path
  190. Setting the filter through VBA
  191. Referencing Field Name Including Variable
  192. Copy Field from table 1 to table 2
  193. SQL result into an Array
  194. Trying to name a treeview control!
  195. Case functions
  196. closing all forms with code
  197. Access table to Excel using vba
  198. Saving xls document from Access on Desktop
  199. Simple Vb Code Help
  200. Populating a form by double-clicking a record in a subform...
  201. Open Form by String
  202. Code for Backup
  203. transform SQL to a more readable format
  204. Using BVA to open and filter a report
  205. Changing worksheet in linked table definition
  206. Suggestion please- Scramble characters
  207. Collection Class
  208. VBA Looping with Autofilter!!!
  209. Trouble using a public variable in Form record source
  210. need help to invoke windows explorer in background from excel using VBA
  211. Iterating Variables
  212. UPDATE OF A DATABASE FROM AN EXCEL SPREADSHEET, COMPARING the FIELDS (NO IMPORT)
  213. Regular expressions: how to find several matches?
  214. Possible? Using field description to automate storing date as integer.
  215. Replacing special characters
  216. creating a new table using vba
  217. Apostrophe in field
  218. import one column of many sheets from Excel into link SQL table
  219. how to copy a record to another table
  220. how to open another database using VBA
  221. Access database with data in Chinese
  222. possible to run two query together?
  223. MS Access and Primavera Integration
  224. Control Visibility
  225. access query criteria
  226. Using Animation PHOTO without external Component
  227. A little question: change color of text in msgbox?
  228. Date Format for the VBE
  229. IF then statement help
  230. adding field in table using VBA data format - short date
  231. Linked Tables
  232. Recordset Field Name
  233. Send Keys to a specific application
  234. Import data from Excel to Access
  235. Customized demo counter module from MSDN
  236. Help with query
  237. Combining "and" and "or"
  238. Query with multiple selections from a listbox PROBLEM!!
  239. Create .Txt File With field data on command button event
  240. Select From Outlook Contacts
  241. Requery a sub form
  242. Alter Table Yes/No Formatted Field
  243. Public Function not accessible?
  244. Compare and replace from a table to another
  245. Printing to several files using a Function
  246. How to display Decimal places using VBA
  247. How to change a path in Access/VB?
  248. SQL query to text box
  249. The .execute method problem
  250. comment out multiple lines of code