View Full Version : Modules & VBA



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