View Full Version : Modules & VBA



  1. extract dates from string
  2. extract dates from string
  3. SQL / VBA run-time error
  4. Enable/disable button based on lookup on another table
  5. Disable a control VB question
  6. Mulitple updates to a table based on the changing # of records from an import tbl
  7. Updating records if Null
  8. Path
  9. dlookup in a form
  10. Input mask for command edit box's
  11. OpenFile Help
  12. Cascading List Box with a twist
  13. Export Works in Step Mode, Fails when Run
  14. Recordset help
  15. Help with User Defined not defined
  16. Help with calculating order total
  17. Tough Question
  18. How to search my entire database
  19. another quick (i hope) query question
  20. validation numeric field and selection box
  21. Dlookup
  22. Conditional criteria in query
  23. Disasterous Error
  24. Compile Error: Procedure too large.
  25. Runtime error 2108
  26. ADO or DAO - I am confused
  27. Error with moving Excel sheet from VBA
  28. Edit Module On The Fly
  29. Code Help
  30. Deleting a Asterisk from a string
  31. My code works when it wants to?
  32. Recordset syntax question
  33. Updating Table/Query/Form
  34. Changing a fields attributes / datatype from using DAO
  35. link record to pdf bookmark
  36. using join query in vba
  37. Urgent Help !
  38. Utilizing data on one field to display in another
  39. Strip HTML code from Memo Field
  40. Using a Form to Populate a Query
  41. Automated import from Excel
  42. 2 questions: rst.recordcount & verify docmd.sendobject
  43. ODBC Connection on Form Open in Access
  44. Help me with this VBA code
  45. merging tables...
  46. hide control in continuous form
  47. Check Excel Sheet Open
  48. Open an access db from vbscript
  49. Newbie table access in VB question
  50. Extraction
  51. progress bar and multiple queries
  52. tranferText to a CSV directly from sql statement- Possible?
  53. change fieldnames in the table using VB
  54. Is It Really Null?
  55. Debugger works in one mdb but not another
  56. OnTimer Events
  57. Newbie problem: Current record
  58. Load image from file location
  59. How to determine if it's a new record?
  60. Filter Combo box on form open event
  61. Checkboxes and Queries
  62. Find specific record
  63. Converting PDF to TXT with VBA or VB
  64. Display only part of text in a field
  65. EVAL function and MS Office Access Class Objects (help!)
  66. Going to VB.Net
  67. Changing Yes/No CheckBox Value
  68. set value in combo box
  69. Distribution list
  70. mso code????
  71. Release Excel damn you
  72. Sending E-mails
  73. Call an outlook dialog box from a from...
  74. Calculating a number to be put into a field
  75. Working History
  76. Dlookup prob
  77. List View Problem
  78. Searching for a Range
  79. How to solve MaxLocksPerFile problem without changing registry settings?
  80. Tools -> Option
  81. Populate References
  82. DataChange Event
  83. how can i create a consolidation script
  84. Help Needed
  85. instantiated a control???
  86. Add Case select statement for fiscal year
  87. PDF and VBA Code Help
  88. export string to text file
  89. ListView/Sql Help
  90. Seek on multiple columns
  91. Error 429 occurs only when run via Citrix
  92. ODBC Connection Via VBA
  93. ListView
  94. Change prompt
  95. INSERT to return record ID
  96. No field referance?
  97. design problem or requery problem?
  98. ODBC Connections on Open
  99. Looping through a query
  100. Dear All
  101. Referencing a field with no record
  102. Listview and checkbox
  103. openfile with date in the filename
  104. Help
  105. Code to go into all tables and remove spaces from fieldnames?
  106. .bat files works fine but errors when run from vb
  107. Vba to move data from table to table
  108. GOTO Next Non Recurring Record - Help?
  109. Shell and Focus
  110. Dynamic Array Reset
  111. ODBC call failed, error 3146
  112. How do I check the excel file modified date before import it?
  113. Appending 1 record information to new table
  114. Access to Excel Question Has Me Stumped
  115. INSERT statement
  116. DAO searching all fields in Record
  117. where condition
  118. Unzipping files
  119. Button Visability
  120. HELP Email from Access..
  121. Querying a stored query in VBA
  122. Report Names
  123. Open PDF in Form
  124. Exporting query results to excel
  125. SET identity_insert, Append Query (stored procedures?)
  126. DateTime stamp for a field, not a record.
  127. reference to a fieldname fails because of quotes
  128. Recordcount
  129. Query to Count Records
  130. automation word/excel copy/paste
  131. Workspace Object
  132. Overflow
  133. Using the value returned by a SQL Query in VBA
  134. Writing data to Combo Boxs
  135. Input Message Box
  136. Export Excel Chart to Access Report Automatically
  137. Problem with duplicates
  138. VB Editor causes an error. And why does a form have a Report in it?
  139. Filtering Question
  140. Hard Code Data Source
  141. Displaying Date in a txt box after Check Box is selected.
  142. Email question
  143. split up InStr line
  144. Use of Null or IsNull
  145. open report dependant on Msgbox Value
  146. Permissions on Macro's and Modules - Recompile
  147. Is Outlook running?
  148. Requery underlying tables
  149. Counting hours and minutes
  150. querydef ; invalid argument
  151. Please help me with SQL...
  152. This should be so easy, why isn't it?
  153. How To Set Rowsource to QueryName Syntax errors ..
  154. Have User input WHERE criteria in an OpenRecordset method
  155. Using Access to Fax Reports
  156. odd report problem with VBA
  157. Column Listing using VBA
  158. insert/datatype
  159. Optimize Query To Test Records
  160. change to standard format
  161. change to standard format
  162. Question on the Browsing sample
  163. Access data into Word
  164. delete columns
  165. Word Automation to find text
  166. Retrieve incoming Email
  167. Security using passwords in a table
  168. Using API to hide the BG window but keep on taskbar
  169. how do I calculate subtotals in a report using vba
  170. Problem with ADODB.Recordset
  171. Better mousetrap? Is Case Select best here?
  172. Recordsets
  173. problem with spaces in opening Excel file
  174. How do you auto generate a number?
  175. Right mouse Blues.
  176. Dlookup in a remote query
  177. Conmparing Dates
  178. Output Access Forms to XLS??
  179. vb sql headache - required parameter missing
  180. Too many fields
  181. Regarding a question that utilizes VBA
  182. Going back to the original control
  183. selection in dropdown box should show a text in a textbox
  184. Round Funktion
  185. Goldmine
  186. Recover database
  187. Nz function
  188. Email Address Duplication In Lotus Notes
  189. Multiple Updates to a table from another table
  190. I NEEED help with IMPORTING Pleeease
  191. Changing the default profile in Ms Outlook.
  192. Hanging Recordset.Find
  193. Checking for connection to internet.
  194. Selecting value in my combobox
  195. Specifying Control>Open SubForm
  196. OLE communication error
  197. changing Hyperlink Address
  198. Passing Parameters to query using VBA
  199. Combo Boxes
  200. Conditional formatting code issue
  201. Passing variable result to originating form
  202. Locking Record Scroll
  203. Code stops working despite correct References
  204. TableDef.Fields not in sync with table
  205. Call a procedure from field value
  206. Multi-Function Module/Macro/VBA
  207. Multiple Checkbox
  208. Question Regarding Splitting a Database
  209. Import Excel to Access 2000
  210. Code overwiting existing records
  211. Open Form in SubForm Control in Add Mode
  212. Syntax for Pressing Enter
  213. Get Stage Date and Description Using SQL Problem
  214. Deleting the first character of a string when importing
  215. Conversion from A97 to A2k
  216. Inserting a .doc file into RTB control
  217. importing folder path and filename info into table???
  218. Data type conversion - text to number & number to text.
  219. Changing Text Box based on Query?
  220. sub procedure that doesn’t always calculate properly.
  221. What's the name of a subform?
  222. e-mail problems
  223. Barcodes and VBA
  224. Attaching files to email
  225. Variable In-line Substitution
  226. problem when adding AND
  227. Im Loop'd - pls Help
  228. Problem with copying record to history table
  229. Programming a option Button
  230. Help me modify this code so it links TWO fields instead of just one
  231. Using a variable as a field name
  232. Converting old Data to a new Version of my DB
  233. Message Box
  234. Export Queries To Current Active Spreadsheet
  235. Export Queries To Current Active Spreadsheet
  236. Export Queries To Current Active Spreadsheet
  237. Export Queries To Current Active Spreadsheet
  238. Import To Current Active Spreadsheet
  239. Need help with my code...
  240. Code dealing with email..
  241. Scripting.Dictionary Object
  242. DoCmd Openform Properties
  243. Code error, is something simple no doubt
  244. Opening Form in DataEntry Mode
  245. SendObject attachment
  246. Updating Combo Box (which updates form) from form
  247. Runtime Error 3146
  248. Changing picture on Toggle Button
  249. Getobject command Causing Error 91 Please Help
  250. Form.next?