View Full Version : Modules & VBA



  1. If...then
  2. creating fields + records?
  3. RunSql vs Open Query
  4. Different aproach
  5. open Visual Fox PRo object
  6. odbc connection
  7. Choosing an Access VBA Book
  8. Form Update!
  9. Get User ID - Environ("username") vs CurrentUser()
  10. All permutations / combinations that meet certain criteria.
  11. Two TransferText Problems
  12. String length maxxed at 255
  13. exporting data
  14. Strange Behaviour?
  15. how to duplicate record?
  16. FileExists Method (for Idb)
  17. Macro
  18. forms/subforms help
  19. Email Report!
  20. SLOW FileSearch
  21. this seems strange to me but...
  22. MS Jet DB cant find table or query
  23. Record filtering
  24. Using VBA to check whether a file in a folder in a certain drive exists.
  25. Accessing a module
  26. Date problem when running application on shared drive
  27. Change default find using code
  28. Color coding in Reports
  29. Calculate/Save XL Worksheet using VBA
  30. Null arguments
  31. delete user-selected table(s)
  32. HELP: Comparing data code
  33. Add refernces in code
  34. Dir Funtion?
  35. Hide Fields Unless Combo Option is Selected
  36. Multi User
  37. Background Color change on a Form
  38. Filter
  39. Closing Word from Access
  40. Problem going through records
  41. Calendar
  42. Calculated Value
  43. Adding record to a table
  44. How to call a Public variable in a query?
  45. Automatic Entry in a memo Field
  46. Automate Import Process
  47. code or query for household mailing scenarios?
  48. Global Variables
  49. record security
  50. Simple question...
  51. Making Message Boxes Look Pretty
  52. Is their a simpler way of doing this
  53. Creating an Xcopy Command
  54. Craziness!
  55. Creating Tables & Records
  56. Date/Time control
  57. toggle button controls visibility
  58. merge field calculation error
  59. Running Sum
  60. Play a certain sound on command
  61. Error in SQL statement
  62. correct syntax: bangs or dots?
  63. Relative Path (?)
  64. Inserting data from one table to Another Table
  65. Close current form
  66. Registering ActiveX
  67. Open subform on last entry?
  68. Using Controls within Form Sections
  69. Go To Record
  70. Worked in Access 2000?
  71. save info when close program
  72. character-in-string search function
  73. F11 Key
  74. Using content of selection in extended list box
  75. 30 day password
  76. record changes to records
  77. Open Report - pass filter params
  78. Multiple date entries
  79. RecordSetClone problem
  80. OutputTo Using MapPath?
  81. Help please
  82. Running Sum
  83. Breakpoints
  84. transform query into sub
  85. Red lettering on a form
  86. Open an Excel File, then save over it
  87. Disable Mouse Scrolling Functions
  88. Learn VBA
  89. Simple problem
  90. Allow Closure of Form if All Fields Are Blank?
  91. Create an control at runtime?
  92. Change caption on msgbox buttons
  93. Quick Question...
  94. Getting a value from SQL in VBA
  95. Reading from text file
  96. Funny Behaviour After Converting from 97 to 2000
  97. Close open reports first when exiting MsAccess
  98. Deleting Tables
  99. Timing of ADO vs. Form level events
  100. convert many records into one string
  101. Transferspreadsheet Using Vb6
  102. Automating Outlook Email from Access
  103. SQL Statement not working
  104. Vb Code to open file on cd-rom
  105. Blank Record Problem
  106. Help grabbing a list of Excel worksheets?
  107. linking to MS Project from MS Access
  108. Validating Data
  109. changing text in a form
  110. Emulate Transactions using Action Queries
  111. access crash
  112. How to write SQL statements in codes?
  113. Disable Mouse Scrolling Wont Work!
  114. RecordSource Problem!
  115. RecordsetClone.FindFirst not working?
  116. Enable button in a subform when certain form contains it is opened
  117. Problems adding a field in a record
  118. Importing Data has Invalid character
  119. Select all from listbox
  120. Please help a stupid person!
  121. whats wrong with this code ?
  122. Importing Question
  123. comparing dates against dates held in variants
  124. Reports in a ComboBox
  125. For Loop - For i = 5 to 1 NOT 1 to 5 (Decrease NOT Increase)
  126. Type mismatch
  127. Report to rft format!
  128. SQL Statement as Row Source...?
  129. RecordSet Inquiry
  130. Changing the Caption of a Label in a Report using Code.
  131. Duplicates error message
  132. Help on Query Codes
  133. For Each Next - I Don't Think So
  134. Changing Data in a feild automatically
  135. Another Parse ?
  136. Not e-mail a second time
  137. RecordCount
  138. Handling Returned Emails
  139. If then Visible Controls on Forms
  140. Import Multiple Worksheets With Same Column Headings In Same Workbook
  141. Record Update
  142. Command Button Images
  143. Reading from a file
  144. Filter
  145. Open and run A Macro in Word from Access
  146. Scrolling news using a record
  147. Autonumber screwed ?
  148. Formatting Text in a report according to a value
  149. Closing an Excel File
  150. Reading & inserting records directly from Excel into Access?
  151. OLE Objects - Which OLE reference library do I need?
  152. SQL statement
  153. Rollback DoCMD
  154. If / then question
  155. Converting Date to number of Days
  156. Search form
  157. Save Form As Report
  158. Subform record!
  159. SendObject
  160. .FoundFiles question
  161. Export text files to excel
  162. Using "SELECT" statement with a Recordset in memory??
  163. extract file name from path
  164. Create query object in ADO?
  165. File Title Properties
  166. combobox on tabular form
  167. If Statement Round a Cancel Button
  168. Boldfacing a subject line in e-mail
  169. Bulk Label Change
  170. Problem with For...Next statements
  171. Last Work Day Problem
  172. Running Access from Excel
  173. Create a bat file from VB
  174. how to return a value from a query to a variable?
  175. wot is the ! operator referring to in VB?
  176. Unable to edit current record
  177. Importing a CSV file not using Tranfer text method
  178. docmd.setwarnings code problems
  179. Advanced Email Handling
  180. Defining table records within VB
  181. textbox layout same as listbox
  182. Outputto method
  183. Undo Action on Command Button
  184. Switchboard Issues
  185. Need help working with tab-delimited file
  186. Emailing Objects via lotus notes
  187. Wildcards in Access 2000 Module
  188. Delimted text export writes random order?
  189. Replace add or delete
  190. Use data from Printer port
  191. Outlook Mail Properties
  192. transfertext with extra bit
  193. Filtering dates on a list box
  194. Docmd.OpenQuery
  195. Open form from another form
  196. modules backup
  197. Opening subform on last record
  198. Initialization
  199. Report title help/IsLoaded ?
  200. Automation Questions
  201. a general guide to replacing data from excel
  202. Adding Multiple Records
  203. Audit Trail Code?
  204. Button disabled IF new record
  205. Compact on command
  206. code for primary key check?
  207. DCount
  208. Help! Listbox from SQL statement
  209. Subform Filters
  210. check for empty/NULL value in controls
  211. DLookup
  212. Question about performance tuning
  213. Form is loosing its RecordSetClone
  214. DoCmd.PrintOut a report from a form
  215. list box with row values: 1-9999
  216. DLookup problem
  217. Synchronize using JRO
  218. Adding Records to a Table
  219. Help! I Can't Disable all Excel Warnings
  220. Using loops to run a report on missing values
  221. List box reflecting files not in access
  222. Active x calendar control (Mile)
  223. Function not recognized - undefined
  224. #error help
  225. Caught in a loop
  226. Print and Export confidential table data
  227. Access XP Compacter
  228. Updating a table from a form
  229. correct use of vb
  230. Vertical Labels in VB for ActiveX controls
  231. Function needed?
  232. How could I get the result of a query?
  233. how to use a value from a combo box in a report
  234. Make Access The Active Window
  235. Function returns missing data
  236. Adding and updating table records from VB
  237. Button won't delete in "user" view - only DB window view -- PLEASE HELP!
  238. Using public function from private sub?
  239. Calendar functions
  240. Code for combining household names for mailing labels
  241. Unhide/enable controls when certain value is chosen from listbox on form
  242. Add Delay to Loop
  243. If Statement with Dates
  244. OPen MS Word Doc from XP
  245. To Quit or not to Quit
  246. closing Word application when finished with it
  247. DSUM strange error
  248. Show a previous month in a calendar
  249. Scorecard Code
  250. Why Can't I Assign This Value?