View Full Version : Modules & VBA



  1. Sort records
  2. Code to change value in table
  3. Parnet problem with subform
  4. saving a recordset to a table?
  5. Force users out of DB
  6. Docmd.transfertext to import data
  7. OnCurrent Event
  8. Camand Button on a Seach Form
  9. Error Description
  10. Argument not Optional - Error
  11. Open a database
  12. Run code on records created with append query
  13. Multiple criterias in VBA Access
  14. Extracting data from excel spreadsheet to update records in Access Database
  15. Modules
  16. Manipulating a spreadsheet
  17. Strategy for Public Function versus Public Sub
  18. baffled by select case situation
  19. Any way to secure?
  20. .filetype
  21. Pop Up comments field
  22. What is function name when DB close?
  23. ActiveX calendar 7 object returning incorrect values
  24. Automating Windows Compression
  25. VBA not working for combo box and text boxes
  26. Updating 'child' records based on 'parent' record
  27. Use of variables in SQL
  28. External Program
  29. Call a Function?
  30. Concatenation of field name
  31. merging and shift-bypassing problem
  32. Import DNSless tables
  33. You cannot import this file
  34. IF disabled shift Key
  35. Deleting Indexes
  36. trim function not working
  37. Email Attachment Code When File Name is Dynamic
  38. Highlight Control w/ Focus
  39. Manage user/group accounts for end user
  40. Unsure of best option to use.
  41. Ooops
  42. Is it possible to write your own total functions for use in query (e.g. max, sum etc.
  43. Data replication
  44. Type Mismatch error with unsure code??
  45. Changing the Required Property
  46. Text box with a "visible" value seems to be empty
  47. Combo Box Event & Dlookup function
  48. Code to UPDATE table
  49. Linking 2 Dimensional Arrays/Table
  50. Updating FK with VBA?
  51. Punctuation Aggravation
  52. Setting Access Window Size
  53. If.. Endif statement not working
  54. Have Access test for open Excel file
  55. Type mismatch inconsistency bet. forms
  56. Writen username to table onOpen and onClose in a form
  57. Autofill value | probably simple.
  58. Compacting ANOTHER database
  59. ERROR 2108 is driving me batty!
  60. Stock furniture Database
  61. Remove specific word
  62. Automated Mail Merge
  63. Duplicate Specific Records - Please help
  64. Security - Load User and Group Accounts Window using VBA
  65. importing csv to a table
  66. Dcount - Incorrect result
  67. Changing form values from a macro
  68. Pass a variable from form code to vba macro code.
  69. reports: no data
  70. Function to return name of current query
  71. Setting field value in datasheet
  72. SendObject Problem - blank attachments
  73. Insert Into not working
  74. Report Embedded in Body of E-mail
  75. Predefined Color Variables
  76. Update Value on Parent Record based on criteria met on ALL child records
  77. Pass value of a contold to code
  78. Reference for Canvas class...
  79. docmd.openform where condition
  80. Creating RightClick context menu's
  81. Referencing Fields with a variable
  82. Import delimited without specification name
  83. Different flavors of vba?
  84. Split function
  85. Invalid Use of Null
  86. Backup and Zip DB without using WinZip
  87. OpenText -- what am I doing wrong?
  88. Need help with Access VB nested If Statement
  89. Function as a query field?
  90. General question about collections
  91. Populating listbox??
  92. Finding a Procedure
  93. Transfering queries without breaking them
  94. Update Graph Title and Export to Powerpoint
  95. Does Access 2007 support coding modules in .net or still VBA?
  96. Record update
  97. Filling in empty cells
  98. Recordset & Bookmark Issues
  99. Creating Folders with Invalid Characters
  100. Error on Quitting 2007 .ACCDE files
  101. First option in combo
  102. Surfing between forms
  103. Addnew, based on IF in loop - problem
  104. Getting the ID of a search match in a loop.
  105. Indirect reference
  106. DMax criteria
  107. Need help with search code
  108. Record just added
  109. use variable as reference in vba select statement
  110. Error 91: Object variable or With block variable not set
  111. look if table exist using wildcards
  112. undefined funtion in expression
  113. Synchronize MS Access and MS Visio
  114. Filling listbox from VBA
  115. Problem with stored textbox names
  116. Optimization question
  117. Showing listbox values in msgbox
  118. incorrect syntax error using ms access project
  119. Change Applicatin Title in Access 2003
  120. Saving an Outlook e-mail to a folder as specifed by Access
  121. Syntax Issues
  122. SendObject and Novell Groupwise
  123. Writeline to textfile?
  124. DoCmd.TransferText runtime error
  125. Integration with other Scripts Questions
  126. Data has changed error
  127. Automate Email Problems- Runtime Error 91
  128. Ghudson fScanDirSelectFileFromCombo example
  129. tweak on coding -numbering
  130. public variables - where to declare?
  131. api code
  132. Amending code for Browsing a Folder
  133. Re-initializing forms
  134. How to make string = field
  135. Generating Powerpoint Slideshow w/Tables
  136. Import multiple text files using DTS package
  137. transfer access query results to excel
  138. Cutom made message boxes how can we make?
  139. Main Log On ID
  140. Transferspreadsheet problem
  141. Table is already opened exclusively by another user
  142. Existing Table Records used to make table
  143. Need Help: This property is read-only and can't be set
  144. subforms SourceObject
  145. merging several records into a single Word document
  146. automation error
  147. Error Handling not working
  148. String Concatenation of same field.
  149. No End if needed - Why?
  150. Automation&mail merge
  151. updating a progress bar during an import.
  152. Logo's taking up too much space.
  153. help plz help plz help plz help plz help plz
  154. Selecting an item in a listbox using VB
  155. Split 1 text field into multiple values
  156. Please Need Help
  157. VBA to analyze Access Macros
  158. VBA code to close form
  159. Folder - Copying files etc.
  160. Search for text characters
  161. Parameters
  162. SQL and textboxes - won't work
  163. Trouble executing Wayne Phillip's Outlook Security Warning Suppression Code
  164. Print field names of table
  165. Need Help: automating continuous subform
  166. SQL with variables
  167. ListBox - Value List as Row Source Type
  168. Help With INSERT INTO WHERE Clause
  169. How many days of the week are in a given month
  170. Merge document with no datasource?
  171. Error Handling
  172. Opening & Closing a Browser from a module
  173. box showing choices, select multiple choices for each record
  174. Triggering event on Application lost focus
  175. Iif statment to evaluate ending in zero
  176. Multiple Filters on one subform
  177. Change query into vba SQL
  178. Another SQL>VBA query
  179. Pulling random cell values for equations in recordset updating
  180. Works with Outlook 2002 but not 2003
  181. Module For Load UnLoad Forms
  182. Search and display records from a database.
  183. Cannot repeat import from Excel
  184. SQL WHERE clause help
  185. Pivot Chart Category Label
  186. How to create a DSN using VBA (or VBS)
  187. Multiple Insert Queries - Some Don't Work
  188. VBA - my downfall
  189. Creating a new MS Access db from another
  190. sld files
  191. Convert single column query to string
  192. Export Listbox to Excel
  193. Applying Filter to Forms
  194. Insert OLE Object
  195. Need help with filtering a search form!
  196. Disable Form 'On Current' Event during Sub
  197. Need help on Logic & Code for Grid
  198. How to get the current value of a combo box?
  199. rst.CursorLocation = adUseClient
  200. Error TRapper Code only running in Debug Mode
  201. Word Automation
  202. VERY stuck - passing forms to modules.
  203. Help with 2007!
  204. Rounding / Truncating
  205. autopopulating specific fields with VBA code based on certain constraints
  206. warn a user to enter data in parent form
  207. display query results into a simple table with VBA
  208. I know next to nothing about VB
  209. determine if text or numeric value using Iif
  210. Dlookup criteria
  211. Enable field = false for two users
  212. cancel form_close
  213. Dang you VBA!
  214. New = Last + 1 ?
  215. Need help in exporting table data to excel
  216. Automate Oracle connection through code ?
  217. Recordset issues
  218. VBA & SharePoint?
  219. Powerpoint Kiosk for MS Access
  220. Another Where clause problem
  221. Append problem
  222. subform subform to control subform
  223. duplicate record VB help
  224. Closing an Open Window
  225. Pivot Table SQL Statement
  226. Got a runtime Problem
  227. Append query issue - 3067 runtime error
  228. changing Excel column names from Access
  229. Importing from csv stopping
  230. Include todays date in export to excel
  231. conditional check if recordset null
  232. events on application open/close
  233. Import contacts from access into outlook - overwrite duplicates
  234. ADO find function problem
  235. .\ versus hard file location
  236. Add values to an array
  237. Accounting for SPACE in location
  238. How to convert a Access application to SQL server application?
  239. VB code to copy and rename files
  240. connectin string for sql server 2005
  241. How to generate a report from ADO recordset?
  242. Scan Database
  243. Using Excel Worksheet Function in Code
  244. Splitted MDB created problem with FindAsYouType
  245. append tables with non matched fields?
  246. Perform same operation on a set of variables
  247. VBA before update problem
  248. Problem: SUDDEN error 2465 EVERYWHERE!!!
  249. Compare two Arrays
  250. MSINET.OCX Promlem