View Full Version : Modules & VBA



  1. I can't find the Type Mismatch
  2. Multipick listbox
  3. Code Help - Assigning Order
  4. Excel automation code sometimes fails
  5. Security Error 3033- MSysTables?
  6. Label versus Label
  7. Help with function declaration
  8. MDE Dazed and Confused
  9. Search Function
  10. Sendkeys to PDF Dialog Box?
  11. My Documents Directory
  12. Back end location
  13. Returns machine name...but
  14. ADO Connection
  15. Help please rookie programming problem!
  16. REALLY complex macro
  17. create multiple cad drawing
  18. Regional Date Format
  19. Compare Entry to Lookup Table
  20. Problem with Loop updating textbox
  21. VBA problem: path to word file is not correct
  22. Msgbox with combobox...
  23. sql statement difficulties
  24. Exporting to Excel Files
  25. Trying to stop Sub that contains DoEvents
  26. Common Dialog Control Error
  27. SQL String not working
  28. calender form posted on database samples
  29. Late Binding...? HOW??
  30. Merge with Word template and save with new filename
  31. Selection - do I need all this code?
  32. Not 'Stop' ing
  33. How to do function, then procedure w/single OnClick
  34. help with sql update statement
  35. Code for Increments!
  36. Identify who is using DB
  37. Clearing memory
  38. Creating own Help file ?
  39. code gives runtime error
  40. Move Down a Line
  41. Calling a field in a subform from another subform
  42. Access 2007 VBA
  43. Procedure call problem
  44. Record navigation for today only
  45. problem with splash screen
  46. Cascading Combo Boxes
  47. Copy table
  48. Remove empty values from array
  49. Help with adding to the code
  50. Select a record form array
  51. Urgent..Please help!
  52. Hiding Object
  53. loop coding
  54. Passing parameters to crosstab queries
  55. Converting string to currency
  56. Check if data already entered based on three fields
  57. Autoexec Question
  58. how do we create an automatic backup of a database
  59. Multiple filters using AND?
  60. Searching multiple columns for partial text
  61. import text into tables
  62. Problem running Query from Excel
  63. Format code help
  64. Quitting Access via right clicking on Task bar icon
  65. Access 2003 Events Procedure Problem
  66. Datasheet view Column Header
  67. ODBC Too many indexed
  68. VB code help to grab data from a linked Table
  69. Coding problem on report controls
  70. Update ODBC Linked Table
  71. Code not working
  72. String Token not working..
  73. Accessing an object in a form that was just opened
  74. Change Position in Excel Spreadsheet
  75. "File Not Found" - DLL
  76. Excel Calculations from Access
  77. Knowing which records are selected on a subform
  78. Connecting to SQL Server 2005
  79. Opening an Excel file based on a Table
  80. from access to excel
  81. Save record code
  82. Obtaining SQL from a Query
  83. how to sum field entries
  84. Sequential Printing Of Reports, is it possible?
  85. Mail Merge with Checkboxes:
  86. Compile Error - Filtering Data
  87. increment no based on previous records
  88. Printing a pdf document from within Access
  89. usrname + passwd verification (match to a tbl)
  90. Problems with .TabIndex
  91. conditional format Excel from Access?
  92. Loop through all controls in a page switches the control indexes
  93. Pass Through Queries and Parameters
  94. Need help with loop to send multi emails
  95. Database Properties
  96. BeforeUpdate disappears
  97. If Statement in a Pass-Through Query
  98. VBA Problem (DAO)
  99. adding textbox value to excel filename
  100. Updating Records via VBA Version: 2003 (11.0)
  101. Default Filename with a SaveAs (OPENFILENAME) Dialog
  102. Activation Code
  103. Method to invoke File Import wizard using VBA
  104. Passing Array into Function from Query
  105. Number format in Excel
  106. Access to word mail merge
  107. VBA code to import delimited text file
  108. Running Query at Form CLose
  109. Read Only Error Trapping
  110. Exporting Queries with Parameters to a single Excel Workbook but Seperate Worksheets
  111. filtering records
  112. Adding "All" option to Cascading Combos and Multiple combo box Filtering
  113. If record does not exist
  114. Need help with Search Function
  115. Import Excel Dialog Box
  116. Don't know How to call it...
  117. Looping through a recordset
  118. Copy Table And Add To Its Name?
  119. Referential Integrity and ADO
  120. ODBC Links and BE/FE
  121. outputto & format Event
  122. Setting dao database
  123. VBA conditional formatting problem
  124. 438 error sending Outlook e-mail
  125. TransferSpreadSheet
  126. Getting Err.Description
  127. Setting a report on focus
  128. Changing the recordsource
  129. Creating a password for another database
  130. Trouble w/ DoCmd.TransferText
  131. is it possible to create a help file which opens internet explorer
  132. compairing/retrieving info on a record
  133. What does this do? - Deleting records from subforms
  134. OutputTo pdf?
  135. On Form Close
  136. .enabled
  137. export individual pdfs
  138. Variables that hold user defined data after access closes?
  139. Transferspreadsheet command
  140. Loop this code!
  141. Display label or text box at specific time
  142. Finding Active Excel Sheet from Access?
  143. Dynamically Call Event Handler From String
  144. TransferSpreadsheet Method
  145. Table Comparison / Partial Text Comparison???
  146. Recordset issues...
  147. PDF File
  148. Yes/No fields
  149. Populating form and subform based on search criteria
  150. This loop is not working - need help
  151. change excel worksheet name
  152. Is this possible ?
  153. Run module and local code
  154. Control size of a form in DS view
  155. Goto First record in ComboBox
  156. Problem With ConvertingCurrencyToEnglish
  157. MSG Box Ok/Cancel Accesss 2003
  158. Locking the Application
  159. Updating an integer in another form
  160. Inserting Data into 2 Tables
  161. Apply Filter in two fields
  162. Report from Parameter Driven query
  163. Customized Menu Bar
  164. Record Position
  165. Module Calculations
  166. I need to copy a file...can I do this in Access VBA?
  167. On Error does not work! HELP!!!
  168. Compacting Source Database
  169. Compacting databases
  170. Sizing open reports
  171. Exporting more than 32,767 characters to Excel from memo field
  172. Run-Time Error '3027'
  173. Select an Option Group
  174. update control
  175. Date format when creating querydef
  176. Menu item delete
  177. Create Linked table with VB
  178. how to make fields in a form non-editable(non-deletable, non-addable)?
  179. How to give a commit statement in VBA?
  180. DoCmd.Close not working
  181. Click a button on a form in a remote db
  182. All my code has dissappeared!
  183. VBA code for counting number of records loaded in a form
  184. Login form
  185. How to suppress confirmation messages when inserting or del recordsin backend tables?
  186. Importing from Excel with multiple sheets
  187. Uhhighlight listbox items
  188. Removing blank characters in a text string
  189. Environ("username")
  190. Can I use a Variable In a SQL Statement
  191. Determine the name of the caller of a procedure
  192. Use only one form for three different queries
  193. How do I find a record in access with multiple criteria using VB?
  194. import date from Excel to Access?
  195. Snapshot format
  196. Code for opening form based on value in subform sitting in another form
  197. Attachmate Macro's
  198. Confused & Frustrated
  199. Error in code driving me crazy!
  200. A kind of proces or deamon
  201. from VBA access calling a webservice over a network
  202. Sql
  203. Calculations on table data
  204. List Box - Viewing Selected Item
  205. OutputTo returning odd number
  206. transforming and coding variables for csv import
  207. Filter Function for combo boxes
  208. Accessing a query and taking info from it
  209. Color Button Control
  210. Data Validation_Able to go to next record before problem is resolved
  211. Enter data for query from VBA
  212. Split Data Base - IP Change
  213. Check if table or query exists
  214. Take a field from Query output
  215. Returning a Value from table and then deleting a value
  216. Copying Tables from Recordset
  217. URGENT: Dsum with Yes/No type criteria
  218. add loop to skip misisng indexes
  219. Problem with connection string while creating linked tables
  220. How to detect broken linked tables?
  221. Problem with connection string while creating linked tables
  222. Access query linked to excel
  223. Paste Formatted Text in Memo Field Acces2007
  224. object oriented progrming - need to learn
  225. SQL statement in VBA
  226. Checking for a NON null value
  227. Taking value from a table into a form
  228. checking part of the value in a field
  229. what is wrong with my code?
  230. Using vba to open a Report based on a Field Value
  231. how to check for refed/needed files for mdb app
  232. User/Password Table to log in
  233. Multiple queries on one field ?
  234. Add record to SQL table
  235. Problem Coding
  236. How to search an SQL Table
  237. FileDialog object
  238. Peter Answers website
  239. VBA Table Lookup
  240. Lookup value from other table ONLY IF there's a match
  241. If... empty fields give MsgBox?
  242. Inserting UNBOUND textbox into a Table
  243. Emailing within Access - 'From' Field?
  244. Clearing a Query using VBA
  245. "If" condition on button action
  246. Else-Userinput
  247. Display Title on Datasheet View's Title Bar
  248. increment variable with loop?
  249. Color as field
  250. Emailing A HTML Report Problem