View Full Version : Modules & VBA



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