View Full Version : Modules & VBA



  1. VBA Access Database to Excel
  2. SQL Query giving different results in VBA and Access
  3. DefaultFilepath
  4. Hide Current Form When Open another Form
  5. SQL Code in VB
  6. deleting records
  7. Defining a Data Type array in VBA
  8. Label visable based on criteria of text box
  9. No current record
  10. record just created...
  11. Reusable Automation..
  12. VB: dynaset and form onopen
  13. Comment Format
  14. transferspreadsheet doesn't go in order???
  15. Adding a new record via Navigation Buttons - PK question
  16. Using google in my database
  17. Finding records in a recordset
  18. Import XL and Update fields
  19. SQL Insert Into Code Not working
  20. Get Home Directory
  21. DAO in Excel and multiple recordsets
  22. Something different then Application.FollowHyperlink
  23. ListBox - Move to next Record
  24. groups and users
  25. Correct Syntax for Variables inside brackets for SQL Statements
  26. Importing Multiple Text Files - Searched forum
  27. Vba & Ftp
  28. Explicitly Reference Control on Continuous Subform
  29. Dynamic Recordsource not behaving correctly
  30. DoCmd.OutputTo
  31. Buttons Flashing
  32. Detect a keypress during a Loop
  33. Delete records on form close
  34. Graph Image in OLE Field
  35. Calculate position in a series
  36. Adding data to existing records
  37. Unexpected reults when filtering for a date value
  38. Next Record Not setting values
  39. Shell32, Multiselect...
  40. Importing excel file ...too slow
  41. Webbrowser ActiveElement question
  42. Prevent Error 2501 if user cancels OutputTo?
  43. HELP! Need to check if textbox is empty..
  44. Applyfilter method gives unexpected results when filtering for date values
  45. CDO working with Exchange Server
  46. sql query
  47. Checking values against a table
  48. Problem with OpenForm Method
  49. how delete current record
  50. can anyone help me with part of that code
  51. Setting and recording file path(s)
  52. SMS Messaging From Access
  53. Dynamic Tab Control/List Box
  54. How to code Append Query In VBA?
  55. Newbie wants to batch process queries in Access
  56. Parameter value in VBA
  57. Create a Customer Account Number/Reference
  58. Combined Search Help
  59. Form Search?
  60. avoiding logging in
  61. Bring Application to Front
  62. Need help with VB code to Excel document
  63. issue identifying a field in webbrowser
  64. Excel Conditional Formatting in Access VB
  65. OutputTo making file read only
  66. VBA's Error Handling: How can it be done better?
  67. simple itterative loop + something a bit harder
  68. Clear bound text box?
  69. Fair message if typing word not found in bound combo box
  70. Convert Month Text to Actual Date
  71. Creating emails in VBA
  72. Access or visual studio - SQL back end
  73. ListBox, COlumnHeads
  74. Check Box
  75. ADP and Programatically Create Server View
  76. EXCEL: Disabling the X (close) button on a UserForm
  77. Recordset in a form
  78. New ADODB.Connection - 'CoInitialize has not been called'
  79. Code keeps snagging on nulls!
  80. sql query problem
  81. Need help on adding criterie to code (probably simple).
  82. authenticate against a protected system?
  83. Applying a filter to a subform on load.
  84. Splash Screen
  85. VBA to determine Windows logon time
  86. Filter data according to many criteria
  87. Forms - buttons - toolbars resizing
  88. Shell not opening my .bat file
  89. Return stuff between 2 forms
  90. creating graphs in access
  91. Detect existence of Exchange Server
  92. Programatically set Reference
  93. Search problem
  94. Absolutely stuck Insert string to table with sql
  95. Problems reading lines in an ASCII file, help!
  96. Updating the Back End structure in VBA
  97. Can a recordset be shared between two forms?
  98. Splitting name from email address
  99. how to export displayed data into excel (automated)?
  100. Split form search
  101. Limit input trough inputbox
  102. Problem with programming code
  103. help with code
  104. Help with funky date format
  105. import email attachments
  106. SendObject v. CreateObject("Outlook.Application")
  107. Use User ID for Auditing
  108. Change Subforms Recordset - Runtime
  109. Setting DB to read only
  110. 'Invalid argument' error when sql run in Access VB.
  111. Recordsets, what I doing wrong?
  112. Need help with recordsets
  113. Append Query Field Name Problem
  114. Wildcard in a string
  115. Random Numbers
  116. Capturing when a report is printed
  117. Select Top (variable) - Is this possible?
  118. Reports based on Crosstab queries
  119. Simple Copy to Clipboard
  120. Primary Key Based On Text/Number
  121. pls urgent....using delimiter (|)
  122. Is this approach folly?
  123. pls urgent....
  124. can't close Excel from VBA
  125. problem with file name....
  126. Using the Tab key to advance to a new record
  127. using arrays in access
  128. Password format for Input box
  129. Password format for Input box
  130. SendKeys and/or Macro Failure
  131. More Lotus Notes eMail woes
  132. Import String as date
  133. Force Listbox Value w/o Me.Refresh
  134. what does this error message mean?
  135. Help adding "text" (ENTER) and more text using VB
  136. Problem wiht exporting in HTML
  137. Upgrading from 2000 to 2003 - Run-time error -2147352567
  138. Problem with ComboBox Get_Focus()
  139. Flexible recordsetclone?
  140. Need to Convert DEC number to HEX number to IP ADDRESS
  141. Call Call Audit_Trail Ambigious Error
  142. delete from value list
  143. Sorting
  144. VBA code to move to a specific record
  145. Almost got the code to copy a file
  146. subform reference
  147. Can someone please look at this if statement
  148. Data Mining
  149. Automate Linked Table Manager?
  150. How to cut off part of a string (parse)
  151. Check for Duplicate Entry
  152. Query SQL and/or Parameters
  153. How to get list of files in a folder
  154. error object required
  155. Invalid Use Of Property
  156. Global variables
  157. Exporting to CSV
  158. Runtime 2001 - Canceled Previous Operation
  159. Strung-Out Text
  160. Collecting MP3 file information
  161. Loop to Create New Records
  162. reset listbox
  163. VBA Editor-Mouse scroll
  164. Word automation - runtime error type mismatch
  165. Beginners Guide
  166. Error 2105
  167. Output Table To Excel
  168. Small Toolbar Code needed
  169. Rename and move
  170. Reset table
  171. Controls on Multiple subForms
  172. looping through properties of all controls on a form...
  173. How to quit a loop
  174. Add From Outlook 2007
  175. Follow Hyperlink to Folder
  176. urgernt..help in building this screen.
  177. Dcount(ing) records with a blank field
  178. password on form question!
  179. SendObject canceled
  180. Rich text editor for access
  181. MouseWheelOnOff
  182. Condensing if statements
  183. avoid MS Access message
  184. Viewing images in access?
  185. Can You Call the Description of a Database Object in VBA?
  186. Help in updateing multiple tables
  187. infinite loop problem
  188. Automatically attaching a screenshot to an email
  189. Give options when Click on a Submit Button
  190. Access2003: enable single cell in datasheet form
  191. Change data set charted with a combo box?
  192. Subform SUM problem
  193. Trimming a string
  194. Executing Multiple Queries
  195. Variables when referring to object names
  196. Setting control source for an object
  197. Week number and ISO8601
  198. Field visible/invisible based on field before
  199. Printing to default and pdf printer simultaneously
  200. Compile Error on rst.Fields("Account")
  201. Is this possible?
  202. Proper Way to Pass an Int
  203. SQL question
  204. Displaying only current record in subform
  205. Weird Date Calculation
  206. word automation - sending multiple records to a table in word
  207. Data Definition on Linked Table
  208. SendObject Not working - help me Obi Wan Kenobi
  209. Copying information to next record
  210. Problem with code for id3
  211. Help w/ check box that can add additional text to field, not just replace text.
  212. how 2 convert 2 mde
  213. Parsing Names -- Not in List -- Requery????
  214. Password Problem
  215. DLookup Question
  216. No Value given for one or more required parameters?
  217. Error Trapping Problem
  218. exporting to xml and recordsets
  219. Dates being recorded into table as 12:00?!?
  220. Dates being recorded into table as 12:00?!?
  221. 4 different forms need the same code
  222. Change the recordsource of a report
  223. Using VBA to add data in a form.
  224. Count the records in a recordset
  225. ShiftBypass Disable
  226. Organizing my code
  227. continue with next event after error
  228. Run a .bat file, after pushing a button
  229. VBA to set focus to a report on load
  230. MouseUp change color label
  231. Removing Letters
  232. 3033 Error
  233. Find out if post has been edited
  234. How to hide items in reports
  235. Creating a PreviewReport Function
  236. Run report based on SQL
  237. Error 0
  238. Path not found error
  239. Call on a range variable EXCEL
  240. Recordset runtime error 3251
  241. VBA for inserting topvalues in table
  242. Find First
  243. Create Query in VB
  244. Ending database connections
  245. using For Each statement
  246. Run Macro from VB at a specified time
  247. Creating report in VB
  248. user-controllable constants
  249. avoid Security Warning msg
  250. Continuous Form issue