View Full Version : Modules & VBA



  1. Need Help with macro
  2. FileDialog Access XP Developer
  3. Hmmm...Where To Begin
  4. Rename image files stored on the hard disk
  5. Blank field
  6. Create a txt file and modifiying it...using vba
  7. Read Receipts using sendto method
  8. Remove relationship b/n 2 tables using VBA code
  9. VBA Problem with Transfer text, Help anyone?
  10. Report Wizard through VBA
  11. Best way to import data from Excel
  12. Pulling My Hair Out
  13. Attached xls tables
  14. Text formatting
  15. OLE Automation with Excel
  16. Send AND Save Email from Access form
  17. Closing Forms
  18. Can't find the object in Visual Basic
  19. Problem referencing FileSystemObject
  20. Importing Excel using DoCmd.TransferSpreadsheet
  21. Run Access on recieving email in Outlook
  22. Run Access on recieving email in Outlook
  23. Syntax used with DFirst etc
  24. Record Locking With Access FrontEnd And SQL BackEnd
  25. Internet Explorer automation from Access
  26. Close disabled on open
  27. Space removal is driving me crazy!
  28. Get Outlook Folder Name
  29. Doing something to each record in a subform
  30. Combo Problem
  31. Help With Export to Word
  32. Type mismatch
  33. Code errors on converting 97 to 2003 see pasted code
  34. Type Mismatch in function?
  35. Task bar - app - MS acess
  36. Deleting a selected record
  37. Graph datasheet - Series By Column property
  38. search for a character in a string
  39. LIKE Syntax in SQL String
  40. Generating controls on a form
  41. Call AfterUpdate of a Control
  42. Check link table link?
  43. Code only working if stepped through.
  44. Run Time Error 13... Type Mismatch
  45. Help hypetertext protocol problems
  46. Print Records selected
  47. Strange problem with link tabels?
  48. I've seen this done....but how?? (automated emails)
  49. Export Delimted Loses Formatting
  50. Email recipient duplicates
  51. Textbox & ComboBox's to be initialized
  52. find a date within a recordset in vba
  53. From one form to another
  54. Can I detect if a program is posted over network
  55. Reading and storing data
  56. Automate - get External Data
  57. dbSeeChanges Error
  58. Select a variable number of records in a table.
  59. Error Message 7874
  60. Callback function not displaying data
  61. Find the User name for a SQL Server Linked table
  62. Create a database
  63. Pass 2 fields into some common code
  64. requery not working
  65. MsgBox on change
  66. Store Combination Of Numeric and Non-Numeric
  67. copying ADO recordset to Access table?
  68. Need help with code - form controls
  69. Filling a listbox with filenames, then opening the one selected
  70. Export Access Query To Multiple Excel Worsheets in 1 Workbook
  71. TransferSpreadsheet with Formatting
  72. get value from one string for another string
  73. cycle through records and add to array
  74. Form.Recordsource :: Runtime Error 2176 " The Setting for this property is too long"
  75. DCOUNT Problem
  76. Loading a form from double click
  77. comparing records within table
  78. Computations in ACCESS
  79. Updating Msadox.dll To 2.8
  80. SQL syntax error
  81. Database usage monitor
  82. How to open PDF-documents from VB code?
  83. AutoNumber
  84. Pass recordset to a query
  85. Setting File Name In Common Dialog
  86. call shell
  87. ADO connection question
  88. Visible or Not
  89. Criteria in VBA for report-query
  90. Help Please
  91. Email from Access
  92. Word database connection
  93. SendObject link criteria problem
  94. novice needs an advice :)
  95. Getting Ebay Data
  96. Type Mismatch
  97. Field Name Reference with Variable as Part of Name
  98. Importing / cycling worksheets Excel to Access problem
  99. ms access+mssql tables
  100. Help! Load query data and output to form? How?
  101. Loading Access Table from other datasource
  102. Update linked tables by program
  103. record navigation error
  104. Creating text boxes in VBA code
  105. relinking tables cant quite get it to work
  106. Adjusting values in Excel from Access
  107. AutoImport from Excel File
  108. Importing Multiple Excel Workbooks into Seperate Inexistant Tables
  109. Has anyone experienced "Error! Not a valid link." after linking access/excel/word
  110. checking for current user or user group?
  111. Copy DB / Close Form
  112. ODBC Connections
  113. Access & Web
  114. output Access form names
  115. Events "Map"
  116. Changing Listbox RowSource
  117. Bet you'll never solve this 1 - VBA compact and resume macro?
  118. AND operator help
  119. Import data matching criteria
  120. Merging Date and Time, is this possible????
  121. adding text to a command bar
  122. Long Case Select statement - is there a better way?
  123. Error linking Oracle Database via ODBC
  124. SQL Field Error
  125. Refreshing Subforms
  126. Eliminate prompts from RunMacro in VBA
  127. tree control question
  128. Divide by zero error-trapping
  129. use a function to change de backcolor of a lable
  130. lookup last record in table
  131. Refresh library references (Error 3075) through VBA
  132. Import Array into Table
  133. Sending 2 reports to 1 Fax in Winfax Pro
  134. Combo box and subforms
  135. Compare two tables with different keys
  136. Date function not working??
  137. How to execute code when someone saves or enters a new record
  138. Export data to Excel
  139. computer purchasing - form trouble
  140. Export Qry to excel - data mismatch error
  141. Transfer to excel
  142. savesAs report
  143. Setting a controls properties using a variable.
  144. String SLice from VBA on field
  145. Abort Loop Process
  146. Regrouping Split Date Values
  147. Filter By Form is it available in runtime
  148. Switchboard button disabled
  149. SQL Question
  150. SQL connection using ODBC
  151. Run resulting recordset through SQL
  152. Need code help with search string.
  153. Dlookup syntax
  154. insert an array with INSERT INTO
  155. TreeView
  156. Import Linked Table Structure
  157. Import Linked Table Structure
  158. Break on error even tho error handling is turned on
  159. Resize the comments in Excel with Access
  160. Email more than one report
  161. Need Help with this code!! Please Help!!
  162. Connections ans opinions
  163. Inserting User Name when transfering text
  164. Opening a form and filtering by date
  165. Help with Avoiding Invalid Use of Null
  166. excel just will not close
  167. Non-trivial problem with Parameter dialog
  168. Object Library Question
  169. Connecting to dat file from access or VB
  170. SQL Syntax with CurrentProject.Connection.Execute when variables are empty
  171. Unsuccessful execution of SQL statement within VBA codes
  172. Listview activex question
  173. Sort Field in table
  174. Auto Selection of ComboBox
  175. Error 2001
  176. Access data into Excel worksheet
  177. Return remainder after subtraction
  178. Check Status of Excel Spreadsheet
  179. Mask in Inputbox
  180. OpenRecordset error
  181. Querydef Help
  182. Adding Relative Image Paths using FileDialog
  183. Can't compile in 2000, works in 2002
  184. Using AppendChunk with ADO
  185. runtime error 3022
  186. Macro to tree view
  187. If Then Else
  188. how to get current record id after update
  189. Command Line Options
  190. DCount not returning same results as query
  191. Should be easy If...Else If
  192. Auto update from one table to another table
  193. Msgbox Options, Problems With HelpFile Parameter
  194. append a record to a table using vba where the table contains an autonumber
  195. "You cant hide a control that has Focus"
  196. Dlookup error
  197. Setting Link fields
  198. Select Certain rsTbl.Field(x)
  199. open pdf based on form fields
  200. Outlook contact problem
  201. Having DB show up on start bar?
  202. Refreshing combo list
  203. form visible dependant on value
  204. VB Code stuck in Loop
  205. Strange problem with recordsets
  206. Mystery MDE compilation failure
  207. TextBox/Table question
  208. number of records?
  209. A SELECT COUNT(ID) query to put result in a var. in VBA
  210. Get number of users currently using an access db
  211. new year in access data base
  212. Copy table structure only
  213. Cancelled previous operation error
  214. How to create a variable with the name of a variables content?
  215. Filter question(s)
  216. Need opinion on books
  217. about DAO Recordset
  218. Multiple instances of one report
  219. Procedure too Large
  220. make QRY, get data, Del QRY...Surely there's a better way
  221. UPDATE table - brain freeze
  222. Updating 2 tables from a form, problem with requery
  223. problem with updating tables
  224. copyfile with date in the filename
  225. cancel openquery if query contains no data
  226. ADODB.Recordset references
  227. Error on enter data
  228. help on matching time against time range slots
  229. Importing/linking csv files
  230. Using DCount
  231. Null Recordset
  232. Printing a variable(?) in a report
  233. Why Access suddenly ignores these codes
  234. Listbox and SQL
  235. syntaxt code error running sql query in a module
  236. Expression for "take the current record and transfer it into another form or report"
  237. clear list box
  238. form based in atable
  239. 3075 Syntax Error
  240. Modified Switchboard; Hit a Snag
  241. RunSQL Action Query Error
  242. extract dates from string
  243. extract dates from string
  244. SQL / VBA run-time error
  245. Enable/disable button based on lookup on another table
  246. Disable a control VB question
  247. Mulitple updates to a table based on the changing # of records from an import tbl
  248. Updating records if Null
  249. Path
  250. dlookup in a form