View Full Version : Modules & VBA



  1. Send parameter to Macro from VB
  2. OpenReport command not picking up parameters from form control
  3. VBA Module to redirect multiple Linked Tables
  4. Docmd.Printout not printing all labels
  5. Visual Basic :: MetaStock Data Format
  6. Looping through query to rank records
  7. CurrentDb.Execute "INSERT INTO
  8. VBA Function
  9. Repeat Element Of Code Based upon Subform
  10. How to make this function more efficient?
  11. Make the Access database used by users on 2010 and 2003 both
  12. Microsoft Jet engine cannot find a record in the table
  13. loop help
  14. Loop Help
  15. Modifying an Access Pass through Query using Querydefs
  16. Event procedure for command button
  17. Compile Error: Method or data member not found
  18. Problems with Record Selection
  19. Access 2003 frontend and Access 2010 backend
  20. daoRS.FindFirst not setting the located field with focus when Form is a Subform
  21. Error in loading dll
  22. Transfer Excel range to Access table
  23. Changing values in a report using DMax()
  24. web service based on wsdl schema
  25. if-then problem
  26. Controlling the size of a listbox with VBA?
  27. Listview Font Size?
  28. Open and update spreadsheet
  29. Msgbox... 2 columns?
  30. Error 2105 - cannot go to specified record
  31. Button opening PDF File
  32. Quick Question about Me.Dirty
  33. Moving Global Variables Module results in "Compile error: Ambiguous name detected~
  34. Checking multiple controls for a value
  35. How do you resize a popup box upon trigger?
  36. Writing vbAND function
  37. Formating book mark text inserted using automation
  38. Date format with TransferText
  39. Turning ordered quantities into unique rows
  40. writing queries to .txt file
  41. Code to save report in pdf to a particular folder
  42. Use dcount with time criteria
  43. Search for value&modify in an unattached table
  44. chart using variable values
  45. Form BeforeUpdate Query
  46. Email and Outlook
  47. Populate a dropdown box using vba
  48. conditional formating
  49. VBA Clipboard.GetImage equivalent
  50. requery not working becuase miscoding(I used look up field)
  51. VBA/Relationship help?
  52. Using HREF from field in Access in Outlook
  53. Help me exec this SQL statement
  54. Is there anything necessarily wrong with how I've done this?
  55. Filtering
  56. GetObject Statement Causes Error 462 - Remote Server Does Not Exist...
  57. HTML Tabbing (I Know) and Currency Formatting
  58. On Exit event Issue on multiple subform controls
  59. Vba code help
  60. Generate new Unique number
  61. Generate new Unique number
  62. error when compiling
  63. Fill multi column combobox
  64. Filter string: between dates
  65. DLOOKUP and date = null... but I know it is there!!!
  66. Str() seems to add a space character, why?
  67. Auto update in separate forms
  68. Column value's to text box
  69. Open Word document
  70. Select Statment in VBA
  71. Delete file or all table after certain period of time
  72. Fetch data from Access to Excel
  73. Access & SQL Server
  74. Multiple connection strings
  75. String: space but not a space?
  76. SendObject/Email
  77. Creating If statements using a for loop for an array of check box controls
  78. Recordset.Update produces application crash
  79. New to VB & Module and trying to make this work
  80. Compare data between two recordsets - only update fields where different
  81. Runtime Error '424' Object Required..
  82. Exporting and Emailing a Report
  83. Programmatically changing the password on a .accdb or .accde Database
  84. Logical error
  85. Events not triggered by code?
  86. Referring to a sequentially created variable
  87. Date Selection
  88. Pass text box value to Access Pass Thru Query
  89. combo box filters report
  90. Using VBA to write a URL
  91. VBA to refresh and publish Excel graphs
  92. Increment Time
  93. Open an Access 2003 report from Access 2010 form using vba
  94. delete a record in subform
  95. Date value
  96. Passing recordset in OpenArgs
  97. Set value in text box based on combo box
  98. Dcount Type Mismatch
  99. Type mismatch error at certain iterations of a for loop...
  100. Visual Basic,NET - Not inserting correct date.
  101. Grabbing windows user name
  102. IF statements to Open Forms (Access 2003)
  103. Error Handling Loop...Stuck Inside!
  104. Retains Particular field Entry in Form & SubForm
  105. Function support
  106. Retrieve ComboBox unbound column in record set
  107. Vba declarations
  108. Diff Form_formInvoice.txtInvoiceID and Forms!formInvoice!txtInvoiceID
  109. Select Case Numeric issue
  110. Refresh open Recordset
  111. Creating Google calendar entries (Access 2010)
  112. Events in Pivot Table
  113. "End If without Block if" error
  114. Dcount with date and user criteria
  115. The code gives wrong result.
  116. Conditional updating/insert into tables
  117. Finding the highest value
  118. ActiveX component cannot create object 429 Error Windows 7
  119. Get Text from Web and Put in Table
  120. It's not a date, it's a string!
  121. Looking through 1 column of a recordset
  122. DAO.Recordset not returning any results
  123. docmd.runsql 3073 runtime error
  124. Run Time 3075 error on combo filter
  125. Sum all values and alert
  126. so simple yet it eludes me
  127. Problems with "{" "}"
  128. Import from Excel
  129. Import .txt files with file name
  130. loop though csv file, zipcode error
  131. ADO error 3251
  132. Error: Microsoft Access has encountered a problem and needs to close.
  133. Excel Sheet to Maximize thru VBA code
  134. VBA/Module Query Automation
  135. data type mismatch in select query?
  136. Datatype mismatch error 3464
  137. Dynamically linking to an Excel sheet
  138. How to Fire VBA Code when a Calculated Textbox Changes Its Value
  139. vba rs.update causing odbc error 3146
  140. My VBA Code Vanishes - HELP
  141. Subform refresh hangs
  142. Splash Screen Woes...
  143. Determine if Snapshot Viewer is Installed
  144. help with nested if and open a certain form based on field data
  145. Extracting numbers from a string
  146. Referencing Form Fields
  147. update table from another table
  148. Query second highest value
  149. When to create modules
  150. Run-time error 3067
  151. Referencing Access Cells with VBA
  152. Strange results of a VBA IF Statement
  153. Working on an SQL Insert / Update combined
  154. SELECT TOP 1 problem
  155. Proper Case function
  156. Text & Memo data - Show scrambled
  157. Find Record
  158. VBA Type Mismatch for link criteria
  159. Email automation without Outlook
  160. Open new form based on this record
  161. Export Information to specific Cells in Excel by way of button
  162. Import from Excel using Import Spec
  163. Outlook Automation Hanging On Address Book
  164. The Ribbon - good reference material?
  165. Show Navigation Pane
  166. Password protect switchboard startup bypass
  167. SQL and VBA
  168. Need help with VBA SQL sytax
  169. 3625 error - can't find import spec.
  170. export report PDF
  171. Go To Record
  172. Keep Excel File In Foreground To Allow User To Edit It
  173. Copy Paste in Access Form: Pls Help
  174. String Function
  175. VBA code to count the total number of cases done by each user
  176. UpdateFE - Can someone please help me understand the code?
  177. Dcount with date criteria error
  178. Module and Macro
  179. Select Outlook Profile to Send E-mail
  180. Syntax error in query expression '#'
  181. Holidays Weekends and Due Dates Calc Form
  182. Auto State and Postcode from Suburb
  183. Run-time error 3075 - Syntax error
  184. Duplicate Form/SubForm/Subform within subform
  185. For Each Control - identify control by name?
  186. How to change the form title or caption from VBA.
  187. Updating multiple tables after updating form control
  188. Multi File import
  189. mass email with different content and address
  190. VBA code doesn't work as required
  191. IIF does not work if outlook is open
  192. VBA SQL syntax
  193. Post XML to a URL inside Access
  194. Pass parameter to Append Queries
  195. attachment question
  196. Replace Function Statements Subverting Automated E-mail
  197. get data from a asp .net web site (java script)
  198. OK this one killed me
  199. Moved MDB to Win 7, Date function doesn't work
  200. Code Extremely Inefficient
  201. Button Two Actions
  202. Lotus Notes and Access
  203. Relatively Basic Double-booking help!
  204. Need VBA Class Guidance
  205. If controls are null exit sub else run search
  206. trigger event after new record added
  207. Quick Helo Plz with Update Sql
  208. IIf formula not working in VBA
  209. Interesting issue with the Front End Update Tool ( basFEUpdate )
  210. String comparision in selection
  211. How do I read a Table by the Primary Key?
  212. Problems using TransferSpreadSheet
  213. Weird behaviour, focus dissapeared
  214. Setting a variable value using a SELECT query
  215. Referencing ADO or DAO
  216. Can I Enter Sub Name In On Click Property?
  217. Can Sub & Form Button Have Same Name?
  218. Schedule MS Access report to be sent out as PDF documents through MS Outlook
  219. VBA for Payroll form
  220. emulating a stored procedure
  221. code tweak (word merge)
  222. Preserving Historical Info
  223. Help in DLOOKUP Function
  224. AfterUpdate Combobox, TextBox = Query
  225. Error Handle "unable to append all the data to the table" Prompt
  226. Help with VBA\MySql statement
  227. Runtime error 13: Type mismatch
  228. Runtime Error 3011
  229. OutputTo PDF action cancelled
  230. Recordset General Questions
  231. Help with VBA and attachments - recordset2
  232. Need to assign a query to Combo boxes using VBA.
  233. VBA Loop addition
  234. Recordset problem
  235. DoCmd.SendObject - Custom Filtered Report
  236. How to Retrieve Extended File Properties
  237. Access/Outlook Automation
  238. Losing Formatting & Pic Position in Rich Text Template Automated Send
  239. Filtering on sub form wont work...
  240. Website Navigation question
  241. VLookup/WorksheetFunktion not working
  242. vba dynamic hyperlink
  243. best way to process a string
  244. Join a Saved Query with a QueryDef
  245. Sendobject method-Multiple objects?
  246. SendKeys to compact
  247. Deleting some files from a specific folder
  248. Create PieChart from unbound form?
  249. Help with Password Login
  250. My query code doesn't work