View Full Version : Modules & VBA



  1. Send Object To A Group Of People
  2. add one hour to file time attribute
  3. Email snapshot of Report
  4. docmd.outputto http...
  5. odd VB input behaviour
  6. Calculate SinceDate when having to UntilDate
  7. Converting XML Files to Excel Files In VB or VB.net
  8. Suppress Action Query Messages
  9. Menus no longer appear, shift gives blank screen
  10. DlookUp Min(Date)
  11. Bbc.Co.Uk Newsfeed.
  12. Image relative path
  13. Dates getting 'inverted' when imported from Excel
  14. Open Password protected XLS which has an Autoexec macro
  15. Update Query syntax issues in VBA
  16. Display English numbers in Arabic-Hindic format
  17. Error 2450 making me crazy
  18. Display results of sql query on form
  19. Corruption, Network delays....best practices?
  20. E-Mail Access Report With Multiple Outlook Options
  21. Open different .be from same code
  22. Message box only first time DB is opened
  23. Create Datalabel for pivot chart entries in VBA
  24. Exporting to Excel w Recordsets
  25. Automate Access to Send Emails and Receive Responses with Outlook
  26. Multiple decision criteria
  27. module to print report data in columns
  28. .Findfirst Action w/the Date() function
  29. VBA code window in dual monitors
  30. Stop a procedure from running with a click event
  31. unbond text connect with two tables
  32. too few parameters expected 1.
  33. Error 2205 (default printer driver)
  34. Transferspreadsheet
  35. limiting one item being chosen at one time
  36. Module to Update tables (skip blank fields)
  37. VBA & Dates
  38. Clear Contents In Excel & Transfer Sprdsht
  39. SQL Help
  40. Listbox Code Help
  41. sql sum as variable - how to?
  42. A better way.
  43. Help with navigating a recordset
  44. quick query with regards to populate problem
  45. Invalid Argument?!?
  46. Adding a 'Browse' Button
  47. How Can I Use rgxValidate
  48. Exporting Data to text file
  49. Data Validation in a text field
  50. SQL INSERT : What's wrong with this statement??
  51. SQL INSERT problem
  52. Embeded audio
  53. help to fix code findmax
  54. Connecting to oracle via VB Acess Script
  55. Best Way to Loop Through and Close Certain Forms
  56. Looping through 2 recordsets
  57. check for blank or null...
  58. I don't understand a section of VBA with "requery" code
  59. Authentication problem
  60. Problem!! listbox
  61. Wierd Ucase error
  62. .net and Access 2007
  63. integers with ADO to MySQL
  64. hiding Listbox column separators?
  65. Linked SQL Server tables become read-only
  66. Returning only from one table unnecessarily
  67. Log in and Log out information save
  68. Dcount Check boxes
  69. Launch a query in code and access fields
  70. Apply DoCmd.SearchForRecord on Seperate Form
  71. Unselecting listbox items
  72. CDO emails
  73. Problem with a continuous form
  74. Looping code based on values in query
  75. NotInList not working in some forms, okay in others
  76. multi-valued variables intVar(1)=X intVar(2)=y
  77. Set rst = db.OpenRecordset() Help!
  78. Subtracting two date fields, result in a third
  79. Set Recordset Using SQL
  80. Do Until Error
  81. Add days while skipping weekends and holidays
  82. Word Form to Access Tables Data Transfer
  83. how to show specific record in report?
  84. Transfer CSV file with ado
  85. add one condition
  86. Code Not Calculating Correct Totals
  87. Run Time Error '2465'
  88. Issue with acCmdImport
  89. Option Explicit
  90. Dlookup
  91. confirm insert on _Click()
  92. Seeing 'ID' instead 'Name'
  93. stock update
  94. Variable type not appearing
  95. Command button to go to a Web page - Plus a little more :)
  96. code change in Access 2007?
  97. Copying a label with code and pasting
  98. Populate multiple control texts via recordset
  99. ERROR 2342 DoCmd.RunSQL
  100. Editing specs in an exporting Txt file
  101. Problems with DoCmd.FindRecord
  102. Persistent form <-> recordset binding
  103. Data type mismatch in Criteria Expression
  104. sending text file as attachment to a an email
  105. Alternative to 'For i = 1 To .Table.Columns.Count'
  106. Using VB code to run append and update queries (Simple problem)
  107. timestamp
  108. Looking for critique of VBA snippet (Familar with C++/databases on Unix)
  109. extract a file from .ZIP using VB or VBA
  110. Use ADO in VBA
  111. Best way to change a character in a string?
  112. prevent formOpen if nodata
  113. changing colour
  114. import data to Access table thru VBA
  115. Populate Text Boxes using VBA
  116. Insert into unless?
  117. Error Msg during append
  118. Help! Convert to tab delimited file?
  119. Updating a table
  120. Error message in coding
  121. Make password form load at startup
  122. Compile error on trying to have function return an object
  123. Populate a ListBox with Tables Names and Table Data
  124. Display Table Data in a form using VBA
  125. Move Object Frame Using Mouse
  126. VBA References
  127. Add a Horizontal Scroll Bar to a List Box
  128. Need help
  129. Subquery with multiple criteria
  130. DoCmd.close Error
  131. Module Identifier
  132. deleting
  133. Disable access to design view with VBA code
  134. FindFirst with Multiple Criteria
  135. ... VBA keeps testing an "Or" statement after it finds a true? ...
  136. Using event "On Change" to force uppercase in text box
  137. "If openargs =" statement syntax needed
  138. Importing files into Access
  139. Calculating the difference between records
  140. List Box Fliter MS Access VBA
  141. Msgbos Question
  142. Combobox RowSource derived from 2 option groups
  143. Remove Leading characters
  144. Code in subform to set focus upon failed validation works unless you leave subform
  145. How do I call a menu command in VBA?
  146. Refresh Textbox with new data
  147. Line numbers in VBA?
  148. Security warning
  149. Calling Subform Module from Parent
  150. Return to field after "After Update" code is run
  151. Filter Report Error
  152. Change the Appearance of a list box (Access VBA)
  153. SetFocus not working
  154. Resetting the Ubound value of a multi dimensional array
  155. Export all tables in Access to a SpreadSheet
  156. the correct way to pass Is Null back to an access query from VBA
  157. How to gray out the "X" main close appl icon
  158. Problem with SQL statement in VBA
  159. Sending Email with Signature
  160. Excel Automation Confusion
  161. Time Field to pecentage
  162. formatnumber need help with module
  163. stock level update
  164. Find multiple records the loop through each one every second
  165. Problem when exporting data from access to word document with bookmarks
  166. Calculating the 'N'th DAY in a month
  167. Change combobox ColumnCount using VBA
  168. Undefined function <name> in expression. (Error 3085)
  169. Requery not working as expected
  170. Problem with initialising a loop
  171. Export Specification
  172. Can i have a recordset without a table/query attached?
  173. Make folder depending on combobox value
  174. Export Table data into an Excel SpreadSheet (VBA, ACCESS)
  175. Quickest/shortest route between 2 postcodes
  176. Removing Characters from Address Fields
  177. Email with no address error
  178. Please Help!
  179. Remove From Multiple fields
  180. Date Function Returns 30/12/1899
  181. Form after Search filtered
  182. Compile Error??
  183. concatenate multi list box selections
  184. Send email from form when inventory is low
  185. runtime error overflow problem
  186. Novice in VBA Please helpout me.
  187. Back to working days / hours with holidays
  188. Simple Windows user identification
  189. string manipulaton - remove unwanted characters
  190. Syntax Error Runtime 3144
  191. MS Access on load blank form and start the find
  192. Check Boxes
  193. Return value from a query
  194. problem with parsing
  195. Openning recordsets on queries
  196. Extract 8 Tables into 1 Large Table
  197. Updatable recordset
  198. Control Properties
  199. how to have a common unique index number within three tbles in Access
  200. Reproducible ramdomisation
  201. VBA Programming Tutorial
  202. identify word in a string
  203. Delete
  204. How to use name concatenation in multi-record report
  205. How do you add a "LIKE" option to SQL VB Code?
  206. How to combine two vba code into one code
  207. refresh passthrough queries
  208. Erratic results from code
  209. really stupid question
  210. Database Window Close Button
  211. Opening a recordset
  212. nubie in need of help
  213. Insert table records into another table
  214. Database is read only
  215. message box
  216. Excel to access
  217. too few parameters
  218. Code prevent deletion of updating front-end mde
  219. Remove Filter/Sort
  220. Date and Time Picker
  221. Event after delete
  222. IsMissing() Glitch
  223. stock
  224. Automate a word mail merge
  225. Importing into Access
  226. QueryDef Issue when creating MDE file
  227. case-sensitive sorting (hex problem)
  228. case-sensitive sorting (hex problem)
  229. Highlighting/Showing unmatched fields and records
  230. Public Variables
  231. Determine If Changes Made to DataSheet
  232. Outlook Email
  233. Formatting Error with VBA Array?
  234. test if object var is set to nothing - also looping through excel sheets
  235. change field name in code
  236. Time Log
  237. Create an Excel Spread with multiple worksheets
  238. Change the format of MS Excel Cells from MS Access
  239. Quick one - refreshing Navigation pane
  240. include argument name in function call, eg ?longpathname(strfile:= "c:\file~1.txt")
  241. Need some VBA guidance here?
  242. Printing Form for Multiple or Single Report
  243. Printing Form for Multiple or Single Reports
  244. Exporting a table to a text file
  245. date activated
  246. Exporting data to Excel into predefined format
  247. Assign Files in Folder to Variable
  248. Updating records
  249. Access and PERL Question
  250. Updating records