View Full Version : Modules & VBA



  1. Copy/Duplicate record problem
  2. Object variable or block variables not set
  3. My output is out of order
  4. Sql Where Clause By List Box
  5. Generic code
  6. Backup Database-Consolidating VBA
  7. Running a query in a different DB
  8. CopyFromRecordSet Object Range failed
  9. generating fieldname from string.
  10. date format issues
  11. runtime error 3075
  12. How automate the logging into computer
  13. How do I get the combo box value?
  14. Access Database to asp web pages error
  15. VBA Error
  16. VBA Export query with filter to Excel
  17. Opinions? -- Automatic Database Login
  18. Error using OpenArgs to transfer multiple values to new form
  19. DB security
  20. Duplicate Record Button
  21. Need to copy object using macro
  22. CDate
  23. Finding Top record by group
  24. Variables not changing values according to situations
  25. Right function
  26. TransferSpreadsheet (Only Specific Columns)
  27. Securing your database from any view or edit try
  28. Automatic Update of FE
  29. Find matching record in a table based on OpenArgs of a form with 1 to 1 relationship
  30. Revised field on a Form
  31. Using a button to open a form from a subform on main form
  32. Data mismatch help
  33. Another ODBC Connection Thread
  34. Number Sequencing
  35. FindFirstFile move through subfolders?
  36. Running a excel macro from access
  37. Openning Other Applications using VBA
  38. Error with Macro and VBA in access 2007
  39. Email Parsing (vb code to find ASCII text)
  40. Update a field on all records in a readonly subform
  41. Formatting dates problem
  42. How to change a fields data through VBA
  43. first time use recordset :s help please
  44. Deleting VB class objects that won't delete
  45. Create pivot table in Access with query as its record source
  46. Incompatible .AddItem function in Access2000
  47. 2 dymensional AAAAAHHHHH!!!!
  48. Changing the Value of a Row in datasheet View
  49. Call Sub/Function in another Module
  50. Error on VBA Code
  51. Using VBA to peform an FTP Upload
  52. Directory selection for array report output
  53. ActiveX error
  54. Problem Exporting with "#" in field name
  55. A quick question
  56. OutputTo Excel command and Switchboard v2007 problem
  57. After update event
  58. Question regarding the security of VBA in MDE files.
  59. seperating text
  60. Exporting to Outlook 07
  61. Runtime Error 13: solution
  62. Number of worksheets in a new Excel workbook
  63. Close button
  64. Check if file exists on ftp server
  65. New to VBA - some help needed!
  66. Controlling Word from Access
  67. Save report pages without preview
  68. How to select field from first row where a variable is unticked
  69. 'ActiveWorkbook.SaveAs' for Excel from Access Module
  70. application constants : where ?
  71. Conditional Statement going to "else" no matter what
  72. Emailing an attachment in Lotus Notes
  73. Always passes as False problem
  74. Module keeps popping up from form
  75. Copy queries from mdb to txt
  76. dynamic field name
  77. vb for 'Back' button for browser control
  78. Security MWD Permissions from VBA
  79. Saving .xls file created on the fly
  80. Calculating Times
  81. AcViewPreview for Previewing a Report- but what about print?
  82. INSERT Problem
  83. Searching Data using a Form, What is the code I assoicate to the Search Button?
  84. To kill the ribbon 07
  85. Main Form & Sub Forms
  86. Connection string
  87. Email VBA Help
  88. VBA Word parse string help
  89. Help with Emailing out of Access
  90. Trim() and "On Not in List" Event Procedure
  91. Slow SQL SELECT Code - Any Suggestions
  92. yet another rounding issue..
  93. check a value is populated before running code.
  94. IF statement from Table Field
  95. Breaklink in Excel doc from Access module
  96. Can you help me with my Search Form
  97. Code to disable text boxes for entry depending on combobox selection
  98. Help posting appointment to Oulook Calendar
  99. Code for Cmd button to select tab page on form?
  100. Code to upsize tables to SQL Server
  101. Conditional statments in VBA
  102. Extramly complex export need help!
  103. Printing
  104. Receiving an error 13 when using dates in an "at-run" query.
  105. Problem with a Function and Question on Passing the Data to a Variable
  106. Convert a number to the typed value of the number
  107. Logistical Help
  108. Calling a modual on error
  109. loading to openoffice
  110. Calling a subroutine on a different form access
  111. DAO.DBEngine.SystemDB
  112. Exporting query fields to specific Excel cells
  113. Code refuses to loop through records
  114. how to copy records/Recordset.
  115. Fill datasheet/Continuous form with vba code only
  116. Problem with making "detail" in form not visible via VBA code
  117. Bold HTML text in VBA
  118. Using bookmarks to insert data
  119. a login form with 2 accounts to have different privileges?
  120. Storing an Outlook Folder Location
  121. Date Function Issue
  122. Using Cascading combo boxes to Enter records
  123. Find Top n in a table
  124. Changing combo box's boundcolumn in VBA to get multiple values from a combo.
  125. Controlling who gets an email
  126. Programatically change linked tables
  127. my views of vba have gone funny!
  128. snapshot error
  129. adding code to a report, how do i get a current field value
  130. FileDialog property
  131. Read value in textbox1 from form1 and showing in textbox1 on form2
  132. Trouble with CreateQueryDef
  133. Function to Link to a Database -- SQL from Access
  134. Search Help!
  135. Can't use Find error
  136. Grouping Data to Export to Excel
  137. How to return a form value mid procedure?
  138. counting problem
  139. Update main form from sub form automatically
  140. Update/Insert Record
  141. evaluate records then update
  142. Tricky from Mdb to Mde
  143. Today's Short Date in Form
  144. Help identifying Duplicates
  145. Open Recordset, Evaluate data, then update
  146. Help with Module
  147. Return value from dialog box
  148. OLEDB connection
  149. Filter Form problem
  150. Bug in API ftLastWriteTime As Filetime??
  151. Steps to create a separate dbase which runs code in Main Db?
  152. Filter Problem on a subform
  153. Undo command
  154. Accessing E-mails in Outlook from Access VBA
  155. I'm stumped...
  156. TableDef Question
  157. vba to create and retrieve a chart from within Access
  158. Adjusting Column Widths
  159. Lastworkingday Code Problem
  160. Quit access applicaiton after defined time
  161. Help with Append Query in VB
  162. Sending e-mail @ 4pm every day automatically
  163. Help please! Update issue with sql statement
  164. Error in Code Mismatch
  165. Help with DoCmd...
  166. Using VBA to split a database
  167. Clear listbox on exit/load
  168. How to get date and time a file has been created
  169. Simple text conversion question (quiz related)
  170. Recordset transactions not completing, no error message!
  171. Referencing a nested subform?
  172. Multiple query export and save as...
  173. Word Merge .. again ... I think????
  174. VBA Error No value given for one or more required parameters
  175. Incrementing a date
  176. Display certain words from a sentence
  177. Multiple Filters
  178. database users
  179. auto-hide mouse?
  180. Print out a report in Access through Excel
  181. Form parameters to be emailed
  182. Detecting a String
  183. Store current sub/function & module name in Variable
  184. Help With error Module
  185. SQL string fault. Something small i think :s
  186. Converting Crystal Report to Access
  187. QueryDef Questions
  188. Add in computed numbers to the table
  189. Run Macro Every 24 Hours On Timer
  190. Stop close if not saved
  191. SOS Access Help plz
  192. prabha
  193. OpenArgs Problem
  194. Creating Function to re-arrange field
  195. Error On VBA code
  196. SQL based on recordset
  197. Code Logic - cancel action if tick box is false
  198. Controlling Excel From Access
  199. Sql
  200. More help for Access 2003 and Outlook 2003, Please.
  201. Check active form
  202. Multiple File Selector Dialog
  203. Opening Notepad and pasting
  204. Calling Functions from command buttons
  205. Parse String
  206. Left function
  207. Code for a Form to add new record on open instead of relying on using a cmd button?
  208. Question about Line Input & Fixed Width for Txt Files
  209. Populate ListBox
  210. Office 2007
  211. Need Help: Getting an Error on .index
  212. Consolidating columns
  213. [Access 2007] How do i create table in VBA
  214. Data Type Mismatch... HELP!!!
  215. IF Then Else.......I need the Else answer
  216. Round function
  217. Progess Bar (or equivalent)
  218. How does the IsNull work??
  219. Precision Error
  220. A complex problem
  221. Import into backend database
  222. Login Help
  223. Check if another Access is running
  224. Programmatically Creating mde
  225. I need to Build an Array that spits errors out to a table
  226. Recordset Looping Help
  227. Is this code lilely to be OK in Vista/A2003 or Vista/A2007
  228. Formatting text depending on field value
  229. Dlookup Date issue
  230. New Record Form Load
  231. New Record Form Load
  232. Send Outlook Tasks Automatically
  233. variable passed from one form to another
  234. msgbox has limited characters?
  235. Querry is too complex...solving
  236. Data Type of a field in a table
  237. Setting Default Value with code
  238. Problems populating a form from a query
  239. Odd recordset problem when loading form
  240. Help! Need to loop Through records
  241. Help with AfterUpdate
  242. Output HTML to access page
  243. Right-Click Menu in SysTray
  244. Problem with Select Case - Help!
  245. Funny Behaviour
  246. Changing variable values in a copied table
  247. Using current month and year in a module for file name
  248. Transfer Text not working
  249. Table description
  250. Using VBScript to open password protected db