View Full Version : Modules & VBA



  1. Open excel form access
  2. PasteSpecial
  3. Max number of characters
  4. What is wrong with this code?
  5. time out for connection
  6. VBA code to set taskbar to autohide
  7. Update/Insert Code
  8. Copying cells to Excel as I want them
  9. I need to create a custom aggregate function
  10. What event happens when jumping from form to form?
  11. Best way to empty a variable
  12. Event query
  13. Excel backcolor cell from Access
  14. SQL statement error on certain computers
  15. Dlookup remembering...
  16. Looking in a table
  17. runtime 6, overflow
  18. VBA and arabic script
  19. Problem with Referencing Office 10.0 Object Library
  20. Timestamp in file name transferspreadsheet
  21. Command Button that Sends Email with Username and Computer Name
  22. variable controls???? HELP
  23. Problem with DCount Statement
  24. Print a Memo field
  25. referencing a form in another access database
  26. Changing Field Name
  27. Linking textbox to a option group
  28. Lockout if table mis-spelled
  29. Recordset trouble
  30. A user Stop Button
  31. DCount Multiple Criteria
  32. excel automation and coloring
  33. DSN-less Connection To Oracle DB
  34. Simple I think
  35. Supress Err
  36. Search then Calculation in form - help
  37. Code to send email with attachment
  38. Check dates and flag message
  39. searching 20 weeks back
  40. How to Detect If Process Is Running?
  41. Select Copied Record
  42. Password when reconnecting linked tables
  43. how do you create a changing control name
  44. Update and Insert in a SAVE button (Urgent! thx!)
  45. from wont open read only
  46. DSUM Problem
  47. Excel Functions in access
  48. Checking in empty table
  49. Create 9.99 column with SQL query
  50. VBA to populate fileds with vaules when using the on-click func for a toggle button?
  51. Field Properties
  52. SQL statement in VBA
  53. would like to enable a button when openform
  54. On Dirty event not Triggering
  55. ADO Create Procedure problem
  56. Accessing OLE data object
  57. Connection Error
  58. You cannot add or change a record
  59. Getting linked table
  60. why a column doesn't get updated
  61. RecordsetClone Problems
  62. mapping cell to column from Access-Excel
  63. calling a public function from a module
  64. Synchroinizing the Data Source between Two Subforms
  65. run-time error 13: type mismatch
  66. automation error
  67. VBA Check for reference
  68. Run Time error 2001 without apparent reason
  69. Error in Form_Curent
  70. VBA to save form
  71. weird effect
  72. SetFocus error on subform
  73. Recordset Update Problem
  74. Hide a tab control page?
  75. V. simple code = ?! (assign date to text box)
  76. Help, Please - VBA Word to Snapshot Conversion
  77. VB command list?
  78. Concatenate fields
  79. EOF and BOF not co-operating
  80. VBA Code to Open Outlook from a Database and start a new message
  81. End Of Statement Error
  82. recordset filters
  83. Checking for empty Recordset and RecordSetClone problems
  84. Searching for names on a form
  85. update column based on text box value
  86. Sent mail with Outlook 03 (use Access 07)
  87. Save - feedback
  88. one list box to another
  89. Closing a form using vba
  90. Code won't work correctly only with the number 7
  91. Embedding an image into an HTML email
  92. Error message
  93. docmd.openmodule on foreign db's modules
  94. Access 2007 - Default Directory Ignored
  95. SendMail
  96. Criteria for reports code problem
  97. Access and taking Pictures
  98. If statement
  99. Previewing Reports
  100. write conflict issue
  101. DbEngine
  102. "For Loop" Mail Merge
  103. Exporting Problem
  104. deleting saved data from a form
  105. populate listbox
  106. Save & Insert script Help
  107. Modify Table of Contents Module
  108. Linked Table Manager
  109. A string using a number, need help please
  110. forecasting
  111. Recognize Empty fields and report them
  112. Sequential numbers for each customer
  113. quantity update
  114. getting total ordered displayed
  115. Automation: Sending Access to Word
  116. Write unbound txt value to table
  117. code to force print layout
  118. On Load Event Double Launching
  119. Populate table with recordset data using vba
  120. Populating Dates via VBA
  121. Function freezes Dbase
  122. EOF loop Help
  123. Locking records
  124. Probably Simple
  125. When is an empty field in a table not really empty?
  126. Shell command to shutdown .exe
  127. Code works in A2k but NOT in A2K3
  128. Counting Records from VBA with SQL
  129. Import tables via odbc
  130. populate fields from related table
  131. KeyCodes
  132. Record Lock
  133. If "X" field of dif entries are the same, join em
  134. Function: "Object doesn't support this property or method" - Run-time error 438
  135. Listbox with varying background colors
  136. different code for maximize and minimize?
  137. DLookup Info
  138. strange problem with DLookup
  139. Problems importing a module using VBA
  140. putting form Procedures into modules
  141. Update long memo field in tables via VBA
  142. getting listbox selections
  143. generate report from listbox
  144. What should I remove from this code?
  145. permissions on a drive
  146. *** URGENT! VBA not breaking on breakpoints ***
  147. combo box not selecting properly
  148. Delete Certain Records with VBA
  149. Set Recordsource for a Subform using VBA
  150. Pop-up form not updating the record
  151. reference subform within a subform in a hidden form
  152. Requery Problems
  153. Can't get Access to display any error messages?
  154. Reference Numbers Haphazard in Reports
  155. Audit Trail Query
  156. Help with DB
  157. Requery Issues
  158. Code running too fast before Access performs calculation
  159. I need help with something a little more complicated
  160. how to make a subform in a hidden form the active object
  161. Set Page Margins
  162. Image In Access Window
  163. update code
  164. Import Spreadsheet depending on network location
  165. Password Problem
  166. Password Issues/Spliiting Database
  167. Set Focus to get text Box Values
  168. Acrobat save as optimized
  169. Reading From A Table
  170. Dynamic Default Values
  171. Date Value
  172. Using the docmd.addmenu command
  173. Automating Excel
  174. Append queries in vb
  175. Combo box/Listbox Help
  176. Undoing changes
  177. Protx Integration
  178. OLE object defaults
  179. VBA Reset
  180. Mail Merge: MS Word Cutting off Text
  181. Cool Search Tool Recordsets
  182. Enumerate ALL List Box items
  183. [access 2000] 7 lines that are killing me
  184. Complex looping: set up time continuums
  185. Search Between Two Dates
  186. Show parent records where childs exist
  187. Saving values on the on click event
  188. Perform Actions for Each 15 records a query produces
  189. Listbox help
  190. Sql syntax in vb
  191. help please...compile error: automation error
  192. Calculate different values for each datasheet row
  193. Reconnecting ODBC linked tables in MS Access via VBA
  194. When does a "shell" function ends?
  195. SQL with a VBA function fails
  196. Problem with how integer is displayed
  197. Disable/enable fields on forms
  198. Distinguish between ‘Active’ and ‘Inactive’ Records
  199. why the code would delete data?
  200. Multiple Import
  201. DLookup statement problem
  202. Locking DB From Time To Time
  203. how to get a value from combobox
  204. Calling / executings a Public Function sCase
  205. Is it possible to pass a variable from Excel to Access?
  206. Count Records
  207. DAO QueryDef and Parameters
  208. Using VBA to avoid the output of #Error on a report
  209. Week Numbers that start at 1st April
  210. Title Caps with tweak
  211. do while loop problem
  212. TransferText Query
  213. HELP with computations
  214. Change query thru Code
  215. Adapt DateAdd Module
  216. Looping through continuous forms
  217. Very Basic MSComm Problem
  218. Backing Up an Open Database using VBA
  219. forcing an update
  220. Not completely random selection
  221. screwed up "do until" loop somehow..
  222. Control properties not fully exposed upon creation
  223. Combo box source code difficulty :(
  224. Can't open form to correct record
  225. Forecolor problem- help?
  226. Over Flow
  227. Random Number Format
  228. Cancel Dialog
  229. How to create a msgbox based on subform results???
  230. VBA help:Exporting Column Names with Data from one table to another
  231. Sendobject
  232. hide queries and forms
  233. Filtering a report from 2 listboxes (both refering to the same field)
  234. Debugger stops working in Access VBA Editor
  235. Create an If statement based on a different query
  236. Head fogged truly by Excel worksheet move problem
  237. Adding a date before file extension on export of text file
  238. Convert CSV to XLS in VB
  239. [access 2000] code runs when opening form but not when opening as subform
  240. Import/Link Outlook Tasks into Access
  241. set date depending on current time
  242. Having trouble autoatically deleting tables
  243. Storing a maximum value at runtime
  244. Don't sendObject on close if record is cancelled
  245. I need help with a function code (getting a number from a string field, data manip.)
  246. Set value to True in code (Novice)
  247. Sorting field names in code
  248. Access 2007 SP1 Mail Merge Error
  249. FileSearch Object Anomaly
  250. Repeat Random String