PDA

View Full Version : Modules & VBA

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