PDA

View Full Version : Modules & VBA

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