PDA

View Full Version : Modules & VBA

  1. text expression
  2. Displaying values of a few fields from the current form to another form!
  3. Filter with date - problem
  4. Open a file using a non MS office application
  5. Return last date in a month plus one year
  6. I have to run the update query twice for it to work!
  7. Using ShellExecute to View PDF's
  8. Align Text in Message Box
  9. Align Text in Message Box
  10. Help working with a table
  11. Help working with a table
  12. Unique records
  13. Recordsets in Access 2003
  14. Opening Access From Excel
  15. Want to combine some code but not sure how
  16. Record locking for dummies...?
  17. Setting criteria for my form (in VBA), why isn't this working?
  18. Activate a workbook based on a value in a cell in another workbook
  19. CopyFromRecordSet gives 430 run-time error
  20. Compare Code in Two Access Databases
  21. printing an external document ??
  22. Putting Access fields in WORD Document
  23. Convert date to int or long ?!?
  24. top 10
  25. how to i run a macro that alters a record in a report.
  26. multithreading in access
  27. openQuery without display
  28. Linking a form to multiple tables
  29. Importing a Table Using VBA
  30. Dlookup newest record by date
  31. Trouble with update button
  32. On Click add 1 to bound text box
  33. ListBox .Value not updating
  34. Splitting the database
  35. problem exporting approximately 500000 records
  36. TransferSpreadsheet Run time Error 3125
  37. rs.find --> searching through currency dataype column (D.A.P.)
  38. Temp Qrydef in SQL string?
  39. Detect scrollbar - urgent??!!
  40. Reset Page property on report
  41. ALTER TABLE problem
  42. Trouble with a search/update button, please help
  43. Help with listing subform controls
  44. Combo Box Syntax Error
  45. Trap Error
  46. Error in code for an edit button
  47. OpenRecordset error
  48. Clearing the Immediate Window
  49. Delete and backup fields
  50. Runtime error 429: ActiveX can’t create Object
  51. creating an access db
  52. string to object
  53. Can i use a record as a variable to then place in a query?
  54. BeforeUpdate and Cancel keep getting Messagebox though
  55. Help opening form
  56. there is no EOF in my code
  57. Searching For a record
  58. Yes No command in msgbox
  59. Different Msgbox
  60. Access to Excel export assistance
  61. It does not like this piece of code
  62. It does not like this piece of code
  63. Would like to click on a button that opens MS Outlook with/User email add.
  64. Finding the source name in standard module
  65. Using Word as my Email Editor
  66. how to close a database after delay
  67. Not in List function
  68. How to interpret Lotus Notes API docuentation
  69. Indexed Field: Creating via VBA
  70. Looking For Simple Query SQL Command
  71. access to excel
  72. Simple Question with IF statement.
  73. For Each Loop
  74. Not so simple question: BLOB Images, HTTP download
  75. Login Form - Masked Unique Key Problem
  76. Trouble with opening form code
  77. Email using strMail
  78. Adjust excel-columnformat on export
  79. Hair tearing time -AAAArrrrggg!!!
  80. Would like like to improve my Query
  81. Would you like to improve my Query
  82. Would you like to improve my Query
  83. Run-time error don't understand
  84. Error handling
  85. For Each Next & ItemsSelected - strange behaviour
  86. Serial Route Memo via Code
  87. AllowZeroLength Function
  88. Spreadsheet Control in VBA Form
  89. access task
  90. Class Module Parameter
  91. access email
  92. Need to locate files on network share
  93. In subform, use a command button to open form
  94. Activate excel workbook
  95. visible if field is not NULL
  96. CurrentProject.Connection failure
  97. change a table entry
  98. access to outlook
  99. Label OnClick Event is calling Function Twice
  100. Msgbox question
  101. ADODB.AddNew not generating incremental ID
  102. Exporting Access table to Existing Excel worksheet
  103. Reading CSV files
  104. Combobox ListIndex and AfterUpdate
  105. Running a query in VBA
  106. Converting case type
  107. Text Selection
  108. Between Satement
  109. formatting a txtbox within a report via VBA
  110. closing excel in access
  111. Microsoft Web Browser http 404 error
  112. Reset Form
  113. acCmdFindNext Settings
  114. Autocomplete Turned Off
  115. Split OpenArgs to Multi-Dimension Array
  116. Next line of Msgbox, not sure how to do
  117. Msgbox if no records to display
  118. combo box, make .visible when combo field selected
  119. Using BULK INSERT to Load a Text File to MS Access
  120. Security checking module not referencing form variables
  121. Compare field names, adding/deleting fields
  122. Form run-time 2105 error
  123. Ambiguous name detected: AfterUpdate
  124. Converting string to date
  125. Accessing Excel through Access using VBA
  126. SubForm
  127. Pasting charts into Notes Memo
  128. Table to table
  129. send data from a table to another
  130. onNotInList combo ->> open form x
  131. Error in Access 2003 Runtime MDE
  132. uploading .csv file to access
  133. Notes Dialog Boxes
  134. Error when report is printed from preview view
  135. Reading Field Data into Variable
  136. Appending data from Access to Excel
  137. How to see ALL users, not only logged users?
  138. createing a blank excel file through access vba
  139. Opening a Form on Startup Help
  140. Dynamically Link SQL Sever Tables at Runtime
  141. Variables and decimal places
  142. Look Up Function
  143. send email from access
  144. LostFocus driving me insane
  145. using a console
  146. Moving Data From One Table To Another
  147. Past Business Dates (Exclude Weekends & Holidays)
  148. Calculating......Error when opening a sub form
  149. Last Business Date Of Month (Excluding Weekends & Holidays)
  150. I Ran accross a great example of selecting muti records and sending emails
  151. Spreadsheet Control in VBA Form
  152. MoveLast doesn't move last...?
  153. disable datasheet rowheight adjust??
  154. Avoid msgbox when deleting
  155. calculations
  156. Save Report as "field value" & ".html"
  157. VBA SQL Word Mail Merge Problem
  158. Problem w/ShowToolbar
  159. Tabular form/report - alternate line colour?
  160. Using RunCommand RecordsGoToNew
  161. Help with simple If Statement
  162. Updating Form Data
  163. tabledefs.delete and open for output doesn´t delete.
  164. Block If Without End If?
  165. change a value on a form when entering the form
  166. Reference for 'Inherited' property
  167. rename Excel columns and import
  168. wondering if it can be done
  169. Exporting Lots of Data - Best Approach
  170. Simple question about button
  171. Empty and re-fill a table within a transaction
  172. Getting Text from Richtext
  173. Sub Form Auto Save Disable && || clear subform field values
  174. delete linked table
  175. Query
  176. acClose form, Msg VBy/n
  177. acClose form, Msg VBy/n
  178. Merge to Word stops after first line
  179. Which group is the user part of?
  180. Embed code inside OLE?
  181. Problem with recordset EOF
  182. Compile error
  183. How to create standalone applications in Access 2003
  184. How to create standalone applications in Access 2003
  185. Problem with recordset EOF
  186. Outlook email from MS Access
  187. Changing font color if value for another field equals...
  188. SQL in Access
  189. Referring to buttons on subforms
  190. Can you help me on some code please
  191. recordset error 3021
  192. Basic VBA task
  193. DMAX Problem driving me nuts.. HELP PLS
  194. Need to Eliminate Hard Coding
  195. Hidden Characters
  196. Comparing Records within a Table
  197. Pass through query
  198. Combo Box null value
  199. extracting data from strings
  200. Resetting the primary key
  201. Need help from the Experts Please
  202. Creating A New Database
  203. No Clue what I'm doing
  204. Data Parsing Problem
  205. Find which field has focus
  206. Query output to emails
  207. Carrying string variables on call to sub
  208. Simple, I just don't know how!
  209. Database Security - set object permissions?
  210. Auto-Enter Previous Record Date
  211. Comparing Date Ranges
  212. Sending HTML E-mails
  213. Confiration Number with 3 parts?
  214. How chceck if record i want to add isn't already exists?
  215. Message Boxes
  216. Hiding Labels
  217. Exporting to a text file
  218. Trouble converting nulls to zeroes using Nz()
  219. IF criteria
  220. Access 97 working slowly...???
  221. How to escape separator in multi column comboboxes?
  222. Spell Check in Acess - Disable the save
  223. Run a macro based on an iif statement
  224. Combo box col 3
  225. DateDiff question...
  226. If function
  227. Help with Message Box
  228. SQL and VBA query
  229. Updating Fields on clicking command button
  230. Hiding Code
  231. Combine 3 text fields but I get a syntax error
  232. printer issue. urg!
  233. Sub returns a value???
  234. Trouble importing unusual text file
  235. emulate on_keydown, (possibly sendkeys)
  236. Populating text boxes from a list box
  237. Printing Notifications
  238. Drop/Stop/Halt Code
  239. Nested Loops
  240. Filter Query By Date
  241. Show MsgBox rather than Standard Access Error
  242. Loop inside If..Then Statements
  243. Write Conflict error, not sure how to fix this
  244. Are string data types dynamic?
  245. mscomct2.ocx
  246. If statement with date diff..help please
  247. Not in List
  248. button Collects Emailaddresses then open a form to create a report
  249. Reset check boxes
  250. onMouseOver equivalent for VBA