View Full Version : Modules & VBA



  1. StrComp Function
  2. Automatic date conversion
  3. use loop to reference ME control
  4. use a variable as a pathname for Dir() function?
  5. Package and Deploy Wizard
  6. Code in subform triggers Active X Error
  7. Update
  8. array issue
  9. how to read multiple records using a loop?
  10. visibility
  11. Delete Current Record
  12. Add Item to List Box
  13. American Holidays - For TessB
  14. Link to Excel
  15. Image
  16. Start Word Macro with variable
  17. QueryDefs Not Working
  18. Focus
  19. Coding error
  20. Not a lick of VBA
  21. Help
  22. Enter ZIP CODE Get CITY, STATE
  23. Code Help
  24. Request for help - Trying to use default value in CREATE TABLE statement
  25. Seaching Tables
  26. DCount Problem
  27. Adding Value To New Record In Tabledef
  28. making a timer on the image
  29. Importing csv file where do not know the full filename?
  30. Calendar Control - Stop Future Dates?
  31. Compile Error???
  32. Passing Variable
  33. dmax issue
  34. Sorting & Counting
  35. Reference a subform object
  36. How to make database password one time only ?
  37. Create date
  38. coding problem
  39. Create Recordset from a word table
  40. A colo(u)r chart for VBA
  41. Decorating cmd buttons
  42. openrecordset
  43. Pull in date of file
  44. Filter Option Group
  45. compare two tables, add records that are different
  46. Login Form with 20 passwords
  47. HELP! Comparing tables, please.=)
  48. Update VBA code triggered by check box
  49. call a sub from a seperate object
  50. shrink to fit
  51. add a GoToControl Action
  52. calling procedures
  53. Referencing a field name in a table
  54. time conversion remake
  55. Printing records & images in order
  56. Active X Controls...
  57. Code Problems
  58. Retain trailing zeros?
  59. Security Login Asthetics
  60. Trying to insert error messages into a table
  61. Link to Excel file
  62. Error with Code
  63. Would like to start new records with PK
  64. Drop Index with VBA
  65. Use leading Zeros
  66. Solution: Import data from Word to Access
  67. Adding a field to a MakeTableQuery
  68. empty text box
  69. problem opening recordset... Type Mismatch error
  70. How do I code this??
  71. Finding a record
  72. something wrong with docmd.openform criteria
  73. ASDD COLUMN "order" problem
  74. Code Changes
  75. Trouble coding Iff in VBA
  76. Access File Properites
  77. Creating an Excel Object
  78. Limit the number of charachters in a Word cell
  79. Import from Text File
  80. String Manipulation For List??
  81. 91 object variable problem
  82. Moving to record
  83. Import Export Functions with VBA
  84. Works on my machine but fails on server
  85. transfer text files to tables
  86. Counting how many times a button has been pressed
  87. Comparing Data
  88. Retrieving data from array
  89. Shell(MD ...)
  90. reference field in recordset....by its index?
  91. Request for help - Querying recordsets as if they were tables
  92. Create a query with VB
  93. Automatically backup database
  94. Security Issue
  95. Handling relative filenames in the DB
  96. StrComp
  97. File List Generator?
  98. Query Results = 0 Then Add New
  99. Mailing
  100. Date validation (if today - 1 week then)
  101. Refreshing
  102. Calendar Query!!
  103. Help, trying to make directorys
  104. Random Autonumber through ADO
  105. Listbox Population and search help
  106. File Export Dpecification deletes file
  107. Calling information from a Web Page
  108. export form to word
  109. Include Autonumber as part of new value
  110. Reference problem
  111. Trying to Return a list of duplicates
  112. multi select
  113. list box driving filter..
  114. Straightforward: Open external database, execute external function
  115. Emailing -- Body message
  116. Insert Single Quote into tables
  117. AddNew problem
  118. Transactions in Access
  119. Adding subforms to form using VB
  120. Question about code
  121. Refresh/requery subform after data added
  122. export (dynamic file names)
  123. Detecting user IdleTime then check value in table..stuck?!
  124. Record set based on security login
  125. Attendance Tracking
  126. SQL Statement
  127. Help with code
  128. Overwrite existing CSV file using FSO Movefile
  129. open an excel file that has spaces in the filename
  130. Hex() and/or Hex$() problems
  131. custom search form
  132. Help with code please
  133. What am I doing wrong?
  134. CopyObject
  135. Please help with fOSUserName()
  136. Enable/Disable a control
  137. Automatically Change and Fill in Table Fields
  138. Creating a customized report number
  139. Count the columns in a table
  140. Pass variables from a subform?
  141. Exporting text to CSV
  142. Col Header in Transfertext - I don't want Quotes
  143. My head is about to explode !
  144. Check my code please
  145. dlookup error
  146. Checkboxes, multiple queries and a spreadsheet
  147. newbie needs help
  148. Calling Super programmer Mile-O-Phile!
  149. Distinguish between multiple selected/unselected subform records
  150. This Operation is not supported within transactions???
  151. RecordsetClone problem
  152. Find record to form
  153. Case Conversion
  154. find records from number of charachters in a field
  155. Coding a word into a textbox
  156. Insert Item Into DropDown
  157. "On Not in List" event
  158. Commandbars
  159. Multiple Email Addresses to Send Object
  160. DoCmd.TransferText acExportDelim
  161. Importing external file - module not picking up the data
  162. Connecting database to VB
  163. Compacting with SENDKEYS "%TDC" doesnt work....
  164. Set Value in subform - beginner!
  165. Method or data member not found
  166. Formatting Fields in a Table Using Access VBA
  167. Date Range Help, Please!
  168. DateAdd function
  169. Custom format for date
  170. Please Take a look at this error Message
  171. Need help with code
  172. Opening/Saving Images To DB With VBA
  173. How to know witch user is login
  174. Coding Security
  175. Variable as a text box name
  176. Linking a Database
  177. Variables, values and strings, and loops - NEWBIE
  178. Getting VB code to wait or pause
  179. VBScript files
  180. Passing Subform as Variable
  181. IFFs and splitting in a query
  182. VBA not deleting with Form
  183. Change Lotus notes email account
  184. OpenCurrentDatabase
  185. Open a file
  186. Acees 2000
  187. Assigning a recordset to a form
  188. change field type from text to date
  189. Navigate a Query
  190. Assigning a recordset with multiple records to an unbound form
  191. Icon Transparency
  192. Code required for searching unlocked records in multi user situations.
  193. USe ODBC to Overwrite Table
  194. Date() returning wrong date (30/12/99)
  195. vba toying with me
  196. How to turn off Access auto commit
  197. Checking record count for Filter parameter of Form
  198. Failing Sendobject
  199. VBA not in sync with rest of database
  200. Odbc
  201. DoCmd.TransferText from TextBox Form
  202. And Operator
  203. Basic Programming question
  204. Dlookup Error
  205. Big problem with code
  206. Strip first character
  207. Why use DateDiff
  208. Edit Hyperlink Address
  209. VBA Help
  210. SQL generation
  211. Export query to Excel code problems
  212. Revise the code please
  213. Getting data from a text file and execution an instruction
  214. Form_Object.procedure variable
  215. ADO Help! / Field Properties
  216. Database On A Network
  217. How to kill a process?
  218. E-Mail question
  219. Change path of linked table
  220. I need to write an IF statement that dos a conditional search of a text string
  221. code
  222. Check permissions for user in VBA?
  223. Code on Combo Box
  224. Text file as Body of Outlook
  225. Sorting text by numbers
  226. Date Time Stamp ? Restore/Backup?
  227. Save Record Error
  228. Wizzards
  229. Microsoft Internet Transfer Control (MITC)
  230. Create a Default Value
  231. Fill control with previously written text
  232. Email Problem (Run time error 2287)
  233. ADO, DAO problems in Access 2002
  234. VBA Delete table module
  235. Access2002: Docmd.OpenReport Error
  236. help with docmd.openquery
  237. Local time to UTC
  238. Creating a reporting tool - PLease Help
  239. Module not found.
  240. attaching files to email
  241. Calculating Business Days
  242. SQL string not working as expected (hoped)
  243. Removing double quotes and extra spacing from a field
  244. VBA or Queries ??????
  245. Source for a report
  246. Seeking forums for Excel and Visual Studio
  247. Object required error
  248. Write characters to PRN or LPT1
  249. Updating named records in a table
  250. Using Write # removes character returns?