View Full Version : Modules & VBA



  1. Deleting Items from List Boxes
  2. Complex Input Mask
  3. Rnd function question
  4. Browse for files
  5. Hex To Dec
  6. Change Table Column Name Within Code ??
  7. Trying to refer to a column in a table but recieve error
  8. Recordset
  9. Auto fill based on second form
  10. Multiple OpenArgs, is it possible?
  11. Importing Outlook Contacts
  12. VBA help
  13. Displaying a custom recordset on a form
  14. Insert Into
  15. Open Exclusively using VB.
  16. Objects in Web Browser Control
  17. Invalid Use of Null Error: Please Help!
  18. Relinking tables
  19. Saving an access mdb file as a vba project
  20. Recordsets
  21. Create a new exel file, lock fields and then exprot to it.
  22. Run SQL in VB upon opening DB
  23. Scope problem I think??
  24. Open Each Form Sequentially
  25. Deleting non Access files with command button
  26. Find and Replace Question
  27. Emails in Access
  28. I have no idea
  29. SQL Recordset ???
  30. link html help file
  31. ActiveX module: TBarcode v2.1.8.
  32. Working with forms and controls
  33. Connecting a text box to Outlook express
  34. missing operator
  35. Problem with accessing controls in subForms
  36. Update fields on a table
  37. Interfacing MSAccess with a Palm OS
  38. Need some help in VB coding
  39. Data type mismatch 3464
  40. How to create report header
  41. Link Module with switchboard
  42. RunSQL maximum length
  43. Create table dynamically
  44. Quote Confusion
  45. On Not In List - NewData includes " ' "
  46. Creating an UPDATABLE linked table
  47. How do I do this.
  48. Prevent / trap CtrlP
  49. Opening Excel Workbook
  50. Database window
  51. XML Parser
  52. Folders, Paths, Files
  53. Help with a DCount
  54. Listbox filtered by checkbox
  55. Validating Users Through Network
  56. Print Automation
  57. Minutes/Seconds format
  58. DoCmd.OpenForm, multiple criteria in WHERE clause
  59. transfer spreadsheet
  60. Calculating time
  61. Add an AutoNumber field(ADO)
  62. How to lookup value in the previous record?
  63. DROP Index
  64. Out of Memory
  65. On Change Event in Combo Box Problem
  66. Access Date Problem With Subform
  67. Solution: Kind of 'UnCrosstab' code
  68. Search and Find Or Error
  69. Checking to see if record exists
  70. Open hyperlink document with button?
  71. Remove the first and last characters from a string?
  72. Random function with a fixed range
  73. stlinkcriteria
  74. End of file in document
  75. Option Explicit
  76. Why does this code fail
  77. Limit to field size in SQL statement
  78. Comparing Data
  79. Scan Application
  80. do until eof
  81. update database from a website form
  82. Copy folder
  83. Linking to Foxpro free tables
  84. Linking to Foxpro free tables
  85. Recordsets and "one to many" tables
  86. Guys.. i need ure help!
  87. Import Spreadsheet to Query?
  88. VBA emailing free at last?
  89. Validation rules
  90. Dynamic stock field
  91. Controlling TransferSpreadsheet - access to excel
  92. Importing data from a CSV file
  93. Selection of a word document
  94. Exporting to DBF
  95. Autofill in Datasheet View
  96. Using Winsock Control in Access
  97. Filter Function
  98. retrieving code in an MDE
  99. Random Selection Percentages?
  100. Deleting objects using a *name* format
  101. Month days
  102. Guys.. this is a real challenge!!
  103. Function to convert CurrentUser() to actual name
  104. Automation in Access 97 (I chanlenge you!)
  105. command button code
  106. Setting focus
  107. Accessing query
  108. Updating a field on a different form
  109. date problem
  110. Advice Needed
  111. Resolution Solution
  112. Select case statement
  113. Copying records with vb
  114. Exporting Linked Tables
  115. DoCmd.RunSQL
  116. Printing Report problems
  117. Select case
  118. Global Variables
  119. link html
  120. timer event
  121. Dates!
  122. Real Brain teaser!!
  123. Close form
  124. Coding Problem
  125. Checkbox
  126. How to code Bookmark?
  127. AccessXP and WindowsXP
  128. Library Problems
  129. Navivating Recordset with VBA
  130. Passing variables
  131. Delete forms and reports programatically
  132. unrecognizable forms
  133. Overwriting excel files
  134. Moving to next record on Parent form via sub form
  135. Getting the current month with code
  136. Global Variables
  137. Filter Weekend and Evening Hours
  138. e-mail a form record
  139. Deleting records on a popup form.
  140. How to connect a wizard with a Button
  141. filtering out holidays if fall between start and end date
  142. Dlookup and varible
  143. THIS IS SOO ANNOYING!
  144. Opening Calendar Form From Sub Form Problem
  145. Print No. Of Pages Msg Box
  146. basic information on writing functions
  147. basic information on writing functions
  148. Code to Open PPS as a slide show
  149. Show/Hide Report
  150. Which Field is Giving the Error ????
  151. Verify unique entry
  152. Access bug???
  153. Apostrophe: Finding Data in a Table
  154. Copying files whilst keeping the original in tact
  155. Shell function not working! :(
  156. Parse a record from a recordset
  157. Validation
  158. query
  159. no data
  160. using wildcards in a string query
  161. placing a variable in CreateQueryDef
  162. Pend printing reports
  163. Center the File Open/Save Dialog box
  164. Delete specific text during a parse...
  165. Variant = Null = not working right!!!
  166. boolean
  167. reusable code
  168. SQL Statement in error?
  169. ActiveX control can't create object
  170. incrementing a field number
  171. ON ERROR GOTO not working
  172. How to write a txt file based on table info?
  173. ComboBox, sos, deadline 2 days away
  174. Script Help
  175. RELATIVE PATH IN A FIELD
  176. Pass a record to a function?
  177. Read files from few sub directories
  178. referential integrity.....using code?
  179. Urgent Help Needed!!
  180. Docmd.sendobject for sending emails
  181. Launching a web browser to view help files
  182. Email with Lotus Notes code!
  183. PasswordChar
  184. Using a find form
  185. using listbox to reorder records
  186. boolean
  187. Recordset delay
  188. Fill table with all form names in db
  189. Enable all fields and controls
  190. Help
  191. Export Trouble
  192. combo box vba help
  193. Mute Button
  194. Can someone help me with this!
  195. Date problem
  196. Assign unique # to groups in table
  197. Currency value symbols
  198. Really Really Urgent Help Needed
  199. File Sharing Lock Count Error, Please Help!
  200. Dates ARE Killing my BRAIN..>!!!
  201. Pause before send
  202. this is a simple one for you programmers
  203. Code problem any ideas?
  204. Network message?
  205. Need Help with Loop - Please
  206. ActiveX OCX Controls
  207. access query to sql serv view?
  208. Copying Files, Creating directories in Access
  209. Open an mdb file
  210. Module problem
  211. Required data Msg box
  212. code to disable an item
  213. Recordset using sql statement
  214. ActiveX Control
  215. VBA variable as criteria in parameter query
  216. Create a timer function in a module.
  217. changing the colour of a label in vba
  218. filtering a subform to display current week
  219. World Time Calculation
  220. filter subform between two dates without use of query
  221. Newbie auto-run module problem
  222. Timer Control
  223. Error trapping
  224. adding a new record with VBA
  225. Handling close instead of send using SendObject
  226. Message box icons, eg, critical X, info i, exclamation!
  227. Fill a group of fields
  228. Crash?!!
  229. Msgbox syntax help
  230. Disabling items in a tabular form
  231. Subform Filter problem. Please Help Me!
  232. Run-time Error 2105
  233. email problems....
  234. Avoid System Tables when exporting to csv files
  235. CDO for Win 2000
  236. Code to AddNew to Recordset only works part of the time
  237. recordsetclone not working
  238. Relationships - HELP!!!
  239. Loop through code assigning values to fields
  240. Database Transfer Option
  241. Calender control!!!!!!!!!!
  242. calculating a sum using a column from list box
  243. Record(s) can't be read; no read permission on msysmodule
  244. Access form in word
  245. Insert new fields through VBA
  246. Add up field values in a Loop
  247. urecognized database format
  248. Input mask on InputBox()
  249. Inserting from index ??
  250. Clear a table