View Full Version : Modules & VBA



  1. Any advice?
  2. Check for file
  3. string as file name/path in macro
  4. Application Defined or Object Defined Err
  5. Run-Time error 13 Type Mismatch
  6. Print from button
  7. Drag over-sized form
  8. Anitmation code?
  9. Number conversion to time
  10. Email problem
  11. VB order
  12. Help with CopyFromRecordset
  13. "Cannot define a public user defined type within an object module"
  14. MemberShip Database
  15. Email difficulty
  16. Word Automation - type mismatch
  17. Declare References in Code
  18. How to determine which reference to activate
  19. Write Conflict in recordset
  20. Class modules - Ambiguous Name Error
  21. Select related tables
  22. Number to time conversion over 24hrs
  23. rst.FindFirst
  24. Format function
  25. Bold Text in MsgBox
  26. Resetting A Variable
  27. len function always returns 2
  28. Testing Null value?
  29. Delete Row
  30. Switch Databases
  31. combo box (using a selection to search a database)
  32. SetFocus syntax
  33. On Error GoTo ...
  34. Unable to recognise a 'Cancel' request
  35. Moving chosen strings to another field
  36. Compile Error
  37. Window Maximized
  38. Importing from multiple Excel spreadsheets
  39. Coloured label used as Command Button glitch
  40. Error 3011
  41. Print TreeView/Control
  42. Automated Email Trouble
  43. What am I missing??
  44. SetUp Maximum Length
  45. Retrieve Outlook Data into Access 97
  46. Extract 6 digit text string only?
  47. Disappearing Form Module?
  48. autoincrement field with added numbers
  49. Adding One Month to Date
  50. Problem with adLockBatchOptimistic
  51. Sending an EMail
  52. scheduled events
  53. How do I limit file types in FileOpen?
  54. do loop with outputto rtf
  55. Getting User Name Using WScript
  56. Advancing to the top
  57. Error in From Clause
  58. Changing subform's currentview
  59. Test for last record on form
  60. [FAQ] Referring to objects in Access: ! and . and (
  61. Record Selector equivalent in code?
  62. Dates
  63. Adding a field to a table
  64. Class reference
  65. VBA Code
  66. Microsft is unable to create .mde
  67. dcount in subforms
  68. Database Update
  69. More help with visibile
  70. Recordsaffected property problem
  71. problems with docmd.openreport
  72. Export to excel problem
  73. Data via ADO to Sqlserver
  74. Display Query Row Number on Form?
  75. weekday
  76. Combo box fails after control source is changed in VBA
  77. requery when txt box is populated by calender form
  78. Tree View
  79. Waiting for keyboard action
  80. Date Format Stuffing up a Function
  81. Calendar Control ADO Problem
  82. Importing columns from an excel-sheet
  83. Calculating Times (Days)
  84. Change one field's value during record duplication
  85. combo box value in the beforeinsert event
  86. Simple If...Then question
  87. Exporting a Spreadsheet
  88. Modify Linked Table?
  89. Need help to speed up my text import
  90. forms vs reports
  91. Message Box Font Size
  92. BeginTrans Rollback CommitTrans withing Access
  93. The % Sign
  94. Using Row Count in Range Selection
  95. User-defined date default
  96. Ole Links + File Browser
  97. Reloading a subform
  98. Removing a - from £-0.40 figure
  99. SQL Help
  100. Insert statement in VBA
  101. Help with missing object in my Multi-Select Code.
  102. SQL Server tables linked into Access - advice
  103. Counting Check boxes
  104. set focus not working
  105. Did You Have Any Luck With This One
  106. Requery Blues
  107. Export selected records instead of printing them?
  108. Dynamic QueryDef for ADP file
  109. Linking Access to Exchange Address Book?
  110. Variable length Records
  111. AccessXP, WindowsXP references Error
  112. Sample
  113. I think my head IsNull
  114. Creating a Form From Within A Form
  115. Exit Loop
  116. different button calling same form
  117. Mathematical dunce?
  118. Record Set Error?
  119. limiting depth of recursive function
  120. Emulate tables and queries using VBA modules
  121. Updating records
  122. Word Templates and Saving as Documents
  123. Update VBA/SQL Statement
  124. Automating Outlook
  125. subform problem...
  126. Excel file created with DoCmd.OutputTo
  127. How to move old record to another table
  128. Passwords
  129. Object Doesn't Support this Property or Method
  130. check boxes for each record in Continuous Forms
  131. Week number
  132. Changing Field Controls on a Form
  133. Simple DAP Syntax Question
  134. Deleting Tables
  135. cangrow box
  136. Tidy up transfer spreadsheet code
  137. email problems
  138. blinking issue
  139. Shut off Menu bar
  140. Changing a Form's Record Source..
  141. limiting query results using VBA
  142. Debugger does not work
  143. Updating BE With A New Table Added
  144. Trouble updating linked Excel chart (unbound object in form)
  145. MS Graph 2000 Chart Axis Scale
  146. Printing Merged MSWord Doc
  147. simple calculation
  148. automate password protection of excel
  149. Prevent Deletion of Records
  150. condition for visible or not
  151. How to open one program or the other
  152. move tables to other db
  153. Clearing Form
  154. Tricky date calculation
  155. dynamic SQL using current RecordSource
  156. Outlook AUtomated email with the "Program sending email on your behlaf " warning
  157. Changing Field Name
  158. Code Stopped working?
  159. Run SQL?
  160. Array Issues!
  161. listindex
  162. command button to open filter by form
  163. export forms to other databases
  164. Activate Command Buttons When Filter By Form
  165. Send Variable Data back to a Table
  166. Add Attachment to E-mail
  167. Don't Save unless "OK"
  168. Auto import & extract ID from filename
  169. 3011 - run time error
  170. Excel Problem
  171. Using Arrays
  172. Naming Convention Please Help
  173. Skip Form_Before_Update
  174. On Exit Event
  175. Suppressing PgUp/PgDn keys
  176. Nz(DCount...)
  177. Help with text string match
  178. Using Yes/No fields to get a number count?
  179. Emailing without email program opening
  180. My report generate 66 same pages
  181. Check Please (my code I mean)
  182. Read a Database Using DAO - Type Mismatch Error
  183. case sensitive
  184. Public functions within a form module
  185. Trouble getting vba to work in Windows XP
  186. Synchronization Code Needed
  187. Problem with superfluous decimals during export to .txt
  188. How to check if synchronization is needed
  189. open file with application
  190. SpellChecker
  191. Call Form_BeforeUpdate ??
  192. Looping DAO Recordset
  193. Creating table based on a query
  194. Looping through a recordset
  195. Need suggestions for practice material
  196. Checkboxes - automated looping?
  197. selecting fields from query
  198. Odd page up \ down problem
  199. Creating an Autonumber field programmatically
  200. Compact and Repair - Reset Autonumber field
  201. NotInList code in Access 97
  202. Parsing Comma Delimited Lists
  203. CurrentUser's password
  204. DLookup
  205. Docmd.OpenForm Condition Problem
  206. DoCmd.OpenForm ?????
  207. FileSystemObject Property to determine if file is currently in use?
  208. References
  209. Email a report in the body
  210. How can I improve/speed this code?
  211. passing null value
  212. Hiding Menu Bar
  213. Select Case
  214. Miscounting a Recordset
  215. Re- Set Focus After Calendar Form Call
  216. Code Error
  217. sendkey through VBA to field in a form
  218. SQL syntax issues for VBA
  219. Date Formatting Issue
  220. replace text in a string with a command button
  221. Make Table Code Not Working
  222. Hide "Debug" Option
  223. date advice needed
  224. Updating tables without using an update query
  225. Call to modules in front / back ends
  226. Gantt Charts for Access 2002
  227. dBASE to Access
  228. Customised Help Feature
  229. MAPISession causing Access to crash
  230. Excel VBA conversion to Access code
  231. Summing Check Boxes Pt 2
  232. DoCmd.RunSQL INSERT INTO Syntax
  233. syncronising records
  234. What trigger to hang code off on close database
  235. Probably a simple answer
  236. Postcode data
  237. Compile Error Expected: List Seperator or )
  238. Update [] Set Help
  239. Date format in SQL Statement
  240. Best method to catch blank fields
  241. Trying to append with a calculated number.
  242. Error Launching DTS Package
  243. DoCmd.RunCommand acCmdRedo Failure
  244. Label Captions
  245. AfterUpdate to change value in table
  246. Do I need to do this in code
  247. Multiple Where conditions in openform
  248. SQL, ADO and Order
  249. Project is Locked
  250. Set Start Value for Order Number