View Full Version : Modules & VBA



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