View Full Version : Modules & VBA



  1. HOW DO I USE the txtbox(txtfrm) as a form name
  2. Using a checkbox to update a field
  3. How can I import a fix lenght file using schema.ini
  4. Print Multiple Reports Into Single PDF
  5. bad calling convention
  6. data in subforms
  7. Refering to Unbound Text Boxes on Form
  8. docmd.Close won't close... sometimes
  9. Too few paramters, yet parameters evaluate correctly
  10. How do i sync with outlook contacts?????
  11. Possible to use DMAX with SQL Insert??
  12. Instr not behaving as expected
  13. snapshot viewer?
  14. help with append query in VBA
  15. File Attributes to Access Table
  16. How can I wait for 10 seconds
  17. How do I disable the "Exclusive access" messages
  18. Change of fields in Array Module
  19. Create Addin that carries on working when currentdb is made into mde
  20. I need help with an If Statement
  21. Increment Loop
  22. Open subform when field has been populated in Access
  23. Please tell me about Queries and VBA modules.
  24. Running SQL from vba
  25. 3 strikes and you’re out
  26. Use of Eval with Access Recordset
  27. Why does this IF AND statement work?
  28. Line numbers in report
  29. Help required with a recordset
  30. E-mail/ mail merge/ automation. Almost there...?!
  31. If not End If query
  32. Using VBA to Control Combo Boxes
  33. Check if query returns Null
  34. Restored Window has blank menu bar
  35. How to add key/value pair to Combo Box in VBA.
  36. Why are my records duplicating
  37. File download from Internet in VBA
  38. Can you open a recordset from another recordset in Access 2003?
  39. Help plz. How do i backup a database with code?
  40. Looping problem sending e-mail
  41. Access doing calculations after form is closed.
  42. Form filter syntax
  43. How to Delete a database *.mdb with VB??
  44. How to check each tbl for a date, then archive all data older than a month?
  45. Acces and Excel Help
  46. Automate checkbox using VB
  47. Help Filtering Multiple Combo Boxes
  48. Help with Eval Function
  49. code not working
  50. SQL Coding Errors
  51. Tabbing out of subform
  52. Form Filed Validation
  53. SQL inquiry
  54. Was working, now it's not...
  55. How to search for all *.mdb files on a drive
  56. Problem sending a String to the Screen
  57. help with " and ' in the values (i've tried everything and i'm still lost!)
  58. Help needed! : SELECT TOP "n", where n = query value
  59. security workgroup sometimes not recognised
  60. DLOOKUP error 2471
  61. Update Field records from a form
  62. Query objects
  63. Specify the sender using SendObject
  64. How to go through a series of records twice
  65. VBA to check if recordset is empty?
  66. how to get Caption of current control for errmodule
  67. Refreshing ADP connection
  68. Counting records in a subform HELP!
  69. Trouble With Dcount returning all the records
  70. Access won't let go...
  71. Exporting to excel
  72. “Requery” problem
  73. Current Form Module only vs All Modules
  74. Continuous forms
  75. Report vba scripting
  76. Code to send a PDF email from a Form
  77. Hide a cascading combobox if there are no values to choose from
  78. Question about VBA between Access and Excel
  79. docmd.openform and openargs making me crazy
  80. Coding help on Search function!
  81. SendObject to email reports
  82. QueryDef.Connect
  83. XML Data
  84. tab paging issue
  85. Difference between Declare statement and References?
  86. some variables lose thier data?????
  87. Enter Parameter Value?
  88. Error In UPDATE syntax
  89. Please help a noobie with some VB code in MS Access 2007
  90. Problem with rounding numbers
  91. I cannot see my VBA code
  92. retrieve tables data fields
  93. I Need Help with Loops!!
  94. Run-time error '3001' invalid argument
  95. Run time error 3315
  96. Update after deleting a record has no effect
  97. DLookup with string
  98. Excel as record source
  99. TransferSpreadsheet limited to 253 rows?
  100. Run Time Error 3075
  101. VBA access 2003 doesn't work with access 2007
  102. Add a button to a cell
  103. Find a Date & Time using GetFileTime
  104. Any help would be appreciated docmd.findrecord
  105. Caption not updating
  106. Using A "SELECT" SQL command in VB from within access?
  107. Insert Into and Delete SQL functions in VBA
  108. Time calculation problem
  109. Wildcards
  110. SQL Insert Errors
  111. Hiding empty Text Boxes in a tabular Form
  112. DAO type Mismatch
  113. Mapping Network Drive
  114. Grouping multiple rows
  115. Advanced Question - Data Import Old Table to New Table
  116. Need a password input box
  117. DoCmd.OutputTo AcReport <CRASHES>
  118. Automatic Import Access records from table to MySQL table
  119. Are commas possible in a List Box?
  120. Overflow error with ODBC link in large table
  121. "Include" Or "Import" VBA modules
  122. Connect to Remote MySQL from VBA (Access 2007)
  123. Access E-mail help question!
  124. VBA equivelant of ParseInt() ?
  125. Filedialog:How to save path to field.
  126. Printing Report from Form Problem
  127. SQL Select query output to Access or Excel?
  128. Recordsets
  129. Open Microsoft Word Document
  130. Capture network logon name
  131. Add New record from excel Cell
  132. Manipulating Zip Files In Access
  133. Avoid jump to first data after update
  134. Opening a Word Document within CURRENT Word Application
  135. Txtdoinp
  136. Change Link from SQLServer to Access
  137. Night shift
  138. Split text records by "*" in variable amount of fields
  139. SQL Server linked tables - importing from
  140. SEarch for and replace carriage return in a memo field
  141. Run a batch File
  142. Insert Subtotals Within Range Using VBA
  143. INSERT or Update Issue
  144. DLOOKUP with a one-one relationship
  145. What query do i use to get all products from 2 products tables
  146. Removing the Startup form using VBA
  147. Extracting data from multiple databases
  148. Combination in an array
  149. Encrypt and De-Crypt a table with this code
  150. using multiple cmdPrint buttons to print different field info
  151. add new records to a table
  152. stuck using vba
  153. Update a Table from two combo boxes
  154. Move records from one record set to another
  155. Exporting Recordsets From Access To Excel
  156. If loop problem
  157. For Each Loops
  158. Environ("UserName") & Office 2007
  159. How to determine version of access
  160. MultiDimensional Array Issues
  161. Browse for filename without Common Dialog Control
  162. Using VB to delete table in another database
  163. Case Statement problem
  164. Return an MP3 files bitrate?
  165. Question about Word and Excel Behving together...
  166. Listbox referer to specific excel sheet
  167. Null Value in Number Type Field
  168. "Sendkeys" problem
  169. SQL & Array - Is this possible??
  170. E-mail creation using template as body not correct formatting
  171. String Truncated
  172. Can't call a sub from another form.
  173. Why does &h8000 = -32768
  174. DLookup based on the results of a combo box
  175. VIN Encoder
  176. DLookUp?
  177. Help?
  178. 2501 error with pdf file
  179. Propert or method of the OLE object
  180. DLookup Problem
  181. GetUserName error in MDE file
  182. Extracting information from a text file
  183. Opening a second database
  184. Mark duplicates without deleting them
  185. Get value from one table and subtract it from a similar value in a different table?
  186. Help Me With Code Please!!
  187. Calling LabVIEW Shared Library (dll) causes Access 2007 to hang
  188. Listbox Delete Item
  189. intermittent problem updating record set
  190. Get date from External file...
  191. SORTING an Table
  192. The Twilight Zone - Help
  193. Docmd.openform problems
  194. One more Docmd.openform problem
  195. Calendar Control vs. MonthView
  196. need to send reports via Outlook 07
  197. Move file to new dir (almost there :s)
  198. null and dlookup
  199. Help with VBA - Runtime error
  200. update table
  201. Error EVERY TIME I try to edit code
  202. Access forms to Excel
  203. How to set a breakpoint on a condition.
  204. How to tell where code jumps to next?
  205. how to test string for proper formatting
  206. A control array in VBA like in VB6 is that possible?
  207. Help With Importing Txt File
  208. Docmd.RunSQL
  209. rst.AddNew
  210. Problem Setting Text Property of Combo Box
  211. Keeping format while transfering data
  212. SOS plz Help
  213. TransferText
  214. Problem with my little code
  215. Stock misery
  216. Set focus to button on Form Header
  217. Overwriting existing text file
  218. Variable in control name
  219. unusual code problem
  220. Different Font color per record in listbox
  221. how to filter a listbox
  222. Get path to msaccess.exe?
  223. Change Code from IF statement to CASE statement
  224. Form Array
  225. Date Format Issue
  226. Sql
  227. Problem with Split() function delimiters...
  228. Update Excel File name using a Access Module
  229. How can I increment filename?
  230. Get Focus on a New Record in a SubForm
  231. Data from a form to a table
  232. AppActivate Issue:
  233. Syntax wrong? or what could it be?
  234. How do you add a field to an existing query using vba?
  235. VBYesNo problem...
  236. Add a field to an existing form
  237. Kill a process
  238. More effiecent way of comparing data
  239. Help needed: Consolidating Data with a twist
  240. Can this code be changed from Constant to Variable?
  241. Functionkey F1
  242. Logging failed append records
  243. DCount
  244. Copying and moving files in excel using access
  245. upload and view files
  246. Kill the " ' " in O’Donnell
  247. moving textboxes/labels through vba?
  248. reducing value to 2 decimals
  249. Need help finish SQL Insert Code:
  250. Barcodes in reports