View Full Version : Modules & VBA



  1. From Excel to Access
  2. Query based on date ranges supplied by a form
  3. Out of stack space error
  4. FTP upload w/MSINET.OCX: PROBLEM
  5. Reports from Sub form criteria...
  6. Duplicate a Mainform and its sub forms
  7. ADO in Access97
  8. Drop down list in a form
  9. compile error using oldsoftbosses image sample
  10. Relative Path problem
  11. Expected: list separator or )
  12. How to minimizing database window using code
  13. How to minimizing database window using code
  14. Suppress Save Record messages...
  15. SQL Action subroutine
  16. Find current tab open?
  17. #Deleted showing on form and Error 2455
  18. Absolute into Relative Path problem
  19. how to control the pc speaker in vba
  20. Open a .xls from Command button
  21. form to run sql queries
  22. Form open!
  23. Date Range search problem
  24. Anyone know how to...
  25. Help with a slight code adjustment
  26. Populate a form from a double click
  27. Help concerning rounding.
  28. Simple Problem Driving me maD! Plz Help :)
  29. SQL line continuation help
  30. Create a calculation formula
  31. Import 'Filtered' Excel Spreadsheet Into Access Table
  32. Email issue
  33. Display Results of Indexing Service Query
  34. Help with Textbox Value on Report
  35. Having big problems with Variables
  36. Help with Msg box that executes
  37. Help with VBA filter code
  38. Import Specific lines from Text File
  39. Help with validation
  40. Help with Next button
  41. Code to count records
  42. Update new Access field
  43. Copy info from one field to another.
  44. Help: SQL request as List
  45. How to build a string from a query and use it to append a record to a table
  46. LDAP / Shell() Problem [No Download]
  47. importing mdb <> mdb
  48. Access 2003 Runtime Error - Function not available in expressions
  49. FindFirst Alternative
  50. Error Handler problem
  51. ADO Connection gets RunTime Error - 2147217900 Invalid SQL Statement
  52. dao function alteration
  53. Backup according to user choice...
  54. Electronics Firmware Burner, DLookup(x2) to Command Line
  55. Code problem?????????
  56. Empty Field and control
  57. DAO table structure only
  58. Sending E-Mail
  59. 1 Command Button 2 actions
  60. Update Table With Multiple Records Using Listboxes
  61. Open and Save a Web Page at Text
  62. TransferText and German characters ä, ö, ü
  63. Write data to table
  64. Date Problem
  65. Record Count
  66. Loop Without Do
  67. Cycle Through All ComboBoxes On A from, without using the name?
  68. Code just won't work when it should!
  69. Help with some code
  70. LDAP ADO Query
  71. ADO recordset creation
  72. Save a Record on Another Form
  73. Error when using (') in sql SELECT string
  74. Keep recordset open from Db start-up until Db closing
  75. Populate Text box on Web page
  76. Import word document
  77. Seek??
  78. appactivate
  79. update query code problem
  80. Password protect rtf
  81. Pass form valued argument to module
  82. Changeable Criteria Expressions
  83. VBA: Class Modules
  84. Simple Code Problem
  85. getting list box data from table in access 97
  86. strange refresh of subform
  87. Sending multiple attachements via LotusNotes
  88. Problem in a recordset
  89. VB for sending emails on click
  90. ADO Connection Error
  91. Getting the value for the next field
  92. Numbers... Help
  93. Pausing a Loop, Threading Etc
  94. very basic, basic ;)
  95. nested IFs not working, though top-level does
  96. Waiting for a complex query to run....
  97. annoying problem!
  98. VB Program to list customers "Smit*"
  99. can someone explain this pls?
  100. Password problem...
  101. runtime error 94 invalid use of null
  102. Access / Outlook "Cannot send this meeting request"
  103. OK What is wrong with this:
  104. Calculating Date
  105. object type argument blank or invalid
  106. Screen Resolution
  107. relative pathways
  108. Help with VBA syntax
  109. Dynamic If...Then using variables
  110. Save an report's output (Access2000) as a PDF file
  111. ComboBox VBA
  112. Date problem
  113. Field value on a report
  114. how to apply the same filter used by a form to a report
  115. How to apply the same filter ... (second part)
  116. refreshing a subform
  117. Command Button in Form to open certain files
  118. SQL against query fails
  119. Filter a report, but need to then print it
  120. Call query
  121. On Change Data
  122. Execute
  123. yes/ no text box
  124. Avoiding delete confirmation pop-up
  125. Record count of a Delete Query
  126. Access to Outlook and back again
  127. Exporting a CSV file using a macro / module
  128. Syntax Error with Insert Statement
  129. rename user accounts in system.mdw
  130. Need Assistance Please -- Count/Sum Function Queries
  131. Gremlins in the VBE editor
  132. Assign result of sql query to a variable... help plz
  133. Recordset problem
  134. Subform to Subform
  135. Exporting to Excel..Custom Column Name
  136. run code on report open
  137. For...Next: Help cycling through controls
  138. problems with Find method in ADO
  139. Help with Syntax
  140. run VBA if/else statement in report?
  141. Use vba to modify the query table's condition.
  142. Fields won't print
  143. Select Muliple Prices for Invoice
  144. Run-time error '13' Type mismatch
  145. Update recordset
  146. VBA - ".body" assistance - please?!
  147. chart in a form to report
  148. VB works in version 2002 but not in 2000
  149. Format Outlook Task text using VBA
  150. Searching for and linking tables
  151. Proper subform control naming
  152. Building a shell string
  153. Connection string to Access db
  154. Opening External Table
  155. Insert into linked tables with ADO
  156. Get Values of Macro Objects
  157. Working in a memory Space??
  158. Importing datefield not working, help !
  159. Deleting table Record from Listbox
  160. Returning appropriate type
  161. Parameter Queries
  162. Obtaining Line Number on Error
  163. Store Global Const Values in a Table...?
  164. Copy table cells to the clipboard
  165. ADO Conversion
  166. What is wrong with my code?
  167. Need Redemption to add Report for Outlook
  168. Help wih code
  169. Sending multiple tables using sendobject
  170. Send email WITHOUT open OUTLOOK question
  171. Getting location of linked tables database.
  172. What do I need to look for?
  173. Close Access if table is NULL
  174. Ugly Code: Works but needs help
  175. Comparing two tables / subsets
  176. Simple dlookup alternative question
  177. combine multiple buttons into 1
  178. Text File Import
  179. Importing/exporting tables
  180. Abnormality
  181. why does On Format event is preformed twice
  182. Formatting listbox
  183. check string length and run code...
  184. Score a poker hand with vba...
  185. Export a RecordSet to Excel
  186. populating a list
  187. One for the experts - SQL and VB
  188. SQL in VB
  189. Using SQL in VBA - inserting text
  190. Reopen switchboard on report having no data
  191. sql syntax problem
  192. AutoNumber Decrement
  193. Sql
  194. Writing Modifications from Bound Form
  195. label in 2nd form visible
  196. List Box selection problem
  197. Enhanced Switchboard
  198. Declare variable as Printer Does not work
  199. Syntax Error when using Apostrophe or comma
  200. A problem with on key press event
  201. Access rights for database users
  202. Formatting Date
  203. Sql
  204. need help with this function call - please
  205. Lost Focus
  206. Passing in Passwords as Parameters
  207. multiuser issues
  208. String Generation Routine
  209. Info About Module
  210. Outlook Attachment Location
  211. Opening Remote Database with Password
  212. Importing to Access application by code
  213. Calculating multiple dates
  214. Problems ending a loop
  215. Help SQL-VBA needed !!
  216. Searching With SQL on Switchboard
  217. strange problem with a date varible
  218. Help With Loops
  219. Path
  220. How to use Tabledef to get list of tables in access
  221. Rounding to the nearest .5
  222. Continuous Forms Loop
  223. Syntax question
  224. DLookup Help
  225. Change text of duplicate records in report?
  226. finding newest timestamped file
  227. Need help with DLookup function
  228. Using SHCOPY and wanting to limit file types
  229. Loop Until Last Record
  230. Coding for a date problem
  231. SQL Statement not working...why??
  232. Multiple Selection
  233. help with record set
  234. SQL Update/ Error 3020
  235. App Object Model
  236. Get values from .exe in "stdout"
  237. vb Yes/No
  238. multiselect list box problem
  239. Tab control - hide one of the pages?
  240. Counting Checkboxes On A Continuous Subform
  241. Can't disable object - has focus...
  242. Celtic name issue
  243. Control CheckBox
  244. MultiSelect List Code
  245. Syntax Error PLEASE HELP!!!!
  246. Lost all modules
  247. Set another databases password using code?
  248. Update unable to accept appostraphes or Commas
  249. Using a multi-instanced form as a child form
  250. Verifying Required Fields