View Full Version : Modules & VBA



  1. List Box problem
  2. Run macro in 1 database when you open another that is linked
  3. #Error in form...
  4. Connection to Database
  5. Code/SQL experts help
  6. Still trying to connect
  7. how to transfer data from one form to another blank form
  8. hide the text in an input box with *'s
  9. Return value in Function
  10. Using dates in VBA/SQL code
  11. Open report based on multiple criteria
  12. "between" date criteria
  13. Set Zoom for Report using VBA or PrtDevMode
  14. Security thru VBA
  15. Exlusive mode right
  16. Lookup values
  17. Rerunning a script within Access
  18. Go back to current record
  19. Password Protect A Form
  20. Run time err ‘91’
  21. VBA for beginners....Book needed!!!!
  22. The Openreport action was canceled
  23. Code to tell if a query name exists?
  24. Modify Access Tables thru VBA
  25. Locked recordsets on a multi-user database
  26. Compile Error
  27. Error in mde file
  28. This is a Visual Basic qustion but....
  29. Multiple Import ?
  30. embed period in text
  31. hide system error message
  32. Display contents of recordset
  33. SOLUTION: Numlock problems after SendKeys
  34. RunApp
  35. How to hide & in error messages?
  36. Breakpoints
  37. Running code with Msgbox
  38. FindRecord
  39. Returning multiple values from a function
  40. How can I set global variables?
  41. Getting ActiveX Component Cant Create Object
  42. Shortcut key
  43. Field name as an argument
  44. Making an ADE file
  45. InputBox
  46. MS Access Add-ins
  47. use variable in report header?
  48. Common Dialog Control?
  49. column names
  50. DlookUp
  51. SendObject
  52. Refer to database window in VB
  53. Trouble Coding A Browse Button
  54. Can I setup a one-dimensional array like this?
  55. Carrying Values forward to a new record
  56. Select text in Access like Visual Basic
  57. Question about InStr function?
  58. Dynamically Accessing the VB Editor
  59. commondialog box
  60. Help with Command Button
  61. Help with Command Button
  62. DLookup "type mismatch"
  63. How to determin if Outlook is running
  64. Access 2000 Recordsets
  65. table names
  66. Hyperlink on form
  67. Searching for Records
  68. Extracting
  69. Drop in System Resources
  70. Small App If Anyone is Interested...
  71. Identifying user who input record
  72. Week Number
  73. Shell command with variables
  74. Getting Current User's Group
  75. Using the In() Function
  76. VBA
  77. Dlookup problems
  78. Variables
  79. Dlookup problems (string criteria)
  80. VBA HELP PLEASE FOR A LEARNER
  81. Can t apply FindFirst to a RecordSet (method seems unavailable)
  82. coding navigation button record x of y
  83. Can t apply .FindFirst to a RecordSet (simplified)
  84. Compare one table to another
  85. navigation buttons... record (x) of (y)
  86. Problems with applying .FindFirst to a Recordset: Solution
  87. Refer to/modify forms(controls) in external DB
  88. VBA objects & collections listings & syntax
  89. Check for value in two List Boxes
  90. Writing code for arrows in fields
  91. Too Few Parameters error message
  92. Before Update Usage
  93. Table reconstruction
  94. Whats the correct way to call an event procedure?
  95. Code help needed
  96. Report Printing
  97. Using variables in controls
  98. Mutli Select Combo Box
  99. Syntax to call a general module on an event, from a form
  100. Names of Embedded Queries
  101. Using Variables in form filters
  102. How does one handle rollovers when doing subtraction with time?
  103. HELP NEEDED NOW!!! CurrentUser Function
  104. Can I set up a sub in the general declarations to be called later?
  105. Module that Opens a Excel File
  106. TimeClock
  107. Reading text file as Binary
  108. Can t apply properties to a RecordSet
  109. time diff
  110. Adding values to a new field based on calculation
  111. Flagging the page of an "onglet" control to use it as default
  112. Cannot successfully change the ColumnCount or ColumnWidths of a Combo Box after it is
  113. Looking for some basic VBA advice
  114. URGENT! VBA and queries
  115. Why can't zero-length strings be inserted using INSERT INTO SQL?
  116. Possible to use dongel on Access Programme ?
  117. errror handling help
  118. A few questions about recordsets (ADO)
  119. Show1 not working in Access
  120. Need to hide password in Replicated database
  121. On Load event
  122. Using what is in a variable
  123. SendObject syntax
  124. Recordset and Queries
  125. Message Boxes
  126. Identifying Users on Multiuser Environment
  127. ***Updating the record source on a tabular sub-form.
  128. Code freezes on opening a recordset. Need help to debug!
  129. Open Access 2 from Access 2000
  130. Message box/e-mail
  131. Quick and dirty search function
  132. Programmatically Link an Object in a Form
  133. How to Compact from VBA
  134. Which Event
  135. Question regarding setfocus
  136. Communicating with serial ports
  137. Help implementing "Browse" for filename
  138. Converting an Access application to a Visual Basic Program
  139. I keep getting "Database Needs to be repaired" on multiuser environment
  140. Compacting and Repairing
  141. Letting VB dicate the content of a report object
  142. Code question
  143. Can Access 97 run a module at a particular time?
  144. Disabled controls still show calculated values
  145. Index related question
  146. About retrieving part of a string
  147. First Run
  148. number in words
  149. Compile
  150. DoCmd Problem
  151. Send all listbox contents to parameter
  152. Switch between dialog and datasheet view
  153. VBA Varriable in Select statement
  154. Type Mismatch Error
  155. Invalid Reference Nightmare
  156. Link graphic to form
  157. Saving items from a listbox selection
  158. Alternatives to Autonumber datatype
  159. Invalid reference Error 2455 - Is it Access 2000 bug?
  160. About retaining values globally
  161. just a test - please ignore
  162. Need help trying to pass variables.
  163. What data does a function act on ?
  164. Class module code runs twice
  165. Focus
  166. Passing values
  167. Winfax from Word97 & Access97
  168. Function expert needed for Help with fraction addition on form
  169. Variable in a Command Line String
  170. Check for #error fields in query with VB ?
  171. Output to a named folder
  172. Input Output Append and stuff
  173. Assigning the Value of a field to a table control name
  174. Error Message
  175. Access data type conversion
  176. Question on dlookup
  177. WHERE clause and use of wildcards
  178. Populating a listbox via a dynamic array
  179. Need to make Do loop stop
  180. Array problem?
  181. Array... of recordsets?
  182. Alter multi list selection
  183. Date format problem in 2001
  184. Random Numbers
  185. automating importing
  186. "Sorry, can't find .mdw file."
  187. Adding Countdown Routine to an Excel Splash Screen
  188. Help with using Visual Basic database program
  189. Clearing a field
  190. Test for existence of a network drive
  191. Move to next record in subform
  192. problem: accessing Word from Access via VBA
  193. tell user the number of page of report before print,
  194. counting page numbers
  195. If then Stmt - VBA???
  196. How-attach external files to database??
  197. How do I modulate my code?
  198. Can I run an On Timer sub and a module simultaneously?
  199. connect to access 2 tables
  200. How to Make Excel Read-Only?
  201. MultiUser Database vs VB
  202. Linked Tables
  203. replica of password protected databases
  204. Write record to table
  205. Help w/If-Then Statement
  206. beginer on recordsets
  207. Loop help
  208. Compact dbase after close
  209. storing results of an sql query as a variable
  210. Set statement (setting a form name as a variable)
  211. BeforeUpdate mixup
  212. Allowing blank entry in combo box
  213. Change From Address in Email
  214. Preventing Controls From Printing With Form in Word 97
  215. password coding
  216. Modifying an Open Source Database
  217. Method Failed
  218. Tags
  219. InputBox Size
  220. Urgent Help: simple password coding
  221. return break between sentences in a memo field
  222. Click event question
  223. test if changes have been made in a form
  224. Exporting Access Table to Dbase file
  225. Modifying a record layout
  226. getting data from excel
  227. Inserting multiple Ole objects
  228. trouble with IF and/or
  229. Record date when button is pressed
  230. Tab Control
  231. Coding question
  232. Project Management, Product Breakdown Structure
  233. Standard can call class module procedure?
  234. Me keyword help
  235. Query another table to populate text box
  236. Recordset as alternative to append query
  237. Module help needed
  238. Error #67: Too Many Files
  239. Display tabledefs in remote pwd protected db
  240. Matching Numbers
  241. Print design view from VBA
  242. Syntax Error
  243. Training
  244. How To Set Access Options Programically
  245. To link or not to link - that is the question
  246. DDE between Access and Excel
  247. How to Change MS Outlook Rules Programically
  248. Code question
  249. DoCmd.SendObject only works once!?!
  250. Data Types