View Full Version : Modules & VBA



  1. Strange "Variable not defined" error
  2. case choice statement not working, please help
  3. dcount and sql count
  4. Change a Query fields criteria in VBA
  5. Help! - Runtime Error 3061:Too Few parameters Expected
  6. Disable mouse wheel
  7. Transfer database
  8. Passing a value from a pop up form
  9. Combobox = 2115 error
  10. Count(*) variable ?
  11. Navigate to previous record??
  12. Using Excel Solver Addin through VB
  13. Run-time error '2115'
  14. recordset - printing access report pdf
  15. Filesize
  16. Create a new Excel File in VBA
  17. Mail Merge with MS Word produces incorrect date format
  18. Querydef ODBC connection problem
  19. If statement vs loop need help
  20. mail merge - word complains that no lock can be set
  21. Select Case Help - No Current Record Error
  22. Recordset problem
  23. Literal vb in text field...
  24. Problems with Date Filter
  25. How to pass logon credential to a form/record source
  26. Run-time error 2137
  27. I want to know about user...
  28. Public Variable - 2 Forms 2 Tables
  29. Output to a Vertical Text File
  30. How do I get "Transfer Text" to recognize my query name
  31. Passing Recordset Parameter
  32. Form_Error for subform
  33. Option box grow
  34. auto-compact bypassed by docmd.quit
  35. When Date + 7 days then...??
  36. Updating one table via lookup
  37. Using a form to add new things to a database
  38. Interrupt the code
  39. Validate fields & display just 1 message
  40. Exiting other Subs within a Sub
  41. Calculation in VBA
  42. Running Stored procedures
  43. Is this possible?
  44. Really Simple Question (Hopefully!)
  45. Rename lots of files
  46. custom deletes
  47. Numbering using dmax problem
  48. Strange typing behaviour
  49. promting a command on closing a form
  50. Using Excels Statistical Functions from within Access
  51. problem outputing a double to a text file
  52. Advanced MSGraph Behavior
  53. How do I populate a table with an ADOX recordset?
  54. Function Question
  55. Changing the tables column size using VBA
  56. DAO vs ADODB
  57. could any one explain this code for me ?
  58. Possible?
  59. TextStream
  60. Darned Arrays....
  61. Exporting string to text file
  62. Compiling problem in MS Access
  63. Selecting Printers for reports (A97)
  64. Tab control
  65. General VBA Question....
  66. Multi-field search: SQL string formatting issues?
  67. Required fields....
  68. Import records from Access into Excel
  69. OnClick event
  70. How can I calculate datediff between 2 records?
  71. Passing a value from a module to a querydef
  72. How can I disable altF11???
  73. View files in folder
  74. limiting pull down list menu
  75. Executable Access DB file
  76. long sql string
  77. Runtime error '3426' with .edit (for recordset)
  78. Howto: Replacement for RecordExit, and to move back to previous record ?
  79. "Program sending email on your behalf"
  80. Learning vba
  81. Media Center & Visual Basic (Access) Are They Compatible?
  82. Send email without edit
  83. Refresh form that looks at query?
  84. Mail Merge coding problem
  85. Formatting Now()
  86. generate a table from a sql string VBA
  87. problem with for loop
  88. How to add feild size and null constraint check to this vba
  89. Same code.. different results
  90. Can PHP be invoked w/n Access?
  91. Conversion of Date to Number
  92. Copy record(s) from a form into table?
  93. Carrying out calculation based on equation in table.
  94. linked table in access
  95. Microsoft jet engine stopped the process
  96. Access upload to an ftp page
  97. INSERT INTO to return ID
  98. Error checking for table fields null value constraint
  99. Excel Automation: I am confused
  100. Hot to split data?
  101. DoCmd.OpenQuery ???
  102. Unable to declare object of type DATABASE
  103. Help Writing VB Code
  104. Scraping values from a webpage
  105. Access 2k - Attempting to create a customized search, need help!
  106. Send email to webmail service
  107. Populate Unbound Control
  108. Reference another Access DB
  109. converting text to number
  110. Transfer text gives parameter value error
  111. DSum not working :S
  112. DLookup Query
  113. Form code does not run - Deug? - URGENT
  114. queries and functions
  115. DB.Execute Method not working
  116. Changing Text Color for Negative numbers using VB Code
  117. Help with Application.Run
  118. Generating a Service Number
  119. getting recordsource from subform
  120. Open form in entry only mode
  121. Superscript textbox
  122. Setting a variable Problem
  123. Need help with If statement…
  124. New Item Coding
  125. Exit without saving
  126. Populating List Box From Query
  127. Need help with findfirst command
  128. Visible code not working when viewing records
  129. No writing a value in a cel of Excel
  130. counting number of times a record has been touched during a day...
  131. execute a module. How??
  132. Trim to Space Char
  133. Selected Record Jumping In List Box
  134. uploading picture using access
  135. Strange printing behaviour
  136. For...Next Loop Problem
  137. Required Field error not caught by Exit button
  138. Little help with code
  139. Window User Name
  140. Data Transfer to off-line mini version of DB
  141. temporary table for VBA Access
  142. open a form from a query in VBA
  143. to many recordset operations
  144. Compacting db with pw through vba
  145. Reset Public Variable Value to Zero
  146. Access to Excel variables
  147. Mail Merge Help
  148. existence of VBA code to manage users and passwords
  149. stLinkCriteria with two times on one button
  150. Setting Printer Print-to-File
  151. "Error in loading DLL" when looking for Outlook
  152. Bypass entering password to ODBC data sources
  153. Days in month
  154. How can I put attachements in my email with Outlook Express?
  155. Removing missing Reference with VBA
  156. using DoCmd.TransferDatabase to import data
  157. open folder from hyperlink
  158. Eliminating Repeated Characters from a String
  159. Subscript out of range - Arrays & NPV
  160. speed in look ups
  161. Can i insert VBA code into an XLS exported from Access?
  162. New fields won't show up in VBA
  163. Search function problem
  164. Button to open subform within current form?
  165. If Isnull() function
  166. Determining the number of Vbcomponents in an Access database remotely opened by Excel
  167. TransferSpreadsheet
  168. VB Code to Import data from Excel to Access
  169. vba help
  170. Find/Delete Table in TableDefs Collection
  171. Export to excel and "skip" a column?
  172. Another Text Manipulation Question...
  173. CurrentRecord equivalent in ADO
  174. Modify Loop to create tables and import XLS worksheet
  175. Dates and NOW() statement
  176. Test If Database Is Already Open
  177. Reading File Structure from a CD ????
  178. InputBox with ComboBox
  179. Call fOSUserName()
  180. cannot recreate a query after deleting it in vba
  181. calculate Double OT
  182. please help with a "where" statement
  183. CalendarControl outputting date AND day
  184. Copy File in Access
  185. Skipping first in recordset loop
  186. ...missing or broken reference to the file 'filedialog.dll' error
  187. array questions
  188. Multithreading? Or something else, perhaps?
  189. TransferSpreadsheet not "releasing" the file
  190. No Duplicates Code?
  191. open a form using application object
  192. MSWINSCK.OCX, runtime 429, ActiveX can’t create Object
  193. Using a module for multiple forms
  194. Append filename CSV imported files
  195. Import Excel into Access Table
  196. interact with xxxxxx.MDW file
  197. How to save the sub form into another table ?
  198. prob with date and if-procedure
  199. DoCmd.OpenReport with SQL condition
  200. Sending e-mails via Lotus Notus from Access
  201. Strange SetFocus behaviour
  202. Using variables in VBA...
  203. getObject() and shell() question using automation
  204. sub form values
  205. VBA to Open a Form
  206. Tab Index sorting like Form Controls
  207. Using Collections
  208. CreateField(dbBoolean) Lookup = CheckBox
  209. iif statement in a query
  210. Mail merge questions
  211. Convert Number to String
  212. Start word from access
  213. SQL and VBA
  214. Retrieving Parameter from Stored Proc
  215. Next Try
  216. Disable copy to clipboard
  217. ADO Recordset
  218. If statement
  219. UPDATE Statement and User Permissions
  220. Repeating Code
  221. Can you use SQL in VBA code?
  222. Importing from Outlook Contacts
  223. How to use Iif and EOF
  224. Data Type mismatch
  225. Search for records with existing part numbers
  226. Error 3464
  227. referring to combo boxes
  228. Increment Subroutine for multiple fields
  229. Variables with " in them.
  230. VB doCmd.openreport where clause gives prompt
  231. Excel spreadsheet locked after procedure
  232. Class not registered error
  233. split name field into parts
  234. Add to recognized file types
  235. Printing from VB using the "Printer" object
  236. Concatenate a string in If statement
  237. Can you create MDE using VBA?
  238. Retrieve System language
  239. Exporting Report To Excel via List Box
  240. Getting data into unbound text boxes
  241. CREATE TABLE with decimal
  242. A few probems...
  243. Import special delimited .txt file
  244. Crystal Report Viewer Connection
  245. MDE Files
  246. Load Statistics
  247. DoCmd.RunSQL statement error. MS Jet DB not able to find table
  248. Dlookup Help
  249. please correct my code..new to ado
  250. Problem with Access Report to Excel Code