View Full Version : Modules & VBA



  1. Error handling not execued second time
  2. Combo Box Value in ElseIf Statement
  3. Help on "missing operator" error.
  4. Missing Reference ????
  5. outputto new worksheet in existing workbook?
  6. Year Value
  7. Unable to open database.
  8. Using a form to select data from a query using SQL
  9. Access to Excel and Modify
  10. Bypassing table update confirmation screens....
  11. Forms/Sub-forms
  12. Coding Help - Email Reports
  13. Freeze Columns
  14. Create an mdb file using VBA?
  15. Login Form + Code
  16. Email with attachment?
  17. Complie error: ByRef arguement type mismatch
  18. Stop Opening The Form
  19. Stopping a crosstab query sort fields alphabetically
  20. Date format in filters
  21. Using VBA to send an email.
  22. Link Criteria Question
  23. Excel User Defined Functions (Modules)
  24. Opening an external database
  25. Suppressing Alerts in Access
  26. What event for "HOVER"
  27. Find Record/SaveRecord
  28. Can't figure out why this will not work
  29. End Of File error
  30. pages within a control
  31. Trying to get a first module to work.
  32. load id from text box on pressing enter
  33. Customised Record Counter
  34. declaring global variables
  35. Delete Issue
  36. open form
  37. If, Then, Else
  38. Help with Delete
  39. Date Problem
  40. form to form VBA
  41. Compile error: variable not defined
  42. Hard Case on Weekday
  43. Database File Path
  44. updating feild in access through serial port input!
  45. ADODB.Recordset multiple queries
  46. call to a macro in a module
  47. Automatically generating a report title
  48. Maximum length when declaring a variable As String
  49. getopenfile_CLT
  50. Syntax error in Insert Into Satement
  51. Adding array info to a table
  52. Call an Access query in a Module
  53. simple code snippet required
  54. open a table with a filtered view?
  55. picture linking.
  56. football management have problem
  57. "Refreshing" reports...help please
  58. If checkbox checked, then grey out text fields
  59. Alter query criteria based on current object
  60. Text Box Character Count
  61. Addition
  62. “EASYLABEL” and “MS ACCESS”
  63. Code need to search data that contains (-) sign
  64. Why do I NOT get a duplicate key error ?
  65. Open Template from MS Access.
  66. open sample database
  67. visual basic v6 crashing
  68. vba and .net
  69. me.requery help
  70. StartUp
  71. Adding validation, if cell not complete prompt messge?? help??
  72. VBA Help Need
  73. StartDate/EndDate question.
  74. Requery a sub form
  75. Help with code
  76. Coding help please...
  77. VB Code won't run after Windows Update
  78. email - thru Hotmail account?
  79. Validation Check
  80. Adding items to a combobox
  81. KabirPatel
  82. Re: Write text from a list box to a table in MS Access 2003 (VBA)
  83. How Insert Embedded Picture with VBA
  84. Menu Creation With Vba
  85. Vb6 Drivelistbox Dirlistbox Filelistbox Activex
  86. Access debugging
  87. Inserting text from module as a hyperlink
  88. Working with listboxes
  89. Date Formatting
  90. Removing Action query prompts
  91. Switchboard questions
  92. Pulling records from a query in VBA
  93. Capturing Path from a FileDialog Open Procedure
  94. Source of recordset in listbox?
  95. Using FirstFirst with an ' in the value
  96. Writing to a HTML file so i can display as a web-page
  97. "Indirect" Function
  98. Import to append and upate?
  99. Static Array Question
  100. Security for VBA
  101. Open debug window from code
  102. display login name
  103. General Advice needed - cascading combo's
  104. Audit Log provided by Allen Browne
  105. Blank data causes crash with word bookmarks.
  106. Syntax
  107. Modifing a Stored Query with VBA
  108. Automatic dialling
  109. Problem with form resize
  110. Display email before send
  111. Import csv and split data
  112. Code to open form in add new record mode???
  113. change application title
  114. What is the group of my currentuser
  115. Create new table with VBA
  116. retrieving parameter query records
  117. Backup without Zipping
  118. Error Creating Multiple Excel Sheets from Access
  119. Run-time errors, coding errors, a catalogue of errors
  120. Custom error codes
  121. Error Handling Overkill?
  122. Table of database defaults
  123. Acccess 2000 Help...
  124. Run-time error '2448'
  125. RunTime error 3070
  126. Use of For Next Loop with an array
  127. Passing a Variable to a Popup Form.
  128. Help with compile error
  129. Copy & Paste in VB
  130. Trouble showing correct records from Combo box
  131. Help with Code
  132. adinteger declaration in ado
  133. Referencing Tables
  134. Access 2003 Import
  135. Macros to run Queries with different values
  136. How to read BDD.OpenRecordset(SQL). Code Insert.
  137. Montrer resultat sql
  138. Help
  139. Checking for existing record in multiple tables
  140. Referring to main folder
  141. change default language
  142. Delete Field Code
  143. want to retreive current user name in windwos
  144. Date plus three
  145. List Box Transfer - Overflow error
  146. Check if file exists or not
  147. How do I download and save a file from a website?
  148. "Solver" Function
  149. Searching every row
  150. VDA entering data
  151. Listbox Right Alignment
  152. Click On Record Return Same Record On Another Form
  153. ADODB.recordset update values
  154. Where is my .mdw file?
  155. Check field format through VBA-code
  156. Using a ADO Connection with SQL Stored Procedure
  157. PivotChart Properties
  158. Help with deleting files
  159. SetWarnings fails on second hit.
  160. Form Name Argument???
  161. basic IF statement problem.. i mean basic
  162. Option Box Code Help Please
  163. Code produces error (Trying to iterate through rows in a Table)
  164. Populate variable using SQL
  165. VBA Disable outlook message
  166. comboBox.text=Error
  167. Too few parameters. 2 required.
  168. Database file location
  169. Open Outlook from Access
  170. Cascading Combo-boxes
  171. 'Close' Button
  172. Getting the drive and directory info of an access database
  173. close form.. add a delay or close after event
  174. Trying to send email
  175. Rounding Issue
  176. Msgbox code
  177. Access 97 passing object ref to subroutine
  178. Sort Recordset then add consequtive numbers to a non-key field.
  179. Converting a hex file...
  180. Display Query Results in a Message Box
  181. Data from form to report.
  182. Multiple Users Access
  183. Update: "locked by another session" ???
  184. Update Subform Control From Another Subform
  185. Question - Browse for Files/Folders Dialogue
  186. TransferText using a CodePage
  187. Bookmarks in Word stopping at first blank record
  188. Reading info from form to report/query
  189. one listbox to another..
  190. Error Checking Problem in Access 2003
  191. runtime error??
  192. Method for retrieving fields from multiple tables
  193. getting column data
  194. VBA to Scroll the Application Window
  195. Question - Trimming text in OnClick() Event Procedure
  196. Listbox refresh problem?
  197. question about range and input boxes...
  198. Do Bookmarks have a limited length
  199. List Box
  200. clear a list box?
  201. Get module to run from macro and not just open the editor.
  202. Debugging in Immediate Window
  203. Access Front-end Auto-Updating Utility
  204. Writing to a table
  205. Error Handling
  206. clear a field if condition met
  207. OpenRecordset with Multiple Tables
  208. subreport problems
  209. Switch Board help please
  210. command button visible
  211. Writing to a table with a variable as the field name
  212. Orderform Problem
  213. transferring a variable or data type
  214. basic else if problem
  215. Question - Adding Hyperlink command button with dynamic output
  216. Please help
  217. Writing Quotes in a variable
  218. Error message when running on a WXP machine.
  219. Need help with email function
  220. Access Trigger
  221. Copy tables and their relationships?
  222. Need Help with address fields
  223. Do I use the seek method?
  224. How to declare this variable
  225. Control with VBA import from Excel
  226. Importing and Parsing Records
  227. Lost network connection handling
  228. Task bar help
  229. Elapsed Time
  230. Check for email
  231. Rounding of numbers?
  232. Access Reports to Adobe 7
  233. Help with ADO - if record not found...then
  234. Option Group ! Please help
  235. Passing a variable from access to excel.
  236. Page Set Up Reports via code
  237. Best Practices question
  238. Using Attachments in Access 2007
  239. Newbie: For Loop RunSQL Question
  240. Multiple Reports to Multiple PDF's
  241. updating a table using a command button
  242. Recordset update results in badly fragmented file
  243. Trying 'Patch' existing form module
  244. TransferSpreadsheet help please
  245. VBA to add two or more strings
  246. RunCommand and Save As and PivotChart and Data Access Page
  247. How Insert Picture into Unbound Object Frame with FilePicker (OpenFile Dialog Box)
  248. Can I copy files from 1 folder to another
  249. String Manipulation
  250. Making Objects Become Visible On Timer