View Full Version : Modules & VBA



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