View Full Version : Modules & VBA



  1. how 2 use RECORDSET?
  2. Import Text from a web page into database
  3. VBE windows setup
  4. delete records problem
  5. Integer part
  6. Date formats
  7. Yes/No message box!
  8. Trap run-time error in parameter report
  9. Compact the CurrentDB
  10. Print these pages
  11. convert ac2
  12. copy from excel & paste to word
  13. Switchboard
  14. 'Insert Into' code
  15. Mvb
  16. Almost completed the merge
  17. Retrieving first part of e-mail address
  18. Refresh form
  19. How do I use DAO to compare text box on form to query result?
  20. Running Code
  21. Simple Question - changing value of a field in a table
  22. Network Issue - Awful record retrieve time
  23. How to convert table list to report
  24. Date() causes error 438
  25. Modules, Aaaarrrggghhhhh
  26. Referencing confusion
  27. If statement
  28. Opening a form
  29. Another If statement question
  30. updating a Combo Box after delete
  31. Need help!!!!!!!!!!!
  32. Hidden Modules etc
  33. Writing a frontend in VB6, need help with reports
  34. Created Module now getting rtrim compile error
  35. Creating A Link To Sql Server Table In Code
  36. How to review security (use code)? Access 97
  37. Creating Letter in Word from Access Runtime Error
  38. Digital Signatures?
  39. Make CurrentDB as DataSource
  40. Update records
  41. for each record action??
  42. How to use current DB as Datasource for mail merge
  43. Another save/cancel record question
  44. query variable in Querydefs
  45. Sending Data to a Serial Device
  46. DSum
  47. Sort on Subform causing problems
  48. Creating, Writing to and Deleting Text Files
  49. Hperlink to Powerpoint
  50. Split Code Maybe?
  51. reference forms
  52. Set visible property (basic)
  53. update database from a URL?
  54. Skip when nothing found
  55. Remote Macro Access
  56. Calling a form/Opening a form - basic
  57. need code to clear texbox
  58. Variables not resetting on DB close
  59. Out of memory when running module
  60. clear filter on close
  61. Renaming a Form object in VBA...
  62. Count number of groups in a table, in code
  63. Questions about Tables and Recordset and VBA
  64. Loops and Textboxes
  65. Open Form on Last Record
  66. Event procedure on Form level
  67. undefined type
  68. Dynamically Update Fields
  69. format in the id field not showing
  70. OLE object?
  71. Using Chinese literals
  72. public sub sos
  73. Tricky question
  74. Module Hangs Form
  75. Ode 97
  76. Update Statement
  77. Input Box to SQL Statement
  78. Abort Insert....
  79. 'data member not found"
  80. open form in edit mode rather than add?
  81. Using Ddl To Create Sql Server Table
  82. Email field
  83. Record operations with subform
  84. Length of String in a Text Box
  85. Syntax problem - strCode
  86. Subquery filters
  87. code to convert clock count to date - simple?
  88. VBA Help
  89. RunMacro
  90. Changing report name for SendObject
  91. Counting records in folders. Please Help!!!
  92. Help with adding default text to a field
  93. Daily Calendar
  94. Find Max in specific rows
  95. E-mail Authorisation
  96. Explanation of Code
  97. simple if statement question
  98. How many characters allowed?
  99. Bound field problem
  100. Abs(olutely) wrong
  101. Saving email from Outlook into Access
  102. Problem with sqlStatement
  103. Email Addresses and Groupwise
  104. Error code not running when it should
  105. Print fields
  106. An Access Form issue
  107. Dim db As DAO.database
  108. Update Outlook Contact
  109. Mutiselect Listbox
  110. Data Insert...getting back the "autonumber" value.
  111. date syntax problem
  112. not going to before update
  113. Continuous form data
  114. VBA Explained
  115. Filesearch
  116. Hyperlink in email
  117. Opening MSAccess Form from Desktop shortcut without Access window itself opening
  118. between dates
  119. Create Timed Events in a Closed Database
  120. Writing members of a RecordSet to a text file
  121. duplacate output
  122. e-mail problem from newby
  123. Filling an Array from a Record
  124. The Joys of converting from A97
  125. Merging 2 Text files
  126. code for looping
  127. dcount code incorrect - please advise
  128. Listbox/Textbox doesn't refresh on form
  129. How to convert this code to a module
  130. Automatically Send Email When Date in Table = Current Date
  131. Loop only updating on last rec
  132. List repeating records in text, separated by commas?
  133. "Records Lost" error, but they aren't
  134. Trbl with Filter
  135. type mismatch passing values to function
  136. again - sorry on my english
  137. Mod function for decimals
  138. i need example for an advanced search!!
  139. help please!!!
  140. Access Modules, Reference
  141. Double/Parallel Data Entry Check
  142. check if file exists
  143. edit code for e-mail
  144. system date
  145. TransferText giving unwanted decimals
  146. Roundup
  147. flushing disk cache
  148. A hard one - Login and Log Off
  149. compare excel cell to access field
  150. DLL Add-in
  151. Developer software
  152. Add field to LINKED table
  153. Update tables based on another
  154. Query Parameters not suitable for QueryDef ?
  155. transfer text rename output file to variable.
  156. Useing Refresh in Module
  157. Calendar Calculations
  158. calculation to change value from DOB to age in VB, not what u thnk
  159. Please Help! Round function.
  160. Date + Time() problem
  161. ADO query on ODBC-linked table
  162. Compare 2 tables
  163. Passing Criteria to a Query
  164. Cancel option group update
  165. Rounding time to the previous half hour
  166. Some quick $$
  167. GoToRecord and subforms
  168. Set value based on other value
  169. Complex Calculation
  170. Combo box select critieria for a report
  171. I feel so dirty!
  172. Swedish Versions of Code Access 97/2003
  173. Relinking Tables etc
  174. Finding a particular value in a recordset
  175. Find differences in two memofields
  176. Changing field backcolor based on another field
  177. Decimal VB help
  178. Calling a subroutine whose name is held in a string
  179. Error Accessing File
  180. Combo Box Problems
  181. applying filter to a form
  182. Louts Note
  183. Concatenation issues in VBA
  184. Dates
  185. DLookup
  186. Updating a desktop shortcut.
  187. Automation: Access to Word_ BookMark does not work in the word table
  188. Quick DLookup question and another...
  189. Update Text Fields when List Clicked
  190. Function to change foreground
  191. Delete Record On Subform with Control on Form
  192. Using Dcount to count records with todays date always returns zero
  193. what is the diference between Form_MySubform and Forms!MySubform
  194. Data to List Box
  195. Automation: Help! Access to Word Table
  196. Check file copy
  197. How to get rid of a vba module?
  198. applying filter to a subform
  199. ADE File creation
  200. TransferText under XP
  201. Execute an Oracle procedure from VBA with parameter
  202. Form.Printer.Orientation
  203. Select Record
  204. Getting logged in user (of Access workgroup security)...
  205. Sequencing a Bill of Material
  206. New User - Without shutting db down.
  207. Testing for Null fails
  208. master file
  209. Import / Link Excel cell into Access field?
  210. Checking/Unchecking All Records
  211. Mail Merge and Sql Table
  212. A better way...
  213. Loop Function
  214. Does audit trailing feature cause problem later.
  215. Database rollback help?
  216. Export Recordsets to Word Bookmarks?
  217. Select Record Statement #2
  218. Spell Check different fields
  219. TransferSpreadsheet Range
  220. SQL Statement help
  221. Background color
  222. Dirty Property
  223. can i rename a recordset...?
  224. Control one access vb from another
  225. Using a VByesno message box
  226. Msg Box
  227. ADO connection-recorset problems
  228. Using Modules to Neaten My Code...
  229. Newbie - I have tryed this
  230. Monthly Append Query automated
  231. Prob with Update Code
  232. saving long text to a memo field
  233. The vba code that won't go away!
  234. Code taking too long
  235. Outputting records as a string in a textbox
  236. Rearrange date string
  237. Complicating the absolute
  238. Working With Hyperlinks on Input Forms
  239. Recordset Problem..please help
  240. Need expert help. Don't know VBA. Cascading Combo Issues.
  241. FindFirst Problem - Porting Access 97 to 2002
  242. Email option on Form
  243. Making connections to DB
  244. Import data (transfer) from excel and exclude some coloumns/rows
  245. close all open forms
  246. using Dlookup to test for null value in field
  247. If.. ElseIf... Statement Not working???
  248. Synchonization advice
  249. Disable Return Key
  250. TransferSpreadsheet acImport and RunApp