View Full Version : Modules & VBA



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