View Full Version : Modules & VBA



  1. Need user to input file path, whats the best way?
  2. Save As ?
  3. Dynamically Build Query
  4. Deleting & Creating Tables using VBA
  5. Open table via ODBC
  6. How to hide option group
  7. increment or auto number
  8. Append to detail table using SQL
  9. Good practice on transactions
  10. Object Invalid Or No Longer Set - Error
  11. Hide Navigation Page using VBA
  12. Insert Related records from previous Relationship
  13. AfterUpdate 2007 Question
  14. Create multiple columns from data in one column
  15. MsgBox prompt after SQL
  16. Loop with SQL result
  17. Cascading DropDowns With Subform
  18. VB code to send a form to email
  19. low value based on other variables
  20. Troublesome textbox
  21. Cannot Expand named Range - But new file, no range, small result set
  22. open rpt, asking for parmeter value
  23. get criteria string from a text box
  24. Permissions/sharing?
  25. Problem with calling a function
  26. Watch Window for Simple VB script
  27. 3021 Runtime Error
  28. Writing Access functions
  29. xml import to access error!
  30. SQL and Access Recordsets in Word
  31. Disconnected Record-set
  32. Putting a variable in a Me statement
  33. ActiveX Reference
  34. Error 2158 on a Recordset
  35. EXPORT does not work in some pc's
  36. Locked controls - how to warn that control is locked
  37. SQL Temp Table Issues
  38. access function runs slower afer being run multiple times
  39. Auto Send in Outlook
  40. Calculation with Time
  41. Check Yes/No Data Type
  42. How to get 0.5
  43. Requerying forms record source
  44. MkDir and add file
  45. Checking for existing record befor proceeding with append querry
  46. Delete all associated records
  47. Descending loop
  48. Add New Records With VBA
  49. Automated adding of column
  50. hiding fields when displaying tables
  51. Filter Sub that does not work in Windows 7
  52. Help With Module
  53. Small Quick question about Access Emails
  54. hidden windows
  55. Exporting multiple reports to one Excel Spreadsheet
  56. Remove Button Underline
  57. shell open db
  58. Itemsselected.count reports wrong figure
  59. Help with process
  60. Zip Code Distance calculations
  61. Weird problem with Email field
  62. Open Excel file from Acces using wildcards??
  63. Displaying selected records of a Form/Subform
  64. Identify & Message Logged In Users
  65. VBA - How to preview reports with a filter?
  66. Report to PDF - Lossy Image quality when converting to PDF
  67. Open default web browser and navigate to a page.
  68. Need help copying columns from Excel & pasting into Access table
  69. Access 2003 app stops working after 2007 upgrade.
  70. Smartcard/Certificates
  71. Table ID to Table# to Main Table
  72. I keep getting 2501 error
  73. DoCmd.Close - Save path
  74. Format function is not working.
  75. Creating Export Specification
  76. New ComboBox Question
  77. Customize function/sub template
  78. Setting up Collections
  79. Menu toolbar and splashcreen
  80. Bar Chart
  81. VBA Project
  82. Assign Autonumber of choice
  83. amend or delete appointment from outlook using access
  84. Data Import Programatically
  85. Counting Database Objects
  86. Populate UserName into a field
  87. Weird things happening with the Me.OpenArgs
  88. SQL in VBA
  89. How to Rename Linked Tables?
  90. Including headings in export .txt file
  91. Update to 2 tables
  92. Creating a Custom Menu
  93. msgbox combo box value
  94. Select query from vba
  95. Lotus Notes - Body Text
  96. Open Recordset from variable recordset error
  97. RecordSet Update throwing invalid argument
  98. Update all Null Fields to a specific number using VBA
  99. Launch Access using VBA
  100. Select records and processing one of the fields
  101. Report to separate PDFs
  102. Multiple image display on the form
  103. Getting people out of the Database.
  104. External Name Not Defined
  105. Removing #Num! errors or showing empty field
  106. Copy and Paste Append not appending every field
  107. VB code to display all the 52 weeks in a year
  108. Personal Error Messsage for Error 3011
  109. how to restrict view of certain data
  110. Problems calling a function from a command button
  111. Get Windows Version from MS Access 2007
  112. Input as string, the use that to calculate or conver to long data type?
  113. Importing HTML Files Into Access
  114. Changing table field format using VBA
  115. Help Please - Global Vars
  116. Module not found problem
  117. ODBC link to Foxpro problem
  118. Static Variables
  119. DoCmd.OpenQuery but for another database
  120. General Code Question
  121. Access Sharepoint linked table date update failure.
  122. DataValidation
  123. Paste Link code (Excel to PPoint)
  124. Percentile UDF
  125. Restricting the Access Distribution
  126. Replacing acSaveRecord
  127. OpenReport error 2585
  128. Remote queries
  129. Copy filtered recordset
  130. How to Create a Table in Excel
  131. Syntax problem
  132. Embed multiple pictures in Outlook Email
  133. DoCmd.TransferSpreadsheet to Unsaved Open Excel Workbook?
  134. Automation error
  135. Change data in a field on a form
  136. Open external Files
  137. Open external Files
  138. Setting Invoice Numbers to Start At .....
  139. using IIF inside a Dcount function
  140. When to use the Control Source property of a Combo Box?
  141. Hide / Unhide All forms - reports - Modules
  142. HOW TO: Declare Global Vars for Usernames
  143. Advantage to full object reference
  144. VBA - my recordset isn't filling up
  145. Query reading Query in VB
  146. Delete Object
  147. Find Where A Sub / Function was called from?
  148. Updating a second combobox based on current value of first combobox
  149. Lack of memory resizing pictures
  150. Help with VBA generate query based on mulitple lists
  151. Filling in values on a form based on a lookup key
  152. Dynamic Creation of Combo boxes
  153. Error 9 Subscript Out Of Range when copying records from form (datasheet) to Excel
  154. Open Append Query In Datasheet View With VBA
  155. What is the proper method to know whether the optional arguments are supplied or Not?
  156. Outputting all variables of the Me object
  157. Where to place code to hide control
  158. Open Word Doc in foreground
  159. Status Bar
  160. Open file dialog for multiple file selection in Access VBA
  161. 'Go To' code
  162. password input box should display asterisks
  163. import linux text files into access database
  164. Public function
  165. Changing Cursor Shape
  166. Is it possible to query from Recordset?
  167. Adding Event Procedures through Code!
  168. How to replace with one line of code with two lines of code?
  169. import txt file skip first 10 lines?
  170. Speed up Dcount
  171. ODBC database
  172. Please help me on my code
  173. Passing an array through an SQL query to a function
  174. Using SQL to get data into a variable
  175. Print Report Depending on Selection and Filter
  176. workgroup flash drive.
  177. Select Default Item in ComboBox
  178. Checkbox check uncheck nased on field value
  179. Is the recordpatrol(rs.movelast and rs.movefist) really necessary for DAO Recordsets?
  180. Alternative to getopenfilename in Ms-Access
  181. SQL debugging as mismatch but works in a query
  182. Export Code - Excel Named Ranges
  183. Setting SourceObject of the subform holding crosstab datasheet failed activeControl
  184. Help date check nightmare!
  185. Is it possible to put a combo box in a MsgBox?
  186. User Session Timeouts
  187. Access shortcut Executable path
  188. deleting a table with only a partial name
  189. Access VBA to extract email from Outlook global address list based on name input
  190. VB DCount per ID instead of whole table?
  191. Applying VLookup via access VBA into Excel
  192. Save changes to the following objects?
  193. does DAO.FindFirst use table indexes?
  194. Referencing a text box on a form from a module
  195. Calculate Date/Time with Access!
  196. disable print? Read only? 2 questions.
  197. Converting an MACRO to VBA
  198. Selecting multiple long-filenames
  199. Sync Access Contacts with Outlook
  200. Select field with mutitple records to show in report
  201. Error 3027 Cannot Update. Database or object is read-only
  202. Error 3170: Could not find installable ISAM
  203. Loop question
  204. Syntax with DLOOKUP?
  205. error 2105 with gotorecord,, acnext
  206. Date formatting and Efficiency
  207. DLookup Runtime Error
  208. Importing text file with form and buttons
  209. Modifying Bob Larson's VBA code that putts Access data into Excel
  210. Checking value in another database
  211. Edit a given value in a listbox
  212. Code to change form properties
  213. Help! Access won't close - have to end task
  214. Guidelines to Understand and work with the OLE Datatype.
  215. Access 2007 releasing saved records
  216. TransferSpreadsheet to write to desktop
  217. Password Code
  218. Update date in three different fields based on date in another field
  219. First Record Not Displaying in Report
  220. OnClick to Print Multiple Reports
  221. Run-time error '3134'
  222. run a counter on records meeting a criteria
  223. Delete Record in Subform
  224. Query with Criteria export to excel HELP...
  225. Subform Linking Problem - Automation error
  226. Displaying flat file data in a specific hierarchical format in XL
  227. VBA Access, checkboxes
  228. Help With Access 2003 VBA Enable Function
  229. Nested IfNull
  230. Multiuser system problem
  231. Calling a sub??
  232. Write method adding erroneous quotes
  233. Howto trap " Cannot open the file"?
  234. Access Registry Windows 7
  235. need help - Access to DLL to Access
  236. Argument vs Parameter?
  237. Repair and Compact
  238. Multiple Instances of the same Form
  239. Help Working with user defined types with nulls.(For loop?)
  240. Different report types changes due date
  241. Bookmarks and number points
  242. Display mutiple rows from a querydef in the body of an email created from Access03
  243. import files
  244. Comparing a row to multiple rows within the same table
  245. Give Access Query and Alias using VBA Code
  246. VBA to update values in one table based on another table
  247. Range Global error if run same code second time
  248. Access Runtime issue
  249. requery of form has no effect
  250. Using string as code