View Full Version : Modules & VBA



  1. Sql
  2. Refer to another form's controls
  3. Create a Word doc & Make Current- easy peasy
  4. Correct syntax for a date field
  5. Another SQL
  6. Delete records if...
  7. Test if array contains any elements?
  8. trip bookings database - modify to route through a hub
  9. User Access Level
  10. Really new newbe
  11. another user access Question
  12. locked field msg box please help
  13. TableDef connection - Appending & Removing
  14. Change foreground color in 20 reports at once...
  15. SQL code not doing what is expected
  16. Extract Year from Serial Number
  17. Could not update: currently locked by another session on this machine
  18. Hyperlink
  19. Search List
  20. Record set parameter query problem
  21. Insert statement
  22. Update Query
  23. Quite simple question
  24. Obtaining Address From ActiveX Control
  25. Run code every 5 minutes
  26. text import 1st record missing
  27. Invalid or unqualified reference error with an IF statement
  28. Reverse of BackUp and zip to A drive
  29. Recordset Problem
  30. Releasing VBA Application
  31. what if not found when Finding a record
  32. Splitting first and last name from one name field
  33. E-mail reference the "Microsoft Outlook xx.x Object Library"
  34. If-Then-Else question
  35. Update Project Name Programmatically
  36. Returning Values from a Sub/Function
  37. Access-Word mailmerge recordquery
  38. Help with params and variants??
  39. E-Mail and Recordsets??
  40. Check my code please
  41. DCount and Parameters
  42. DCount + SQL
  43. Problem pausing execution
  44. Automatic emails choke
  45. Sql
  46. Get value from a single row listbox.
  47. Dates
  48. Reference a variable from a variable
  49. The Cancel Button
  50. Cant Get Previous Working
  51. another convert question
  52. Prompting user to locate a db and then import a table
  53. Search term in field on form & return record.
  54. works on one but not another
  55. Adding numeric values to a TreeViewControl?
  56. Custom Class Modules
  57. VBA help please
  58. Wildcards
  59. Suddenly class is not registered?!??
  60. Click event has priority over exit event
  61. Spell Check VIA Code
  62. Run-time error 424
  63. Command line problem
  64. change subform from Form View to Datasheet view
  65. DCount
  66. On Record Change Property?
  67. Creating an Add-In for Access?
  68. create database
  69. a97 VS AXP .... Me.Repaint
  70. Lotus Notes Email (I know... not again!)
  71. AXP & Locking
  72. If statement problem
  73. TreeView parent syntax
  74. Problem with Where condition for DOcmd.OpenReport
  75. Trouble with SQL Update Query using AutoNumber field
  76. Insert new record and loop
  77. Automatically close the Find Record form
  78. Errors compiling Access 97 modules
  79. OnLostFocus: Close
  80. update
  81. Excel expression "sumproduct" in Access
  82. Email txt file
  83. Rowsource on subform combo not working
  84. Trouble passing value across forms - syntax?
  85. Fetch Files from internet
  86. Remove Leading Comma
  87. String Case Function
  88. Read Large txt files
  89. Option button groups not holding default
  90. docmd.transfertext to Excel error
  91. New Record: Save Now Please
  92. User name on all forms
  93. How to search a record with two criteria
  94. goto new record in subform (Datasheet View)
  95. Problem with no entry
  96. Next/Previous Record buttons DAO/ADO problems
  97. Inserting Unicode
  98. On open problem
  99. Set Projects connection in Code
  100. Select Sql Date Problem
  101. Open specific hard drive folder
  102. Resolving shortcuts
  103. Need to delete all records in the recordset
  104. Find Record and Populate rest of fields. Please tell me how?
  105. Create Relationship *Without* enforcing RI
  106. Consistent write conflicts
  107. Assigning values with VBA
  108. Passing variables from form to module
  109. Why do we need XP? Import .dat file
  110. attachment name
  111. Copy Items from Listbox into Text Fields
  112. Dmax??
  113. Formating time/date
  114. DAO to ADO question about "Find" and "Move"
  115. Transfer Data from one database to another...
  116. VBA method for saving records
  117. docmd.runcommand.accmdSaveRecord
  118. Auto Open a Form at start up
  119. How to get Listbox information on select
  120. Time How Long A Record is the current record.
  121. Scrambling of records
  122. Not Advancing to the next record
  123. Multi select list box
  124. VB help with sql statement
  125. Current Form Name
  126. Save save txtbox to table
  127. Backing Up
  128. Public Sub
  129. And Statement
  130. How do I do this?
  131. Change DB password using code ??
  132. Updating Text box with results from Combo Box
  133. Adding Empty Textbox to table
  134. Return 0 or 1 in SP if any data exists
  135. VBA332.dll Error
  136. transferdatabase produces ms-problem
  137. How to build a number?
  138. Reading parameters and sent to debug venster
  139. Importing Alternative files
  140. Datasheet form to resize with master form
  141. Autonumber Woes
  142. Calculating a value in a subdatasheet without needing to click on plus sign
  143. Progress Bar
  144. Code to show data in txt boxes
  145. Error handling within error handler.
  146. Simple VB if/else structure to quit application?
  147. Hyperlink text box
  148. Deleting Directories
  149. Tricks on Error Handling
  150. Include TransferText within Transaction?
  151. Help finalizing code for search/update functions
  152. Running Word macros
  153. Problem with divide by zero in linked table?
  154. Rectangle
  155. Meshing VB with Access
  156. Simulate VLOOKUP in Access
  157. copying recordsets
  158. Date Format Troubles
  159. Hiding a form on startup
  160. Append key violation generates no error.
  161. Generate the SQL Code
  162. Another Regional Options/Settings 'problem'
  163. Searching thru 400,000 records
  164. code for no match in Subform based query
  165. Date Reference
  166. Simple if structure - if checkbox is ticked, then open the form - how?
  167. Problems with Debugger
  168. recalculating subforms
  169. Get server time instead of System Time?
  170. Automating Word with OutputTo or VBA
  171. Counter code
  172. .BAT Quetion - Close Window
  173. Import Multiple csv file into Access Table
  174. Multi Select
  175. Problems with IsNull
  176. Incorporate Search using a SQL Query into A Variable
  177. How to pass a frame to a function
  178. A problem With NULL!!!
  179. External RecordSource As SQL
  180. Update Table from Form
  181. Using a List box to goto a record
  182. find record using criteria from variable
  183. Code Acting Up
  184. Permissions Constants - Numeric Values
  185. VBA in Forms and Combo box
  186. QueryByForm, search for records with date field inbetween a range... code not working
  187. cannot update recordset using ADO
  188. vba for form
  189. i am such a tool
  190. Possible Library issue
  191. variable type for Addmenu.
  192. E-mail Formating
  193. Referencing Class Module Variables
  194. Automatically unzipping files
  195. Put results of a query into a text box
  196. XL Charts in Access VBA?
  197. FSO in Access VBA?
  198. Sending a Report and/or Record Via Email
  199. View record related to a particular name
  200. Processing multiple records
  201. Cancel the Close Event for Report
  202. calling class module subroutine from behind form
  203. Help with code
  204. Form.Recordset and combobox.requery problem
  205. DoCmd.RunSql syntax problem
  206. vb does not recognise queryDef and Database
  207. Create Database
  208. Menu/Toolbar Property - Show On Toolbar
  209. importing
  210. Cannot fathom Type mismatch error
  211. grabbing table values and placing them into a variant
  212. Password help
  213. Looping through each record in table
  214. rental databases
  215. If / End if troubles
  216. Maybe timer?
  217. Test length of field contents
  218. Registry Settings
  219. need help for a VBA solution
  220. Validation
  221. multi choise questions code
  222. Too few parameters expected 4
  223. Item is read only
  224. Click a button on another form
  225. Sending E-mails
  226. Check Mark
  227. grabbing table values
  228. Is it posible to implement polymorphic function/Sub in VBA?
  229. table locking?
  230. Findfirst w/ date field
  231. Please help with a conditional statement for query by form method
  232. Open DOS Program and execute keystrokes?
  233. SQL - Insert Into
  234. MCount - Faster than DCount?
  235. Use a set / array of values in function
  236. Combo refresh poser
  237. Trouble adding and editing with same form.
  238. Got Stuck with VBA+SQL.....(panicking, please help~)
  239. outlook automation - deleting message from "sent items".
  240. AutoNumber
  241. Position record of table???
  242. IntelliSense Problem
  243. goto new record in (Datasheet View) not working
  244. Combo problem
  245. DMax + 1
  246. inform user of additions
  247. Problem with QBF "Query By Form"
  248. Object Required Error Message
  249. Dmax + 1
  250. ADO connection to Exchange