View Full Version : Modules & VBA



  1. Challenging CmmndButton
  2. Custom Date Function Nightmare!!
  3. Launching particular parts of Acess
  4. Disable Right-click
  5. ActiveX Calendar Current Date
  6. Compact Command
  7. pauses in code
  8. Sending Email on a machine with multiple profiles
  9. Copy imbedded OLE object to hard drive
  10. How to send an email using Outlook Express
  11. Invalid Argument - Database Size?
  12. problem with an expression
  13. vbKeyPrint
  14. NT Accounts/Logins
  15. Cmd Button to add record in subform
  16. Import .csv file problem
  17. Open the Calendar from Outlook Express
  18. Can I Append an Array to a table???
  19. msg box code
  20. Updating links in an Excel Workbook from Access
  21. Synchronized Forms - New Record
  22. Increase & Decrease Numbers in Qty field
  23. Sorting Data in A Table-Type RECORDSET
  24. Import and export problem
  25. Problem with incrementing numbers
  26. Making standard letters in Word with VB
  27. Making a backup copy, with out using a DOS macro file.
  28. Duplicate Data & SubForm
  29. Expressions in Access2k
  30. Combo box ListIndex to -1
  31. Using the ActiveX Calendar Control
  32. msgbox
  33. E-mail using Outlook
  34. TabControl OnClick Event
  35. Sum values
  36. Option Group Filter
  37. Modules
  38. SetWarnings
  39. Varible not defined error
  40. Finding records and printing reports-HELP!
  41. Too few parameters in openrecordset line
  42. Format Number
  43. Dynamic Reports
  44. On Error Handling
  45. Calculate TimeDiff
  46. Change RecordSource at Runtime
  47. SQL Within VBA
  48. Line Spacing in Reports
  49. Comparing 2 files
  50. When to Perform a Split Database
  51. Creating recordset then string problem
  52. Msg Box for user input
  53. finding a record from the contents of a text box
  54. using MAPISendMail to send EMail with VBA
  55. How to determine whether a table exists
  56. How to return Fractional Work hours
  57. Finding a record by using 2 combo box!
  58. Maximize forms
  59. Short-cut Key for View Code?
  60. Understanding of Bookmark and RecordClone
  61. Controlling toolbars On Off by VB Code
  62. carriage return in a message box
  63. SQL String
  64. Module not working
  65. Network User logon
  66. Does any one out there know ?
  67. VB problem on a report (its a strange one)
  68. PopUp Messages
  69. Detecting Screen Size Automatically
  70. Can you import Tasks from Outlook into an Access Form?
  71. OMR Scanning linked to Access Database
  72. save reports to file
  73. Database Password
  74. too many concurrent users
  75. WorkDays Between Dates.Zip
  76. Need Help with Finding Records using Criteria
  77. How to get the full path to database
  78. Weekday( ) function troubles
  79. importing files from excel
  80. Writing QueryDefs
  81. Opening MS Office Apps from within Access
  82. Changing Printer with VBA
  83. Record Navigation
  84. Date Validation
  85. File Conversion...
  86. Suppress Update Confirm
  87. Inputbox Input Mask
  88. Error 13 (type mismatch error)
  89. SetFocus
  90. Reading ASCII Text File
  91. Responding to Negative Values
  92. Hiding db window and Error 2046???
  93. Common Dialog Control
  94. Search and Import Files using Modules or Macro
  95. deleting a query
  96. deleting a query
  97. OpenRecordset...Should be simple!
  98. Workday function
  99. Using Code to respond to negative Values
  100. Access Search Page
  101. median and mode calculations
  102. Record look up and Max number set
  103. Referencing a subform
  104. Checking for nulls and setting focus
  105. Access97 application remains open
  106. VBA ? SUB REPORTS ?
  107. Specifying a Path when importing
  108. Assigning Records
  109. Update Statement
  110. VBA Relationship Management
  111. Addnew
  112. does a table exsist????
  113. Second time I ask, can ANYONE help me???
  114. Updating from a Linked FoxPro table
  115. If-Then-Else statements in VBA
  116. Code not running
  117. Form and Subform
  118. Subtraction Problem
  119. ASCII Codes and CHR$
  120. Truncate or Trunc()
  121. Printing Multiple Copies of a Report
  122. Positioning in a Subform
  123. scanning a docuement to a specific record
  124. Automation - Turn off Excel Links
  125. change database
  126. Please can you help??
  127. Select Case
  128. Contains
  129. Lookup Field
  130. Linking a OLE Object but speifing a path using Browse button
  131. maintaining relationships while importing tables
  132. Mod Function?
  133. Webpages
  134. Make a copy of a TableDef
  135. Report per record
  136. create file for output + name it current date
  137. Variables
  138. Sorting an existing table through VB for Access
  139. Calculated value in a table
  140. add new record to a customer
  141. Skip Function if Table is Empty
  142. Check if Folder Exists
  143. Msg Box with a cancel option
  144. Dlookup problems
  145. Evaluating Controls with If IsNull
  146. Access from Word
  147. Novice in Need of Serious HELP!!!
  148. User Permission Error
  149. transferring data from access to excel
  150. Sending data to Winfax
  151. Function to test if an application and file is open
  152. Help in Validation
  153. Placing cursor
  154. error message
  155. In Need of an If statement
  156. Calling a .bat file
  157. Confirming Recordset Updates Succeed
  158. Error Code 3022
  159. waiting on a form to close
  160. Search for Records
  161. To have a fixed number of space between each field when exporting data.
  162. How to MOVE a text file after importing it?
  163. Moving Field Values
  164. picking out text
  165. delete one fields value.
  166. set a reference to a report
  167. Working with Null values in a recordset
  168. Methods to Open a Form Thru VBA
  169. Database Replication
  170. display something based on combo box
  171. Number of elements in an array
  172. executing queries on click event
  173. ActiveX Component Cannot Create Object
  174. ActiveX Component Cannot Create Object
  175. Multiple Select list boxes
  176. visible property
  177. replication with password protected machine
  178. recordsets collection doesn´t work
  179. Adding OLE objects to Access Table automatically
  180. Making label visible...
  181. How do you drop part of a file name...
  182. Tough One
  183. Path-Selection: CommonDialog/WinAPI possible?
  184. How do I cancel an event from being carried out??
  185. Loading a combo box
  186. Invalid use of Null (Error 94) - Need help w/ Code
  187. Renaming file names
  188. Sending automatic email notification using SendObject
  189. I just don't get it!!!
  190. a button with 2 functions
  191. search page in access
  192. refresh combo boxes
  193. Weird problem: Can't find Project or Library
  194. Open a particular form on first opening of a database.
  195. Using and event to update chnage an event!
  196. Access Runtime
  197. Building a Recordset
  198. dim as database in 2000
  199. How to search wisely in a recordset
  200. Email attachments into Access
  201. Can Access administer a TEST?????
  202. Hiding the Access Window
  203. Finding out who is logged on.
  204. Converted Macros
  205. Procedure too large? What does this mean?
  206. opening and closing forms with 1 button
  207. update values in a subform based on a value in a main form
  208. VB and Keystrokes?
  209. Importing external data
  210. Closing Recordsets in Nested transactions
  211. If Or Then Question!
  212. Remove a Filter from a Recordset
  213. Time / date Quandry
  214. create table from param query
  215. how can I copy data field from form into data field in table
  216. JOINING FUNCTIONS
  217. sub standard subform
  218. Can I slow Access down?
  219. Canceling Key Press
  220. How to find first order
  221. Help with dim statement
  222. Is there a CurrentGroup() function?
  223. Send Object addition
  224. show values in one Combo box based on values selected from another combobox
  225. Assigning control source at run-time..
  226. Debugging?
  227. Updating Controls
  228. assign a record
  229. Compile Error:
  230. Multiple Filter Criteria
  231. Code not working in 2000
  232. validate data and cancel if answer is false
  233. UPDATE statement - at wits end - Please help!
  234. is there a code that forces data entry?
  235. Time Calculations
  236. vba5.dll help
  237. OLE Automation
  238. Data Validation
  239. Forcing uppercase letters in a control
  240. After Update
  241. Import Macro
  242. Report Date Range Expression
  243. ODBC Connections to Access
  244. query on time
  245. 1000's of text files!
  246. code that copies text
  247. Using Power point in Access
  248. Cannot Set Form Property AllowDesignChanges - Get Errors
  249. Import Outlook E-mails
  250. can somebody please help a complete idiot with the DLookup function?