View Full Version : Modules & VBA



  1. Tired of using double protection
  2. email delivery failure
  3. VBA to check a box
  4. Data entry form to update a record without overwriting
  5. Dynamic Array Question
  6. Code for Printing a report is not working
  7. How to convert ODBCDirect DAO to ADO code
  8. Preventing duplicates
  9. Object variable or With block variable not set. Noobie here :(
  10. Me. Noob question...just wanting to be sure...
  11. Code to close form...
  12. Record Count problem
  13. Inacurrate calculation in a formula
  14. CheckResNo()=True... Validation Rule Error??
  15. unbound textbox errors when depending textbox encounters delay
  16. on click for cmds
  17. Invalid Use of Property!?!? ><
  18. How do I lookup a cell value (given row number and column number) and return it?
  19. Making function avaliable to all forms
  20. Date stamping records
  21. Difference between Access written code, and writing it yourself?
  22. Archive or Delete old Records with some complication :)
  23. Export Lookup Values and not their IDs to Excel
  24. Change label report layout based on record
  25. Project Management Tool?
  26. Reference Manuals
  27. Create multiple records from one user input?
  28. establishing table relationships.
  29. Compile Error help needed please
  30. Is _ an issue with VBA?
  31. Access and Excel quandry
  32. Can anyone see a problem with this code to close word without saving
  33. SQL Update syntax
  34. References 2007 vs 2003
  35. Incorrect Number of arguments when declaring sub
  36. Access VBA End(xldown) error
  37. Yes/No Combo box
  38. Visio 07 VBA/layers question - post here, or?
  39. Takeaway project
  40. Clearing Excel files with no records
  41. Hey my module stopped working
  42. Adding an email attachment
  43. Parsing and Replacing Data in a Memo Field
  44. Bah! I could use help with this! 'Select Case' perhaps?
  45. schedulling MS Access
  46. Use listbox to choos Query to Export??
  47. Logically update two fields in a table
  48. adding a new feild in a module
  49. calling a VBA procedure whose name is contained in a variable
  50. Import multiple workbooks into 1 access table
  51. quick syntax question
  52. Listbox with a "yes/no" checkbox column?
  53. Button to initiate hyperlink in field
  54. Openform Action Cancelled RT Error '2501'
  55. Too few parameters. expected 1 Error
  56. object variable or with block not set
  57. autoexec compacting issue
  58. form, subform and events ....
  59. Can't quite get the SQL correct
  60. Send E-mail from Query Results
  61. Type mismatch error
  62. when popup form is closed...
  63. DoCmd.TransferSpreadsheet - ACCESS doesn't see my query
  64. Batch instead of individual items
  65. Building Excel Pivot Tables in Access
  66. Allow Zero length in Table
  67. Export query; 1 record to a workbook and certain fields to worksheets
  68. RunTime error: 3075 - Dlookup Issue
  69. Query Criteria from Form textbox not working. Ideas?
  70. MS Access: Editing cell in Listview
  71. how to suppress the title in OutputTo' html table?
  72. event after find record?
  73. Pulling meeting replys to Access using VBA
  74. RunTime Error 2107
  75. Allow user to reorder steps in instruction database
  76. Exporting A Recordsource To Excel
  77. difference between two dates
  78. create text file with 50000 rows
  79. Opening an MSWord template from MSAccess.
  80. Changing values with mouse wheel
  81. Search Form Using Buttons
  82. replace 0 with / in number field
  83. dialog box in report
  84. Plannergrid
  85. Search Form
  86. Code to refresh form details after adding data in different form?
  87. How to use VB to make a custom error msg to replace the default PK violation msg?
  88. Help detecting Idle Time
  89. Upload excel into Access
  90. Run VBA when windows startup/shutdown/log on/log off
  91. write checks from Access in Hebrew
  92. VB to Check Duplicates then update two Linked Tables
  93. Create excel file from Access and enter 'Round' function in a cell
  94. Duplicating an Order (and all its parts)
  95. Audit Trail using VBA
  96. MultiSelect property of one control depend on value of checkbox?
  97. Finding Oldest and Newest Records
  98. one list to another
  99. Will Pay for Code!!!
  100. no data event report
  101. Change Caption on Another Form with VBA
  102. update Rank Order field
  103. Write formula in Excel w/Access VBA
  104. How to set input mask for a field using ADOX
  105. help please
  106. Catagorizing a person within a duration
  107. Using Initialise
  108. reversed references
  109. Can't use record set in sub-subs, Why?
  110. Clear form after update
  111. Calculating the number of records per user
  112. Avoid Acrobat to open
  113. Date function compile error
  114. Validation Rule to Popup Text Box
  115. SQL syntax error in VBA
  116. textbox as criteria for query
  117. Calendar
  118. Small modification to code
  119. Access 2003 - Formating Excel Column
  120. Problems with DSN-less connections
  121. How best to use Setvalue in later calculation
  122. Reverse words
  123. Grab selected item in listbox
  124. How to insert a number with eight or more digits in standard format?
  125. open multiple queries
  126. How to run a code?
  127. Error handling on new record
  128. ADO, VBA, & Hyphens.
  129. Problem with form SQL vba code
  130. lookup specific record number
  131. Else message box won't fire
  132. Recordsource report
  133. Importing specific fields from text file
  134. Moving data.
  135. Drop Changes or Copy to clipboard
  136. Entering Parameter Value
  137. Split database only allowing one user at a time
  138. End process from MS Access
  139. Problem Using Query in VBA
  140. Select Case Statement issue:
  141. Problem designating Excel file type when saving from Access
  142. Access noob - problem using query in VBA to change an object's property
  143. Cannot populate combo box with array
  144. Set variable for nested subform?
  145. Capture User Information
  146. Cannot create dynamic reference to subform control
  147. Calling Access Data into Excel Loop Question
  148. Reproducing RunMacro action in code
  149. Add error message to a table?
  150. Check my code
  151. Syntax help please?
  152. Populate Annual Calendar Report
  153. Determining in which table a value exists.
  154. Can't compare two dates?
  155. Alternative to DLookup?
  156. Trying to do a filter
  157. SubForm Actions within a MainForm
  158. Does VBA have an "OrElse" operator?
  159. Adding and deleting a record
  160. Path to the current Database
  161. Using Access 2007 for maintaining Access 2003 ADP projects
  162. Gizmo's calendar & ACC2000?
  163. Please help with conditional Validation in MS Excel
  164. result query in msgbox
  165. Display a Msgbox in a form based on a Query
  166. Force to open link table
  167. Code to show or hide contents of field
  168. Application.Ontime in MS Access
  169. Running Excel Sub from Access
  170. Passing variable between events within same form
  171. Closed Form not closed
  172. Getting Error
  173. How do i sum up all values in a field given some criteria?
  174. how do i look up the value of cell using access?
  175. Concatenate e-mail addresses from query into string
  176. Inserting into a field called ' Currency' problem
  177. Flickering message box when loading image on current
  178. Help with SQL code in Module
  179. Naming cells in Excel
  180. Using Mail Merge - question on VBA
  181. Output report to file
  182. Export Access form data into Excel template with check boxes
  183. Form coding help Please
  184. transfering data from the sub form into the form in ACCESS run-time 2007
  185. Average of a string?
  186. Taking over the Control Box
  187. VBA CODE HELP on boolean
  188. Purging Redundant Code
  189. Adding Voting Buttons to an email
  190. multi user form
  191. Error message 3847 rewrite code from DAO to ADO
  192. Calling a function from a command button
  193. Problem with Mouse Wheel in a sub form
  194. VBA to check if table, form, report exists in DB
  195. Interpreting Excel cell color
  196. Data type not defined?
  197. ColumnWidth question.
  198. Compile Error Method Not Found
  199. I need an example of a VB script.
  200. How do I append a field?
  201. Tables not able to be locked
  202. Write names of folders to table once added to directory?
  203. DAP exporting to excel as read-only
  204. Using Mailitem to send multiple emails
  205. Lookup record
  206. Auto Create button by VBA
  207. Lookup Table with Sub routines
  208. vba code that generate 3 random letters
  209. Maximizing the DB Window ONLY
  210. How do I delete a record?
  211. How do i delete all the records in a table but retaining the structure?
  212. How to get the RDN name
  213. Oulook displayalerts
  214. Create Table With Multiple Monthly Splits From Single Record Date Range
  215. Access programming
  216. Controlling the display of an image by another field
  217. Access VB, new records created from variables and loops etc
  218. Value not valid for field in Combobox
  219. Early Warning on Date Field
  220. Email attachments in 2003
  221. Report Preview Window Size
  222. Open Report from Form using Dlookup
  223. dial a phone number
  224. Text Box - Password Input Mask
  225. CurDir() in MS Access ???
  226. Applying Borders in Word Report - Object Unknown
  227. Not In List then fill in a form
  228. textbox to texbox on subform
  229. Find all currency values between a specified range
  230. How do we connect mainframe with hummingbird software.
  231. Opening form to slow
  232. Working Days but different condition
  233. Form and queries w/parameters
  234. Get XML data from webservice
  235. email address from access to outlook
  236. Quick Calculation/Formula Help
  237. UNC path vs. IP Address
  238. 3 conditions to be met by 2 different fields
  239. tax problem
  240. Error handling: report bombs at VBA function when query returns no records
  241. Bitwise comparison and optional criteria
  242. Object error on a DLookup
  243. Inserting maintable's autonumber to subtable field
  244. Need some help.
  245. Button Always Appends 8 Rows Instead of 1
  246. SQL and VB
  247. Listbox Column Head
  248. VBA code for matching Records in DAP
  249. Command button to send all clients email through outlook
  250. Code Boxes