View Full Version : Modules & VBA



  1. TransferDatabase
  2. Deleting duplicates but keeping totals
  3. IF vs. SELECT - Check if Date Textbox is empty / null
  4. Multiple If...Then...Else statements
  5. Using Excel from Access
  6. Coding Tools for Snippets
  7. open a drawer
  8. OutputTo Cmd?
  9. Ensuring references in distributed databases (and VBA)?
  10. Variable representing Max Value
  11. too few paramters. expected 3
  12. Regular Expression and Output Text File
  13. Wait for the existance of a file, then run macro
  14. Referencing Security Levels with VB
  15. Coding question?
  16. combobox - vba
  17. Import Text file- Tab Delimited
  18. Dlookup & Max
  19. Erratic Code
  20. SQL Function value in text box
  21. 3021 No current record
  22. Stopwatch
  23. Message Boxes
  24. Need a bit of help working out a date?
  25. Make Table as oppossed to Making Query
  26. Urgent - Modal Forms
  27. Skipping a few records
  28. Run a Query
  29. Generate Password
  30. code problem
  31. No message boxes
  32. It opens once, but not again
  33. Need Help with Code
  34. Import table with user prompts
  35. change query in querydef
  36. Urgent ! Please !
  37. increment a string field
  38. Search form in xp
  39. Highlighted tex
  40. A2K - ADP Reference uniqueidentifier
  41. User create table
  42. Weening a global junkie
  43. Insert Into Command
  44. Output to Snapshot.
  45. Active Page on Tab-Control
  46. Paradox/Access
  47. Record height
  48. Sending an SQLServer TSQL command from VBA
  49. Snapshot
  50. get the first file
  51. loop passing all object on form like 'name'+x
  52. Rich - A Question If You Don't Mind?
  53. Sample code please
  54. Roundind up!!
  55. passing a value to a function
  56. SendObject for email references needed
  57. Duplicate Values in a TBL
  58. GoToRecord in Subform
  59. Question about dates and Excel in Access
  60. Recapture the caption value of column
  61. First File (Repost)
  62. Get Network Path of file in VBA
  63. syntax error (comma) with quoted field
  64. Moving records with Arrays
  65. Need Some Help Here Please
  66. Copy an active record on one form to another
  67. ActiveX Controls and Visual Basic References
  68. Populate field based on character in another field
  69. It's just an 'if' statement
  70. Help Please
  71. problem with text delimiters
  72. Pause Function of ActiveX
  73. filter form data on the fly?
  74. search fields-urgent help needed
  75. Double quote " in string variable?
  76. Filedatetime
  77. Cmd Button based on query related to textbox.
  78. Create a new Table in VB
  79. Run time error "2486"
  80. Batch File
  81. OLE Object's Images
  82. Using code to change object permissions
  83. Strange .bat file problem
  84. Help with docmd.runsql
  85. Need an Explanation ?
  86. Trying to add a TAB into a label/text box
  87. Stealth Combo Box
  88. running batch file
  89. problem running excel macro in module
  90. Compact and Repair another DB from VBA
  91. Running a batch file
  92. Checking Numbers
  93. Access to Lotus Notes
  94. problem with a small code
  95. Code Error and System Error
  96. ALTER TABLE - Format Datatype
  97. check for 1st or last record
  98. Delete a table from another database
  99. Source Library
  100. Access VBA - One of many ...
  101. transferdatabase
  102. Loop and End of record
  103. Rename files per table
  104. Specify decimal places for variant used in a msgbox?
  105. Listboxes on Froms
  106. Dynamic Form not so dyanmic
  107. Code to run defrag
  108. Code to run defrag
  109. erasing content of text file.
  110. Importing spreadsheets into one table
  111. Ambiguous Name Detected
  112. Default Delete Button Code not working?
  113. capture the year of a date
  114. Running a parameter query through code.
  115. Adding Records
  116. Shortcut on desktop
  117. Controling objects on subform from a mainform
  118. replacing two spaces with one
  119. How to obtain server's datetime through ODBC/MySQL?
  120. How to refer to collection in a called function?
  121. Option Group Filtering
  122. Read-Only RecordSet
  123. exporting to current directory
  124. Predictave text for form text boxes linked to tables
  125. Close DB when button pressed
  126. no database reference
  127. References...Again
  128. Importing filenames
  129. VB6 - Displaying messages using a form
  130. Access won't let me modify VB Code
  131. Creating an Import spec
  132. combine fields from different records
  133. Error 3021 for code to combine duplicate records
  134. Button to copy listbox values to new listbox
  135. Carry current value of a control to new records
  136. code for duel functions
  137. Query or vba
  138. Option Explicit?
  139. Change column names to first row's data?
  140. File attachments
  141. Invalid SQL Statement Expected 'Select'
  142. Append Query Using VBA
  143. TransferSpreadSheet w/filtering??
  144. Format Function
  145. Pop up message
  146. Action when DB Closes
  147. Get list of available fonts
  148. Can one combo filter 20 tables at once?
  149. Access project refreshes?
  150. select case not working
  151. Populate data in different 'Sheets' in Excel from Access
  152. Pointless and Flashy
  153. Copy a database - how to in code?
  154. Cancel Unload Clears Form
  155. runsql command
  156. how to make field value auto. increased by one when inserting new
  157. Can't Find Function from Switchboard Command
  158. Learning VBA
  159. Referring to a sub-form from a module
  160. code for focus on a text input field
  161. Command button to make a subform visible
  162. Compile error
  163. QueryDef definition
  164. Date formats
  165. Delete Information In Column with Code
  166. Help with InStr() function
  167. Give a form a good title
  168. export table as delimited text
  169. count resulting record from SQL expression?
  170. Converting macro's to VBA
  171. Select Case with Wildcard
  172. Import From Excel based on Worksheet's Column Headings
  173. Table data last modified
  174. Select a record through VBA?
  175. How to delete all names in xl workbook
  176. Pausing code
  177. Hide Footer
  178. code stored in table
  179. Code and some query errors: in a complete pickle
  180. Is is possible to embed files to extract?
  181. Please help with loops
  182. table data was last modified
  183. OWC MS Office Spreadsheet problem
  184. Fatal Error while running reports
  185. Error Messages
  186. change sort order of table
  187. Send an active form as an email attachment
  188. AllowBreakIntoCode
  189. Bookmark trouble
  190. 1-365
  191. asign var velue with sql
  192. Identifying Connected Track Mileage
  193. Performing a custom search Through the 'Date' variable to ascertain the month
  194. copy to clipboard
  195. Office XP Developer suite
  196. Linking or Exporting Excel Cells Automaticly From A Table
  197. Syntax?
  198. insert email address into a table, help!!!
  199. I want to insert a time/date trigger
  200. Referential integrity
  201. Relink Backend code
  202. Create Database joining specific mdw
  203. Too many rows on expot to excel
  204. How to call a Rollback in an Error-Handler
  205. Outlook Forms and the Shell Cmd
  206. MsgBox
  207. Best way to search recordset and set up a form?
  208. Refering to diferent instances of access
  209. Problems executing code
  210. Combo box "Number" Problem
  211. Deleting a report if it exists
  212. Compiling
  213. Check form control vs. recordset field?
  214. set form control based on recordset field?
  215. First Attempt at Error Trapping - How am I doing?
  216. Exporting table to excel using VB
  217. Incorporating VB form inside an Access db
  218. Automate Update Query
  219. Opening Excel template
  220. Set object value with dynamic value
  221. Refer to all fields in a form
  222. Shell or Hyperlink Is there a way to work around spaces in the file name?
  223. Vb code error
  224. Refresh Link to SQLServer View through Code
  225. Transfer Multiple Spreadsheets
  226. Reset values to default values
  227. close forms
  228. End the Wend
  229. Delete record in Subform
  230. Calculate date of nearest Thursday
  231. Sql Help!!
  232. Routing From Excel to .txt before Import
  233. How to use a recordset
  234. Running to Form
  235. Perform action on sequential variables
  236. Code for opening Excel doc
  237. Run Batch File from within Access
  238. Run macros in Excel from Access button
  239. Exporting to Excel
  240. Set an object = to one of two currently open instances of Access
  241. Cant complete code
  242. On Change event
  243. Open form criteria
  244. How to determine an empty recordsource result?
  245. Coding Problem
  246. Can't set index for recordset!
  247. Data management module
  248. Type Mismatch
  249. Tarting up an autonumber
  250. Microsoft Graph automation help