View Full Version : Modules & VBA



  1. Two rows in a msgbox?
  2. acCmdRemoveFilterSort not available now
  3. Access Secuirty - What type of access for DLOOKUP?
  4. transferspreadsheet range
  5. Converting to string
  6. caanot delete a record with ADO
  7. How to write a script to allocate data
  8. Okay, I did something stupid - Restoring Full Menus (When Shift is already Disabled)
  9. Using GetFiles Sample Database to Update table with existing data
  10. Changing a table field data type to hyperlink via code (w/o design view)
  11. Querying a database that you just put new data into
  12. Bloody annoying date problem - used as part of large filter for report
  13. List Box - Fix columns when scrolling
  14. ActiveX Cal Problem
  15. Error 91
  16. What is wrong with this script?
  17. How To Seperate Offending Code...
  18. Type Mismatch problem
  19. MailMerge Problems
  20. XP - Importing a Text file into Access 2000-3
  21. Copy of DAO recordset without affecting table - filter by bitmask field comparison
  22. Default blank new record not showing ...
  23. Looking for a good SQL Tutorial
  24. FTP hanging...
  25. Beginner Needs Help with Access 2K Search
  26. Fill combobox from recordset
  27. Type mismatch on DLookup
  28. ADO version of FindLast
  29. Urgent EXIt from Access Progam
  30. Check for active workgroup file
  31. Change ODBC connection in VBA
  32. Insert Into probs.
  33. Using the SQL COUNT function
  34. Fill Combobox through code
  35. running code from switchboard
  36. Simplify queries
  37. Form - Go to newest (recently added) record using DAO's .Bookmark & .LastModified
  38. Filter
  39. Problem with switchboard
  40. Null Date
  41. Append on criteria but show duplicates
  42. Required type library or wizard is not a VBA project
  43. Add Entry from combobox code giving error messages
  44. insufficient permissions
  45. VBA and the "like" statement
  46. Type Mismatch
  47. problem with switchboard and run code
  48. simplest way to duplicate a record from recordset but change just one fields value
  49. open excel & have access wait for excel to close
  50. Assigning variable to a text box
  51. Find Record Problem
  52. Wildcards in SELECT statements
  53. Like in a Dcount
  54. Deleting record
  55. Runtime Error 5 in calculation. Driving me crazy
  56. CloseCurrentDatabase Method what is saved?
  57. Field format in querie
  58. Form not working properly
  59. SQL String Returning Wrong Number of Records
  60. Form Refresh Error
  61. Create & Position Textbox in Word
  62. Dcount query
  63. Hi! Need help: Form_4TextBoxes_to_filter_SubForm
  64. Change Font of Word Textbox
  65. ADO connection verification
  66. SetFocus after Error
  67. Where do I start
  68. How print multiple labels based on a query
  69. SQL Statement
  70. Topvalue query populating textboxs on form NEED SOME CODE!!!
  71. Linking access to an e-mail form
  72. Update Fields in a table
  73. Create table in one database using data from another
  74. Need to improve running average function
  75. Pausing until Excel has finished
  76. How do i pass the parameter of a query in VBA?
  77. General VBA Function Question
  78. Clear Form and Query results
  79. Pulling Stock Quotes from the web into Access
  80. XLS object created in function only...
  81. ACCESS and MS outlook
  82. How to open password protected mdb in VB
  83. Any MS Access Mail Merge Experts Around?
  84. Custom ID's as Primary Key
  85. String is valid range - return Lower & Upper boundary
  86. Public Variables
  87. Advice on Import requested
  88. Chart Types
  89. Setting properties on an open form from another open form
  90. API Reference
  91. D-function Syntax with variables...
  92. Getting a subform to control navigation of parent?
  93. Problems with Internet Control Transfer
  94. Retrieving HTML From Website, Parsing, Then importing - Whats the best way?
  95. Cancel add new record?
  96. Setting properties of controls in report
  97. Setting properties of controls in report
  98. Setting properties of controls in report
  99. Setting properties of controls in report
  100. Custom function currency getting # Error
  101. Type Mismatch / ADO AddNew
  102. Auto entering of HTML in to a column
  103. view new records in the form
  104. How to test for a keystroke combination
  105. Need Help with a qry.sql statement
  106. Automated on close?
  107. Disable Save Question
  108. Error Global
  109. MoveLast
  110. Open Report
  111. Exporting an Access Report to Excel spreadsheet(s)
  112. please help on this project
  113. Time To Live
  114. Access2003 VBA Debug Question
  115. Access - Freeze - Crash
  116. How to get control height thru VBA?
  117. Run Time Error - No Value Given
  118. Adding Links to Word Documents
  119. Dcount, Grrrrrr......
  120. Supress "type conversion failure" message and continue with Import
  121. Dlookup
  122. Adding Form Objects Programmatically
  123. set printer tray
  124. Should Dcount return 0 for no records?
  125. Name and a body of file
  126. User Defined Query
  127. Using comms with Access 2000
  128. Checking to see if a string has a number in it before converting
  129. Changing a Query
  130. Type Mismatch error with "Like"
  131. If Now() between X and Y then???
  132. VBA Code to import text files
  133. Refreshing/Requery a subform on a form
  134. passing a parameter between 2 queries
  135. change font styles when sending emails
  136. how do i get vba to count upto large numbers
  137. keep form maximized
  138. Looping code
  139. Dates in functions
  140. docmd.copyobject not copying form module
  141. Unzipping files using WinZIP in VBA
  142. Complicated Date Calculation
  143. ComboBox Error when choosing with mouse, but not when typing
  144. cnn.Execute - cant append data to table using sql
  145. SQL Statement to generate a random "confirmation number"
  146. DefaultValue and Dates
  147. loopy question
  148. MkDir using a command button
  149. Input Mask
  150. Can I hold Integers in a Double?
  151. Formatting question
  152. Default dates
  153. Run time error '13' Type mismatch
  154. Refresh speed
  155. Disappearing Tables...
  156. Backcolor for Tab controls?
  157. when to declare variables
  158. Building Complex Expressions
  159. Update table
  160. Command button to find specific info not working
  161. Formatting Issue
  162. Change Wallpaper
  163. Use of Format () in VB
  164. Recordset EOF is True, but there are records.
  165. Transfer text into a database other than current database
  166. Shell Command
  167. TimeBomb Feature...
  168. stupid dialog box
  169. unmatched records SQL problem
  170. Backup Database dialog filename control question
  171. Refering to a particular column in a list box
  172. XML - Importing XML when given URL
  173. overriding error message
  174. Make a Function TimeOut after a certain interval
  175. AccessError and MsgBox formatting
  176. Automatically run F5 (refresh)
  177. Works in Debug but not in runtime
  178. Create backup of db in vb code
  179. Concatenation & Sending Email via Lotus Notes
  180. SetFocus Problem
  181. Check for Internet Connection
  182. VBA help
  183. Recordsetclone Problem
  184. No Body Ever Helped Me on This, Can U???
  185. To be Visible or not to Be Visible
  186. Reshuffle order of visit
  187. errors while deleting a record
  188. Recordset Loop
  189. Why? Why? Why?
  190. run sql for lookup and change on record and one field
  191. Automated Data Editing
  192. Compile Error: Error in Loading DLL
  193. how to create a form in access using vba
  194. compacting remotely
  195. Ip Address
  196. dynamically link Outlook contacts.
  197. name of control
  198. Creating a string
  199. call a sub
  200. Moving an object
  201. call/run ASP from Access VBA
  202. VBA & SQL
  203. Using FindFast with SQL Table?
  204. VBA code to change a child form
  205. Creating a RunTime Array or Matrix to Edit data
  206. Problem with Dlookup
  207. Access 2003 vs. 2000
  208. Scrollig SelectedItem in LB
  209. Open specific email message using access
  210. String
  211. set array as record source of a form
  212. FIND and replace via a form
  213. Change file read only property.
  214. Export datas from specific column cells to Access
  215. DAO objects
  216. Accessing textbox value
  217. Populating a list box after a search
  218. Recommend a Reference Book(s)
  219. Code in Functions and Procedures
  220. It's so simple- but why not?
  221. change the backcolor of subform in the form
  222. referencing a table
  223. Finding Number of fields in a Recordset/Table
  224. "Option Explicit" not working?
  225. [help] datediff function
  226. Question about Code
  227. Create a function from a text file.
  228. Add Attachment
  229. Trying to do tough calculation
  230. Email With an Excel Attachment
  231. Excel Automation from Access
  232. How to append resultset to table in VBA in one time ?
  233. Check query for data
  234. Visual Source Safe for Access XP (2002)
  235. IsLoaded Function Looking at subforms
  236. use different forms for startup depending on external criteria
  237. How to trap sql server triggers error in access 2000
  238. listbox populate from sql query
  239. problem with code
  240. email not sent Handler
  241. Looping through table data
  242. how can i copy one folder to many subfolders??
  243. Please Save My Soul...
  244. Display names of forms and reports in alphabetized order in a list box using vb
  245. How can I avoid duplicates in a query programmatically?
  246. Total Beginner
  247. Set array as record source of a chart
  248. return full path of a field in subform
  249. Help with retrieving file DateModified timestamp
  250. Open Embeded Word files and save them out