View Full Version : Modules & VBA



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