View Full Version : Modules & VBA



  1. Last Working Day
  2. Change source of linked tables
  3. Conditionally run macro
  4. import csv files to multiple tables
  5. Find out if a subform is existing or not
  6. Using the Write # method (remove quote marks from output)
  7. Row Numbers
  8. Search tif Files & Move to New Folder
  9. How to make an ADO Connection Public
  10. If Statement help please
  11. Thermal Receipt Printer problem
  12. Search for a Number
  13. Getting value of a variable from string of variable name
  14. First Character Upper Case Only
  15. Get the size of a string in bytes
  16. Link File dialog Box
  17. ACC2000: Recursive RSS/XML Reader
  18. Alternative to a Msgbox?
  19. day of week - help
  20. Importing Excell Into Access
  21. Late binding question
  22. Docmd.sendreport acSendReport Outlook 2003 v. 2007
  23. Error 3075: using BuildCriteria
  24. Dynamic Multiple Choice Inputbox
  25. Access Runtime Launch Issue
  26. Setting the controlsource of an object
  27. Need module to add dates to report.
  28. Can't Edit an Excel Book from Access
  29. Problem with Code
  30. passing start and end dates and a third criteria to a report query
  31. DirectCast from .Net for us VBA COM'ers
  32. simple loop questions
  33. Type Mismatch in Expression
  34. Set Visible property of Image in Detail section of Report
  35. Deleteing Folders in a Set location with a specific date format
  36. Pull Value from Query and Sum
  37. Add a AutoNumber to a query
  38. Broken Link In Send Report
  39. a p roblem in Ms Agent
  40. Form Filter Problem
  41. send email with results of query
  42. Need help with this code
  43. Access UDF doesn't work from .NET (Csharp) ?
  44. Day of the week VBA Help
  45. CAsh Drawer Kick Code: VBA- Access 2000
  46. Import Data from separate Access DB
  47. data type conversion error...
  48. Browse [Find a directory or file] inc subfolder files
  49. Combo box not in list error (now wondering if my approch is wrong)
  50. Finding the location of a database
  51. can you update a row in a query using ADO?
  52. Generate & store distinct random numbers
  53. N00b wants a form
  54. mail merge with pdfMaker add in
  55. Ribbon ChangeProperty
  56. Navigation Pane and Ribbons
  57. Filter Form; If no record found turn filter off question
  58. Test if a Window is on top or not
  59. how to aggragate a column of records?
  60. deleting every record in every table
  61. Autonumber Next Increment
  62. How to use a .net class library
  63. flickering labels
  64. Deleting Text Files using VB
  65. Lablel Message
  66. Calculate Working Days inc. Staff Start & Finish Dates
  67. Little help with SQL in VBA
  68. Change format of name?
  69. Change Font in DataSheet
  70. Sending to Word Bookmarks
  71. Timesheet "discretionary" time
  72. Call up Module Function
  73. FSO Files Collection Size Limitation?!?
  74. Importing Excel into Access
  75. Sendobject with Dlookup
  76. Problem with strings
  77. group by query in vba
  78. Combine # text files but remove first line from all but 1
  79. Outlook calendar (Delete and update)
  80. Lebans calendar on parent and subform does not work
  81. ADO Count records in existing query
  82. Filting by check boxes and option buttons
  83. Stuck with SQL Script
  84. Values of recordset to textbox
  85. How to tell if a Query Exists
  86. How Do I Stop Code if No Records in Query?
  87. Need Help Global Dictionary
  88. Split() Where Cursor is
  89. Method 'CurrentDb' of object '_Application' failed / Error in loading DLL--problems
  90. Auto Send Mail
  91. Emtry Table Error Trapping
  92. Coding help with data input
  93. Code for new query
  94. VB Code to email active worksheet
  95. Select Case trouble
  96. Dynamic labels
  97. How to keep popup form on top
  98. Calculation in a field
  99. Reading in a textfile one line at a time.
  100. Validation Query
  101. creating a Data Dictionary
  102. No breakpoint set - and yet breaks?
  103. Importing and running a .bas macro
  104. Export "Transfer" Query to Excel
  105. Suspend Code until function completed.
  106. Referencing Selected text access 2007
  107. ADO Export to Excel, Error on rs.Open
  108. DLookup Function
  109. Automatically populate a field using a field on another form
  110. Stop user accessing code...
  111. cumipmt code
  112. finding smallest combinations of a list form another list
  113. Line Graph
  114. Convert Date 5:44 pm MON FEB 23, 2009 to yyyy/mm/dd 24:00
  115. OnChange - txtbox keeps pace with other txtbox
  116. DoCmd.PrintOut
  117. Selecting multiple matches of Regular expression searches.
  118. Form to Report - Between two Dates
  119. Coding for grade results
  120. Onclick in subform updates another subform
  121. Deleting columns in Excel Sheet from Access VB Code
  122. exporting access tables to tab delimited txt
  123. Access closes on running this function
  124. DATEADD in VBA
  125. Overwriting changes to a saved excel file
  126. Importing Excel to Access through a form
  127. Test Screen Resolution
  128. run macro in another database
  129. Using VBA to rename a table in Access
  130. Delete Records Based on Filters
  131. Access 2003 to 2007?
  132. Query result in VBA
  133. adding cumpimt
  134. Searching arrays in access 2002
  135. License/Permit expiration notice sent to email
  136. .accde to .accdb
  137. Microsoft Access not accepting or showing 0
  138. Kick users out of Access via Excel VBA
  139. New to VBA
  140. Predefined Email
  141. Error Message 94 - Invalid Use of Null
  142. Email loop not recognizing apostrophe
  143. Retrieving continuous data on a subform
  144. Notinlist not working
  145. Export to Excel
  146. Cause number to act as a string?
  147. ADO and SQL help
  148. Importing Excel to Access using VB
  149. How to change a report logo based on criteria
  150. Reset Combo Box
  151. Linking/Importing Visio 2007 Data
  152. Program Design advice
  153. Run Access sub from Excel
  154. Controlling Excel from Access
  155. Query not able to update
  156. "Where" condition in a DoCmd.OpenReport command
  157. Passing Variable between VBA and external module
  158. reference subform object
  159. Email Based on a Form
  160. Problem with DoCmd.close acReport
  161. extremely slow for exporting data to Excel from Access
  162. Validating a Field
  163. Get last ID
  164. Apostrophe Issues
  165. Use Button on Main form to ALSO control the subform
  166. Open image in IE
  167. HOW Do I: use Coding to Get a Value from 1 Table...
  168. Exporting table to .txt file
  169. How to create "custom events" or easter eggs for button clicks
  170. Comparing databases
  171. View table data across the internet
  172. To print a part of worksheet using vba/access
  173. Automate Key Stroke on an Update Query
  174. Current Group?
  175. 24 hour time format
  176. How to refer to a field value in a Table's Specific Record
  177. When open a form go to the new record
  178. how to automate time/date insertion in new record
  179. Cannot Create MDE File
  180. Recordset.FindNext Question ????
  181. simple slookup error
  182. Problem with SQL (delete)
  183. Compact On Close
  184. Clever Filter
  185. Print all snapshots in a folder
  186. Inforcing a password criteria?
  187. Date Stamp
  188. runtime 2001 error with DCount
  189. Value listbox
  190. Exporting memo fields to Excel via VBA
  191. Report in PDF format
  192. run time error '424' object required
  193. Calculate average value from several fields
  194. Opening Numerous Excel docs from Cmd Button
  195. why does this code work in one form but not the others?
  196. Fill a combobox with table values
  197. Input a variable to a query
  198. 1st of every month
  199. VBA for Attachments?
  200. Quick Help on Combo
  201. To store barcode value in a control
  202. Export executable OLE Object
  203. Open Form to Specific Record with OpenArgs
  204. populating list boxes
  205. populating list boxes VBA
  206. Error on Dim WApp and Dim WDoc
  207. hard coded timeframes
  208. No exception thrown?
  209. Select statement with where condition
  210. runtime error 424 with DoCmd
  211. Mailmerge Access 2003 frontend with SQLExpress
  212. Select query problem
  213. Else without If error
  214. Progress Bar Within Code Structure
  215. syntex error in update query,extra braket
  216. Completely Automate Email Procedure
  217. To print a worksheet from access form button
  218. Bloat
  219. Send Object
  220. Write Conflict
  221. Convert numbers to text
  222. fuzzy matching
  223. Producing report in PDF format
  224. dBASE data type mismatch - using CAST?
  225. List of Tables
  226. Passing command line arguments to VBA and Access
  227. barcode with check digit
  228. Quick Code Adjustment...take you a few seconds probably
  229. Access VB Code Put to Work on SQL Server
  230. Creating email in VB, how do I change the "From" field?
  231. need to add a OR clause ot an IF statement
  232. Addings a counter (autonumber)
  233. To display the result of a query in textbox
  234. VBA application to import data to access, then export to sql server
  235. call procedure in a module to clear all controls in the form
  236. Enter barcode automatically in textbox
  237. Urgent: programming linking tables
  238. Syntex error:Update multiple columns at once
  239. Email Format Issue
  240. Simple Question: How to get VBA to Press OK for you automatically
  241. Delete current record in form using input box confirmation
  242. Exporting from Access into Excel - but only new rows
  243. combobox property to select values only
  244. Transfer time from a textbox to table field
  245. Code to change Data Series color
  246. Easy Msgbox Issue
  247. How to close a table to update the same table?
  248. Compacting a ms access 2007 database by vba code
  249. Duplicate records appearing in my Form
  250. Link PDF file to a record using vba