View Full Version : Modules & VBA



  1. Enable Button
  2. Thousands and Thousands and Thousands of New Records
  3. getting message to say YES while sending mail
  4. On View Change
  5. Searching tables and displaying specific data in forms
  6. Pausing vba until click
  7. Creating a log using text boxes.
  8. saving OLE-objects!!
  9. Making a field required
  10. icon+text buttons
  11. SQL Question
  12. Open a DB with a variable.
  13. Outlook question
  14. linking multimpler fields between forms
  15. table refresh
  16. How to find out information on form's current record
  17. Access 2007 - Error Message re: New ADODB.Recordset
  18. Problem in where to Use Module to Get it to Work
  19. Get record quickly without duplicates
  20. Reference Current subform control dynamically
  21. importing text files & using it for relationship
  22. Export a query output as csv format
  23. Capturing login information in Win Server 2003
  24. Tricky Import
  25. First Post: Upgraded clients computers to Office 07 and now have problem with code?
  26. Debug help!
  27. Merge to word using Doc Props & Template
  28. Using Shell to open and hide an application
  29. reading out path for table link
  30. value conditionated field
  31. Import Daily File Names to listbox
  32. Add a customer
  33. Shell command and return focus to Access
  34. Outlook
  35. Do Until
  36. Outlook tasks
  37. common code
  38. change the chosen record in a listbox
  39. Problem calling function
  40. Runtime Error 3061 Too Few Parameters Expected 3
  41. Run-time Error 2118 - You must save the current field before you run the Requery acti
  42. Export to Excel
  43. Unbound textbox to filter a different form
  44. Breakpoint removed, yet program stops at that point
  45. Attachment control in form
  46. Referencing the field ID in a multi-selection list box
  47. Challenge - Search function!!!
  48. Access to Excel Macro Automation Error
  49. Date Function
  50. Help with Runtime Error 424
  51. Error Accessing File Message!!!!
  52. Adding data to a table from a multiselect list box
  53. Importing a Table with DBF Extension to Access
  54. Print Records Between Headers
  55. Using wildcards
  56. Recordset Cursor and Lock Type
  57. An easy way to find a number in a table.
  58. resizing a picture
  59. INSERT INTO using data from a form AND a table
  60. Opening a Word doc embedded in an Access OLE field
  61. Delete Report After E-Mailing
  62. DSUM VBA and stored variables
  63. DAO - TableDefs
  64. construct dynamic field references in VB?
  65. Chisled effect characters
  66. Loop or Running Totals
  67. String replace doesn't always work
  68. Update Query by VB issue with Date field
  69. Counting number of records in query in VBA - problems opening the recordset.
  70. How do I trap error: "The text is too long to be edited."
  71. VBA Newbee
  72. Exclusive use of DB for User Login
  73. What is the correct syntax?
  74. Question about open form process
  75. Using code in Access Pro 2007
  76. Setting values in Continuous Form
  77. 3061 - Too Few Parameters. Expected 2
  78. DSum function results on Single data type
  79. Database or object is read-only problem
  80. Populating a table from multiple spreadsheets
  81. Setting the position to enter text
  82. Setting value of record in table
  83. .value
  84. are my if statements clashing?
  85. Cycling through Records? in Allocation Problem
  86. Runtime Error 3061
  87. Select record with blank in specific column
  88. Place values in new record on subform in continuous form view
  89. Converting code from DoCmd.SendObject to SMTP
  90. Mod Operator returning wrong value
  91. How do I insert an underscore between two alpha characters using VBA.
  92. How many users opening a BE .mdb?
  93. selecting report to open by Yes or No
  94. concatenate a return space
  95. Linking files to a database from a specific folder
  96. Transfer VBA created DAO Recordset to MS Access Table
  97. Code won't run on all PC's
  98. Intermittant error - does not pick up contexts of tet box
  99. Wrapping IF Statement
  100. Writing a table to a word document
  101. Access range Excel objects from Access
  102. Using Excel functions within Access
  103. Is this procedure running right now?
  104. Need Access VBA similar to the given Excel VBA
  105. store one selected from the combo box into a variable.
  106. title for the msgbox
  107. Run-time error '2185'
  108. Closing OpenRecordset connections
  109. Is it possible to Enumerate the properties collection of a Control?
  110. Calling public sub from another form
  111. _.CurrentView
  112. Inserting records comparing two tables
  113. For Each...Next not looping over entire TableDef collection?
  114. Working with a List
  115. Send query separated on tabs?
  116. Mixed data types
  117. SQL Update Query Issue
  118. OnCurrent Code Change Report No
  119. GoToRecord
  120. Data Loading help using VBA
  121. Using Conditional VBA function within a Query with a Date fiedl
  122. Importing a single Excel cell to multiple rows in Access table
  123. if statments with select case making query slow
  124. On The Fly Link -- Password protected
  125. Err - Object Variable Or With Block Variable Not Set
  126. How do you delete the contents of a table using VBA?
  127. Splitting database causes VBA error in form
  128. Tweaking required fields
  129. Folder Dialog Option
  130. Clear Value of a field after delete records
  131. Opendatabase Method & Linked Tables Performance
  132. Using BULK INSERT from module
  133. Quicksearch Form issues
  134. Iterate Macro Items
  135. Sorting out indexes mess
  136. Opening Excel from Access
  137. Delete all rows in Excel document except Row 1
  138. form opens at very tiny size
  139. Use of References
  140. Dont add record to table if any field is empty
  141. IsTrivial function (or Banana needs more caffeine)
  142. Can I use ctlRef.ItemData conditionally?
  143. Nearest Less than Value
  144. Help with my Calendar - One for you VBA'ers
  145. Access 97 Error performing LEFT() on a memo field
  146. Data from Form to XLS and result from XLS back to form. HOW?
  147. combo box to change sortorder on list box fields?
  148. Can't find the field '|' referred to in your expression
  149. Loading a table with the results of a query
  150. Update Form automatically
  151. Open pictures in access
  152. Loop problem
  153. Filtering a number from a String
  154. Another Excel formatting question
  155. How To Construct a Looping Function
  156. Help with Access checking if a window is open
  157. Loop through SubFolder of a Subfolder
  158. Global Variables Help Urgent
  159. How to Convert a TEXT or BOX back and forth
  160. Close external program
  161. AutoNumber field primary key
  162. What is wrong with this if statement?
  163. SQL String Problems
  164. Problem formatting telephonenumber
  165. Update two tables with save action
  166. Access Redemption Outlook
  167. DateDiff and some operations with it
  168. Convert 600 to 6.00
  169. Global 'search and replace' function in Access?
  170. Can you save a file with yesterday's date in the file name?
  171. DSUM - changing criteria values with VBA
  172. ODBC Connection String
  173. Edit Recordset
  174. Reference current value of Looping Variable
  175. When there is any new record, how can I export it to another table?
  176. Unspecified Error in SQL
  177. How do you modify a control by using a string formula?
  178. Import data from outlook
  179. Inserting UserId into table after login screen
  180. Problem with null values
  181. IsNull Problem?
  182. Query with COUNT (DISTINCT...) and Data Types
  183. DB security
  184. use combobox to populate the form
  185. users not running MS Access
  186. Access 2003 report - Nested Select Statements
  187. D-look did work before, but it is now "RUN TIME ERROR 2001" suddendly!
  188. Append data to Access from Excel - Runtime error 3270
  189. Run Time error 3001
  190. rs.movefirst doesn't seem to move to the first record
  191. Query being deleted!
  192. Import data in text datatype
  193. Automatic field name implementation
  194. Please help!!!
  195. Acc MailMerge: Bullet style? duplicate bookmarks?
  196. all macros --> VBA in VBA
  197. Subform management
  198. Why does this code work as a sub on a label but won't work as a module
  199. Anyway to retain object focus when scrolling through records?
  200. Create New Records Automatic
  201. Form not auto-filling with data.
  202. Duplicate "one-to-many" Recordsets
  203. Code to Copy Files
  204. Saving Method Failed
  205. No Current Record
  206. Playing A Sound File (.wav / .mid)
  207. Application defined or object defined error (1004) with Excel
  208. sql syntax error in embeded select clause
  209. use text box to control combo box content
  210. Label blink/flash once or twice only?
  211. Array = [table]![Column] - How?
  212. Export to text help.
  213. DAO Delete record loop not working
  214. Delete a row
  215. Extra Logic Layer
  216. Method for adding attachment not found
  217. Error "Update or CancelUpdate without AddNew or Edit"
  218. Referring to the Backend database
  219. Upload file to server?
  220. Vsto & Access
  221. Moving Excel files within Access
  222. Can show tell me that can I do this by VBA
  223. Not sure if I need an array
  224. Inserting table tields as part of text
  225. Getting the registered owner - got the code but need help
  226. Concatenation Function Issue
  227. Converting Time from Seconds
  228. Undefined function in expression
  229. Applying payments to invoices
  230. ACC2000: Year Calendar Report
  231. Delete Relation from VB - incomplete job
  232. Split string (Path)
  233. Importing Html into Access via VBA
  234. class modules: why?
  235. Help-Ref Table Field in VBA
  236. Form Buttons No Longer Working!
  237. Form Buttons No Longer Working!
  238. Count If
  239. Copy Records Using SQL
  240. 2007 to 2003 function problem
  241. Deletion Question
  242. Run Time Error
  243. Combo Box Won't Find Copied Records
  244. fuction to click a command button
  245. Search for part of a file name
  246. Code Help
  247. Importing Excel to Table
  248. Dynamic query export to excel - HELP
  249. extraction
  250. FindRecord --> Record not found