PDA

View Full Version : Modules & VBA

  1. Error Handling For Module- Not Working?
  2. Requery subform on form open - not working
  3. Code shouldn't allow record to be saved, but it is??
  4. Inserting a line into a text file in alphabetical order
  5. Controlling Scroll Bars
  6. If statement not working
  7. Delayed Email Project
  8. am I doing something wrong?
  9. Using Code to create criteria in query
  10. Use of insert to put data into a table
  11. create tables in PostgresQL with Access
  12. Payment query
  13. Unbound control update data
  14. Sub-form difficulty
  15. Just a simple problem, any help?
  16. Closing all open forms in VB
  17. Get data from tabel into array..
  18. Email Problem
  19. Dates and Times
  20. Remove From Sent Items
  21. Ambiguous name, ?
  22. Environ() giving Undefined Function on some computers
  23. Changing the string after a fortnight
  24. More Probs with Dates and Times
  25. DLookup for multiple criteria
  26. Newbie: who wants to share some experience?
  27. retrieving reports from another Application
  28. DLookup
  29. email coding
  30. Invoice hour checking by date
  31. Date within last 6 months
  32. Select Case Statement
  33. Why Find action is disabled ?
  34. TransferSpreadsheet
  35. Tracking of Excel transfer
  36. commands
  37. Displaying a Table Name
  38. Outlook Upgrade Problems
  39. E-mailing CERTAIN fields from a query
  40. Reducing Balance Code
  41. Adding Users from VBA
  42. help with SQL statement
  43. Using And in VB
  44. ListBox Requery and Change in QueryDef
  45. A2K Developer Tools Version 1.5
  46. Newbie ADODB Question - Selecting The Right Record
  47. Problems with breakpoints
  48. exporting to excel error
  49. Exporting one table to multiple worksheets in Excel
  50. send a fax
  51. Progress Indicator
  52. Another FindRecord problem
  53. Word document disappearing trick
  54. Type mismatch
  55. Filter by form
  56. Error 2391 - Access Runtime Environment
  57. Error 3251, Please Help!
  58. Data Type COnversion Error
  59. Calculations in Access
  60. not another notification by email problem
  61. Using a Toggle Button on a Continuos Form
  62. Change Network user name to Noted DB name (Len, Trim and such)
  63. Please help with working code. Access 2002 ADO
  64. Linked Tables
  65. DoMenuItem equivalent in AXP
  66. Sending multiple records in an email
  67. looping through text boxes
  68. Access Functions
  69. Referencing parent form?
  70. Call to Excel VBA malfunctioning
  71. CSV Auto Import
  72. Connecting To Sql Server
  73. Backup Database
  74. Help!
  75. Error numbers
  76. Dlookup or alternative?
  77. Help with the code
  78. How not to show control durring requery
  79. Hyperlink to a specific form in access
  80. How to force new line?
  81. Bookmark navigation
  82. New unbound doc's from OLE-embedded-object
  83. VBA/SQL Help
  84. Help please
  85. Problem with code which should send an Email
  86. Scrolling subform from code
  87. Getting the record ID early
  88. import text file to table with dates
  89. Opening and Closing Databases
  90. Adding to a DateDiff
  91. A little Help with Append Code please
  92. FTP Upload module sample
  93. Insert object into e-mail body?
  94. table contents as email recips
  95. The Seek/Find Methods and Composite Keys
  96. Save Button versus Save safety net
  97. Problem with And Statements
  98. Use table data based on form field selection
  99. File interigation
  100. Documenting queries: Extracting SQL syntax
  101. reducing sytem resource cost
  102. Calculate Expiry Date on IssueDate & DOB
  103. Tbles, Records, Code
  104. Sending Esc key using Visual Basic
  105. A better way to calculate monthly returns?
  106. Revision to a query
  107. Dealing with Access 2000 "not responding"??
  108. Code wont retain link
  109. Delete Object
  110. Open Query design grid from a form.
  111. Automaticly changing linked tables
  112. Simpler access security nearly complete
  113. OLE Server - Active X Controls - Connection
  114. "Object variable or With block variable not set" error??
  115. Populate text boxes and list them sequentially?
  116. Problem of Common Form & Str() vs CStr()?
  117. Populating TextBox temporarily using SQL VBA
  118. How to get SQL returned value displayed on my form 's unbound textbox ?
  119. Counting Code Lines in a Project
  120. Invalid outside procedure
  121. Open text and save as csv format
  122. SQL string
  123. Run-time error '3251'
  124. Using a List box send selected items to excel
  125. Where oh where has my IIF function gone!!
  126. Pass through queries
  127. How to use a barcode reader?
  128. Get number of users connected to an access db
  129. Check to see if linked table has changed
  130. I need a quick Hint. Please.....
  131. Macro or Module
  132. Select item from ListBox
  133. Referencing file Properties
  134. Reset DAO-database-object after standby
  135. Navigation Buttons
  136. Do Recordsets Automatically Update?
  137. access to excel automation...seem to still have a hidden excel instance....
  138. Manage a Text File from Access
  139. Keypress event
  140. Stop from saving when closing a form
  141. Recordset - Data Retrieval
  142. Null struggles
  143. Importing from linked tables
  144. Saving a .doc file to a table
  145. Current record of a related table
  146. MYSQL Connection string
  147. No show error message
  148. Inventory Help
  149. The command 'SaveRecord' Isn't available now
  150. Problem with error trapping
  151. Using an Inputbox to Search for a Form
  152. Compile error: Variables not defined
  153. jump to function or procedure
  154. Ado ???
  155. DB upgraded to oracle 9i : Access can't handle data-types?
  156. how to migrate one database to another ?
  157. Running a macro within another DB
  158. Access and r/o network share
  159. Why doensn't this work
  160. Notes 6 - Check for email
  161. Can someone help me with a loop
  162. Problem with dialogs
  163. VBA Copy
  164. Display picture dependant on date, regardless of year
  165. Convert a variable into lines of code
  166. docmd.sendobject
  167. bit of code not working in new database
  168. DoCmd.TransferSpreadsheet locks Excel file
  169. Access 97 -> 2000 issues
  170. Recordset - Object
  171. Calling a module in a subform from a totaly different form
  172. Call procedure in a loop
  173. Increment Rounding
  174. Clear Form
  175. Problem with Apostrophe in a string
  176. Slow Code
  177. Importing a Custom Menu Bar from another Db
  178. Data Conversions
  179. Simple Hyperlink (or so i thought!)
  180. Lock a perant form
  181. Do Loop not working or passing back variable
  182. Two Questions:
  183. Move next rec
  184. Access report snapshot -> Outlook
  185. Re-Order list (Bubble Sort?)
  186. Syntax Error
  187. Maximize the screen
  188. Create CSV from a query with VBA
  189. "User-Defined type-not defined" When using Word in Access
  190. Code on a report
  191. How to force a new autonumber on acNewRec?
  192. Object Export Problem
  193. How to open a form in another database and filter it.
  194. formatting excel cells
  195. Preview Window Size?
  196. Autoexec Macro
  197. Automation: Access To Excel
  198. Declare a single quote constant?
  199. Distance & Course Calculations
  200. Common Dialog Control
  201. Progress Bar - Run Time Error
  202. getting the autonum from one table and storing it in another?
  203. New record on subform of subform
  204. isloaded problem
  205. Using Dcount with Query. Counts source table instead
  206. Using VBA To Search For Specified File Types
  207. How to update subform?
  208. Creating an unwanted File with excel code?
  209. Long File Names
  210. Disabling a button under certain criteria
  211. transferDatabase Method Problem
  212. Clear all Records
  213. Time Interval
  214. Select Case Function and Bound Fields?
  215. How to address subform in DoCmd?
  216. Opening databases
  217. Audit Trail
  218. SQL Not working right
  219. Passing a Date to a Report
  220. Run Event Code Of Another Form
  221. Double click on ListBox
  222. Update
  223. Export from active form, then subform.
  224. Trapping "no current record"
  225. Subform requery
  226. Renaming Network Files
  227. Using code from word
  228. Sendobject
  229. Calculations help please anyone
  230. API for VBA in ACCESS?????
  231. Display a list of all reports
  232. SETFOCUS question
  233. update a field in a table from a form
  234. Time calculation/coversion
  235. Populate listbox from MYSQL datasource w/o linked tables
  236. AfterUpdate F9
  237. Entering Schedualed Transactions
  238. Automation: Access to Excel : Change Font On fly
  239. Update Query problem:
  240. Duplicating with calculations?
  241. Add items to multi-column listbox
  242. Copy and Paste excel
  243. Looping Private Sub
  244. deleting records recursively
  245. trbl with sending data
  246. Delete File
  247. Did a query return a record
  248. 3 forms, one bit of code, use a module?
  249. Finding matches by looping through records
  250. transforming string to code