View Full Version : Modules & VBA



  1. saving records to a temp table??
  2. Problem with the Code Page
  3. create table
  4. Opening data with a condition
  5. Recordset Open method is strange
  6. Automated email
  7. Max() function Code
  8. Converting DAO recordset to ADO
  9. Express ClickYes API function
  10. Multiple Email Attachments
  11. How to Capture SQL Error in VBA
  12. new field in existing table
  13. On Error Resume Next ?
  14. ODBC Connectivity to AS/400
  15. VBA auto email and record selection
  16. Import Dynamic Named Range from Excel
  17. Variables!
  18. Date range issues
  19. MouseUp events in ActiveX Controls
  20. OutputTo Runtime Error '2046'
  21. Access home directory
  22. File deletion
  23. Help with Do....Loop? (I think) please
  24. save form data to a table
  25. DoCmd.SendObject
  26. Presenting my Work to the Outside World
  27. Controlling built-in functions like Save & Delete
  28. Refresh Links to Multiple Backends?
  29. Ado Csv Provider Help
  30. Qckst Question - VERY NEWBIE Call Function
  31. Many Frontends/Users with same set of functions
  32. Debug Error
  33. is there an alternative to "Input #"
  34. Changing value of a field on update
  35. Calculating work days and interrupt process
  36. Best Way to Connect
  37. Error #3167 Record Deleted
  38. make a new xls-file
  39. using vba to do the same thing a setvalue macro does
  40. Treeview / Listview help plz!
  41. HyperLinks to open .mdbs on a Citrix server.
  42. How to copy all record on a table to another existing table?
  43. Performing a Conditional statement for each record in a Continuous form
  44. Change Colour in List Box Depending On Date
  45. Module for date in a report
  46. Exporting Foreign Characters
  47. Treeview - Ow, my brain
  48. Data Type for Table and/or Query
  49. Help - Import Excel Sheet
  50. Using Hot Keys to hide menus
  51. record selection in emails
  52. closest match using Visual basic access.. help will be rewarded
  53. Maximise and Restore !!!!!
  54. BeforeUpdate
  55. filter problem
  56. Open Another Database Without Closing Current Db
  57. Import multiple dbf files and filename?
  58. VBA Books
  59. Modifying excel from Access VBA
  60. combo-query!
  61. Error dialog box on quiting access
  62. Open Dialog
  63. Type mismatch error in Access 2003
  64. Select Items in List from a String
  65. an updateable recordset?
  66. Access 2000 ADO CurrentProject Connection
  67. Insert 'Now()' into field OnClick
  68. ADO conversion
  69. Auto Text
  70. Forwarding or Replay
  71. Importing a Excel Spreadsheet
  72. #Error
  73. Strange behaviour help
  74. SQL Queries inside vb code
  75. Month()
  76. Finding Users logged into Access
  77. List Box Value
  78. Split Database--Use of DMax/DCount functions
  79. FindFirst problem
  80. Difference between = "" and <> ""
  81. Link tables on the fly
  82. Auto Exec on load??
  83. Is Access slightly light in the brain dept or me?
  84. Beep when Record Appears
  85. How Send Query to a Network Folder
  86. Application Development Path
  87. Problem printing to PDF
  88. Can't set Constant
  89. Recordset Problem
  90. Trying to create a module that loops throw a record set to split a field in a table
  91. sending email
  92. Greater than current month
  93. creating PDF's from Access 2003
  94. From one record to three
  95. Help Needed on Export to Spreadsheet
  96. Global setting for text size.
  97. Problems with Hide/Show DbWindow
  98. Duplex Printing acc 97
  99. Users Logged on...
  100. Changing Files Names
  101. Determine the calling procedure
  102. Extracting portions of text from string
  103. Copying variable fron 1 form to another.
  104. Going to a record in a Subform???
  105. Updating the value of table based on the sum of another
  106. Referencing a Cell
  107. Truncate a string
  108. Code to delete records in a Table
  109. recordsets and excel
  110. Sending e-mail through Outlook Express
  111. Speeding up application.filesearch
  112. save results from a query into an Array? - Newb Question
  113. variable in a recordset field
  114. SendObject is skipped in VBA code
  115. SQL or somepin else
  116. No value given for one or more parameters
  117. Apply Filter with a Number
  118. C++ V's VB(A)
  119. Find whole word matches in two strings?
  120. noob question
  121. recordset rows to new recordset
  122. Need a better way
  123. Get Users E-Mail Address
  124. reference to objects in access and excel
  125. Count characters in textbox??? (text not selected)
  126. Rule or Listener Event?
  127. Copy Folder problem
  128. cacel record add
  129. Backup and WinZip
  130. Email Parameter dependant copies of 1 query to different emailaddresses
  131. TransferSpreadsheet
  132. Undo an append?
  133. Split One Field into two fields
  134. Query To Textbox
  135. LDAP -- as a linked table?
  136. ADO batch inserts appallingly slow
  137. Print Single Record
  138. Listbox
  139. Can anyone see what I'm doing wrong?
  140. Centre
  141. zero-length string (" ")
  142. Exporting and importing xml data
  143. SQL in TransferSpreadsheet
  144. Debug Help
  145. User-level security using a module
  146. Experts- Need Knowledge & Advice
  147. Importing Names From Outlook() Using VBA
  148. RunSQL Won't Work
  149. Code behind the Forms
  150. Looping through records to sendobject
  151. Security based on the current user
  152. Control Source?
  153. ADO Recordsets are not my forte...
  154. Question, defining recordsets
  155. adding data to table using VBA
  156. multi-select listbox default to selectall?
  157. Show the Table
  158. Returning A Value from a recordset - Dlookup?
  159. access 2003 and stripping characters and spaces.
  160. Locking in ADO und DAO
  161. Excel Cell Functions
  162. Need help about DELETE record message
  163. About to go crazy, whats wrong with this?
  164. Integer = rs.RecordCount
  165. Searching
  166. Creating Indexing using vba?
  167. Tougher Question: Pausing Code/Goto
  168. SQL Table Look Up and Variabe Store
  169. String Concatenation - where did I go wrong?
  170. Syntax error (missing operator) in query expression
  171. Really need HELP!
  172. Count all rows in a table.
  173. Listing In Unbound Form
  174. DCOUNT function
  175. 2 Column Listbox to Textbox
  176. Obtaining detailed ODBC errors
  177. Obtaining the application name using VBA
  178. Waiting for a PDf to finish printing.
  179. Import multiple ASCII files into one table
  180. Sub Name
  181. DCount fails in subform?
  182. Comparing LanUserID to a tblUsers UserID
  183. Export to Excel
  184. Getting Module & Sub/Function Names
  185. rst.close vs. set rst=nothing
  186. Automatic Display...
  187. Basic set caption problem from a noob
  188. VB to change box color from check field
  189. Trying to elimnate locking errors.
  190. listbox question
  191. Run Module from macro problem
  192. Script for importing tables and building relationships
  193. Why .ldb stays open???
  194. get a value from a table
  195. How to make a duplicate of an existing record?
  196. Open Report from Data Access Page
  197. exiting form from keypress event
  198. Loading... or Waiting... Pop-up
  199. loop through all workbooks in a folder and import to access
  200. Importing text file
  201. Desciption/Address Break down
  202. Exporting Access Query to Excel (into a temp file)
  203. Calculate a Compounding Value
  204. Variable File Path for Mail Merge
  205. recordset.open returns no records
  206. InputBox Function
  207. Event Proceedure Help..
  208. Help with security for database
  209. using TransferSpreadsheet to specify a sheet
  210. Hide Controls In Subform
  211. Disable Screen Updates in Access VBA
  212. Control Database
  213. Backup Database(access 2000)
  214. Referring to recordset field with variable
  215. VB macro for creating index
  216. Group Query results By Months
  217. Calculation based on month
  218. Toolbars using VB?
  219. Where did HELP go?
  220. referential integrity
  221. need help with email code
  222. Input from RS232
  223. How to test whether a form is open
  224. Using Global Values
  225. Inconsistent Updating of records (access 2002 bug?)
  226. Select Case won't update all fields
  227. Multiple String Matching
  228. event being triggered but not sure why
  229. Using Shift And Cancel
  230. SendObject problem
  231. Function help
  232. What Happened
  233. FileDialog comes up behind form!
  234. If in VBA
  235. Assigning
  236. Drop down list in Input Box
  237. error code
  238. Asking for Assistance
  239. Not sure what is going wrong.
  240. Update and Inner Join Question
  241. Syntax error in INSERT INTO statement.
  242. Drop Down Calender
  243. Utterly baffled by something so easy.
  244. Using a browser dialog to select a file
  245. email excel attachment
  246. Reference Libraries- Access 2003
  247. Printing the Report Multiple times
  248. Index or Primary Key cannot contain a Null Value
  249. DCount
  250. Ask the user to continue or not