View Full Version : Modules & VBA



  1. Keypress problem
  2. Get last modified date for files.
  3. ADO Dsnless Connection strings
  4. Recordset Problem
  5. Filter question
  6. Setting ControlSource on Report Using Tags
  7. Save and Open form
  8. ODBC opportunity?
  9. Using code in a query
  10. Inexplicable
  11. RecordSet, Find, Easy and Simple??? Help :)
  12. Runtime Error 438 - Urgent please
  13. Selecting data based on a variable
  14. Restore a table index using VBA
  15. Determine a date by a number
  16. pass parameters from Access to SQL
  17. HE:LP with type mismatch error!
  18. Closing connection/database/recordet objects
  19. Can I test to see whether a form is loaded or not?
  20. Where'd they go?
  21. Form to report
  22. Text versus Numbers
  23. Importing Text Files
  24. Capture User/Machine ID
  25. Vba strategy required
  26. MsgBox function, password mask?
  27. store procedure
  28. binding data to a calander control
  29. OnError code not working
  30. Not being able to save a record
  31. Multi-user enviroment
  32. Finding a date
  33. looking into another db for an object
  34. Can any one help with this matching problem!!
  35. Date Format Export Problem
  36. if then code
  37. NOBODY WANTS TO HELP???
  38. Macro Substitution
  39. Bookmarks, when transfering data into word
  40. VBA Coding for calculating an average amount of time using military time.
  41. Emailing Snapshots
  42. How to run VBA program automatically from database
  43. Please clarify – member exists in derived from module
  44. Adjusting Table Column Field Width from VB
  45. Error trapping Null or zero-length Primary Keys
  46. Button with a saved search
  47. removing unused spaces when printing
  48. Using code to validate existing data
  49. SQL and a bit confused
  50. Create Multiple Forms From Single Data Source
  51. Matching event procedures to actions....
  52. Opendatabase
  53. Updating Units In stock after an order is placed on another form
  54. With statement help
  55. Automated adresses with Outlook?
  56. calanders
  57. Class Modules ???
  58. OpenDatabase
  59. Database Utilities: Compact and Repair
  60. Browse
  61. Find another record and get data from it
  62. MsgBox (VBA beginner)
  63. Changing Printers using code...
  64. Saving Form Field Properties
  65. Close Acces Event
  66. Input mask on Input box
  67. Passing a variable
  68. Populate other fields from a combo box
  69. Code to export text without quotes
  70. Call variables from a table
  71. Referencing a control on Page 2 of a Tab Control
  72. Locking a field after data entry
  73. Automating an Email system?
  74. Close form wihout saving data command button
  75. OutputTo path problem.
  76. need help with edit screen
  77. SQL Delete Statement
  78. Parameters
  79. Do While..loop problem
  80. Menu Bars
  81. Problem creating a word document in Access
  82. How to open an database fom code
  83. Sql insert into from external source
  84. Code question
  85. Bit of a Problem...
  86. Weird ghost breakpoint
  87. Select directory when exporting text
  88. help with SourceObject
  89. passing a variable into a sql
  90. Reading a HTML File
  91. changing properties of a closed form
  92. Search a recordset
  93. Once again about splitting BE / FE
  94. Is it possible to rename table field names?
  95. email Invoice
  96. Credit Card Validation
  97. Outlook Object Model
  98. Active X: Date/Time Picker
  99. Close Current Database
  100. Creating controls via code
  101. Click event yields Overflow
  102. MsgBox Size Question
  103. ApplyFilter question
  104. FTP from within Access 97
  105. using seek
  106. Create Table
  107. SendKeys (menu control)
  108. savins access 97 as ASCII
  109. Reorganizing a table
  110. Message Box (vbYesNoCancel)
  111. Updating one field with 90% value of other field one record at a time
  112. Window Prompt for Vaue
  113. Rounding vlaues
  114. Zero-Length Error
  115. String Conversion
  116. Weird Weird behavior
  117. Referencing Record sets
  118. VBA
  119. Saving User Data From App ????
  120. Saving Outlook Attachments
  121. Opening a specifice spreadsheet from Access?
  122. msgbox manipulation
  123. Module problem in MDE
  124. DCount function problem
  125. Error Code Tables
  126. Append Action Query Code not on List
  127. Giving a Constant a Value
  128. Need some ideas
  129. Error Correction in reports
  130. SQL UPDATE very slow via Jet?
  131. How to check that a DAO exists
  132. Check for a - in a string
  133. how to duplicate the function of some of the toolbar buttons
  134. How to do this...
  135. Cancel Form Open Operation
  136. Tick Box Security
  137. Problem calling a function
  138. Error Check Help?
  139. Message Box
  140. Finding a Library Database
  141. Locked by user admin?
  142. Importing a text file into a table
  143. Using a String in an array?
  144. Can VBA Run a Macro?
  145. creating a new record button
  146. Caught in Loop - Cancel Button Not Responding
  147. two combo boxes
  148. Cannot create an OLE Linked field in a recordset using VBA
  149. Open a report based upon a form
  150. Import routine
  151. Sorting Arrays
  152. Finding a dtae field in a table
  153. Union queries in VBA
  154. Opening one table and writing to another
  155. filtering
  156. Advice please
  157. Runtime Error 7794
  158. Print a report to PDF and name it
  159. TreeView Control
  160. Screen Object
  161. Is this a bug or am I cracking up !
  162. problems with vb code
  163. I need to make this run faster...
  164. Formatting a VBA Message Box
  165. Reference a field by its ordinal number
  166. Pop Up Box
  167. Help with memory issues (RAM)
  168. Message Box (help please)
  169. Compile Error
  170. Compact on close
  171. Counting Records in query
  172. Program One Database from Another
  173. How to export table or query to a dbf file ?
  174. Opening a recordset based on an SQL statement
  175. Recordset
  176. Using a select query to find something in a table
  177. Date Validation Code
  178. Concantante Fields
  179. Click on a button must change table value
  180. Equipment Utilization
  181. How to use the ActiveMenuBar Property
  182. Enabling/Disabling List Box Entries
  183. Need help w/ Dmax criteria
  184. Format
  185. PreviousDay
  186. Some advice`
  187. Worked in Access 97 but not in Access 2000
  188. OpenForm
  189. visual basic code
  190. Dim db As Database
  191. Best way to insert scanner image
  192. Having trouble concatenating....
  193. How to clear the Debug Window programatically
  194. Instr
  195. Access window
  196. Access 2000 date madness
  197. Big Trouble in Little Mail Merge
  198. What’s the new record event name?
  199. SQL or VB?
  200. AutoNumber Help
  201. Creating a number of a set size
  202. Insert Into Statement
  203. Extracting Digits from a formatted number field
  204. SubForms Record source
  205. VBA Editor has mind of its own
  206. Challenging Excel Export
  207. SQL7 and Access with ODBC
  208. Data type mismatch problem b/c of dmax criteria
  209. Dcount not working but should
  210. Adjusting Field Properties on a Query using VB
  211. How to make this a module
  212. Programming the Network for a Back End .mdb
  213. Need to only access filtered recordset
  214. Subform problem
  215. Change field color based on field value
  216. Looking for Scheduling Control
  217. Key Press F1
  218. Code errors on 1 machine but not another??
  219. Learning VBA
  220. Modifying Tables NEED QUICK RESPONSE
  221. Need advice on how to accomplish string examination then delete
  222. I need to access the value of a VbYesNo msgbox
  223. Timetable Help!
  224. Defined Function question
  225. Need help accessing a query table from code
  226. Security For Non-Network Situation
  227. Append a header in a text file
  228. Option button code help please
  229. Date Range
  230. Extracting numbers from a field
  231. Automatic Export
  232. Reversing a field
  233. Turning numbers into words
  234. Need help w/code that uses collection objects
  235. Recordsets
  236. Arrays
  237. date problem
  238. Testing to see if device is enabled/disabled using VB
  239. Apply Case Statement to all records
  240. Invalid use of Null (Error 94)
  241. Assigning a value to primary key
  242. Date keyword not displaying system date
  243. Date Reminders
  244. "run time error '48' "
  245. Changes to msgbox, Help!
  246. Tracking Changes In Form
  247. Check if a form is open
  248. How to check if file exists
  249. Help on Action property in VB to specify operation on an OLE object
  250. I cannot assign a value to a control object