View Full Version : Modules & VBA



  1. SQL and Like
  2. one value based on a many values
  3. Email Mailmerge to multiple recipients
  4. avoid creating an error table when using DoCmd.TransferText
  5. passing date value from ListBox to TxtBox
  6. Report snapshot woes: runtime error 2024
  7. Help with error
  8. Duplicate Button
  9. database performance problem
  10. Finding duplicate records using VBA
  11. Transpose a table
  12. ADOX relationship creation
  13. Insert Record
  14. Use field condition to open correct record "Newbie"
  15. Help?!
  16. check if true
  17. Select case and invalid use of null
  18. Close ADO Connection?
  19. Manipulate QBE Query with VBA Code
  20. AddNew and variables
  21. Dependent validation
  22. Processing
  23. commas in text/memo fields
  24. Execute function at database startup - how?
  25. How to add click value in the table?
  26. Sorting
  27. Null value not being picked up by if statment
  28. Send records to outlook
  29. Export Table to Text File
  30. Running Reports in Succession
  31. filter a ServerFilter for Word Mail Merge
  32. Help with DLOOKUP?
  33. De-dupe
  34. Help troubleshooting simple code
  35. Recommend a Word Mail Merge Method
  36. referencing more than one cotrol
  37. Security Warning Updates
  38. Value from record w/oldest date within a range
  39. DLookup HELP!
  40. Running Message
  41. VBA in DAPs ?
  42. How can I make this order in the table?
  43. Help Building A String!
  44. Using quotes with Instr
  45. Instr and wildcard
  46. Creating Outlook appointment
  47. Joining Filter Criteria
  48. Finding text in string
  49. PLease help, problems with selstart & sellength not working as expected
  50. DSUM Problem
  51. Make a Table
  52. Table to button code
  53. Extracting data from attachments in .msg files
  54. Dlookup fields not able to undo
  55. Can I copy files and folders with VB...
  56. Help! Filter by Date
  57. Subforms (open with criteria or GoTo ???)
  58. Link Access Table to Table in Word
  59. Detail_Format
  60. Make Table with WHERE clause - HELP!
  61. Date cell copy from Excel to Access table
  62. Excel Trend function in Access
  63. testing Combo Box Values to Table
  64. Date order problem
  65. Sum until current record
  66. Refreshing The Database
  67. Timestamp
  68. Desperate for Help - VBA output to Excel Trouble
  69. Using Dlookup
  70. Retreiving Field Data
  71. export to Excel
  72. Concatenating Subform Details
  73. Listing Folders
  74. Backup Database OLE or DDE Error
  75. Pulling the record souce object out of Report from a FORM
  76. Create and delete table: refresh?? HELP!
  77. Export to Seperate Excel Sheets Same Workbook
  78. Color current record
  79. First Try at Updating via code Help please
  80. IsHyperlink and Textbox control
  81. Reffering to single form on continuous form view
  82. Clear Column in Table
  83. JMail in VBA
  84. Access Warning Msgs
  85. 'Modul not found'-error shutting down db.
  86. Overwriting text file and adding the name of database
  87. VB Code problem, field lookup not working
  88. multi-select list box, multi-user environment, error 3421
  89. Hiding Columns in Datasheet View Subform
  90. formatting excel sheet
  91. Compile Error - Failure to load Dll
  92. Delete Extra fields
  93. Data type mismatch in criteria expression
  94. Error: The Command or Action 'SaveRecord' isn't available now
  95. using access to update powerpoint slides
  96. Cancel timer event after one instance
  97. Fetching other value from combo than the selected
  98. Adding a record in a table unsuccessfully
  99. Multiple results for textbox
  100. treeview vs treectrl???
  101. Public function not recognised in 2003
  102. SQL to Variable - Help Me Please
  103. Very simple Vba code
  104. Can I use a trigger?
  105. Basing textbox on choice from combo box.
  106. Archive tables within the DB and put time stamp
  107. Removing a trailing ;
  108. No UD functions return values...
  109. Make a form look like Windows Explorer
  110. Default Value from entry in another table
  111. Report Output as a File
  112. copy files to folder
  113. can it be done?
  114. Filter Table Problem
  115. Real Date format
  116. concatenate textbox name
  117. 0 as a first number problem.
  118. command button help!
  119. Form help
  120. =GenerateWhere() Help
  121. Loop through folder and print all files in folder
  122. Data Field Format
  123. AutoCompact
  124. Loop and modify all Excel worksheets
  125. Outlook Routing Slip
  126. Problem with App.Path
  127. Usage of Percentile WorkSheetFunction...
  128. Date format for Mail merge for Indonesian language
  129. Button Control Class Not working
  130. About references?
  131. modules and macros for download
  132. Using Recordsets to find records in VBA
  133. Copying cells in same column with command button
  134. User and Group accounts
  135. Emailing Out Automatically From Access
  136. Print an MS Word document??
  137. Connecting to secure database
  138. formating form or report fields using VBA
  139. avoiding duplicates in string problem
  140. Can't Get If Statement To Work Right
  141. Using a variable within a module
  142. Synchronize
  143. Error : You can’t go to specified record
  144. Mouse Wheel Woes
  145. User-Defined Type Not Defined
  146. DLookup Error
  147. Open a query with a parameter
  148. Undocumented Filter?
  149. Searching for keywords in Word-documents
  150. Moving between records
  151. Joined tables - deleting rows (ADO vs DAO)
  152. Dynamic MultiDimentional Array
  153. What event to refresh subform ???
  154. Set focus to textbox without selecting text...
  155. Updating a database
  156. field yes/no database
  157. Dynamically loading another record from table
  158. Glitch in trapping code
  159. Test if query contains no records...
  160. Run-time error “3201”
  161. Append problem
  162. Change backcolor field in datasheet view
  163. Error handling
  164. simple code question
  165. Copying records between identical databases
  166. How to display the image in a form with relative Path.
  167. New record 'change' flag
  168. copy text from one textbox to another
  169. Dim cnn As Connection
  170. confusing declaration
  171. changing RecordSource of a form and/or report with VBA
  172. Help with Run-time error '70'
  173. Drag & Drop in Access 2000
  174. Query in SQL
  175. Create a data retrieval sheet
  176. Problem with Bookmark, Runtime Error: 3022
  177. Select Case with Time
  178. If then EOF Parameter Query
  179. insert in DB many records
  180. Set Col width on SpreadsheetCtl 9.0???
  181. Send hidden email
  182. Which event on datasheet
  183. Query Based on Combo Box
  184. acFormatRTF creates Excel file
  185. Breakpoint stays after reboot
  186. Docmd.RunSQL for Union
  187. Conditional footer
  188. Camera Interface?
  189. Error Handling SWitched Off !
  190. Error in switchboard (opens macro that stats vba code)
  191. Locate Open Word Documents
  192. Problems with OpenReport function...
  193. Edit a Table Using VBE
  194. Using excel's "workday" function in Access
  195. Opening a file in "quick view" mode?
  196. Property Let/ Get
  197. Syntax to check multiple criteria with If
  198. Missing reference
  199. Change detail background colour on continuous form
  200. Requery when navigation button clicked
  201. Get extra records into Datasheet
  202. Importing Automation
  203. VB question on List Box
  204. Input Validation
  205. Data Base Entries are too slow
  206. Soundex/Extended Soundex/Metaphone Algorithms?
  207. Binary File Conversion
  208. MS Queries in VBA
  209. ListView.AddItem???
  210. Table collection and linking tables
  211. Minimize to System Tray
  212. Add a record from a bound subform to an unbound subform
  213. Updating Access table from transaction records
  214. find username
  215. Passing Parameters for Subreport
  216. Mail merge then save document as str name
  217. Authenticate database deletion
  218. Reverse Instr()
  219. Help with Runtime error 2001
  220. Search function chokes if there is no match ...
  221. ElseIf Code
  222. Value entered isnt valid Error
  223. How to find if database is opened?
  224. Using the password input mask
  225. Not Enough Space on Temp Disk - Error 3183
  226. Open a text File and interrupt code
  227. Big multi-user mixup, need help
  228. Two mini queries!!
  229. #If...Then...#Else Directive
  230. FileDialog(msoFileDialogOpen) - get selected file name
  231. Microsoft Outlook Object Library
  232. Evaluating Null
  233. Simple SQL statement
  234. enabling formatting options in runtime
  235. Form criteria using a list box
  236. Backup table data to new database
  237. Custom function with "automatic" variables
  238. Null=Null ??
  239. Execute DTS package
  240. Excel with VBA
  241. OpenArgs Arrgh!
  242. Variable X axis on a Chart
  243. Record retreival based on multiple combo boxes
  244. advice request
  245. Export Updates on a table to excel
  246. Check table if fields exist
  247. Refer to parent form in standard module
  248. Debugging VBA
  249. Programmitically altering Graph Properties
  250. SQL Syntax Error