View Full Version : Modules & VBA



  1. im stuck
  2. "Last modified" for a DAP
  3. checking if record exist.. why won't this work?
  4. Function sytnax for multiple returns
  5. File Not Found: VBA5.DLL
  6. Append table without duplicate
  7. Is it possible to make two events run the same sub routine?
  8. Save Hidden Spreadsheet
  9. Trouble with an ADO Execute statement
  10. Select Case help
  11. SQL Update
  12. Recordset.RecordCount
  13. Mail Merge Error
  14. Oracle Views
  15. Mail merge - MS Publisher
  16. Audit Trail Adjustment
  17. Run-time error 3251
  18. Spreadsheets
  19. Emailing a form
  20. DCount
  21. Run-time error '2115':
  22. Access 2000 VBA
  23. Open MS Publisher
  24. Open multiple files
  25. Importing an Excel file on weekly basis to Access w/o losing data
  26. Dynamic Query Def/SQL Statement for Report
  27. Dumb Question On Saving Record
  28. No Database window?
  29. Good book?
  30. Set focus to an item in multi-select listbox
  31. Converting queries to VB?
  32. Referring to multiple form names via code
  33. Progress Bar - MB ActiveX
  34. Entering a Value in a Control Automatically
  35. Rank Me...
  36. Finding a Record
  37. MsgBox - MB MsgBoxEx (Active X Control)
  38. Disable item in listbox
  39. Choose an item from a combo box automatically
  40. User selecting printer
  41. Problem with email code
  42. DCount Revisited
  43. automatically fill in full name of weekday
  44. The field is too small to accept the amount of data you attemted to add.
  45. Generating document w/ Table info.
  46. File Version
  47. Double Action Query
  48. email from a table as text
  49. datetime button
  50. Code help please
  51. Problems on my function with dates
  52. Automated Faxing
  53. Session Variables type thingies
  54. Autoexecuting code at access exit
  55. parse text if it contains a "/"
  56. delete table in backend from frontend
  57. Access97 and Outlook 2000
  58. More AllowEdits Trouble
  59. drop down search on data access page
  60. With ... End With
  61. Hidden Forms Not Maximizing
  62. count rows in all tables
  63. Can someone tell me what is wrong here?
  64. multiple input masks
  65. Automatically populate fileds from combo row source value
  66. how to bypass SHIFT key ?
  67. How do I open a database using VBA
  68. how to encrypt database?
  69. Can I send a variable to a text box on a sub form?
  70. Can i "Add New Record" in a sub form?
  71. Error -2147467259
  72. Working w/ Sub-Forms
  73. Simple Command button
  74. TransferSpreadsheet
  75. DAO.Database not defined error
  76. openrecordset troubles
  77. Select all on click
  78. Excel Automation
  79. Syntax Error (comma) in query
  80. Checking if a number already had been added to the db
  81. Combo to choose queries
  82. Control in question?
  83. listcount value
  84. Backend database in use
  85. Import records from Access
  86. send objects locking up
  87. Print Dialog Box
  88. Sending multiple criteria to a query via a function
  89. Compacting backend data
  90. Open form trying to use where parameter, somewhat lengthy.
  91. Do Until EOF
  92. Combining records in a single table
  93. Day problem
  94. Empty record
  95. Transferdatabase
  96. DMin problem
  97. How do I call a function From a command button?
  98. docmd.runSQL. Trying to pass in a string
  99. loop
  100. Newbie Question: Queries in SQL view then SQL to VBA
  101. Open more than one file in excel
  102. Print Preferences Dialog
  103. Exported data is not caculated in Excel
  104. field names for tables
  105. Find most recent date
  106. Colouring certain parts of a Text box (is this possible)
  107. Arrays
  108. File Names
  109. Error trap printing
  110. Error code 3260
  111. invalid use of null
  112. Can you trap Printer Error messages?
  113. Is there a wildcard character that VB recognizes?
  114. automatically populate combo box with available tables using SQL
  115. prevent an append query from running
  116. Help request - VBA to copy data from one set of tables to another
  117. loop through all open ADO recordsets
  118. what's wrong with this string compare check?
  119. PostCode Distance UK
  120. Information Display
  121. Insert query run in VB
  122. Table Renaming within VBA
  123. MS Common Dialog - Print Dialog
  124. different addresses of Backend for different clients
  125. Button visible IF other form is open
  126. AutoFill new record with data from previous record in a specific field
  127. Text File
  128. Message box
  129. Running SQL in VB
  130. Simple problem I cant figure out
  131. Auto search facility module?
  132. Generate Automatic Number
  133. Passing WHERE Statement with DoCmd.OpenReport
  134. Video
  135. Setfocus on another form
  136. Setting the Text Property of the StatusBar
  137. Help with program logic
  138. Not 'Else' - Or?
  139. Add Field to Table and user select data type
  140. scope of variables/controls between objects
  141. Help with code...
  142. What's Wrong With Already_Run Code?
  143. Add Item to List Box on Form Load Event
  144. Image Population / Timer Event
  145. Not in List Event
  146. Date Formatting??
  147. Email A Link?
  148. Matching a Public Variable to a Row in a Combo Box
  149. Menu Bar Only After Form Run
  150. Hyperlink - Follow on click
  151. Including an attachment in automated email
  152. Just feeling my way with VBA...
  153. Form
  154. Automate Import Process?
  155. Help Me Please...
  156. Help with this Code please!
  157. Hyperlink HTTP Checker
  158. Call to procedure messing me up!
  159. redim preserve 2 element array
  160. Testing for a locked record
  161. Recordsets
  162. Open a form when Access is opened
  163. Clearing Check boxes
  164. converting text field to double
  165. MapPoint Automation Expert Required
  166. Copying record!
  167. declaring global variables.
  168. Relinking FE to 2 BE
  169. create emails from address list in access
  170. Problems with a calculation in a form - from a query
  171. Shell Command
  172. create emails with attachment
  173. Too few parameters expected1
  174. changing background colour when typing
  175. Create a Primary key in VB
  176. Replication Synchronising
  177. Vb6/msaccess2000
  178. Publish a table to word for mail merging
  179. list box
  180. Deleting Record Problem
  181. Help with forms/code on forms
  182. Can I call a module from within this code?
  183. Open explorer and navigate to a specified path
  184. How can I Unload an object?
  185. printer not available
  186. Export Dialog though Code
  187. vb code help
  188. Does the table exist?
  189. Quotation Mark Problem
  190. Password Protection and Audit Trail
  191. Running/Closing an .exe file??
  192. Office version
  193. Importing with an InputBox
  194. Add and edit in the same form
  195. Why aren't Tag and OpenArgs arrays?
  196. Subform not showing changes
  197. transfer text VB help please
  198. Password table
  199. Global replace function for table??
  200. Functions Not Working
  201. Split db Generates Errors
  202. Can anyone help with this?
  203. Linked Tables
  204. attachment by using sendobject
  205. Copying Tables?
  206. Hidden Database window problem
  207. Comparing cases
  208. Help with yes / no box or OK / Cancel box
  209. Autonumber
  210. How to track a column being used in 100 different forms
  211. Dos commands from VB
  212. Complicated text file import
  213. Import name of file
  214. Importing a TEXT file automatically at certain times without opening ACCESS databas.
  215. TransferText adding extra fields
  216. Order by entering sequence
  217. Runtime Error 3270
  218. from list box to tmp table
  219. Nz? IIf? Trouble with dates
  220. file version number
  221. Maximum Records In A Database
  222. Automatic Emailling from Access 97
  223. Deleting Tables...necessary?
  224. Sequel Server Connection
  225. How to view a word document in a form
  226. Putting a query into the closet
  227. Specific Error always fires
  228. multiple option group
  229. type-declaration character error
  230. Access XP - Code to searh records in a table that has not got focus
  231. Changing Calc Field in a Query with VBA?
  232. VB Functions
  233. Import from another database
  234. Simple question about Access form
  235. can this be done?
  236. Error Accessing File. Network connection may have been lost.
  237. Is it possible to create an output file upon record insert?
  238. Referencing Selected Text
  239. Blue Monday
  240. Hiding Database Window
  241. Code for moving to next record (right navigation button)
  242. Generating Automatic Email, Based on a Criteria!!!
  243. Recursive network coding
  244. List Box inserting into empty field in existing record
  245. Exporting a report to MS Word
  246. help with code?
  247. CreateField - AutoNumber
  248. Year Calendar / Dynamicly created textboxes
  249. Launching MS Word mail merge from an Access form
  250. Trouble with SetFocus