View Full Version : Modules & VBA



  1. Output to Excel (over 65535)
  2. What is wrong w/my DCOUNT statement?
  3. InStr() return values
  4. To check whether the property in access exits using vb
  5. Qry records to string values
  6. Data connections
  7. Adding Dword to Registry via VB
  8. exclusive access to db?
  9. CreateProperty for a field
  10. 2000 vs 2002 Version Conflict?
  11. Weird Send Mail cancel problem
  12. Email, body text
  13. Creating a Currency Field
  14. VBA and reports
  15. How do I add spaces?
  16. How do I convert a string to a double
  17. programmer defined data type
  18. error trapping problem
  19. How to refrence primary key and forgine key
  20. Alternate After Update Event
  21. Yes or No Box
  22. Requery syntax problem
  23. WithEvents - object disconnected from clients
  24. Date Field = #Date#
  25. best way to reference a form or control
  26. Delete old files, keep the newest file
  27. Runing action queries through VBA
  28. VBA Error
  29. Calling Default Windows Sound Events
  30. refer to recordset field using variable
  31. afterupdate problem
  32. Copying and pasting new worksheets
  33. Default Property
  34. where clause uk date problem
  35. Unable to correctly use a module for a file browser
  36. Missing Project or Library
  37. Search a Word with VBA
  38. Query result in an "array"
  39. List of all arrays & last array?
  40. Need Help Quick
  41. How to generate create table statments using vba
  42. Run time error '3251' - again...
  43. Connection to Database
  44. How to trap error number and error discription
  45. Stopping a form from maximizing on load
  46. Changing Paths
  47. importing CSV file - problem with data conversion
  48. someone plz help me with this vba coding!!!!!
  49. Problem with UPC #'s
  50. export the results of a query string to a file
  51. custom data type
  52. copy a folder to many subfolders
  53. Database Backup
  54. Access Runtime - Runtime error
  55. Transform an array into a table and vice versa
  56. Insert images in OLE field with VBA code
  57. Message box error
  58. ehandle for every function sub?
  59. How to Pull Data From an HTML Doc
  60. Help with Visual Basic
  61. Reselect items of the listbox after its requery
  62. List Boxes and Trailing Text
  63. Getting error in data base after using insert sql command in vba
  64. Giving myself a "If, end if" headache
  65. Open a file in windows association
  66. Want One Form to do everything
  67. update subforms query result
  68. Refreshing after Update Query - Write Conflicts?!?
  69. Adding counter to deliver the search results
  70. Connecting to Sybase with ADO
  71. Redim Preserve Help!
  72. Export to Excel w/ VBA
  73. Select record in ListView control
  74. Instr With a Wildcard
  75. Overflow problem with double data type
  76. How can I get record counts faster?
  77. Help with my Select wildcard statment?
  78. VBA Code for refreshing Excel Spreadsheet Query Table
  79. Relationships
  80. Problem to import numbers with decimal sign from Excel to Access
  81. delete error
  82. Create one field from 3 using a function
  83. suppressing default access error message
  84. Missing Class Object
  85. Check User
  86. using queries to delete
  87. display html formatted text
  88. ADODB.RecordSet - Events...
  89. adodb and .find
  90. Copy Table to Word Document
  91. dlookup anthing better?
  92. Please help fix my If statement
  93. insert id
  94. code behind sendreport locking up
  95. How to build a funciton to return primary key,alternate key and foreign key fields
  96. Possible?? - Use DAO to loop though back end file properties
  97. Help need in setting up Call to Open/Save dialog box
  98. How do I debug VB error #80004005
  99. Stupid Report Question
  100. How to build a funciton to turn on/off Caps Lock?
  101. How to Make a Form Read Only on the bais of user login access level...
  102. Saving result in a file
  103. Importing multiple CSV files
  104. ConnectionString for Data Access Page
  105. Changes from a combo box
  106. Error 3464 while running For Each
  107. Automation Error
  108. application window resize
  109. Events/WithEvents
  110. Data Validation
  111. Automatically import excel data into Access table
  112. insert imported filename into table
  113. Application crashing
  114. Array of Forms
  115. Check value of SetWarnings
  116. close form
  117. Help with formula please
  118. Using query result in VBA
  119. save record and then if statement
  120. Auto generating emails with populated info
  121. list box with 2 cols and 8 rows
  122. "Run-time error '13': type mismatch"
  123. Getting behind interface to VBA Code
  124. Variables! Why All the Hubbub?
  125. Listing application references
  126. label on mouse move
  127. storing filename in field (rarther than path)
  128. Updating table from import
  129. how to print a report from code?
  130. Set height of a reports detail using vba... and more
  131. VB Script
  132. how to AND Search in access 2000?
  133. Working with a List Box
  134. how to check if a record is currently edited by another user?
  135. getting file names in a given directory and then storing them in an array
  136. assigning a number to a record
  137. assigning a number to a record
  138. Importing Issue
  139. Maybe someone has a good suggestion
  140. Excel Macro Question - Copying Rows to other spreadsheets
  141. IfThen doesn't respond
  142. Auto Populate fields (B & C) from a Lookup query in field A
  143. please help..losing parts of data when retriveing using code
  144. Too few parameters problem
  145. opening other access databases and excel
  146. 80010108 client disconnected - URGENT
  147. Disabling Access warning when sending email
  148. Color background in Listbox
  149. PDF Collections
  150. Calling an Orcale Stored Procedure
  151. Word doc report with embedded database
  152. "OutputToExcel" is Overwriting instead of Adding
  153. Does object exist
  154. Preview Crytal Report
  155. Calling Professor McAbney
  156. creating shortcuts in VBA
  157. Execute Method
  158. Excel calls Word via DDEExecute, Error 438
  159. Faster way to clear a table
  160. UPDATE with DoCmd
  161. help with insert into statement
  162. Visual Basic Question
  163. Updating form
  164. SQL Statement Syntax
  165. Help with an If Than Else statment
  166. Utilizing Code from an Excel macro in an Access form
  167. dirty subform
  168. ComboBox heirarchy
  169. Saving choices from an option group
  170. Schedule Microsoft Access Synchronization
  171. Recordset won't open
  172. TransferSpreadsheet
  173. Print Report Page 1 ONLY!
  174. DAO: updating a field value by looping through another table
  175. Help regarding finding out maximum value from the records entered by form
  176. UPDATE syntax error
  177. Formatconditions not saving when form closed
  178. Fractional time
  179. Assign a max value from parameters to other parameter in table
  180. Add 1 Each time
  181. Not standart button's forms and colors
  182. Look at code please?
  183. Why setfocus to hidden text box? – File open dialog using API functions
  184. User Defined Functions Module - VBA Coding
  185. Array Question
  186. Exporting to the same excel sheet
  187. Passing a Value from one subform to another subform
  188. Compare two fields and display a message
  189. Invalid use of Me keyword ???
  190. Problem with an VBA SQL Statement
  191. Invalid Outside Procedure
  192. Need to Update the "Day" field in all records. how?
  193. Update different Tables
  194. SQL syntax in VBA for an Append To query
  195. Cannot run VB Code and Cannot Open VB-Editor
  196. DoCmd.PrintPreview.......
  197. Help - populating a Listbox from a query with parameters?
  198. Help - populating a Listbox from a query with parameters?
  199. finding out if a word object exitst
  200. Check if Textbox Text in a ComboBox
  201. Form to show progression
  202. If a textbox value = null then
  203. MSOWCFLib.OCFunc.NormSInv in Access 2003
  204. ADP Project Refresh Issue
  205. Database file properties
  206. multiselect, multicolumn listbox
  207. Need help with a simple Duplicate Item check.
  208. Loop Problem... Need loop inside loop maybe...?
  209. BeforeUpdate Date field
  210. Saving OLE object to file
  211. newline character
  212. Auto line number
  213. Object variable or With block variable not set (RunTime Error 91)
  214. Using a DCount Function dor my password
  215. .find runtime error cant work out why!!
  216. Default Value For A ComboBox
  217. Import multiple rows of text into one field
  218. Robust solution to allowing easy passing of arguments to forms
  219. Delete a file
  220. Alternatives to Sendobject
  221. Unlocking the vba
  222. Change decimal value with code ?
  223. Insert string to table with sql statement
  224. Insert string to table with sql statement
  225. copy row to new table
  226. Mass change to field found in reports, etc.
  227. Using the value of i as a field name
  228. Inserting matching records from dbX into dbY?
  229. continueous update of the time in access
  230. continueous update of the time in access
  231. Catastrophic Error -2147418113
  232. Assigning Quey values to VBA Variables, help = tutorial needed
  233. Object or class does not support the set of events
  234. vb and access/multiple queries one report
  235. Mouse move error handling
  236. Code printout
  237. Merged fields in vba multiselect box
  238. formula in a control source
  239. Trouble with INSERT INTO
  240. Hi!!
  241. Bulk loading email adresses to MS Outlook
  242. Complete Boolean Evaluation
  243. Create and Save New Form
  244. Programme works most of time - deleted records
  245. Receive Email in to a ACCESS App?
  246. How to create a duplicate popup message
  247. How to identify a form existence in a database?
  248. odbc data embedded howto
  249. QueryDef syntax
  250. problem understaing this vba code!