View Full Version : Modules & VBA



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