View Full Version : Modules & VBA



  1. Dlookup with with 2 fields as criteria
  2. Recordset Update
  3. new records with record sets
  4. Currently Locked by another session on this machine!!!
  5. How to Open Mutiple Instances of Internet Explorer
  6. saving records of a subform
  7. How to Add a ID number (not autonumber) Max +1 over a group
  8. Help with recordset code
  9. Automatic Program Name
  10. Help Files
  11. Run-time Error and Nz Function
  12. Maximize Property in InternetExplorer Object?
  13. Linking Queries
  14. function for rename file
  15. Adding a new record on a subform
  16. Windows API using VBA
  17. Putting Code behind Print button
  18. VBA Update Error 3218
  19. Delete tables on Exit
  20. Format Excel in Access
  21. Any way to stop a process by using a button?
  22. If/then stmt in a module, please help!
  23. Linking tables from a password protected database
  24. Problem with Filter
  25. Do Next Loops to Create Recordsets???
  26. How to hide controls based currentuser()'s group?
  27. Code to enter Jet Security?
  28. Options on a MsgBox
  29. Problem with Class Module
  30. Searching database for a specific table
  31. Using table values to control form properties.
  32. Initial Capital or Proper Case
  33. Left joins and is nulls
  34. Can't find Chr Function!
  35. Coping tables between two Databases
  36. Passing the contents of a table to a module
  37. What Can Go Wrong With Access?
  38. arrays in Access
  39. What is the purpose of Cancel as Integer?
  40. Key Violation Problem
  41. Time functions
  42. Input box to change field label
  43. Hiding the main meny bar
  44. How to undo or prevent a record save from a cancel button?
  45. Updating a field
  46. Code Question
  47. Outlook Recipients.Add only allows single email address
  48. Type Mismatch on recordset
  49. Need Music MP3 Example Using Multimedia MCI Control
  50. Flaws in Module VB causing import failure?
  51. combo box requery/linking
  52. Using Infared port to Control PC in VB
  53. Searching for a record in a recordset
  54. controls on a report
  55. SQL string not working
  56. on check never load again
  57. How to change a field's data
  58. Importing an append table query
  59. Looping through records
  60. Re: Looping through records
  61. Open Word with a referenced Document
  62. If Then question
  63. Code for text box date event
  64. Check if a form is opened/close all forms
  65. Transfer Field Column Names
  66. How can I maximized the Access window?
  67. Information on Access 97 Default System Tables
  68. Fax Pro 9 macros for Access 97
  69. Controlling Printer Properties from a Report
  70. Moving Contents of a Fieldin a Table to Another Form/Table
  71. How to make dates rolling and autofill?
  72. limit combo box based on whats selected in another combo box
  73. How to disable Page Up / Down keys
  74. Switching between Forms
  75. Keeping variables through an error?
  76. Importing Text
  77. Set field to allow ZeroLengths using DAO
  78. How can one tell if a database has been opened or not?
  79. Create New Record with Some Info Present?
  80. access 2.0 to access97
  81. I am Stumpted - Parsing Nightmare
  82. Select Specific record in recordset
  83. Class Library
  84. Filling Arrays
  85. Need to Count a value and copy answer to field
  86. Access Equiv of XL Evaluate Function
  87. Help a VB novice
  88. Text manipulation
  89. Changing QueryDef with VBA in 2000
  90. Selecting Specific Records using For i =
  91. Displaying other fields linked to a lookup field
  92. inserting an email address into Outlook Express
  93. Filling a field automatically from a labels text string
  94. A complicated FIND record search
  95. Unanswered Questions
  96. help..function from module in query
  97. Problems with FIND and display record
  98. making progress..
  99. Frustrated
  100. problem with DoCmd
  101. Ranking Groups of Data
  102. What is the E-mail Address Format?
  103. Access 2000 to Access 97 Vb Conversion troubles
  104. Rounding - Date Calculation
  105. Date problem with CreateQueryDef
  106. MSACCESS compatibility with other applications
  107. New Record With Old Info
  108. IF and SELECT CASE commands
  109. Auto-Mail in Outlook
  110. NO MATCH
  111. "You can't carry out this action at the present time"
  112. Creating Export Specifications Using VBA
  113. Calculating
  114. RDO connection
  115. Changing the way a combobox list data
  116. global variable
  117. Setting a condition to open one form or another
  118. Using .foundfile
  119. Registering Libraries
  120. 'Dim' ing a Database object
  121. How to code a Command button to display current form to a report
  122. Serious Help needed! What causes error 2486?
  123. Turning on Debugging
  124. Display a warning MsgBox
  125. Last Record
  126. Recordset
  127. Queries With Specific Names
  128. restricting users to import objects..................
  129. modify code for deleting records
  130. Can you display records side by side?
  131. Code won't break at breakpoints! Help!
  132. Viewing specific data in a tab control
  133. Problem with Saving a record with RunCommand
  134. Modify delete code-still need help
  135. Need help on displaying data
  136. unaccessible database
  137. using & to refer to different objects
  138. a few quick ?'s
  139. Hilight option group labels corresponding to button selected
  140. Conditionally change text color
  141. Memory when using VBA
  142. Changing Listbox Columnwidths
  143. Encryption/Decryption challenge
  144. Different Text Color for Different Value
  145. Setting query column widths from VBA
  146. removing part of a field
  147. Nope did not work
  148. Open Excel Workbooks
  149. Calling embedded word documents
  150. BalloonLables
  151. Automatic Updates
  152. Subforms Updating other Subforms Problem When Opening a Form
  153. Manipulate Excel worksheet from Access
  154. ISAM error
  155. Running a Powerpoint File from Form.
  156. Import file from excel
  157. Is this a module situation?
  158. Year() function not working
  159. command button code
  160. Searching Field Names of Tables
  161. Data Validation
  162. error code not working
  163. Problems when OnCurrent Event is Used in Subforms
  164. Manipulating Form Properties
  165. counting fields?
  166. SendObject Automatically
  167. Microsoft Access is freezing
  168. Running a check on all records in a table at once
  169. InputMask for string in ComboBox
  170. Design Code for Defaulting Previous Field
  171. Microsoft Access still freezing!!!
  172. Using KeyPress Event
  173. How to prevent users from deleting more than one record at a time in a datasheet form
  174. Need help...appreciated greatly!!!!
  175. Help - Wish to Delete Record Using a Command Button on a Form
  176. Problems with Libraries
  177. Trying to store a control reference as a variable
  178. At wits end, Need help fixing dynamically generated report's vba code.
  179. Creating Shortcuts Programmatically
  180. File Viewing
  181. A book on VBA
  182. How to prevent a user from using the SHIFT key
  183. HELP!! Trying to build a front end for a database in Access Basic
  184. combining two records
  185. Transfertext Export number of decimal places
  186. Please Help-Pop up message box
  187. Why are Recordsets in Forms Read-Only when there are Unions involved?
  188. Job Stream Functions
  189. VB code on a report problem
  190. Grabbing data from form fields
  191. Information on VB code and Access
  192. Record Locking
  193. Linking Microsoft Project
  194. Disconnect all clients then Backup.
  195. Beginner
  196. Form to keep referential integrity
  197. How do I change Windows Status??
  198. DoCmd.openform questions
  199. Counting records to do a loop?
  200. Linked tables and Indexes problem
  201. overtype in SQL
  202. subforms within other subforms
  203. Reading constants outside the source code
  204. Counting records
  205. using word to spell check access fields
  206. problems with OLES
  207. Round function
  208. Automation of Access-Word
  209. Null Problem
  210. Is there a way to shell() internet explorer?
  211. Required Field Entries
  212. Eval("NameOfVariable") somehow possible?
  213. Problem referencing subform data item on main form
  214. SendObject command
  215. I want to PURCHASE Office 97 Developer's Edition from YOU
  216. Compile with code
  217. Center text in a Msgbox
  218. Entering text result of On Enter comand
  219. Wait a minute.......
  220. Hide Receipent Name
  221. Runtime Error w/ Treeview Ctrl
  222. File Transfer
  223. runtime3709
  224. Code conversion problem
  225. changing name format
  226. reference integrity - problem delete
  227. Counter in VBA
  228. Write fields to db when commandbutton clicked
  229. Or Operator Question
  230. Type mismatch (Error 13)
  231. OpenDatabase method
  232. I need to get rid of leading empty spaces...
  233. Help!!! Using AfterUpdate Event
  234. Visiblity of TextBox; ComboBox
  235. Type Mismatch - Help!
  236. random number generator
  237. ADOX Catalog in Access Project Module
  238. Determine if a table exsists
  239. TYPE MISMATCH ERROR AGAIN!
  240. How can I jump to a specific record in a subform
  241. Set Focus
  242. Filename with spaces in the 'Shell' function
  243. Sending Email Via Modules
  244. Don't save changes to a record
  245. QueryDef?
  246. creating HTML files using OutputTo command
  247. How to pass control name as argument?
  248. Broadcast printing in Access
  249. Error Trapping
  250. Converting Databases through VBA Code