View Full Version : Modules & VBA



  1. Is there a way to check if the this year is a leap year with VBA?
  2. Code to format chart series
  3. Duplicate account numbers
  4. Check if Form is open
  5. EXCEL linked table password problem
  6. Image with Scrollbars
  7. Cancel open on error in function call
  8. sending form to email address
  9. linked excel table
  10. Code Linked table into Access
  11. Take Over The Mouse
  12. Environ() Variables - Get E-Mail???
  13. Data field
  14. Problem with sending email automatically
  15. Storing ID values in field and retrieving them
  16. Something wrong with the SQL-line in VBA
  17. Common Dialog Box "view" value options
  18. Problem with Excel while using Access
  19. Scrollbar positions...
  20. Copying linked tables to new tables in VBA?
  21. Insert blank records in a table or export
  22. fixed dates but now cant see room vacancys
  23. Timecode Calculator Brainache
  24. VBA - Delete Relationships - Setting Object Variable
  25. Form Data
  26. Back-Up
  27. Problem with DatePart Function
  28. Fixing Data
  29. Using Table Field to SetFocus on Object
  30. Detecting no records in query
  31. selecting number and enter key to open form
  32. Save lotus email attachment
  33. Learning VBA code ?
  34. Sum operator
  35. Reporting lines
  36. Run dialog
  37. Hide default menu bars
  38. Progress bar on file upload
  39. Security & Modified Form
  40. Need help.
  41. random selection not marking enough
  42. Calculating number of days between multiple dates
  43. Browse Directory and select file the easy way
  44. variable names to objects
  45. How to make the code work in both US and UK date formats?
  46. Opening a dbase in vba module...
  47. Automatically Quit after a specific period of no key pressed.
  48. SQL Update
  49. compatibility problems - Outlook
  50. Problem with control form property
  51. send more then one attachment
  52. Loop and MoveNext problem!
  53. Method Open the object _Recordset Failed
  54. Please Help Me, Run Time Error
  55. Ok here's a good question...
  56. Dim db As Database returns error User-defined type not defined
  57. Field Data
  58. Browse through records sorted on dates
  59. incoming keycode
  60. Message box
  61. For Loop Problems
  62. populating items on a form in VB
  63. Back-Up Databases
  64. Transferring data between databases - Not Internet
  65. Dlookup quirk
  66. How do I return to BOF in text file
  67. VB Code to update Multiple Table Fields
  68. Help with VB
  69. Insert blank records in a table or export #2
  70. Matching values and changing.
  71. Advice Needed With Function
  72. Opening Form and Passing Variables
  73. Data Manipulation
  74. Automatically stops on non-breakpoint line
  75. Another problem....
  76. Faster data export from access to excel
  77. Manipulate Excel from Access
  78. Exporting multiple queries to Excel VBA prob
  79. Export to Excel, empty recordset
  80. Validating a Yes/No field from a different field
  81. display 'ok' message when automatic email sent
  82. Sort ascending with null values last
  83. Import data from Access to Excel?
  84. How send an open report as SendObject?
  85. Test current value....???
  86. Code -> Module
  87. How to hide my program
  88. How to calculate mean and standard deviation?
  89. SQL Issues, I think? (Overflow, runtime 6)
  90. Access's Recordset GUI bug
  91. Email Reminder
  92. Repeating Code
  93. Importing Progess Bar problem
  94. Recordset status, batch mode.
  95. change listbox rowsource using vba
  96. can this be done
  97. Update field in a table using VBA ?
  98. Is there a tidier way to write this?
  99. Runtime Error 3075
  100. Transfer database macro or code
  101. Appending 100 tables to 1 table w/0 query?
  102. Code to open the Access Database Window
  103. 3rd question...
  104. Maximize Application
  105. generating omr marks using vba
  106. Strip out text
  107. Type Mismatch error
  108. Manipulating data via VBA - confused...
  109. how do you check to see if field exists?
  110. setFocus back to incorrect entry
  111. Email Signature not appearing
  112. subform code from a form
  113. Changing the source table of a query via VBA
  114. Ordering button
  115. module calling
  116. DCount
  117. Stumbling with a sql insert
  118. Expected variable or procedure, not module
  119. Error 3011 Jet Engine Could Not Find Object
  120. Look-up blues
  121. Is there some way that I could find a mdb file
  122. Update OLE Object Path
  123. varArray with type mismatch error using GetRows method
  124. Hyperlink causes workbook to open minimized
  125. Options Button
  126. form and finding records
  127. Weird Error Message: Update or CancelUpdate without AddNew or Edit
  128. Searching Text File
  129. Bug opening Excel spreadsheet from Access
  130. Checkbox in a form
  131. Scrathing my head
  132. Simple Maths regarding division?...
  133. Data in String
  134. Removing Spaces
  135. VBA Formatting an exported file
  136. Anyone knows why Clipboard.Clear doesnt work
  137. Checking records on subform against text box on main form?
  138. Link to tables via code
  139. Divisible by 5
  140. Print report from VB
  141. Outlook compatibility again - please help!!!
  142. Defining specification types in Access
  143. Can I optimize this further?
  144. Set Outlook reminder from Access form
  145. Data field
  146. SendKeys Mouse Click?
  147. Help with message boxes
  148. Password protecting a single form
  149. How to requery data on a form automatically
  150. Simple syntax error, I'm sure
  151. Sending strings to the command line
  152. Help with passing an int to a funct and returning a str for field name
  153. Creat an Error Log
  154. Import Images/OLE LBD
  155. VB to automate a procedure
  156. Dlookup without a record ID
  157. Best way to lookup a single value from a table...
  158. OutputTo Excel
  159. Need some help with code
  160. Help on Retrieving Security Infor through VBA Code
  161. requery problem
  162. Query Timer
  163. Autosave name as field
  164. HELP! How do i enter value from VBA into a field???
  165. Function not firing
  166. .visible giving strange results in on current event
  167. need notinlist to send more data
  168. run-time error 424 object required
  169. Edit a record on a Table
  170. Module to delete record
  171. Code to save record Help
  172. Word Merge Issue - Office 2003
  173. loop through every record in a field
  174. SQL problem
  175. Conversion 2002 to 97
  176. Calculation Time
  177. Array Problem
  178. Accessing Hyperlink Base property from Visual Basic
  179. Need help to use VBA to update fields in Table
  180. .Update not working
  181. Run Time Error 13 - Type mismatch, Something to with Date??
  182. Go To Record Action
  183. calling a function
  184. New database with subform will not stay open
  185. Open form based on table authentication - How?
  186. Error with code
  187. Event Loops
  188. Finding last primary key value
  189. Repeat a record a specified # of times on a report
  190. Directly Accessing a Teradata Table
  191. error handling
  192. CopyDatabaseFile
  193. properties of forms
  194. Anyone know how...?
  195. replacing carriage return with funky square
  196. Advanced Searches / "Fuzzy Logic"
  197. Calling sub from NotInList
  198. Connecting to a database password protected back end
  199. Compacting Question
  200. Advice on bug hunting
  201. Edit recordsource in another form
  202. Writing Form data to two tables
  203. enable/disable from a combo box?
  204. manual autonumbering...
  205. Obtaining a list of reports
  206. Transferring data from 1 table to many.
  207. calling a macintosh application...?
  208. VBA in "STARoffice"
  209. Output Filtered Report
  210. Email code stopped working with Outlook 2003
  211. Seen this before ? (Built in function giving error)
  212. SQL String Value
  213. changing message box?
  214. checking field not working anymore
  215. SQL/VB code to debug
  216. getting different results
  217. Analyzing and reviewing VBA Code
  218. lookup or connect to a csv
  219. Undefined Function in DAP only
  220. Locking an Excel cell from Access
  221. SQL Table Update
  222. Email an external text file from within access 97
  223. Editing a txt file before using docmd.transfertext
  224. Stop loop and wait for ONComm event
  225. Error trap referential integrity
  226. Zipping database
  227. Rolling Averages
  228. Launch Word.Doc using eg.Code
  229. automated report
  230. Query or Function for moving/rolling average
  231. Sorting QueryDef by Parameter??
  232. DAO vs ADO
  233. How Can I use If Statement to check if field is blank?
  234. Two versions of code with a slight difference. One is faster, but why?
  235. exrpression format ?
  236. import/export wizard
  237. recordcount
  238. What's wrong with this code please?
  239. automatic table entries - decomposing "From" "To" entry date
  240. pipe delimited table script
  241. EMail to multiple receipents
  242. Copy record from table to another
  243. Problem with Recordset.FindNext
  244. Docmd.ApplyFilter
  245. Front/Back end communcation?
  246. Subform command button makes main form jump to record
  247. Unbound status bar
  248. Find the most popular book in a library
  249. Please help syntax
  250. description in report not sizing correctly