View Full Version : Modules & VBA



  1. If statement not doing what I expect
  2. run-time error 91 with recordset in form
  3. Concatenating Problem
  4. After Splitting
  5. Code to restore the previous value.
  6. Sendkeys "{ESC}" closes open form.
  7. Problem Inserting Record Into Table
  8. Function Problem
  9. BE/FE Startup Problem
  10. Searching title
  11. Help with date diff
  12. Data Manipulation
  13. How to Use Recorset and Loop
  14. record error information to a table
  15. HELP - Need OrderBy Solution for Report
  16. Expert Advice: Need To Open the VBE outside of Access
  17. intermittent Access to Word "Copy & paste" anomaly
  18. Multiple Email Addresses in Lotus Notes through Access Query
  19. Mobile Integration
  20. Error 3258 VBA SQL
  21. simple (i hope) VBA problem
  22. Access Programming tutorial
  23. Calculating PCI BMI
  24. Open a file using code
  25. Closing Adobe after printing PDF file
  26. Winzip encryption
  27. Overflow Error
  28. Object Libraries
  29. highlighting based on VBA code
  30. Using VBA to Export Multi-page Report
  31. Error Expected: )
  32. filtering combo box on form using vba
  33. hiding excel manipulations and showing a progress bar
  34. Saving databse
  35. Date Validations
  36. Half way there
  37. Accessing Public variables
  38. SQL Statement
  39. Problem in a recordset with the next one
  40. How does the code work?
  41. determine word is open?
  42. Difficulty With ListBoxes
  43. save on close problem
  44. Opendatabase problem
  45. Can't add worksheets to multiple spreadsheets from Access using VBA
  46. runtime func name
  47. % datatype
  48. OnClick SQL Select -> Compare -> SQL Update
  49. Field/control display function
  50. Saving file as xls with VBA code ?
  51. storing address of active cell
  52. filter column
  53. password for backend database
  54. Public/Private Functions Or Subs
  55. Error 2486 - Cannot Perform This Action at This Time
  56. input form for a scan gun
  57. Finding Database Size
  58. Allowing a macro to log in to Oracle ODBC automatically
  59. Reduce the code ?
  60. Error Message
  61. Append ONE Record
  62. Populate Table with start date to end date
  63. Code to supress warnings in excel
  64. MySQL date problem
  65. Date problem
  66. Forcing pagebreak through code in report
  67. Mailmerge Word problem in VBA with change of location/machine.
  68. Maximise on start up
  69. Running code after a Yes/No response
  70. Type
  71. Help with recordsets - DAO
  72. Update table data with VBA
  73. Recordset problem
  74. Database locked - why?
  75. get real user name
  76. Fax function malfunction
  77. Make a path with spaces "clickable"
  78. Lotus Notes Email to Multiple Recipients
  79. Add Builtin Option to Custom Menu
  80. Do while loop not playing the game
  81. Hiding Text box code
  82. filling and using arrays
  83. ODBC password confirmation
  84. Requery subform (not linked)
  85. VBA for Legend label
  86. Addressing subform field in Where clause
  87. Copy and then Rename a document
  88. Modifying the default value of a field?
  89. Remote shutdown of a shared DB...
  90. Update Sage Tables
  91. Count Whole Months
  92. Need simple counter module
  93. HELP! - How to parse memo field?
  94. Refresh a single record in a Query or Form (datasheet)
  95. Stuck with a query in VB
  96. VBA to read and write to particular record's field
  97. Check to see if a file exists
  98. Changing a field in all records in a subform
  99. Rename Module
  100. Currency Round UP
  101. Update record of a table
  102. Text boxes...
  103. close all forms, run action query, then quit???
  104. Pass string from Access 97 to Word?
  105. Simple Email Code: Send an email while looking at a Form
  106. Need code to update fldFY05 IF fldDate is > 7/01/04
  107. SQL as row source for a combo box
  108. Stand Alone Software!
  109. Accessing button on subform ...
  110. Function won't eat Null...
  111. help Please
  112. Put text string into a Word document?
  113. Chart requery
  114. Charts in Access
  115. Copy "New_value" of a period as "Old_value" for next period
  116. One service, different prices for it/city
  117. FileCopy Function
  118. redim preserve multi dimensional array
  119. ComboBox.Column in a Query
  120. Re: email with criteria?
  121. Date format
  122. Sort (order) data on forms
  123. ADO Connection String Class
  124. VB filter help please!
  125. QueryDef + Variable
  126. Access 2004 "Expression on Click Error"
  127. Turn Off Outlook Save to Sent Folder
  128. One-to-Many export to new Database, and retain structure.
  129. newbie needs quick help
  130. Unconventional Conditional VBA Formating
  131. Delete a file that is kept OPEN
  132. opposite to ABS function
  133. AfterUpdate Question
  134. Generated Code From CMD Wizard
  135. OutputTo: Variable Path, Fixed Filename
  136. Todays Date (But Editable)
  137. Calculation result problem
  138. IIf Statement, Please Verify
  139. Before using made find button how can i make it so a field is selected
  140. use search value to populate a txt box
  141. returning an ID from the last record inserted with query
  142. Unable to get excel to close after import
  143. integer equal value of another integer
  144. Functions
  145. trusted SQL SERVER connection
  146. Difference Between Calls
  147. Error 2046?
  148. Need help returning values from database in vb code
  149. Force carriage return in string
  150. String limit?
  151. Need help using QueryDef to create SQL
  152. Examine ALL beerinput
  153. Odd stuff - Overflow Error
  154. Beyond my VB ability
  155. For Each - Record Add
  156. openargs function
  157. The Collection Object
  158. Passwrod to close Database
  159. Reset a field's value
  160. help with chart for loop
  161. File Check???
  162. Textbox Scroll Problem
  163. VBA: Is it possible to check for a duplicate entry in a table before insert?
  164. For...Each - can it apply to form section controls?
  165. A Veriable (what is it in VBA)
  166. Need automation tool for Save As action
  167. Shell command
  168. Carrying over field data from form to form
  169. Please Check
  170. Code for calculations
  171. Calculation based on yes/no boxes
  172. Add hyperlink in Lotus Notes from Access 2000
  173. Save and move to next control
  174. Creating ODBC DSN Connection
  175. Numerical Data Only + Textbox
  176. Relation based counter
  177. One click creates a new database
  178. Save Record + Not Using The Wizard
  179. If field = "" Then...
  180. A quick solution to an annoyance
  181. Another "IF" PROBLEM
  182. Select case statement and controls
  183. Using MS Outlook
  184. Outlook Problem
  185. VBA Drop Down Box Activation
  186. rs.findnext problem
  187. Send file to pinter
  188. OK | Cancel Msg Box?
  189. merging rectangles
  190. Masking passweord input with *******
  191. reduce window size
  192. Error Trapping not working
  193. Looping through files in a folder
  194. Date Forcasting
  195. Auto Update Database
  196. returning key and text of specific nodes in tree / treeview
  197. Application won't die!
  198. Move Form with Rectangle
  199. Breaking down strings to search on
  200. OutputTo Report Pages
  201. Changing a variable value into a variable name
  202. String Editor
  203. how to break a long piece of code into subroutines
  204. SQL Statement
  205. Editing Restriction on Form - How to help?
  206. Merging Fields - some help with my code
  207. Moving Around a Word Document
  208. QueryDefs and dates
  209. Remove two small squares at end of string
  210. Copy To Database
  211. Compile MDE through Code
  212. What is the difference?
  213. Form/subform go to new record
  214. Shell command passing variable into
  215. Remove Filter By Form parameters
  216. Change Report Printer Settings
  217. Password Protect Excel File
  218. Do Until Loop not working?
  219. Space In MsgBox Code
  220. Inserting Outlook auto-signature
  221. Word macro
  222. Best Post Code Validation?
  223. Ordering Validation Functions
  224. Don't show alert messages
  225. Problem with recordset loop
  226. Form Recordset Problem
  227. Silent mode for long batch update
  228. Another OpenRecordSet problem
  229. Help with Math in this function
  230. If Problem
  231. Inner Join within a VB module
  232. calculate number of working weeks between two dates
  233. importing multiple txt files into Access
  234. Subscript out of range error
  235. Return Array
  236. help with my function
  237. Syntax error in FROM Clause
  238. Single Select List Box
  239. Deleting tables on exit
  240. Function Madness syntax error on call
  241. Collection Key/Index
  242. OldValue of a ComboBox non-bound field
  243. Working with dates
  244. Displaying Correct Recordcount/CurrentRecord
  245. Open a Doc with VBA
  246. Cloning a set of records within a table strategy
  247. List of Reports on a combo box(sorted)
  248. Set Rowsource Propety- Excel
  249. Sub Error
  250. Queried Form Results Open Another Form to Specific Record