View Full Version : Modules & VBA



  1. ActiveX Calender
  2. Access+mysql?
  3. Set Focus to last record
  4. Count Down
  5. Impossible parsing to learn quickly!
  6. Transferspreadsheet wasn't a problem last time?
  7. running append queries from VB
  8. Make a command button visible
  9. Email on error event
  10. VBA and Excel - Multiple Values from a Listbox into a Named Range
  11. Monitoring a DOS Shell
  12. nimda virus ?
  13. Buildcriteria DataTypes
  14. AppendEquivalent
  15. Too few parameters
  16. manipulate excel file
  17. INSERT INTO Question
  18. Memory could not be "written"
  19. Printing Word Documents in Access
  20. Search Form Problem
  21. OutPutTo - not outputting
  22. Memo Field: DAO
  23. what Library reference for left and right functions
  24. For Loop not initialised ??
  25. Code for "Browse" feature like Windows when saving a File.
  26. Which variable and how ?
  27. Database documentation
  28. Building an array from files.
  29. Problem with the references
  30. Problem with timeslot generating code
  31. Create Table KEY problem
  32. Command Bar Combo Box
  33. Updating table records
  34. firstweekofyear
  35. Dlookup criteria
  36. password logic
  37. referring to a variable
  38. jet engine not updating long strings in access
  39. Help Req'd with Word Mail Merge!!
  40. Small bit of VBA not working
  41. Assigning a value to a form
  42. Select Case
  43. VBA - output dynamic $ query to excel - $ gets truncated
  44. Search code not quite right
  45. Printout is printing unload forms??
  46. "Can't use Find or Replace Just Now"
  47. DoCmd.TransferSpreadSheet query with paramaters
  48. Imaging & Scanning
  49. Update using VB
  50. Usage timer function
  51. Dynamic Option Group
  52. Back up and zip code from ghudson
  53. Help running external script on a query
  54. Interactive filtering/querying
  55. Accessing data in a table/query from VBA
  56. AutoIncrement (Sort of)
  57. Play tune through internal speaker
  58. Date data from Access does not transfer properly to Excel
  59. Carriage Return for an automated email
  60. Autoexec to reattach tables
  61. Changing tab sizes
  62. Error Trapping
  63. Error handling
  64. what is wrong with this list box code ?
  65. String Teaser
  66. email CC to multiple recipients
  67. Calculating Elapsed Time
  68. Converting Access 97 to 2000
  69. Group name
  70. Date converting problem in function.
  71. run-time error
  72. Adobe Acrobat Control
  73. easy way to execute SELECT sql? (via VBA)
  74. Reusing Application object
  75. Multiples lines of code on a single line
  76. Adding Outlook tasks from Access
  77. Scrolling to a record in a List Box
  78. Security
  79. " you have already choose B!"
  80. Query troubl in VBA code.
  81. referencing OLE
  82. Personal "Standard Library" Module of often used functions?
  83. combobox value written as list number not text string
  84. Printing Image From Access
  85. copy table
  86. VBA simple error?
  87. Visual Basic Editor won't stop calls
  88. Counting A Recordset
  89. Complie Problem VB6
  90. Dynamic key Based on User Input - Is this even Logical?
  91. List of Queries
  92. Know any good tutorials???
  93. password generating
  94. Active X Ctrl can't create object
  95. Dynamic Query - WHERE did I go wrong;?
  96. How do I code to make an email object default to Rich Text
  97. Preventing two users from Accessing the same Record
  98. Change name of control as form opens
  99. Beep
  100. fill listbox from recordset
  101. Help referring to to object (in a module)
  102. Send Bulk Email Thru Outlook from Access
  103. first and end of this week
  104. Flag up all dates that are over a year old
  105. query with vb code urgent
  106. Password protection using VBA
  107. CreateQueryDef and date range problem
  108. Question sending email from Access
  109. Open e-mail message before sending
  110. Require code for Random Number generator
  111. Web form data import
  112. Trap Inoput Mask Error
  113. preventing scrolling on forms for split databases
  114. change property value of fields
  115. Urgent help required for automatic deletion problem in multi user project
  116. Append query error message
  117. Create shortcut to a file using VBA code?
  118. Changing font of the toolbars.
  119. Getting date downloaded from text file
  120. Cycle through all records (Newbie)
  121. Common Dialog
  122. Calculate age and length of service
  123. Newbie question:Switch to another tab of a form?
  124. Wait until Call Shell is finished
  125. password input mask problem
  126. browsing and selecting file
  127. Bound Object Frame & Clear
  128. Is there a find function for Access
  129. Access Not Working!!
  130. Turn Off Database Options in Visual Basic
  131. Switch tabs & go to corresponding record
  132. Access 2003 virus security - HELP
  133. How to get Option Group values into a tbl TXT field
  134. Calling a global access function externally
  135. Form refresh After Update
  136. Checking a record
  137. add days + 1 extra if past 29 Feb
  138. Adding AND/ OR to strSQL
  139. Using parameter queries from within vb code
  140. too few paramaters
  141. Type Mismatch Error in SQL Code
  142. Print setup
  143. An easy way to animate gifs on a form
  144. macro and module security
  145. trying to check if an object exists?
  146. Do-While Loop
  147. comparing dates and other stuff...
  148. Convoluted process
  149. Refreshing
  150. calling a sub - recorset problem
  151. Unique Account Number
  152. followhyperlink problem
  153. SetFocus problem - Run-time Error '2110'
  154. adding new data that updates else where
  155. Having Null Trouble
  156. Winsock Control
  157. rst.FindFirst - Case Sensitive for String field
  158. how to import doc file into access table
  159. File not found - differs between computers
  160. if-then statement to jump to subform on exit from control
  161. Network Connection May Have Been Lost
  162. GDI Heap & Win 98
  163. Trouble with "On Error Goto"
  164. Link BackEnd With SQL
  165. determining system setting variables (first day of week)
  166. How to learn SQL?
  167. DMin and IsNull
  168. ' character at the beginning of excel cell
  169. Property - set / let / get
  170. Store values in an array and check if exisits via loop
  171. Pls double check my vb code
  172. Use of custom controls
  173. Query optimisation
  174. concatenate ""(double quote) with any other string
  175. Display Folder Structure
  176. check for duplicates
  177. Too few parameters error
  178. Check to see if a word exists in a string
  179. Export shtml page from access
  180. Sorting a Collection
  181. vbUseSystemDayOfWeek
  182. different color for line in listbox
  183. Generate Html page from access
  184. Standard Module Not recognized in code
  185. Display Progress Bar
  186. Display all installed mailing labels p/n (Word)
  187. Query With Parameters In A Form
  188. Record Change Event
  189. Invalid Use of Null
  190. form open?
  191. Workspace Objects
  192. Outlook automation type mismatch
  193. Removing the Minimise Button
  194. Preventing Users Exploring Database
  195. Automate Setting Form Properties
  196. Open Second Database With VBA
  197. import data in to ms graph
  198. Loop - Set properties of controls (textbox, combobox, etc)
  199. Query
  200. Not Nz
  201. Selecting Rows In Listbox
  202. Searching for a record with VBA
  203. disable menu option
  204. SQL query checkbox prob
  205. Error 3075_code syntax
  206. Record calculating
  207. Password protecting VBA Code
  208. Enabling Controls Dependant Upon Criteria
  209. module problems 97-2000
  210. recordset problem
  211. Message Box behaving weirdly
  212. MS access records to MS word
  213. VB Question
  214. Referring to a Form
  215. Access 2002 and ADO
  216. Check to see if table exists
  217. Blank Combo Box Problem
  218. Cancelling Out of Edit Checks
  219. Dates in SQL Statement
  220. For To Next Loop
  221. VB question
  222. Assigning References Dynamically
  223. MsgBox
  224. Concatenating Values
  225. Passing Null As Parameter
  226. Change Data If Requirement Met
  227. SQL
  228. Passing criteria to parameter query
  229. Open Current Database
  230. Flashing Label
  231. Combine two rows
  232. Error mesage
  233. Refresh Excel link to Access
  234. Exporting to Text File
  235. Citrix ODBC connection
  236. API Call / Capture the File Path Selected
  237. E-mail attachments
  238. Creating a discount function
  239. Database Backup
  240. Do Until Question
  241. Simple accounting system, is it best to use codes?
  242. Syntax Error in SQL statement
  243. List or Combo Boxes
  244. [Example] Computer Class
  245. Default Image
  246. numbering invoices
  247. Enumerating field property values
  248. Desktop Shortcut from Package Wzd ?
  249. How To Locked A user
  250. Editing Data in Tables vs. Forms