View Full Version : Modules & VBA



  1. Looping Through Records on a Subform
  2. project vba
  3. Data Access Objects not in Access 2000
  4. Running excel macro after exporting data into Excel
  5. How do I store Constant values
  6. CyberCash from Access
  7. Excel pulls in 0 instead of null
  8. how to use a variable to access an object
  9. Delete item from Listbox
  10. Error Number of Duplicate Record Error
  11. Open form and close existing form
  12. multiple sort!!!! Help!!!!
  13. How to make a function return a query?
  14. position in listbox
  15. Selecting a single value from a listbox with multiple items selected
  16. How to Delete
  17. Help
  18. reusing SQL statement
  19. recordsets and data
  20. Code to pause for specific time.
  21. VBA Functions in Class Module
  22. OutputTo Filter Criteria
  23. Still looking for help writing to a table
  24. Calendar Function & ReDim
  25. DoCmd.GoToRecord , , acNext
  26. Code problem where it should be working
  27. On Not In List
  28. Modules or Functions
  29. Stuck in a sort of loop...
  30. Stop Scroll Scrolling
  31. INSERT INTO help
  32. bad with recordsets.....
  33. dynaset problem....
  34. Print to specific printer?
  35. Modify text file
  36. Easy question - public variables?
  37. Converting pre-97 code
  38. Referring to a report control
  39. How to trap the roller in the Mouse
  40. Go to newly added rec on form - ?Find
  41. invisible / visible forms
  42. NT username storage
  43. Password Query
  44. TransferText
  45. Disabling the Keyboard
  46. Loop thru filtered recordset?
  47. 'MSysTables', where are you?
  48. Module Name
  49. calculate difference on every entry
  50. Export Tables Via Code
  51. leap year
  52. method to delete import error tables
  53. Copy Files according to Time Range
  54. Counting records using SQL and writing to a table.
  55. control name???
  56. Find string but 1 character at a time
  57. For the programmers
  58. Create table from code - data refresh
  59. Data Type Mismatch - recordsetclone's bookmark
  60. Clicking button on hidden form with VBA
  61. Run Module Button Function
  62. Call Module From Batch File?
  63. Selecting Listbox Items on Hidden Form
  64. intermittent problem with outlook automation
  65. Disable Warnings Problem
  66. Using recordsets
  67. E-mail Attachment through Notes
  68. Output a recordset
  69. Moving Documents and Reading for Existance of Server Folders
  70. Use an If statement to fill in a field
  71. Vbe6.dll
  72. Updating Table Via VBA Help
  73. ADO Connection
  74. mailing......urgent
  75. Inch marks vs quotesm
  76. problem with this code
  77. Hit the Debugging 'brick wall'
  78. Adding record with an auto-increment field
  79. How do I Autoselect listbox record by value entered in text box.
  80. Mental Block please help
  81. Updating multiple fields from VBA
  82. Hiding txtbox in form
  83. Copy a table
  84. Automation leaves hidden Excel session
  85. filling fields
  86. Insert Object without using the Insert Object Open Dialog Box.
  87. coding problem
  88. loding report text boxes with values from array
  89. One more question
  90. Now less 60 minutes
  91. If all records completed = true
  92. How to find the MAX. Value in 1 record, 12 fields
  93. listbox
  94. Recordset Filter
  95. Security problem
  96. Like command
  97. alert system
  98. How to Open Excel thru VB/VBA please
  99. Help!! User-defined type not defined?
  100. .Index
  101. Compile Error:
  102. Compile Error: Expected: =
  103. GetOpenFilename
  104. OLE server problem
  105. Microsoft Access Help
  106. Does VBA Complete Shell Before Proceding
  107. Math Calculations
  108. recipients.add ?
  109. Excel constants in access automation
  110. Error message
  111. Set import dialog box
  112. openRecordset method problems
  113. wee bit code...
  114. Access Security
  115. Emailing Reports
  116. Help with emailing company logo.
  117. writing to text file
  118. Excel Control Through VBA
  119. Log data entry time
  120. Rollback not working
  121. Follow-up on previous problem-
  122. Excel manipulation in code
  123. Error 3226
  124. Folder Copy
  125. VBA sql statement
  126. Search a string
  127. Checkboxes
  128. Global Variables
  129. Reference label with variable
  130. Importing text files
  131. Convert a string into a mathematical formula!
  132. TransferSpreadsheet Method Curiousity
  133. Best Approach???
  134. MoveFirst not working in code to find duplicate records
  135. File and Path handling in VBA
  136. Why is DCount super slow
  137. Functions
  138. Office Assistant
  139. Reading Lotus Notes Inbox
  140. Temporary dynamic recordsets
  141. Help/Direction Please
  142. crazzzy question
  143. changing colour of one record on continuous form
  144. Displaying a recordset as a normal query
  145. Loop thru fields in Current record
  146. On Condensing Code
  147. Needs help about a function with dates
  148. Use FIND Menu item on subform
  149. Count records in the recordset?
  150. Need a kick-start...
  151. Use Autonumber on insert
  152. Email Preview before send
  153. Calculating the "Bank Holidays" between Dates
  154. Modifying permissions via VBA
  155. Needs help about a function Bank Holiday
  156. timer event question
  157. Global Functions
  158. Translate from SQLView to RunSQL statement?
  159. Object Library Reference Question
  160. differences in functions
  161. declare global variable (with value)
  162. Buttons on a Message Box
  163. Database and OpenRecordSet mismatch in XP
  164. recordset question
  165. add a roww to a listbox
  166. capture time from server
  167. >need assistance on my function
  168. Strings in Code
  169. Code behind option group ... trouble
  170. How to write a function?
  171. Public Functions
  172. exclude holidays and weekends in access
  173. ADO - Query - HELP!!!!!!!!
  174. (NOT) Going to a record by selecting from a List or Combo box
  175. Access 97 and Windows XP
  176. Using the FindLast Command
  177. newbie question
  178. Detect email system
  179. add form controls
  180. Loops to determine if button visible
  181. autonumbering
  182. Global code
  183. Export table with schema.ini
  184. Set Chart RowSource in Report via code
  185. Maths Game
  186. Updating QueryDefs to a table
  187. Emailing details from a form
  188. Delink Backend for Copy?
  189. If a field is true then MsgBox - HELP!
  190. IIF statement need help
  191. Cancel Before Update Event
  192. Insert Into Problem
  193. Compare Value in Control with Value in table
  194. Run A Macro From One Db In Another Db
  195. Combo box - setting selected item - Access 97 vba
  196. Constants in Access 2000 VBA
  197. Function - ExitWindows or LogOffWindows
  198. Incrementing Record Number with Code?!
  199. Determining query owner
  200. Access 97 versus 2002? +
  201. DBGrid Problem Plz Help !
  202. Help With Query Problem
  203. Missing References on Shared dbs
  204. Recovering From Errors
  205. Error Recovery
  206. Write conflict on main/subform
  207. help with code needed
  208. Add-in for advanced, canned reporting
  209. VBA syntax Help
  210. Question about DAO 3.6 reference
  211. Printing PDF files in addition to reports
  212. Duplicate Value from Preious Record?!
  213. How to close a specific App w/ VB Code?
  214. dbOpenDynaSet and "Seek" Method
  215. expression
  216. Form BeforeUpdate not firing
  217. How to send yes/No fields to Word with Automation?
  218. date extaction
  219. Append Query Fails When 2 Users Run At Same Time
  220. Problem Deleting records from VBA code
  221. Object variable or with block variable not set
  222. Making Items Visible on Invisible
  223. SendoBject Code Only Works Once
  224. two joined querys ?
  225. VB Code - Any good books for beginner
  226. Where to start?
  227. Is it Open ?
  228. Allow edits
  229. Generate new records by code?
  230. Scripting.Dictionary
  231. File path Objects...
  232. New record not added to ADO recordset
  233. Accessing a Query
  234. Code to pass data to Adobe
  235. Set Reference to another Access Database
  236. Access VBA - SQL (quick question)
  237. Recordset parameter query
  238. Exporting tables to a password-protected Database through code
  239. Reaching Controls Properties in AllForms Collection?
  240. input/output devices
  241. problem trapping in append query
  242. How to make a 'Paste' Button
  243. SendKeys Syntax Trouble
  244. Check If Tables Exists
  245. Reduce code
  246. DeleteObject A_MODULE in Access 2.0
  247. Password fields & verification in AccessXP (2002)
  248. one of my wee problems again......
  249. Using the For ..Next Loop
  250. Date function not working on 1 form ???