View Full Version : Modules & VBA



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