View Full Version : Modules & VBA



  1. date diff in validation function (weekdays only)
  2. Disconnects to Excel
  3. strange error
  4. Set Default Printer in Module
  5. load tables from different database
  6. Enter Query Criteria from Form
  7. OfficeClosed Function /Holidays Module
  8. Multiple Card on One Report
  9. copying files
  10. trying to refresh data
  11. Runtime error 3709 The search key was not found in any record
  12. Get all values from a listbox
  13. message box form name
  14. Check for file open
  15. Paste From Clipboard to Open Email Object
  16. Open BE exclusive
  17. Passing string values to VB declared "holding" variables
  18. Available Com Ports List
  19. Trapping system errors or Warnings
  20. Hide objects in report based on text in text box.
  21. Filter code in Access 2007
  22. Inserting graphs in powerpoint
  23. Filter SubForm by changing query criteria
  24. Parse Strings
  25. onClick Event - Search Using Dynamic Query
  26. Recordset question
  27. Date/ format function...
  28. Immediate Window
  29. Code Modification
  30. Using access to send multiple emails with lotus notes
  31. Trying to design a 'page' subform module
  32. close works sometimes
  33. Looping a Query changing it as it goes !
  34. Assigning a query result to a variable
  35. Progress bar
  36. Function for extracting portion of file path
  37. DMax Null Error
  38. Search/Match a Field
  39. Createing a Date
  40. Please someone explain...
  41. CurrentDb is nothing!
  42. Can't update a query
  43. Multiple email recipients
  44. API Calls: How to translate from C/C++ to VB
  45. Public variables lose value on subforms
  46. Putting the last record from a table into a variable
  47. macro and pivottable
  48. Trouble Connecting to Excel w ADO
  49. Password deletions
  50. Ambigious Name Help
  51. I'm pretty sure there is a better way...
  52. Handling form loading with Dates and Checkboxes
  53. Refresh Data from Excel Sheet
  54. Calculate the last working day of current month
  55. Type mismatch
  56. Backup 2
  57. Code To Check If An Application Is Running
  58. creating a report from a form
  59. Which line did error occur on?
  60. delete a control
  61. Error When Debugging?
  62. Private Function help
  63. Control IE download dialog?
  64. VBA - Creating Table From Query and Connecting to A Linked Table
  65. Need help with DLookup syntax:
  66. Polling the Google Maps API from VBA - possible?
  67. Old module names
  68. Numbers into lines
  69. Microsoft Outlook Macro - Selecting a different mailbox
  70. Get the name of current control
  71. what am i missing?
  72. For each control on a report
  73. What to do about " signs
  74. Code causing crash
  75. Using variables when refering to controls
  76. Any idea why this returns no records?
  77. Export a table column to a single Word table cell
  78. SendObject and Dlookup error
  79. change values of a report
  80. If Statement using les than and more than
  81. Query and Date Problems
  82. Loop, then add 1 to the value...
  83. First time poster to this board...Looking for some feedback.
  84. Write / Append Recordset From A Table To Textfile
  85. Help Reading in Query and Setting to Variables
  86. Runtime error 3075
  87. copy values
  88. Date field subtract and insert it into a number field
  89. I think VBA is making memory problems and changing query values
  90. Object variable not set...
  91. commas
  92. Programming Enter Key Behavior
  93. setting a time interval timing for backup
  94. save textbox values to a record
  95. why is my Beep function silent?
  96. Insert SQL Statement If a New Record is being Created
  97. Display commas in Word Merge from Acess
  98. tabledefs beginning with "~tmp"
  99. Cannot find object
  100. Format data in excel using a query table from an ODBC connection
  101. Pricing Lists
  102. Import selected Excel cell contents into Access
  103. parentheses in field text stop email from sending
  104. Check table to see if record exists, if not -INSERT
  105. RecordCount
  106. get array of values into textbox
  107. Array Help Requested
  108. List table, field, properties objects in table
  109. Barclays Bank Statements
  110. Loop order
  111. TreeView control
  112. DCount Problem?
  113. Eval Function - Recursive call?? Routine Being Called Multiple Times
  114. Creating New Tables With VB and Populating With Recordsets
  115. Code for resetting a password
  116. Determine if Object Property is Set
  117. Export Report ACCESS vers Excel
  118. VBA on Subforms
  119. SQL statement not time stamping field and closing window
  120. Appending objects to collections
  121. String Value Is Not A Date
  122. vb6 and ADO syntax error
  123. Start at beginning, change Rec, Stop at End
  124. Reading File Attributes using FSO
  125. Return number of records affected by Query
  126. Use a Control's Datasheet Caption or Associated Table Column in VBA
  127. Me alternative Reference in a Public Function
  128. Assign a value from a report calculation to a table field
  129. SQL With String TableName
  130. Rename Exported File?
  131. Show image IF record is a certain value?
  132. Outlook from Acess using DAO
  133. How to Select a Row in a Datasheet
  134. Count current records entered on data input screen.
  135. Run Method not working as expected
  136. Autonumber sequence incorrect
  137. Is there a way to make this work faster?
  138. How to hide a subreport?
  139. Problem with hiding control/setfocus
  140. TransferText Changing Data Type
  141. security problem
  142. Meaningless error messages
  143. Sending E-mail from Access (Full Automation)
  144. Removing "Seconds" From this time code
  145. Run-Time error '3075'
  146. Error 3274 External File Not In Expected Format
  147. VB editor views
  148. Text Entry for Query
  149. Sorting characters within a string
  150. Enquiry about coding explantion
  151. Delay Running a module
  152. Simple copy module
  153. Problem when checking if memo field is empty
  154. Excel for combo box using Access Tables
  155. VB Help
  156. SQL to generate Reports
  157. DoCmd Question
  158. Complex Problem
  159. Complex Problem
  160. Complex Problem
  161. Code to avoid overlapping date entries in Products/Rates tables
  162. ComboBoxes ??
  163. Copy Tables with Relationships?
  164. Syntax for Defined Variables used in DoCmd.RunSQL
  165. Run time Error 3061.
  166. change from 7 to 07
  167. Searching and returing info based on user input
  168. Trouble populating forms from table within db
  169. Example of getting effective dated rows and doing math on some fields??
  170. Add Condition to If ElseIf Statement
  171. VB Conditional Formatting
  172. ComboBox and TextBox combination
  173. Export multiple excel file base on fosUsername()
  174. create a progress bar in VB
  175. Backup
  176. Command button that will auto enter fields into table
  177. Carriage Return in code for email
  178. Insert Image
  179. Help with IF Statement
  180. Powerpoint/Access 2007 Automation Issue
  181. Export to CSV
  182. DoCmd.TransferText + Concatenating Results
  183. Gurus: Conditional Printing
  184. Help with ElseIf function please
  185. Access info to outlook Calendar
  186. Access cant find my control ???
  187. If Than elseif this is to difficult
  188. Converting Macros to Code/Modules
  189. SQL server login from Access
  190. Convert Access Date to Unix Timestamp
  191. can i run a select statement in module?
  192. Type mismatch in report
  193. page up command?
  194. acc 07 runtime question
  195. Convert action to Function
  196. Audit Trail - Allen Browne - prob with insert
  197. Remove Hours, Minutes, Seconds
  198. REPAIR TYPE to return value
  199. retrieving username fails . .
  200. Opening the Database Window
  201. Help with SQL statement in VBA
  202. send contents of textbox to excel
  203. Message When Field Is Null
  204. More Word/TXT fun!
  205. Check a file has records in it
  206. why does Update statement in VBA work incorrectly?
  207. Deleting a row via a cancel button
  208. Formula assistance
  209. Select Case
  210. Hi All...should be an easy one
  211. DCount and "For Each" record help
  212. Code to automatically trigger a command button when a form is opened
  213. How to Square a number?
  214. Getting report to open with where clause
  215. Link to Outlook, small query
  216. compare date in vba
  217. Altering RecordSource property
  218. Frozen Select Case
  219. how to capture the input data for a query of a form and pass it to vba code
  220. Set Warnings Learning Experience
  221. Which Event to Use?
  222. please help me with my password textbox
  223. Limit the input
  224. Delete a record specified in a combo box
  225. Error 3464 - Data type mismatch
  226. emailing with access
  227. Array Loop - Need Help
  228. Query help needed
  229. Electronic Signature insert???
  230. Linking tables via VBA
  231. excel to access worksheets
  232. Run-Time Error 2448
  233. Text Box Message In IF Statement
  234. VBA in query criteria
  235. Average of partial records in a field
  236. basic things
  237. Please Help With DLookup Error
  238. Trouble opening a new instance of Access
  239. Criteria in DCount
  240. Shell Function
  241. Randomizing a Resultset 2
  242. Field Names in SQL
  243. Current Control
  244. Adding a record to subform
  245. Duplicate Control...
  246. VB for Search in Tables
  247. EOF error again (sigh...)
  248. Import Module
  249. Dynamic Fliter in Query or Form
  250. Convert Metric Date