View Full Version : Modules & VBA



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