View Full Version : Modules & VBA



  1. Sockets \ (winsock?) possible in access 2000?
  2. Using VBA to add values from one field to another
  3. DoMenuItemMethod
  4. can somebody help a complete idiot with the DLookup function (2nd edit - sorry)
  5. Working with a Lotus Notes Database Through VBA
  6. Linking Back end to Front end once Database is split
  7. Trim Function not working in Access 2000
  8. Script?
  9. Email a Report Using a Command Button
  10. filter by current user
  11. Controlling DoCmd.Close
  12. MS Graph Not Updating....
  13. i am at my wits' end - i've tried DLookup, DLMax...etc...please help
  14. Form/Report Design
  15. Date search
  16. Access modules
  17. Updating a field using Access Code
  18. Code to Tab Between form and subforms
  19. Creating new values in a table based on existing values
  20. Can't compile module b/c sub is out of scope??...
  21. references
  22. Opening Access reports from VB program
  23. Displaying multiple selections from areport in a table
  24. ASKI FILE
  25. Can anyone help me.....!
  26. DoCmd.SendObject
  27. Command in VBA to delete records
  28. Is IsObjectLoaded a vb method?
  29. Two Delete Message boxes
  30. Determining what group a user belongs to
  31. Adding a - to the end of a string.
  32. Invalid Argument - Error 3001
  33. Email Report using only Current Record
  34. Null Values
  35. Convert Report into Excel Spread sheet
  36. Mailing
  37. Mailing
  38. ameding records
  39. Coding Assistance....Last business day of month
  40. Setting Up a Database where attachments when opened
  41. Strange AppAcctivate behavior
  42. Can you Set two criteras in a Query?
  43. Setting Column Width Programatically
  44. Suppressing Import Message
  45. Suppressing Import Message
  46. Open result from datasheet view
  47. VBA
  48. Macro conditions problem
  49. Help with turning off append/delete query messages.
  50. validation rule giving me "run time error 2115" grief
  51. Class module reference
  52. Find Latest Date before Current Date
  53. Combo/List Box Populating
  54. Purging Records Automatically
  55. Code disappeared!
  56. Automate Printing of PDF
  57. Help!!
  58. appending a record using code..
  59. Limiting # of Open Databases
  60. opening MS Word
  61. Delete & Create an AutoNumber Field
  62. Catch 22
  63. carriage space in code
  64. setting variable of ActiveForm
  65. Exporting Query to Excel
  66. appending a record using code..
  67. I need a date....
  68. hide database window
  69. Getting output from command prompt
  70. MSGBOXES!!!!
  71. Input Boxes
  72. dbCurrent as Database
  73. odd order of events
  74. Referencing from Modules
  75. Multiple criteria for Query from List Box
  76. Set primary key based on date
  77. Validation rule to only allow todays date to be entered
  78. Control calculations
  79. Adding info from other Tables
  80. lookup procedure
  81. Using Sendobject to email Excel spreadsheets
  82. I wonder if I'll ever get this...
  83. ListView control won't display columns
  84. EOF
  85. need to make a custom function to split a sentence into words
  86. Incomplete info Message Box
  87. Update Method
  88. Filenaming
  89. Why is it Null?
  90. Write Conflict Problems
  91. Upgrading to OfficePro2000
  92. Transferring text from one field to a hyperlink field
  93. Getting NT authentication information
  94. Recalling data in a form field
  95. Globals in queries
  96. CURRENT USER
  97. Pass variables to reports
  98. SQL SELECT difficulties
  99. VB Propercase Conversion
  100. Update Query
  101. popup control button
  102. Any good VBA books?
  103. SQL vba ?
  104. Open Document Using Combo on AfterUpdate
  105. Problem using 'DoCmd.OpenReport'
  106. Building Text String
  107. Converted 97 code won't work in a new 2000 db
  108. TreeView Control Expanded when form opens.
  109. Call functions
  110. Null Problems with using data access class
  111. OnClick Counter
  112. Error 94 invalid use of null
  113. Vba-Set control visibility by vba
  114. I need a real code expert.. 'Cause I'm not :)
  115. Filter help
  116. Vba-run time err 2450
  117. Vba - Using variable to view only part of a
  118. functions not working
  119. Calling A Procedure
  120. Improper If’s executing
  121. dlookup problem
  122. parsing btwn class modules
  123. Largest number in field (unsorted)
  124. Do Until Loop, Sum then Write
  125. Do Until Loop ? II
  126. class module- to use or not to use
  127. class module- to use or not to use
  128. DLOOKUP and DMAX Together
  129. Using DCount with two tables and criteria
  130. Connecting Outlook (Original reply by Travis)
  131. transfering groups of database objects
  132. Access Permissions
  133. displaying information in continuous forms
  134. Active X calendars
  135. Controlling how Access Fills in Bookmarks in Word.
  136. Dynamically declaring the length for the Left(str,len) function
  137. using an array to add several textboxes
  138. Cancel command button
  139. Trying to update date to current whenever a specific condition is met...
  140. Recordset Too Few Parameters
  141. Ping from Access Database
  142. Refering to the currently selected ListItem
  143. Variable not declared as a particular data type
  144. Understanding Code execution in Reports
  145. recordsets and subforms
  146. Command Button to update tables
  147. copying data
  148. Compact Database??????????
  149. Splitting a database
  150. Controlling Excel From Access
  151. Tough Problem With Two Subforms
  152. I want to know how the screen resoulution of the system of a user can be found out us
  153. A simple one for the logic gurus...
  154. Insert a string into a control property
  155. Code Builder
  156. help with "DoCmd.OpenForm"
  157. Class Module - maybe
  158. Copy and Paste
  159. Virtual Reality panoramic picture insertion
  160. How do you temporarily hold output from a query
  161. Repeating data entry
  162. if statement question w/LIKE operator
  163. year and autonumber field to create a primary key???
  164. Change Field Data Type Using vba
  165. Dates Merging
  166. Help- Open recordset
  167. Passing parameters to a Chart
  168. Forcing a subnode to have the focus in a treeview control
  169. Capturing the value in a parameter query
  170. run time err ‘5’
  171. Visible field on a continuous form
  172. Placing a value from a function in a Query
  173. Trying to use a function to fill a text box
  174. Easy way to handle TopValues?
  175. Auto populating a field
  176. run time error!
  177. Coding Help
  178. How do I use option buttons with VBA in Access 97
  179. Need help with controls that have no On_Click properties
  180. evaluating an empty textbox w/ isnull()
  181. Iterating through SubItems collection of a given ListItem
  182. clearing textboxes when opening form
  183. Compile Error
  184. Defined Type not Defined
  185. Run Time error '13'
  186. Help Code Experts..
  187. Sending a report
  188. Find and Replace
  189. creating and running a SQL statement in VB
  190. how valid is this variable assignment?
  191. Simple if you know how...
  192. SendObject Help
  193. Passing list box selections to query
  194. calling function in a query to update table
  195. Coding for Email
  196. Supressing and error message
  197. Open file
  198. Printing from another database
  199. cant reset visibility property
  200. Turn Off Message Warnings
  201. count # of records
  202. loop statement
  203. Compile Error / Variable not Defined
  204. calendar
  205. Code Required
  206. Finding out how many records an SQL returns
  207. Microsoft Access can't open the mail session
  208. printing reports
  209. password protecting db
  210. Change location in the Open Dialog box
  211. how to implement a search
  212. Insert Into
  213. find record
  214. Compile Error - Hidden Module
  215. Help needed on code, totally stuck!!
  216. TransferSpreadsheet Method in 2000
  217. Same Command Button for two different forms?
  218. Same Command Button for two different forms?
  219. I keep being able to bypass Access user-level security...
  220. Multi User Passwords
  221. watching variables
  222. retaining global values
  223. Memo field not displaying
  224. Updating a value in a text box
  225. word wrap in msgbox?
  226. Time calculation
  227. looping help
  228. need to learn error handling
  229. update two fields based on criteria from one
  230. Unique Number
  231. File Rename within Access
  232. TransferDatabase Command without overwrite
  233. form open & close code mixup
  234. Distinctcount
  235. OnExit not working
  236. code exists but not executing
  237. 1 code for many events
  238. obj required run time err – why?
  239. VB sql to return value
  240. Using Previous Record in a formula
  241. ok....how about emaililing someone based on field contents? =]
  242. OnClick question
  243. need opinion on array function
  244. Duplicate Records
  245. follow-up question about SendObject
  246. Scanning proxy server with time criteria
  247. How to detect if a subform has data or not?
  248. Passing list box selections to query
  249. Select query in VBA
  250. Is it possible to change the default code editor colour scheme (A97)