View Full Version : Modules & VBA



  1. Create a graph in MS Excel from MS Access
  2. ListBox & Conditional Formatting
  3. Movement within a form
  4. Send Message
  5. "What's This" type button
  6. VB Dir function - not working?
  7. Creating a report with pre-formated text
  8. Stop dialog box
  9. Change Event vs AfterUpdate
  10. Some Access to Oulook stuff
  11. Import and Append Data
  12. Overflow?
  13. Formatting Excel Spreadsheet within Access error
  14. Copy TableDef from one DB to another
  15. Locked records nightmare
  16. VBA Formula for: Last Day of Last Month
  17. Simplify an update from a Control box
  18. how to stop an excel process after opening in it access 2003
  19. Mail Merge problems with a text file
  20. path requester for linked tables
  21. Run-Time Error 2465 in Controls syntax
  22. Simulating MS Project Type Hierarchical Views of data
  23. Assign a recordset to a continuous form.
  24. Updating data in "Find Record" combo box when current record on a form is changed
  25. Type Mismatch when Set myRS
  26. Refreshing a subform
  27. TransferText : Lookup and remove duplicate records automatically
  28. New to VBA
  29. How to select a table to delete from another database
  30. Email parameterised report
  31. List Box Refresh When Filtering
  32. Create keyword list from doc, pdf, ppt, etc. files?
  33. Import unknown multiple Excel worksheets into Access
  34. An "Unsubscribe" button/link on emails?
  35. Code No Longer Works with Access 2007
  36. Generate a Table of Contents for a report
  37. Populate combo with list of form names
  38. SQL Date formats within VBA
  39. Using a file but not importing it, Excel,dbf,Text
  40. Microsoft Common Dialog
  41. Code For Warning Message
  42. DB Password
  43. Dcount problem
  44. Expression on Click
  45. using Me.Undo on form causes 'You can't go to specified record' error
  46. If Then IF issue?
  47. How can I include criteria selected as new field?
  48. Changing Combo Box Values Based on Previous Input
  49. Lotus Notes return receipt
  50. SELECT Statement syntax
  51. Loop email. Attaches wrong report
  52. Type Mismatch on db.OpenRecordset
  53. Need VBA code for Update Table Record, Need help?
  54. Waiting for a textbox to update
  55. Copy portion of a string
  56. Recordset criteria problem
  57. Modifying Ghudson's Browsing Example
  58. Help with VB Loop
  59. Loop and Recordets
  60. Dlookup help
  61. Control over a timed MsgBox possible?
  62. Type Mismatch Error
  63. Using Office 10.0 (XP) References in Office12 (2007)
  64. Average an entire record
  65. Encrypt/decrypt
  66. IE Scripting problem from Access VBA
  67. SQL Help Please! + 1 Other thing
  68. DLookup on query in external database
  69. Mysteries of the Outlook calendar labels??
  70. Delay
  71. Error with DDEInitiate
  72. DateModified Property maybe?
  73. Problems Using a Search Form
  74. Error using MODI "Object hasn't been initialized"
  75. Updating date in table produces bizarre results
  76. Import Spreadsheet Into Access - Issue
  77. Can't open secondary db to full screen
  78. Cannot refer to form controls after coded change to acDesign and back to acNormal
  79. FSO CopyFile Problem
  80. Opening an external file from Access
  81. Postmessage API question
  82. Importing a list of CSV files using VBA
  83. Macro to VBA
  84. Calling Excel macros from within Access
  85. Checking for Data Entry
  86. Help with a function
  87. Close all forms in one command?
  88. Formatting issues with Excel from Access VBA
  89. Updating Reports programmatically
  90. 3 List box's
  91. taking code from txtbox/lstbox and inserting into record set.
  92. Capture Input Mask Error before Access does?
  93. Limit for operators in a SQL string
  94. InputMask - setting quotes
  95. (Re)Connecting to Multiple BE's from Single FE
  96. Spaces in a multie value field.
  97. VBA Error 1004: The Macro 'sgc' cannot be found.
  98. Retrieve a value from a query field
  99. Cannot run sub in another form's module
  100. Excel Personal.xls not opening
  101. How do I link and open a PDF file with a primary key field via a button
  102. Contain link to access record in email
  103. Using adVariant DataType for Parameters
  104. SQL in VBA Transfer Spreadsheet
  105. Update Query
  106. build list of dates as string
  107. Case Select - i think
  108. Problems With Screen.ActiveForm.Controls
  109. Lesson Database
  110. Using in Between to Compare Numbers in SQL Statement
  111. Separating Concatenated Data
  112. Kill Print notification?
  113. Open ADODB.Recordset with Parameters
  114. importing then normalising data
  115. 2007 Ribbon - Help
  116. Iterating through objects and adding to collection
  117. PresentationOpen Event
  118. Help with a Search Function
  119. Make-Table query using VBA
  120. Calculation in Subform - Event leaving subform
  121. help with Requery
  122. DoCmd.TransferText Invalid Argument 3001
  123. Query Switch
  124. Help - returning windows logon name
  125. How to delete a table in another database
  126. Compact/Backup & ZIP
  127. Read and write to a sharefolder using a Windows username and password
  128. VBA Module(s) not available to ACCDE file
  129. Problem with setting a value in an If statement
  130. Personal.xls - Missing Macro's
  131. Problem comparing dates in If sentence
  132. VBA to log into Password protected site.
  133. Change field format in table
  134. DoCmd.OutputTo Exporting in Excel 5.0/95 Format
  135. Comparing Dates in VBA
  136. Activeworkbook.Saveas (FileFormats)
  137. Automation - hide backend table
  138. DAO Do-While Nested Loop ...
  139. Using Mousewheel to run query in textbox
  140. storing information from 2 tables into one.
  141. Is it possible to calculate and use calculated control names?
  142. VBA to change header text
  143. Immediate window
  144. How to select 2nd item in combobox
  145. cbo.Column(0) = null ?
  146. Remotely accessable database
  147. Question of References and different versions of MSOffice
  148. Searching Multiple Fields
  149. Saved Imports
  150. How to get Window Handles in VBA
  151. DTPicker and/or Missing References Generally
  152. VBA Help
  153. OLE Automation
  154. How to update a record in a different table
  155. Concatenate string to Field Names
  156. Intermittent "Object Variable or With Block Variable not set" Error
  157. HTML Code for Email Body Text
  158. If statement not working as it should!
  159. Report with complex criteria
  160. String method
  161. Outputting multiple .CSV files from a set of data
  162. Saving spreadsheet = invalid propert assignment?
  163. Retreiving a field from the current record in a subform
  164. Code to replicate File>SaveAs for Word to HTML
  165. Problems with data positioning on printed output
  166. GetPrivateProfileString - API - Unicode Version
  167. SQL simple error
  168. Detecting version of MS Office
  169. Format Query in Excel
  170. filter to VBA for email addresses
  171. OnClick event function question
  172. Procedure Too Large
  173. Onchange event in bound textbox
  174. passing two control values
  175. Show matching data in a form
  176. Adding Fields to PivotChart
  177. Covert SQL Code for use in Access SQL
  178. Custom navigation button
  179. Run Method error when using automation
  180. Finding array limits
  181. Code to Delete a Form
  182. Audit Trail Idea
  183. Combo select - precheck control
  184. Applying the same code automatically to various fields
  185. Dlookup and Null
  186. Newbie VBA - averaging fields
  187. Help with an array
  188. Comparing Separate Lists
  189. Print to PDF loop...files being overwritten
  190. Help with ADO open method best practice
  191. Date issue relating to table
  192. Cut and Paste Macro
  193. automate link to multiple text files
  194. Absence Management
  195. HOw to open a POP UP form to a specified size
  196. Cancel / stop command?
  197. return actual column value??
  198. Duplicate a set of records
  199. How to run a bunch of queries through a single click
  200. TransferDatabase trouble
  201. FollowHyperLink method is slow?
  202. "Run-time error '2455'" when closing Access after making editing changes to a form
  203. Should be easy....
  204. List Box Refresh/update
  205. loop trough records?
  206. need code to decide which date was inputed first
  207. array destruct
  208. Button not working on one user station?
  209. Delete Selected List Box item from Table?
  210. Problem with reference or ???
  211. Allowing Users To Create Formulae
  212. Main Form -> Subform -> Label
  213. Logging ADO operations
  214. SQL linked tables
  215. Help in VB Code
  216. Comparing counts and deriving a value
  217. Outlook Automation - Attachment Position
  218. Removing first two characters.
  219. More on Dmax?
  220. Fill Listbox with 2-D Array
  221. Export query to excel range on the fly
  222. Problem with ADO or DAO?
  223. Form Write Conflicts in VBA
  224. Removes Holidays from Date Diff Cal.
  225. Multicolumn Unique Constraint?
  226. Data Collection via email
  227. String
  228. Import txt files
  229. SQL with Dlookup
  230. FileCopy to Sharepoint Server
  231. Can't find object error when using TransferText Method
  232. set db = nothing
  233. Runtime error 462 with Excel
  234. asset tags
  235. Stock database
  236. Copy Records from One Table to Another
  237. MSFlexGrid Menu Popup in MS Access VBA
  238. Change VBA applied filter value
  239. Compile Error: Next without For
  240. Add "Where to Save to Prompt" in FileCopy
  241. Decimal datatype not working
  242. Using sql output in VBA
  243. How to return database name in correct format
  244. When to use code
  245. Export File with Date/Time in Name
  246. Passing datasets to subroutines
  247. Check record exists code needed
  248. n variables in a loop
  249. If...then for cmd button enable/disable
  250. How to code to connect to SQL server?