View Full Version : Modules & VBA



  1. Running Modules Using Command Button
  2. Creating chart in excel from Access
  3. TRIM last 4 caracters from String
  4. Add Quotes to Code
  5. mac address check
  6. Hypertext Link > Copy linked files without opening
  7. Import Record from Remote Oracle DB
  8. Passing Multiple-Parameters and If Scenarios
  9. Dlookup with numerical criteria
  10. Before_Update with Command Close button on Subform
  11. Control what form is viewable
  12. stuck on find and goto VBA
  13. Downloading multiple text files into a database
  14. Getting a Data Type Mismatch error... I can't see why
  15. Check excel cell values in multiple files
  16. Button Automation
  17. Syntax for "Not" in VBA
  18. Code stopped working - delete and append
  19. Long Binary Data to Image
  20. Help with Error Message?
  21. DAO Diplay or populate Help
  22. DSN problem
  23. stLinkCriteria syntax help
  24. changing a control property
  25. Export access table to Excel format
  26. Code for multiple form instances
  27. Record Printing Loop
  28. Compacting File.
  29. Importing Access Table to Another Access Database
  30. SQL to VBA (with a concatenated alias)
  31. Runtime Error 3367 when using TableDefs.Append
  32. Export all tables to a spreadsheet(s)
  33. [VB] Printing a label through print dialog
  34. Other ways to open vba editor?
  35. code gives error 3020 second time around
  36. Setting Outlook appointments up through Access
  37. Dynamic Frequency Function VBA
  38. Hexadecimal String to Image
  39. Need help with formula returning #Error...
  40. Multiple Multiselect listboxes for data entry
  41. Requery SubForm based on Checkbox
  42. Customizing the TransferSpreadsheet Code
  43. Array within a Split Function
  44. Using SendKeys with a Browser
  45. Switching between Access - Excel - Acess
  46. "Access could not recognize"
  47. Export a record to an open Excel workbook.
  48. vba update table
  49. Using Autonumber
  50. HTML value references in VBA code
  51. Simple VBA code please
  52. How to Do.Cmd.Output Crosstab to Excel
  53. Class modules and constants
  54. How do i update some table records...
  55. Dynamically calculating a check digit.
  56. If Value is not null
  57. recordsource ,BOF EOF
  58. Textbox based on UDF(subform value) Problem
  59. Add records to table using Listbox
  60. Code for handling dates
  61. Error:3464 Data Type mismatch in Criteria Expression
  62. Custom record counter on subform?
  63. Set file attribute of external file
  64. SQL in VBA with a string variable??
  65. Import Excel Sheet into Access and adding a field
  66. Updating Access Table With Excel Sheet Daily
  67. Variable not defined when killing scroll wheel
  68. not good with VBA
  69. Print reports to PDF
  70. Search for 1 item, error message if not found..
  71. Exporting a recordset to Excel
  72. Refresh data in Access
  73. Imprecise positioning of chart datalabels?
  74. variable in quotes
  75. Access 2007 DoCmd.SearchForRecord
  76. Admin rights using VBA?
  77. Automated Outlook email in batches
  78. Memory and speed
  79. Options Group Wizard? Using A2002
  80. deleting a ms access database
  81. Removing last digit on different length numbers
  82. Field names as variables
  83. Export query results to multiple Excel sheets
  84. Scrolling Through a Record Set
  85. Help with backorder creator in VB
  86. Why is this form not re-querying?
  87. Export to Excel into separate files
  88. validation entry
  89. Searching for all calls to a function
  90. To display the result of sql statement on the screen
  91. Multiline Comments
  92. Problem to create a report using condition
  93. Parsing a set of records.
  94. DAO Reocrdset
  95. Resume Statement
  96. Can anyone explain why this doesn't work?
  97. Couple of Problems
  98. SelectCase Error
  99. Have multiselect listbox select unique values
  100. Using Docmd. OutputTo and Docmd.transfertxt
  101. Filling in Blank Columns in a Table
  102. Code button to delete specified data
  103. Update Report filter to current control value or record
  104. Check for Latest Program updates
  105. Use of the " ' " sign
  106. VBA coding for SQL Server in Access
  107. Function Excel in VBA
  108. AfterUpdate Question
  109. Translate a query to vba/module
  110. Exporting and importing data
  111. Navigate recordsets in a loop
  112. Not So Simple Search Help Needed
  113. Object Doesn't Support This Property Or Method??
  114. SendMessage API Question
  115. Error Type Mismatch (Access 2007)
  116. Connect backend
  117. Form with linked path to logo
  118. Export report chart to jpg file
  119. Re: Handling API events
  120. VBA not working for a Multiselect Listbox
  121. Email via non-Default email Account using Sendobject
  122. Access 2007 form / Sub form problem
  123. Replacing text in my database
  124. Access VBA and Excel Add-in
  125. Calendar Form Wrong Day
  126. Importing Dates from Excel
  127. looping Problem
  128. functions COUPNCD in VBA
  129. Noob help with executing SQL UPDATE
  130. Store an unbound text box value to the DB
  131. Call the sub of one form from another form
  132. Field check before update
  133. VBA Loop records and fields in table
  134. Speed issues
  135. Select An Option Button With Code
  136. Take control of active application?
  137. How to debug a UDF
  138. Run Several sub functions
  139. Access vs Big CSV Files
  140. Search string in a table
  141. Checking excel values
  142. Checking excel values
  143. sending a formatted excelsheet under condition
  144. error message sending mail
  145. Access keeps closing - help please
  146. Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression.
  147. Late binding Microsoft Word
  148. Parse a feed url
  149. Changing a combo box value from a form
  150. if [combobox] is empty then msgbox - not working
  151. Out of memory when deleting controls from a form
  152. VBA Counting number of items in listbox
  153. 7zip Command line Problem
  154. Refine Search
  155. Request a specific record value from a continuous form field
  156. Cascading comboboxes
  157. Checkbox in a datagrid
  158. Checkbox in a datagrid VB.net 2005
  159. Word.Application Reference
  160. Error 2448, cant assign a value
  161. Need Multiple entries in Email Message Body
  162. Problem with code
  163. How to use/display "&"
  164. Problem with retrieved data
  165. Select all text in a combobox when a user clicks it
  166. Problems with date function
  167. Codes
  168. Transferspreadsheet Import with Dynamic Range Name
  169. dlookup against date finding american format
  170. Insert Into statement not recognising non-standard characters
  171. Emails sit in Outbox of Outlook when sent by Access
  172. insert select with addtional value - confused newbie
  173. print-to-fax automation
  174. multiple popup forms
  175. Linked Tables
  176. Word Export and Import Problem
  177. Change feild value table
  178. All my code has disappeared - HELP!!
  179. Copy File
  180. escape sql statements
  181. Checkbox uncheck in a datagrid
  182. Windows Folder Creation from Code
  183. Transferspreadsheet to specific cell
  184. Consolidating Code
  185. Quirk in Access where 1 code error = "The expression On Load you entered as the ...
  186. DCount syntax
  187. Error 2051 - Cancel SendObject
  188. bit of coding question
  189. Change query filters
  190. Help with a VB Script
  191. Change User's Listbox Selection
  192. operation in data...
  193. error in entering variables
  194. Error 3159: Not a valid bookmark
  195. VBA List Box
  196. dcount error
  197. Access 2003 Error 2448 causing problems
  198. field comparison and contrast
  199. Help needed running modules from a form.
  200. Closing MS Word Application
  201. Update single field from multiple rows
  202. List Custom Database Properties
  203. Problem with InSelection property
  204. Moving focus on expand subdatasheet
  205. Records not updating correctly when looping through recordset
  206. Multi-User Db / Vb Generated PK Values
  207. Code to populate a temporary table
  208. Problem due to no design view support of mde DBs
  209. Help!
  210. Error #40036 now causing problems.
  211. Using ComboBox DropDown for Node Selection
  212. Basic question
  213. Image Display
  214. primary key in VBA
  215. Opening an Excel Spreadsheet from Access Command Button
  216. Changing Datasheet attributes with VBA
  217. inherited Db with REALLY missing menubar
  218. Count-If
  219. eof and recordsets
  220. Assign/Email Outlook Tasks w/ Access 2007
  221. In over my head - VBA query - help!
  222. Help with I/O
  223. Semicolon (;) import specification behaving as fixed length
  224. Import confirmation / status message box?
  225. Save as date with filename help needed.
  226. Importing Web Data into Access Table
  227. Dlookup function in VBA
  228. Database compaction
  229. File name as stored variable via dialog box
  230. missing references
  231. ReadyState WebBrowser Loop.
  232. Code to change sort
  233. Problems with Dsum function
  234. Line break and justify in msgbox
  235. Updating a text box
  236. Help/Advice needed for Exceptions
  237. DCount with an IIF statement for two tables
  238. strSql INSERT INTO / Values - creates 2 records
  239. Select Case Statement
  240. Can't find QueryClose Event
  241. update table
  242. need Word maximised after merge
  243. Trying to delete record from listbox and it doesn't work...
  244. Error opening form, some reason it goes to vba code?
  245. variable not defined...
  246. Adding an attachement to an email
  247. input into two tables
  248. Custom find and replace to alter text in a field
  249. Access - how to programatically unlock vba code
  250. A discrepancy with aliases.