View Full Version : Modules & VBA



  1. Brain Dead
  2. Progress Bar Problems
  3. Assigning Function to multiple Textboxes
  4. Array's <Subscript out of Range>
  5. Message to appear until query has run.
  6. String Export to AS400
  7. Help file
  8. auto minimise
  9. Importing files???
  10. Append data from multiple Excel Workbooks
  11. updating and editing a table
  12. Passing Parameters to Query via Code
  13. Problem with findfirst for subform
  14. CSV file import
  15. AllowBypassKeyProperty
  16. toolbars
  17. user log form
  18. Restart pc
  19. what is a 'user profile' and how do I...
  20. Error 3011...sometimes
  21. Trapping the close box
  22. coding command button
  23. Easy date/userid function ? for experts (I think)
  24. export fields into text file
  25. Can't fine my table
  26. Mail Merge
  27. Data types
  28. Array data types
  29. Wildcard???
  30. simple(?) compare problem (i.e. if x > 2 then...)
  31. Any way to Send Mail in access using Lotus Notes
  32. List Box thing.
  33. What's wrong with my code?
  34. Dim As Database
  35. Could someone explain Me.RecordsetClone.FindFirst ??
  36. How To Write Code 101
  37. Don't allow update if.....
  38. How do I change the name of a field in a table
  39. Using "On Change" to Append A Record
  40. basNormalDistributionINV
  41. Named Arguments: How Do I create
  42. StLinkCriteria ???
  43. OK... I've read the help on Select Case... but...
  44. count number of characters while they are being typed
  45. Referencing Forms
  46. Monthly Email
  47. "Intelligent" Search Form
  48. Deleting tables from Code
  49. Having Trouble Poplulating an Array
  50. Error # 3146
  51. Run application that has .ini file
  52. Looping through selected records of a continuous form
  53. Converting String to Text
  54. Concactenating Date/Number
  55. Need Help on how to use combo boxes as a query
  56. SQL statement in VBA Concatenation
  57. How to include libraries
  58. Please Help MultiSelect ListBox!!!!!
  59. Auto update next record's value on change to previous record
  60. Why -1?
  61. Update Append Queries
  62. Adding Records to a tabl dynamically
  63. need to create generic code
  64. Open a form using a VBA Sql statement
  65. Database Properties - Custom Tab
  66. Open Form in add mode
  67. getting code on subform to run before main form
  68. Print DevMode Issue
  69. Break out of the code
  70. OutputTo default directory
  71. User write to hard code
  72. GoToControl question
  73. Need Help Please, Having trouble referencing a field that is a autonumber
  74. Placing records of a table into an array
  75. Question About Visual Basic Access Programming
  76. NO Save
  77. ODBC timeout
  78. Getting a too few paramaters Error on OpenRecord Set
  79. Trapping DB error source
  80. Creating text files from a single file
  81. windows logon name
  82. Help!!
  83. Catching a cancel event from a Non-Access dialog box
  84. simple synchronising listbox question
  85. TransferSpreadsheet Method
  86. Converting a LongInteger into String??
  87. Send Object Error 2287
  88. Changing weight of part of message box message
  89. Check Boxes
  90. Trying to get vba code to enter in data depening on the value of another field
  91. MS Excel 97\MS Access 97
  92. Checking Existence of Folder
  93. Copying a query
  94. Docmd SendObject Problem
  95. Passing arguments in module function
  96. Password retrieval
  97. Multiple Records display on a DAP or ASP
  98. Problems converting security form from 97 to 2000
  99. Passing variable values
  100. help
  101. Using Docmd.RunSQL to delete a record
  102. Dealing with an empty recordset
  103. Looping
  104. If statement
  105. Controling Values in a Combobox
  106. Maths and VBA (Variance)
  107. im stuck///////
  108. simple syntax question
  109. pause?
  110. change password
  111. Automatic Password
  112. Opening a Directory
  113. Run timer error 2451
  114. Dcount Problems
  115. Udate to move a record to another table
  116. Query Propeties and VBA
  117. Help With Lotus Notes
  118. swithching subforms
  119. VBA to return a record from a query?
  120. Using Data from a Previous Record
  121. Populating a Combo Box Issue...Again
  122. Importing Excel spreadsheet into Access
  123. ODBC Refresh
  124. VB Help
  125. leading zeroes gone in text field
  126. Macro If NEW record then ...
  127. C:\WINNT\Profiles\ - USER ID - \Desktop
  128. Highlight Selected Row in Tabular Form
  129. random letter generator
  130. Minimize current database & Open a different database
  131. DateAdd
  132. Selection.Copy
  133. Setting values for all controls on form
  134. Running code in Excel via Access using GetObject
  135. How is it with ADO?
  136. Sending Objects.
  137. Extracting a list from a query
  138. Developer Tools
  139. VB with Lotus Notes
  140. Using Comnbo Fields as Lookup Fields for a Data Access Page
  141. Automatic Email Updates
  142. Problem with Continuous Form
  143. Code Problems! AHhh!
  144. Treeview Control
  145. Sub/Function not defined
  146. Randomly select a file
  147. Menu/Toolbars
  148. Selecting a Query
  149. Insert Into Word
  150. Help with populateing a table using VBA
  151. FileDialog object - where I can find it?
  152. Multi-field Index - Custom Error Message
  153. Unsuccessful FOR NEXT loop
  154. If sheet is updated fill in date field?
  155. delete first 3 rows in an Excel-File
  156. Sub Calling
  157. Sendkeys Problem
  158. Dde
  159. stumped on INSERT INTO statement
  160. Create code to select records
  161. FindFirst with 3 variables
  162. Update Excel spreadsheet
  163. INSERT INTO prompts for value
  164. strange ADO error
  165. Stop Code
  166. copy a webpage
  167. Can't seem to call subroutine of a subform
  168. listbox doesn't support method
  169. how to automatically create new records with fields filled in
  170. Scrollbar value
  171. criteria to filter form to only recrds which have had a field peviously filled
  172. How do I access the Import Errors Table?
  173. pick list of sorts
  174. combobox value in variable?
  175. OLE Excel Spreadsheets
  176. SQL in VBA?
  177. Option Groups
  178. make image visible?
  179. help!!
  180. Code Driving Me Crazy! Need Help
  181. DAO Recordset Sort
  182. Automating Several Mail Merges
  183. Making code efficient?
  184. Write form data to Module (Once)
  185. Common Dialog Box Not working Properly
  186. reference an ActiveX control
  187. Running sub procedure in Excel from Access
  188. Dim As Database in Access 97
  189. Querydef with Parameters
  190. HELP! Running VBA Procedures from EXcel
  191. Close Excel through VBA
  192. Help with changing page size/layout using PrtDevMode
  193. For Each Array()
  194. OnTop Form or Command bar TextBox
  195. Importing File into Table
  196. Please Help! VB being arsey!!
  197. Starting up...
  198. Need Help with Query by Form Code
  199. Read Rows Warning
  200. Printing a Report to *.pdf - But no Links
  201. Import File into table (again)
  202. Cool way to have a Hello Message. (Remember Calculus?)
  203. Current Record
  204. The Mysterious Category Agent
  205. Message Box with Number
  206. using one table to check another table's data
  207. Access Terminates while using MailMerge
  208. change the action of an existing button
  209. I just can't seem to get this right...
  210. Array with a Loop!
  211. Conditionally hide a subform
  212. Add carriage return to a string
  213. Copy Text in WebBrowser Control
  214. So close...Does not like the way I Dim Database
  215. Recordset
  216. Code made from macros
  217. action when moving to next record
  218. Error with VBA code on search
  219. Moving to start of recordset once end is reached
  220. Getting a circular reference in a Module
  221. Hiding and disabling things
  222. Option Group Values
  223. Radio button and Combo Box Problem
  224. Record from table into string
  225. Printing a PDF to a specific location
  226. Building an application
  227. TransferText
  228. How to compact current database
  229. How do you get a combo box to auto-lookup its value?
  230. Resorting a table through code
  231. ODBC fail error 3146
  232. Having trouble with DLookUp on a Field name
  233. Notifying Users of import errors
  234. Converting Access 97 module to 2000
  235. Problem with recordset statement
  236. "Predictive Text"
  237. open in Shared mode all the time
  238. Missing operator error
  239. Code check - Null value
  240. Selected property in the background
  241. can't KILL files with Hidden and Read-Only attributes
  242. Getting data from a website
  243. Auto Refreshing data?
  244. Running multiple command buttons
  245. access and downloading from internet
  246. Simple piece of code but it won't work
  247. Copy and paste
  248. API: show Icon on a form
  249. Multiple Attachement with SendObject
  250. OCX Files