View Full Version : Modules & VBA



  1. WHERE portion of Update statement not working
  2. adding new records to a table through a form
  3. Code to close a form IF it is open
  4. display multiple column using a combo box in vb
  5. 2 after updates
  6. Pivot Table Form - Display Null Values as "0" on Data Axis?
  7. Send html Outlook Email, options for signature, attach, embed image plus many more
  8. Need a field value before VB opens form
  9. user-define type not defined - Dim itemInfo As Info
  10. Formatting Problem
  11. New to VBA
  12. Using VBA to populate dynamic crosstab report
  13. Edit a record in a table.
  14. Code to set multiple check boxes in a query
  15. Code to print a report to a specific Printer
  16. Problem with Notinlist
  17. Breakpoints not working...
  18. Get rid of the MS Excel Object reference
  19. SQL problem
  20. FindFirst issue - "Operation is not supported etc"
  21. Compact backend (with password) using Application.CompactRepair
  22. Search Array to determine if MyName is last array value
  23. VBA Importing to/from Access + change table name
  24. Export Query Problem in Access. Advice Please
  25. Search Populating a list box.
  26. dynamic table name
  27. Change to DSN-less tables
  28. Limit Character length with combo
  29. Between two numbers?
  30. Queries SQL and VBA
  31. Read values from a report
  32. Messages
  33. how to check for a value???
  34. Check boxes to appear with Table Names
  35. Export Wizard cannot export Queries with Criteria?
  36. Programatically Update Table
  37. Need help with graph/chart solution please
  38. Check Email Address for validity in address book
  39. 2007 Data Collection help
  40. On the fly Search Query from Excel querying Access
  41. Subform-Form: Go to next record
  42. Between a listbox and two combo boxes
  43. Data Access Page - data entry on groups - the basics???
  44. VBA Code - Checkbox - Label problem
  45. Advantages of Module vs Macro?
  46. Access 2007 run time problem
  47. weird request (maybe)
  48. FindFirst Error
  49. capture/stop the access "Application" minimise event
  50. Create Check Boxes/Option buttons/Option Group using VBA
  51. Send email by looking up the address in a table
  52. milliseconds to hh:mm:ss
  53. Format text in an automatic email
  54. Next Hireno
  55. how to combine two SQL query's
  56. Help With Login Screen Code! 07'
  57. Sync Database
  58. Filtering a Multiple items form using VB!
  59. Help required : delete / update
  60. recordsource issue
  61. Access Word Automation Book marked Text dissapears when printing
  62. Noob VB question(s)
  63. Access 2007 VBA and Report Print Preview
  64. Access F1 programmatically
  65. For loop
  66. calling a module
  67. Help with select and update module
  68. Help With recordset
  69. Invalid Procedure call or arguement
  70. New Record - Multi Choice Combo Box
  71. Loop through a Table and return the value
  72. Annoying Hourglass problem!
  73. Excel to Access Import.
  74. Please help me
  75. Data Mismatch error
  76. Filtering help! 07'
  77. Error #3219
  78. OutputTo with variable
  79. Required fields on form gives Error 2105..
  80. QueryDefs/Recordsets/Expected parameters......so confused!
  81. Paste image from clipboard
  82. Divide string by a number
  83. Macro/ VBA to print report from updated sub form
  84. Saving a Filter as a Query?
  85. Deleting Worksheet
  86. Need to copy data from Tables
  87. Get last record and display in an Text Box
  88. Email Sending through Access
  89. Add a button with code into Excel
  90. inserting pics from scanner
  91. Need Help with Code
  92. Continue Statement
  93. Subform Requery
  94. Error 3197
  95. Pivot Tables
  96. Using a DLL without registering it
  97. Random Pick, but grab identical records
  98. DBPix help
  99. Help With replace Function
  100. Populating a table from a combobox
  101. another invlaid use of null
  102. object required
  103. hard drive serial number issue
  104. multiple network cards one mac address
  105. Populating a combobox with a textbox
  106. Browse records of subform from main form
  107. Exporting table as DBF
  108. On Click Unselect All items in Listbox
  109. Record Locking Form
  110. Delete
  111. detect "hidden" status of Access Object
  112. Linking button and text field?
  113. Input Mask Error
  114. type mismatch
  115. CurrentProject method for Access '97 ?
  116. displaying VB query in list box inside same form
  117. add new record form,subform
  118. Setting Criteria on a Query using VB
  119. Produce string of random/unique/sorted numbers
  120. How to hide MS Access window
  121. I think I'm getting close? Find next business day by skipping weekend and holidays
  122. Wrong respond from Shell
  123. Bypassing validations if focus shifts to previous control
  124. Export a Table into Word
  125. How to Exit a form with no update and no prompt avoiding the beforeupdate trigger
  126. Increment/Decrement
  127. highlight text after paste
  128. Create Manual Header Line For Exported Csv File
  129. Update Data Loop
  130. Help With Login attempts!
  131. Error Handling
  132. If statement won't run
  133. Reading from .txt file
  134. Building a query in code
  135. Directory Search Error
  136. Run Time error '424' Object required.
  137. Need Readonly query output
  138. data mismatch in criteria expression????
  139. Getting Fieldnames to also Export
  140. Help needed with age restriction code
  141. Using VBA to process web response.xml
  142. opneform action was cancelled
  143. Making my code smaller
  144. How to insert row and sort a datasheet using a vba
  145. which control triggered the MouseMove event?
  146. calling multiple shell command in CMD via VBA in access
  147. error in SqlStr so they tell no Current record
  148. Passing global variable to query
  149. Adding, Subtrating, Replacing
  150. Email Problem
  151. VBA SQL Query
  152. Last nth records in listbox
  153. Importing a delimited text file using VBA
  154. Need help to add a "schoolName" in a form when a user clicks on a list of schoolnames
  155. Report Opens behind Form
  156. Interacting with Word
  157. TransferSpreadSheet Method
  158. Referring to a VB variable in a query
  159. Insert values into a table
  160. Scope of a recordset
  161. Add XML tags to selected text in memo field located in a subform with command button
  162. Open excel Workbook code
  163. Grabbing LonLat from GoogleMaps (Very very Hard) !!!
  164. Transfer Text append file info to field
  165. Creating and linking table in Backend database
  166. Type Mismatch
  167. Edit "TableDef.Connect" vs Delete/Append new TableDef
  168. Error 3061: Too Few Parameters
  169. wild card error "*" in sql script
  170. Join Expression Not Supported. In SQL
  171. VBA problem with audit tables
  172. Get Excel cell reference
  173. Insert File Path
  174. Get Table window in front of form
  175. Issues With Vbnullstring And Vista
  176. VBA code to account for greater/less than>,< signs for my Report.
  177. Sending mail in HTML format
  178. Find specific Primary Key record number?
  179. Module not working
  180. code to overwrite query
  181. Scrollbar Positioning Question
  182. Confusion with module and ldb
  183. log in
  184. Form Variable into a Global
  185. DAO.Recordset
  186. Pass Variable to SQL parameter
  187. Counting the number of fields ticked "Yes"
  188. Compile error
  189. Updating recod
  190. Need to randomly allocate a resource based on a change in week value
  191. VBA code to manipulate grouping on Reports
  192. Avoid Interleaving Transactions
  193. Help on linking two tables vertically and horizontally
  194. Double Clicking subform wont work???
  195. Shell COMMAND.COM + multiple commands
  196. Adding a date
  197. Use a recordset from a table as arguments for a function
  198. Phone input mask
  199. SQL INSERT INTO "Enter Parameter Value" issue
  200. CurrentDB.OpenRecordSet Problem
  201. How to display query count before it's run?
  202. Using array containing Control Source
  203. Copy fields to next record
  204. Processing last record
  205. Enable Macros Requirement Question
  206. Wrong Number of Arguments or invalid property assignment
  207. Print Reports from VBA
  208. How get values from one table to feed a form bound to another table
  209. Calculating the worked time per person
  210. Error When Attempting Edit of Form Code (Random)
  211. Add customer function not working HELP
  212. Call ASP page from ms access
  213. Need help in form calling properties
  214. VBA to set Form properties when the form opens
  215. disguise letters in password
  216. nearest date in two tables -- help
  217. append questions in vba
  218. Update recordset problem and general question
  219. stLinkCriteria problem Access 2000
  220. Sendkeys Ctrl+Alt doesn't work
  221. Running Queries in VBA
  222. Set Printer Options From Access VBA
  223. Open Report & Set Recordsource
  224. Create query through code with 2 or more parameters.
  225. Record Number Function/Old FoxPro User
  226. transfer spreadsheet
  227. Need help in accessing second table data
  228. MySysObjects Table Type
  229. calculating every cell
  230. Add a Hyperlink and Delete Button to Form (Subform)
  231. Problem with SQL statement
  232. replacing data a subsheet
  233. adding values to a list box
  234. Alter table . . . modify . . problem
  235. Function erroring out
  236. Custom Record Numbers
  237. Run Macro in VBA help
  238. Assigning Record Number/Recordset Doesn't Work
  239. Calling NotInList Function
  240. Issue with Filesearch (tried searching!)
  241. Adding values to listbox
  242. If and then statements - embed a list of fields?
  243. Simple Recordset Won't Work--Please Help
  244. Help me use VBA to solve it
  245. using access to calculate age from DOB
  246. Quick Question
  247. Run table make query after form input
  248. Between function for report filter problem
  249. Invalid SQL Statement
  250. Can you nest a recordset within another recordset?