View Full Version : Modules & VBA



  1. Copying Recordset
  2. Specifying printers in code?
  3. Delete exports when finished
  4. Keeping zeros in place
  5. Crosstab info into an array ...? (I'm lost!)
  6. Expressions in recordsets
  7. Edit Checks - No Alpha Characters Allowed
  8. Multiple String Replace
  9. Need help with database design
  10. Outlook.Application error
  11. Whats wrong with this code
  12. Write value to another field - error?
  13. Setting a public variable
  14. Strings in SQL Statements in VB
  15. Dlookup's
  16. Setting Primary Keys in a Table
  17. VB Syntax Question
  18. Command button shuts access down - WHY!?!
  19. Access Hangs
  20. What is wrong with this code? strings in VB
  21. 2 Primary keys please
  22. Macros out VBA in
  23. searching recordsets
  24. FileDialog
  25. VBA in a query or sum in VBA
  26. Enter Key problem
  27. how do you sum in VBA
  28. lets try a different angle
  29. Interrogate subroutine name
  30. Error with Delete Method - code check
  31. Backing up an opened database
  32. Code Needed
  33. Simple referencing, I think!
  34. Problem, help please!!!
  35. Call sub from module
  36. Save doesn't fire, but does when a breakpoint is set
  37. Error Code for "Could not find file"?
  38. exporting a range of cells to excel
  39. Get UNC for local file
  40. Excel Automation Message Avoidance
  41. linking excel with access
  42. Automatically queuing print jobs
  43. Linking data
  44. DAO and variables
  45. strange 3211 run time error
  46. Getting the name of the computer
  47. Function that pauses program execution
  48. Corruption? Compile error? or what !
  49. Menus gone!
  50. doevents doesnt!
  51. Someone help please......
  52. Global Variables in VB
  53. How do I fill in a text box from option group?
  54. File - Date Created Attribute
  55. Why won't this code work
  56. DCount syntax
  57. Spell checking from VBA
  58. Dir()
  59. OpenDatabase VBA
  60. Seperate a memo field
  61. Help I need Code
  62. date field
  63. Run Time Error 3794
  64. Determine if Form is Open
  65. I need to import picture from folder into a table in Access
  66. create a new3 field by joining fields
  67. Delete field code
  68. Forms
  69. Catch Mouse Position (without movemouse etc....)
  70. formatting text email
  71. problems with mousemove
  72. Online tutorial for mediocre VB programmeer
  73. Javascript Validate Phone and Email Data
  74. multiple recordets in a sub
  75. Preventing Changes To A Field Containing Information
  76. Preventing Pasting Into A Field Or Form
  77. Saving Pictures To An OLE Field Via Code
  78. File name
  79. Emailing with access
  80. Cancel Record with No Data Entered
  81. DoCmd.OutputTo problem
  82. File/Access Error
  83. directing user to specific form
  84. List Boxes - Multi Select
  85. "Me" variables
  86. User ID/Password to Login
  87. Help with Error Message
  88. Run-time error: '2585'
  89. Access VBA ???
  90. Help out a Newbie here plz
  91. Trying to make a calendar to control the date..
  92. send fax with WinFax
  93. VBA & Trim function
  94. coding question
  95. Me! or Me. ???
  96. Using a variable with DoCmd.ApplyFilter
  97. Quick If Or Then question
  98. code to determine whether data is new or modified
  99. LIKE statement
  100. Quick & easy one on date() function
  101. Manipulating files
  102. Can't See entire Path of linked table
  103. After Update Entry
  104. Find Gated Dates In Table
  105. blank textbox?
  106. Hopefully another quick & easy one
  107. VB Script help
  108. Reference library needed...
  109. Create A Table
  110. pulling date from system
  111. Can I open a windows window(not the LaunchCD api)
  112. Checking unbound form for changes
  113. Importing Recordsets
  114. outcome of SQL INSERT statement not working
  115. Message box strings in XP
  116. Retrieving data from the web
  117. checkboxes
  118. enabling textboxes
  119. Using value from Input Box in another function
  120. sending data to table via form
  121. How necessary is this code?
  122. Export to Excel with File Browser
  123. InStrRev
  124. Cannot avoid Warning on NoData
  125. "Lock project for viewing"
  126. how to reference a column in a table
  127. ADO Link to DB with Password
  128. Linked Table Loop
  129. Assigning Workgroups via Code
  130. Subform click sets main form record
  131. CreateControl
  132. insert into in the code
  133. Error Trapping (Mile-O)
  134. message box
  135. Linking tables via an InputBox
  136. adding an entry to the registry
  137. HELP! Module Error-
  138. Selecting in a combo box and displaying related results in a list box
  139. CreateQueryDef not working
  140. using DLookup
  141. VB versus VBA
  142. Delete a file on desktop from access
  143. SQL Joins Problemo
  144. Linking tables via an InputBox
  145. Code for a timeout
  146. Kick Users
  147. Setting #,##0.00 format in SQL statement
  148. editing data access pages
  149. Need help with Recordset data.
  150. Controlling forecolors
  151. Combo box question
  152. password form
  153. A piece of code could do?
  154. Transfering data to Excel - linking to other sheets?
  155. Setting a Form Variable FROM a string
  156. IIF function
  157. Accessing Access tables programmatically in Access 2000
  158. Referencing Outlook Sub Addresses
  159. Validation rule
  160. Me.TxtBox.DefaultValue
  161. Compact On Close
  162. Date Extraction
  163. Compact in Access97 without Prompting
  164. Module Not Found???
  165. Count total transfer record
  166. Create new recordset based on an existing one?
  167. put cursor on position in textbox VBA
  168. Trying to use ME correctly
  169. Outlook And HTMLBody
  170. Error 3188 "Couldn't update. Currently locked by another session on this machine"
  171. Get out
  172. Change table field names with code
  173. The very best book for VB and Access?
  174. After Update - using subform values
  175. Need help manipulating Files Outside Of Access
  176. Windows API Calls
  177. Maintaining List Box Selection
  178. sellength to end
  179. How to retrive db filename
  180. pasting - Excel Code In Access
  181. Working with forms
  182. Passing parameters to queries
  183. subform recordsource change
  184. Using Dlookup with two queries
  185. Run a Sub in another Database
  186. auto-size width or Label or Text Box
  187. print report from form with DoCmd
  188. How to refer to a Control variable's properties
  189. can you use variables in different subs??
  190. Bring to Front
  191. Add/Remove Program Icon
  192. Query Builder
  193. Error with Find Record
  194. Delete Import Errors File
  195. Get Current DB's path
  196. MediaPlayer Control
  197. Count Records from SQL
  198. DLookup
  199. Select Blank Lines In Excel Sheet
  200. Hiding application window
  201. Need a ranking function
  202. vb character for quotation mark
  203. Seeking a string function
  204. ADO 2.7 library
  205. Memo to TxtField?
  206. code problem for export Flag
  207. Please Help if you Can
  208. Split function
  209. Opening Excel file from Access button
  210. set focus to particular entry in list box
  211. How Can I Modify External Files?
  212. Over Writing Files
  213. don't want to "Enter Parameter Value"
  214. Multiselect property
  215. Focus problems
  216. DAO QueryDef Object already exists
  217. Cp
  218. Open File dialog help - PLEASE
  219. Auto Ticket Number On Invoice
  220. Sending data from Access to custom Outlook form
  221. Import from Word to Access
  222. tree control
  223. Data not updating before print report
  224. Runtime error 1004: Application-defined or object-defined error.
  225. Seems like VBA cannot handle two excel files
  226. If... And... Then Statement
  227. Mailing a report
  228. Opening a SQL query with DAO
  229. multiple records into one record where common field
  230. Checking Duplicate Entries on Forms
  231. Scolling Text while Refreshing db
  232. Using a variable in Code
  233. record locking
  234. Deleting specific records and counting
  235. Writing to file
  236. hang up the phone
  237. Naming import tables with an input box
  238. error 3021???
  239. retrieve autonumber
  240. passing an array as a set of parameter in a function
  241. Getting rid of final carry return
  242. using KeyCode on KeyDown event
  243. Table lookup using 2 fields from a form.
  244. add data to another database using ADODB
  245. Days Until Christmas
  246. Online Help Problem
  247. PrevRecVal in a Table?
  248. Slow server
  249. UDF to return to Values
  250. email warning