View Full Version : Modules & VBA



  1. Make a windows directory in code?
  2. looping through fields
  3. Problem with Append Query
  4. Error in Append Query
  5. refreshing comboboxes
  6. FindRecord
  7. Opening to a form from another Database
  8. Path to Backend.
  9. File Path
  10. Identify if query returns records
  11. Where clause with Or
  12. Text date into date field
  13. Report Formatting
  14. Please check my vb code
  15. Processing options on a popup menu
  16. Toying with Dates
  17. Passing Variables???
  18. Passing Data to Word
  19. New Record on SubForm
  20. Sorted now - don't worry :)
  21. Add item if not in list?
  22. Need way to check if a query exists.
  23. Type Mismatch Error
  24. Fire event before leaving modified record
  25. How to copy to clipboard
  26. Setting Reports recordsource Crashing db
  27. Upper Case for first letter
  28. how can I cast a Date in "ww" format to an integer
  29. Convert Excel file into Text file
  30. not sure of the code
  31. FileSystemObject Problem
  32. link checkbox to textbox
  33. Learning Sites
  34. .ldb file format
  35. refer to controls on tabbed form
  36. Please Help
  37. Data comparison and alignment
  38. Making multiple selections from a list
  39. Number comparison from a list
  40. Delete excel spreadsheet from code.
  41. OLEDB/ADODB Problem
  42. use array in access module to create excel chart
  43. date miss match
  44. Error Trapping for a hyperlink
  45. Please explain function EnableControls
  46. Update FE Automatically
  47. Choose table to copy data into
  48. VBA Reference Woes
  49. process on pc
  50. saving by code...
  51. active x!!
  52. ActiveX failure - critical problem
  53. reading sql from query properties?
  54. Dim variable_name as DataBase?
  55. .Value vs .OldValue
  56. Looking for words in a string
  57. suppress error messages
  58. populating listboxes
  59. Sub Form Calculation
  60. Adding information to a list box..is this possible?
  61. Reference the the label associated to a Text Box
  62. Please Help with code used on user/pass form
  63. System generated Message Boxes on Update
  64. Check my code please
  65. Import Oracle Database to MS Access
  66. e-mail not sending
  67. Plulling through one record where mulitple records exist in a table in a table
  68. what the hell is my code playing at ?
  69. Delete tables from the code
  70. Heeeelp!!!
  71. Passing Date Values
  72. Find and replace for vbCRLF
  73. Exporting tables from different DBs
  74. Inputbox
  75. calling menu bar controls
  76. Access 2000
  77. What is this ">"
  78. setting references
  79. Date() problem "doesn't always work on other machines"
  80. Different slant on Passwords
  81. Lost
  82. Help with subform controls
  83. Passing (sub, sub) Form as Object
  84. [B]Open Recordset with Dlookup Variable for Field Name [/B]
  85. british date reverting to us date
  86. VisualBasic For Applications Help
  87. Visual Basic frontend configuration database access
  88. Mulitple Reports
  89. Form search
  90. Queries problems, subform problems...
  91. Forms
  92. DoCmd.OutputTo problem...
  93. Return Multi-Values from Module
  94. open form via module
  95. Conundrum
  96. Outputting information into word
  97. Running Totals
  98. casting
  99. Ok
  100. Format spreadsheet from Access vba
  101. Synchronisation
  102. using VBA between 2 tables
  103. Increment letters with code
  104. prevent Alt-F11 entry
  105. Message box which run two times
  106. Nested if statements in select case statements
  107. Do u hv sample program to generate quotation ?
  108. Code to copy from subform to subform?????
  109. Now stuck on addong a new line!!..can it get any worse??
  110. using an if statement on an sql string
  111. E-mail Fields from a form
  112. Variables and Forms
  113. Email a Record of a Form
  114. firstdayofweek
  115. Code Keeps Blowing Up
  116. relating to other fields..
  117. Programmer but new to access programming
  118. Output to different Excel files depending on query criteria
  119. Append an export
  120. where to put abort report on nodata
  121. Last Day Of Job Need Urgent Answer
  122. Edit excel workbook from Access
  123. DCOUNT - trying to count text fields that contain nothing
  124. Enable textboxes
  125. Enable textboxes
  126. DoCmd.SendObject subject line problem
  127. filter for one
  128. Open a CrossTab Query as a Recordset
  129. "File Search" not working as expected
  130. Starting up a form at the right place????
  131. Export data to Excel
  132. Help with code
  133. highlighting a selected record
  134. Page Numbering in a Report
  135. Limiting number of users to database on server
  136. Loop Through SubForm Controls
  137. Is there a simple way to connect to a recordset in Access2000
  138. WinXP + Acc2k = Error 91?
  139. Using the Mod operator
  140. tabular subform
  141. Record Count from Number of results in a query?
  142. Exit Database on Loss of Network
  143. Standard Deviation Formula
  144. Explain RecordsetClone
  145. Find next open key field
  146. Validation Rule?
  147. Locking a database
  148. Database Security
  149. Up for a challenge? Displaying a tree structure
  150. Go to current record in pop up form
  151. Info in Linked Tables doesn't refresh?
  152. FindRecord ""
  153. Can i use the windows logon id?
  154. Mail Merge
  155. Importing
  156. Syntax Error in SQL statement
  157. help please
  158. cmd button that increments numbers
  159. emailing multiple reports
  160. Spli Command Question
  161. Changing Shared Access
  162. Checking two Fields at once
  163. Count Command?
  164. Problem Updating Table
  165. Problem Updating Table
  166. How can I get the db's file path at runtime?
  167. new reord but dont clear all fields
  168. Transfer of Control – Database to Database Compaction
  169. How do I combine 2 expressions in a where condition paramater
  170. Auto generate value
  171. Run-Time error '424'
  172. Starting out!
  173. Referencing ASCII Character
  174. Possible to open form in Add mode using VBA??
  175. Generate new number on new year!
  176. Screen Saver Problem
  177. message box (vbYesNo) not working
  178. Custom Property
  179. Value of a variable
  180. help!?Carriage Return
  181. Setting variables
  182. SQL and recordsets
  183. checkbox to generate control number
  184. splash screen
  185. attachment
  186. recognising variables???
  187. uncomment lines?
  188. creating outlook msg from access
  189. Need SQL help with combining data from multiple tables
  190. Data type mismatch
  191. Writing fields to a table
  192. Code to resize subforms
  193. Calculating Weekdays
  194. it doesn't work
  195. Shell command - not running like it should
  196. SubForm Visible
  197. Escel Query Refresh
  198. Password Authenticated but logon form not closing
  199. Halt Action if query results do not contain X or Y?
  200. How to add new rows and bookmarks when automating.
  201. How do I force a button click
  202. Date Field
  203. Call stored query with ADO
  204. SQL string - search between dates
  205. HELP!? Accrual of numbers by date??
  206. why wont my code work?
  207. help with this code?
  208. The "Or" operator using SQL statement in Java
  209. Trying to find unmatched data
  210. Change data
  211. Exporting to Excel question
  212. find record and set active
  213. Mouse over in VBA
  214. Record Data Manipulation
  215. Error while Updating the Table
  216. password protection?!?
  217. More on using Excel from Access????
  218. what operating system and office version
  219. Draw a triangle on a report
  220. How do I use CreateObject?
  221. help cannot use edit function on recordset
  222. The LIKE operator
  223. Access working with Microsoft Word
  224. Type mismatch error on OpenRecordset
  225. PreviousControl
  226. Set value of field = to record number in form
  227. Active search display
  228. Refresh Combo Box based on Query
  229. Help linking VBA to a report
  230. Trigger E-Mail from Record count
  231. Can I show Execution waiting time?
  232. Automating an update depending.....
  233. dropdown to set multiple query filter criteria
  234. update data to mdb on web
  235. Why won't this code work
  236. Football Fixture Lists
  237. Stuck on Null!
  238. Changing password in code
  239. Access quitting on DoCmd.OpenReport
  240. initialize 2 dimensional array
  241. Help needed: Database and Reference Error
  242. Field's name property
  243. VBA event handler help for Excel
  244. Variable as a name of the recordset's field
  245. automating page setup
  246. Could someone take a look at this code please?
  247. Opening MS Outlook before running a query....
  248. Access 2002 backward compatability
  249. Compile Error with Form Code
  250. before update event > save record?