View Full Version : Modules & VBA



  1. Subform and FindRecord
  2. SQL Update query not running (might be confused by if statement)
  3. Simple Button Problem
  4. Linked Tables
  5. Microsoft Outlook Objects
  6. Shell with acrobat reader
  7. Over My Head...Please Help If Possible.
  8. Disable print in form
  9. cc: on an automated lotus notes email.
  10. Find missing numbers based on user inputted variable
  11. backup SQL Server database w/o Ent. Mgr.
  12. Declaration error
  13. Faulty searching with VBA,SQL and forms
  14. creating formfield on run time in ms word
  15. Dates, Recordsets, SQL HELP!!
  16. Create Folder and copy in it
  17. Filter
  18. Keeping focus
  19. Cannot access public property of a subform
  20. Open a website in access
  21. Import TXT files not csv nor tab
  22. Export to Excel
  23. Special Character in INSERT INTO query
  24. Having a records calculated field get info from previous record
  25. listing all tables / fields
  26. File Integrity - obtain checksum
  27. include template when sending mail
  28. Number of weeks in a month
  29. Run-time Error 2169
  30. Achiving/Moving a single record at a time
  31. 3264 "no field defined--cannot append tabledef" on create temp table from query
  32. Another missing reference thread
  33. Create Menu Bar with VBA
  34. Open Form When Access Window Become Hide
  35. Start OnClick event outside the form
  36. Filter subform based on combo box selections
  37. Cant delete last record
  38. Relinking an Excel Spreadsheet
  39. Holding down a key to confirm an action
  40. Permission Denied from Switchboard
  41. "Browse" Button Needed
  42. Multiple Users add new row in Table
  43. TransferSpreadsheet command - use of Ampersand in Worksheet names
  44. Action at set time
  45. Error Handling
  46. "unrecognised database format"
  47. Non-Event to trigger a wav file
  48. DoCmd.CopyObject when not only user
  49. Running a SQL string
  50. The White Screen
  51. need basic code for a message
  52. auto enter site info from one excel to other excels
  53. help to take value into a variable
  54. Time Calculation
  55. Date formats
  56. FileCopy overwriting files
  57. Mail Merge problem - Word cannot open data source
  58. Email from Access
  59. Refresh Queries
  60. Attachments
  61. Copy rich Text to Outlook
  62. Quick Question About Combo Box
  63. Control is null in VBA
  64. connecting databases and comparing fields
  65. Make read-only recordset updateable
  66. Set Calendar Control Date other than Today
  67. Loop with unknown number of elelments
  68. Inactivity Timeout
  69. Environ
  70. tablesdefs.count is returning an incorrect value, way off!?
  71. Audit Trail Version: 2003
  72. Error help
  73. Exclusive Mode
  74. Query with Paramater
  75. Access to .Net
  76. VBA - Skype
  77. Changing form properties based on group permissions
  78. Save en closing all open Excel-files
  79. Backup Dbase at a specified time
  80. 5 Text Boxes...Need to display DB info
  81. Pop-up with Available id only
  82. Searching
  83. Can You Guys Help Me?
  84. Using a part of a var, last 3 or 4 letters
  85. Returning last character of a string
  86. Alternatives to FileCopy?
  87. Access email Body, Data Access Page
  88. Monitoring Data Change
  89. Writing to table in VB
  90. Hide Access Window
  91. Searching a field for a value using IIF
  92. Capturing UserName and Populating a Name Field
  93. Requery and Bookmarks for Recordsets
  94. Invalid or Unqualified Reference
  95. Parser help needed
  96. Not able to pass array as an argument to Let Property
  97. using sql in the code window
  98. Optimize Recordset update - speed
  99. Importing Data and Transformation
  100. Updating a recordset
  101. Simple programming question about creating fields
  102. DLookUp and Parameterized Query
  103. All Records from a query and only matching from another
  104. Delete only one column from table
  105. Change active tab in a tab control using VBcode.
  106. Email to names in table.
  107. To call a form with details from a table through a search criteria
  108. Validation of Form based on three fields
  109. Supress 'Printing...' dialog
  110. Sending email to a table
  111. Delete temp table in VBA
  112. Navigating data in a subform
  113. Something to Share for a little help
  114. Now() but! always the 1st
  115. query (on the fly) doesnt show empty records
  116. Saving and calling a variable from a field
  117. Code Help
  118. Going to New Record
  119. Emailing current record/screen, if poss?
  120. complex(?) code?
  121. Exporting XML with predefined hierarchy and attributes
  122. syntax error- Rrequire help
  123. Comma woes
  124. Please try and help
  125. submit button should be deactvated before entering the password
  126. DLookup on 3 numeric fields
  127. Transferspreadsheet Range option in regards to worksheets in excel.
  128. Urgent Help with VBA and Design!
  129. Generate 100 records in one go
  130. Using variables in SQL update
  131. Problem Using Array
  132. Import multiple excel csv files into access
  133. Verify first 2 digit of zip code
  134. DSN less Connections
  135. Dlookup and Checkbox
  136. GoTo Record in subform datasheet from a search on main form
  137. command bar sub menu problems
  138. stock code
  139. Leading zero in automatically assigned number
  140. Problem while adding values to Listbox
  141. Help with IF statement
  142. Referencing combo boxes
  143. Problem with query results when called from code
  144. Label Captions
  145. Need help for Complex VBA
  146. shade excel cells grey depending on another cells data?
  147. Masking Password
  148. locking excel cells after data is entered
  149. Error Trap Linked Tables at Startup
  150. Me.Controls
  151. IIf function evaluates falsepart when truepart found
  152. Backup and Restore Data
  153. Establishing Record Number
  154. Importing text file
  155. conditional formatting
  156. GoToControl
  157. Recursive method problems
  158. Bring minimized form back in focus
  159. suppress error messages (2)
  160. Set Part of SQL String
  161. Automating Access from Outlook
  162. Stop execution of code while a FORM is open
  163. Unable to validate other user names and passwords from the Domain or Network.
  164. Using Data Entered as variables for multiple queries
  165. How to use excel fields in access forms
  166. Importing Excel Spreadsheet to a table
  167. Using The Date Class
  168. how do I change the value of a field
  169. common dialog
  170. For... Next code not working?
  171. Requerying Data
  172. Stop second import
  173. runtime error 1004
  174. Difficulty with INSERT INTO, query
  175. Update SQL - What am I doing wrong
  176. Importing text files into Access
  177. DELETE Functions!
  178. INSERT w/ VBA
  179. Append with VB
  180. SQL statement works in query, but on command button
  181. Error Closing Form Runtime 2585
  182. Best way to automatically add records to a table (i.e. trigger)
  183. Calling the SynchronizeNow Menu Command
  184. Listbox .additem
  185. Loop
  186. Help With Code
  187. Getting current user name (not signon name)
  188. Transfer of application from VBA to VB.net
  189. Critical Errors in Access2003
  190. Moving to objects
  191. Code to create graph gives a runtime error
  192. Problem adding to time
  193. DSum and Between
  194. Accessing MySQL tables using FTP
  195. loop problem
  196. Want to Initate a Mail Merge
  197. quick tab nav question
  198. select statement
  199. Clump dates into one pay period
  200. Indexed property
  201. Formatting issues
  202. Option Group Issues
  203. Problem with .listcount
  204. Listbox .Requery
  205. Query in VBA Syntax!
  206. Best event to update everytime
  207. Listbox .additem
  208. Obtaining the Name of the Active Control
  209. Problem with If Then...
  210. No Data on Reports
  211. Concatenating Multiplr If's
  212. Open Report from Form
  213. Resolve Dynamic Reference
  214. Database Exit
  215. Run VBA Script on Link
  216. Access properties of file programmatically
  217. When Double Clicked Enters Todays Date
  218. Line function in reports
  219. Updating backend oracle tables from MS Access
  220. "IF" code needed
  221. Insert Object only from a specific folder
  222. help with on-the-fly query as source for recordset
  223. Multi-Select List box via function
  224. Timer and countdown
  225. Correction of password code
  226. New programming standard for Access VBA
  227. MS SQL 2000 tables linked to Access 2000
  228. How do you display &
  229. Rnd generates same number after closing and reopening the database.
  230. Incrementing a value
  231. How Do I............
  232. Would like help with error checking/validation (I think)
  233. Custom ActiveX Component in MSACCESS2003
  234. How to run function at any worksheet changes?
  235. Access on network
  236. RunSQL
  237. Using Is Not Null in a function
  238. HELP ME relationships
  239. Returning computer name
  240. Type Mismatch
  241. E-mail using Send object
  242. Automating Numbers
  243. Count files in a folder
  244. Bolding control name
  245. create and save a form
  246. Access VBA Question
  247. String Conversion
  248. making header and footer with code
  249. problem after deleting a record
  250. making a button with code by clicking a button