View Full Version : Modules & VBA



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