View Full Version : Modules & VBA



  1. How to create access database from text file through coding
  2. List of record with Bitmap
  3. How do I install Add In
  4. Replacing VbCrLf with space
  5. Alerting
  6. Loop
  7. Stumped on "INSERT INTO..." command
  8. Hidden attributes
  9. ADO not DAO
  10. StopAction
  11. How do I append information to a field?
  12. string parsing function
  13. Filename with spaces in the 'Shell' function
  14. Move records to another DB
  15. Add In Not Displayed in Expression Builder
  16. New Access user requires help
  17. Setting Variable/Constant
  18. Compacting a Access 97 DB
  19. Double-saving == NOnoNO!!
  20. Need a little help trying to use CREATE TABLE SQL statement
  21. exporting a query as a text file through vba
  22. Phonetic match
  23. Folder Existence
  24. Changing the date format
  25. Access 2 and Word 2000
  26. Run-time error 3211 - New User
  27. DCount Help Please!
  28. screen scraping
  29. Email - Help
  30. Setting Focus on field problem
  31. How can I reuse functions in other databases?
  32. How can I delete all the records in a table?
  33. Running Excel Addin Macros from MS Access
  34. don't like the default
  35. Email Application
  36. Variable Table Name in From Statement
  37. Find Record in Form without Filtering
  38. Reassigning
  39. another sticky question
  40. Browse drive for files
  41. requery shuts down form!
  42. Changing "Visible" Property of Image Object from code
  43. Instant Computer Consultant
  44. Can't See the Forest for the Trees....
  45. Filter syntax problem
  46. Automatic Email
  47. combo box with list of available queries
  48. how to set subform = recordset?
  49. looping last column counter XL 97
  50. Outlook 2002
  51. image
  52. onclick event
  53. Create Folder
  54. Report Code Select Case Problem...
  55. List Box Contents as Text
  56. Alert/Message boxes for delete queries
  57. Sending E-Mails?
  58. Initiating "Merge it with MSWord"
  59. Send e mail only once per cycle
  60. run-time error 3251
  61. Copying a table from multiple databases
  62. Multi Select List Box
  63. How 2 transfer records from Access 1 table into another table?
  64. Debug window, Bugging Me!
  65. auto increment
  66. Changing Case
  67. Print reports using Module
  68. Populate a List Box by Function
  69. Calendar and records
  70. Code Help
  71. TsiCompact can't read password
  72. Disable the next button and the end of my data
  73. SQL relationship code problem
  74. Checking for connections
  75. Requery Code
  76. Download query from Access to Excel
  77. Automatic Access to Word Mailmerge: Sooo Close!
  78. library references missing.
  79. Getting info from Web Page to Access Form
  80. Date Transfer and Copy Via Code
  81. Multi Select
  82. Comparing passwords
  83. Tricky Pop Up Alert
  84. ASP DB connection
  85. search code
  86. Form Controls
  87. Auto scan images into Access
  88. Option Groups
  89. run module on opening a database
  90. How to create a code that does the following..
  91. Trim Function
  92. Can this be done?!!
  93. Need help with TransferText function
  94. .FindFirst Method syntax problem
  95. printing copies of 1 record
  96. Kernel32.dll
  97. Recommendations for PPT VBA
  98. Running alter table command on back end database
  99. Docmd.TransferText gives error ??
  100. Append query in code
  101. Validation Rule
  102. Cannot update. Database or object is read-only.
  103. No attachment
  104. Write code with code
  105. VB
  106. Calculating Time Intervals
  107. removing a Duplicate Option Statement error
  108. checking text files before importing
  109. Rename forms in external database
  110. Search Criteria
  111. Follow Hyperlink
  112. Add MS DAO 3.6 Object Lib In External DB
  113. findfirst ain't cutting it for me
  114. Can't set reference
  115. Transfer Text Action
  116. get round limit in the path length
  117. List files on subdirectories
  118. Restore deleted toolbar button for application
  119. Adding a customized text box in a report
  120. Import excel into access 2000
  121. Queries written in VBA
  122. VBA Check for change in record
  123. Duplicate check and find
  124. Loop for find/delete record (2 fields)?
  125. find duplicates from string and display msg box
  126. Syntax Error in code I wrote
  127. Hooking the dbwindow and report issue...
  128. If Then and MsgBox ?
  129. Complicated sorting problem
  130. Check value of a combo box
  131. Need help, not sure if this is correct...
  132. Search fields and show record code
  133. Open a Word document
  134. Attaching a help file
  135. Inserting charts in PPT
  136. VB variable in SQL
  137. move app from test pc to prod
  138. move app from test pc to prod
  139. standard module-public function
  140. Email Via Lotus Notes
  141. serch boxes
  142. Import Specs: getting only the one I want
  143. Refer to Control within a Tab Control in VBA
  144. Basic Append Query
  145. Child Master Link w/ unbound obj
  146. Dealing with different screen resolution?
  147. Requery
  148. UCase
  149. automatically populating tables
  150. Dsum and currency
  151. Using VB to find database path
  152. Check table for existing data via form
  153. Retrieving value of a combo box.
  154. Disabling Buttons
  155. Exporting query to excel
  156. Coding for faster data entry
  157. Access 97
  158. Select a Macro using VB
  159. Prevent Design View
  160. Open Report with DoCmd.OpenReport
  161. Creating an Access table in VB
  162. Passing Reference of Control to Module.
  163. Related table query and DoCmd.OpenReport
  164. Change printer with vba-code for forms
  165. Automatic entry based on a relative value
  166. MS ACcess and Authorize.net
  167. Codw works in '97 but not 2000
  168. Automation to outlook with different profiles
  169. Exporting to excel
  170. ESC Key in VBA
  171. Why won't my 'Do Until Rst.EOF ' statement work?
  172. NoMatch vs NotInList
  173. Dumb question BUT
  174. Create an Array of 3 variables
  175. I REALLY need help with a calculation.
  176. When VBProper works or NotWorks?
  177. Delete an amended record if incorrect
  178. Printer
  179. stLinkCriteria
  180. input masks
  181. Input to form - populated a field in 2 seperate tables....
  182. Form, Recordsource, On open event
  183. Disable Menus and toolbars
  184. Self populating a table from another table with a form
  185. Modules open in debug
  186. % Calculation
  187. assign array with values from a query
  188. Can't write to DB because someone else is?
  189. Procedure for AutoCorrect Function
  190. open folder
  191. Form for querying database
  192. Report Page Setting
  193. Synchronised Combo Boxes
  194. VBA code error
  195. Can't find project or library
  196. One box, many uses.
  197. Access Work Queues
  198. InStr variable
  199. Rowcount on a subform?
  200. Matching a date with a range of dates
  201. Major problems-PLEASE HELP!
  202. Can someone pls help w/ requery problem
  203. Hiding the DB window in Access2000
  204. Passing and tallying variables
  205. Automate mail merge
  206. Error mesage when running code on subform
  207. A simpler message box??
  208. Continue SQL statement on a new line
  209. literal recordset query
  210. Why doesn't this work?
  211. InStr problem
  212. Delete items without a parent
  213. cut and paste
  214. Translate old menu commands
  215. status update
  216. Get Sorting and Grouping info with code?
  217. Making sure a date falls on a Saturday
  218. To Pat Hartman - RunCommand Constants
  219. Use SQL Statement in Code to pull specific data
  220. DoCmd ... sometimes errors ... sometimes doesn't!
  221. Display embedded word documents in asp
  222. When no data in subreport
  223. Problem when opening Form
  224. shell function - specify startup directory
  225. disappearing value
  226. I need some help getting started
  227. Making an access app into VB app
  228. Open rst for update
  229. Problem with subform data based on form variables
  230. Report Design
  231. Updating a table using ADO !
  232. Thank You
  233. Compile Error. Help!!!!!!!
  234. Merging columns
  235. Automatic Compact
  236. Using Insert query in Module
  237. Transfer Table data
  238. Auto refresh?
  239. Help! No Read Permissions
  240. Global Variable in Paramater Query
  241. List Box Problem
  242. Using the Date Function
  243. Single quote error
  244. Subform and Sendobject
  245. Currency converter data update problem
  246. Restarting a database
  247. deleting a table and record at the same time!
  248. .Edit/.Update puts field into 2 records
  249. Insert into Date query
  250. Set a breakpoint does not pause a program