View Full Version : Modules & VBA



  1. How do i open an OLE word object
  2. Identify User
  3. Creating text file in code
  4. Temp recordsets and SQL statements
  5. Immediate Iifs and buts
  6. Can i disable the right mouse button?
  7. SQL Related question
  8. Max number of characters for Recordsource
  9. SQL results in VB
  10. Sendkeys to application
  11. Need help on Building an SQL statement
  12. How to delete archived files?
  13. Closing Recordsets
  14. Speed
  15. Password Question
  16. sql question on form code
  17. Record locking woes
  18. Need a procedure to modify a yes/no field
  19. Is it possible to work a task pop-up reminder to users?
  20. Help:VBA in Office '03
  21. Count equivalent
  22. Refresh Public Declaration
  23. close forms
  24. Data Type Blues
  25. options for printing report
  26. Problem with ocxCalendar (code)
  27. Moving a value from a variable to a table
  28. user friendly message
  29. Lost in SQL
  30. ByPassing AutoExec in Code
  31. Outlook Redemption
  32. Password protected form
  33. Check File Path Accurate...
  34. Timeout Expired
  35. Date Clause
  36. Examples of Temporary Recordset Code?
  37. How to use "workspace" properly
  38. Error in SQL Statement
  39. Updating Subform
  40. Problem with Code
  41. Access and Outlook
  42. Multi-user application + database access
  43. Excel Automation Clean-up
  44. a frenzy of numbers
  45. Learning VBA
  46. email automation
  47. Update problem
  48. Stick additional digits in front of a number?
  49. Startup form doesn't show anymore
  50. Duplicate id routine not working
  51. Delete Records From Temp Table
  52. mscomm32.ocx
  53. Securit Module
  54. Moving Files
  55. What am i missing?
  56. Relinking tables
  57. Multi *HEIGHT* list/Combo boxes?
  58. Create data in table
  59. Update a form with recently added recordset
  60. OutputTo Excel
  61. How do you enable a module
  62. Open OLE Link in VBA code
  63. cannot open form and subform - "you cancelled the previous operation"
  64. Toolbox
  65. Need to Save Twice??
  66. Solving a formula
  67. Run-Time Error 3075
  68. Access/Outlook Email Automation
  69. TransferDatabase
  70. Creating a blank query programatically
  71. Creating Report based upon multiple fields
  72. Call Statement
  73. Second Error does not get trapped
  74. What's wrong with this code?
  75. Delete records with criteria
  76. most profitable month
  77. dates/weekdays calculations
  78. Code that does same thing as Excels Goal Seek
  79. Updating a Date based on Yes No Checkbox valuie
  80. need to maximize all windows in my database ....
  81. Deleting temporary tables.
  82. Can't find project or library (Compile Error)
  83. odbc set-ups by using vba???
  84. Access Invisible
  85. Deleting and making relationships
  86. Compare Databases
  87. Catching keypresses (cursor keys)
  88. insert decimals into a table
  89. RefreshLink makes tables read only
  90. Button Problem
  91. Date Calculation
  92. Access 97/Excel 97 OLE problem
  93. Export Table to HTML
  94. code does not fall through IF statment for Yes/No fields
  95. Wait until file is not in use
  96. Customising a Parameter Query
  97. Need to loop through
  98. Check for valid file path in database
  99. Show Linked BackEnd
  100. Variable Declaration
  101. Insert New Records with Range of Values
  102. Specifying a new user/pass for the current database connection
  103. Help with running SQL statement from Button
  104. call excel functions in access
  105. Unknown message receipt
  106. Code to delete duplicates not working, too slow
  107. Schedule Compact
  108. Need To Create Outlook Task
  109. set value of several controls based on particular value of another control on subform
  110. Copy a Value from a Query
  111. DAO vs ADO?
  112. Switch from 97 to XP - Code doesn't work
  113. Check Value in Table
  114. Date in RunSQL
  115. Queries or SQL?
  116. Create a Unique Tracking Number
  117. Opening a Word doc based on a template
  118. VBA Code Reqd
  119. updating a blank field with its record number
  120. Difference between strings
  121. Navigate Form's Recordset
  122. Differences between DAO & ADO
  123. Executing a DOS command from a module
  124. Changing record source in VBA
  125. Multiple Subs
  126. Query's, Recordsets and parameters
  127. How accurate is Access as a timer? (Timing of Events)
  128. Listbox only showing one item
  129. Tax Table.
  130. Building a txt box from 3 tbl fields...have one question
  131. Compile error does not highlight offending statement
  132. ACCESS/OUTLOOK Email Warning
  133. Recordset from secured database
  134. disable access msgbox while runing append /delete queries
  135. Question About Report With Multiple Printer ?
  136. Compile Difficulties
  137. Bug in Code
  138. Recordsource problem
  139. DMax() and recordset?
  140. Another SetWarnings Question
  141. Updating Related Table
  142. FileSystemObject
  143. using VBA to open a linked OLE object
  144. Error #3464
  145. Pull Single Value from Table
  146. Using Path as a field
  147. Delete Controls
  148. Running Access Query from Visual Basic with parameter
  149. Null Problem
  150. Listview colors
  151. Close Query sub
  152. Create Records with Range
  153. "AutoKeys" in a library database?
  154. checking tables
  155. Message Box
  156. VBA Value Range
  157. Finding next number
  158. Create GroupWise Email with Access
  159. C logic equivilent in VBA?
  160. ActiveX
  161. Save As Dialog
  162. Logging the control that caused error on form
  163. Calculation returns #Error
  164. String Manipulation
  165. Transferspreadsheet/Import Question
  166. Function and Multidimensional Arrays
  167. Edit field
  168. Modifying AllowAdditions property using VBA
  169. You Cancelled the Last Action
  170. Passing an optional value
  171. Loop through recordset
  172. Finding Median in Aggregate qry - Jet error
  173. Access control of Word through VBA (error: remote server machine does not exist)
  174. StrConv Function
  175. Creating relations between tables in VBA
  176. Referencing fields in recordset
  177. Access ListBox
  178. Import Specification and TransferText
  179. Wish to hide the output window
  180. Access to Outlook headaches
  181. Setting a Field Sort for a Table
  182. Iterate Through Forms Collection To Get Recordset
  183. Setting a reminder in Access onto a shared Outlook calendar
  184. Accessing a Excel protected workbook
  185. Should I have several modules or just one?
  186. Mouse Pointer Location - (Get/Set) API Calls (GetCursorPos/SetCursorPos), Controls?
  187. Lotus Notes - Opening database
  188. Public Function Debug
  189. Break down lines of code
  190. can't delete class object in object browser
  191. FormFilter, apllyFilter etc..
  192. syntax help
  193. Syntax Help Please
  194. Store backend file path
  195. On DB Close
  196. Finding duplicates in an array
  197. Open Excel From Access
  198. Export read only error
  199. Command Button code to preview a report
  200. Error in search form
  201. Not Like Operator (Access 2000)
  202. Test if record exists
  203. Getting a 3464 Error
  204. Function not Available - 3075
  205. Continuous Form & Current Record
  206. Insert code...
  207. Pre-load Forms
  208. Non Latin Characters
  209. Cycling Through Tables
  210. the save operation failed
  211. bogus error message 3125
  212. Assistance with Select Case Statement
  213. Me again...
  214. Programatically Export Access Data to DBF
  215. How much code is too much..
  216. Help with bug fix!
  217. Null Value? Empty String? Zero Length?
  218. list with check box help
  219. Promp "Save As" Window For User
  220. Convert Excel file in older format
  221. Accessing a secured database objects from a VB application
  222. How to get a notification message thru email when users submit a form?
  223. Data1.recordset.findfirst
  224. Using VBA SQL for combo box record source?
  225. multiple subform in a form
  226. Redistribution of quantities from one recordset to another
  227. Run Report A or B based on Item in Table
  228. Msg Box Specifying the action of NO
  229. TransferText Problems
  230. Excel Module from within Access?
  231. Parsing comma delimited string
  232. Open MSword doc, search string & print page.
  233. Hooking column select
  234. Custom error message on multiple lines
  235. Check the contents of an external file
  236. cnn.Execute problem
  237. User-defined Type Not Defined
  238. Import multiple txt files into one table
  239. Move/copy/delete a folder with access
  240. Access 97: Dirty Property
  241. Toggle Visible Property
  242. Using (kinda) embedded pictures etc without ballooning... a solution
  243. Relationships
  244. New Record First
  245. Pass Value to Subform
  246. Execute a Command Button on Diff Form
  247. Dlookup or ? to compare windows login to a table of allowed accesses
  248. Checking for a null value
  249. Rich Textbox Controls in Access 2003
  250. Load data from Internet to Access