View Full Version : Modules & VBA



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