View Full Version : Modules & VBA



  1. Startup hang after simple VBA edits
  2. Help with SQL
  3. Extracting SQL results in text
  4. Paste Address values to new Word Document
  5. combine multiple records into a single mailmerge
  6. Excel - size to fit
  7. Delete Excel Chart after automation from Access
  8. Back up all tables to another database
  9. Problem with recordset (fieldname = variable)
  10. change field Data Type
  11. Align column in Listbox
  12. display image residing on a web server??
  13. "3144 - Syntax error in UPDATE statement" ---Help!!
  14. Form KeyPress
  15. Dialog/OpenForm Command
  16. Pimary Key as date type, bug finding record
  17. SQL query in code over 100 lines long
  18. exporting to out look
  19. Selecting a Row in access
  20. add html table to outlook email template in access form
  21. GoToRecord help
  22. context Popup menu
  23. Using Filter Property with Datepart
  24. GetDependencyInfo Method
  25. setfocus
  26. Iterating Through all Forms and changing Form Properties.
  27. Set next quote number
  28. change subform recordource from another subform
  29. pass parameter query ?
  30. Iterate collection backwards
  31. Non-VBA expert: how to reference controls
  32. Send Null values in Date and Integer data type ???
  33. command button to print current record in Landscape
  34. count records in recordsource so I can dynmaically create spreadsheet export
  35. Updating a database with a number of check boxes
  36. DAO vs ADO
  37. Setting autostart property to true for WMP ActiveX control
  38. Is there a difference?
  39. Import Excel into Access database
  40. Word document filled with master-detail Access tables with VBA
  41. VBA Grab some data from a webserver?
  42. Problem getting multiple records to display in body of Lotus Notes email
  43. Convert repetaing fields to relational
  44. Day from date..
  45. command button to create a record in another form
  46. importing multiple excel files into a single access table
  47. Global functions in access?
  48. Naming a Group of Objects on a Form
  49. Displaying SQL Results as bodytext in Outlook
  50. Module For Searching Diff Criteria's
  51. Urgent Help neeeded!!!!!!!!!!!
  52. openargs aren't passed for some reason
  53. Embedded form picture disappears
  54. Populate button caption from table
  55. Getting nr of records before executing
  56. Some help with a function I created for calculating Flexi Time.
  57. SQL to select all records, including blanks
  58. Referencing a Global Variable with a Variable
  59. Capturing DATA form an electronic scale
  60. From field in email
  61. Link/Re-link tables
  62. Syntax Question
  63. Form close problem!
  64. VBA Error on dblClick
  65. Filtering Data
  66. OutputTo method with temporary file
  67. Grabbing Filenames - How to?
  68. Disable close button
  69. Send Matrix to SQL ??
  70. "limit to list" code to switch the settings to False
  71. Turning off Cascading Delete Message
  72. 3021 no current record
  73. Problem updating tbl fields from possible null
  74. The OpenReport action was cancelled using ACCESSRT
  75. Find first Sunday on or after the 6th of the Month?!
  76. too few parameters error ?
  77. Creating a History Log table
  78. Import Specification
  79. Executing Import Wizard via code
  80. Add strings altogether
  81. Error counting
  82. Me![mycontrol] versus Me.[mycontrol]
  83. Opening a remote database from the switchboard of another database
  84. List Boxes
  85. Autodetect VB Script's References?
  86. On Click Event Procedure Problem
  87. Synchronisation code
  88. Return Errors to Table
  89. Stored Procedure with table name as variable
  90. EOF to determine empty recordSet doesn't work with RecordSetClone
  91. Date Format Pop Up Calendar
  92. "THIS MAY NOT BE POSSIBLE" Help Pleeeze Linking .jpg using code
  93. Excel worksheet not visible to Access
  94. Can't Update table
  95. API for VBA?
  96. Relink tables without user intervention
  97. Records nagivation in form
  98. problem with importing a file
  99. DSN connection
  100. VBA to query with variable field names?
  101. How do you Email with Web-based Lotus Notes
  102. Setting focus on a subform control
  103. INSERT SQL problem
  104. Environ("Username")
  105. NotInList with Active and concatenated field
  106. Please help to generate an email
  107. Allow Additions on what event?
  108. Help with tracking of contract dates
  109. How to determine a controls, bound fields datatype.
  110. working with a database from another one?
  111. Problem with QueryDefs
  112. Recieve XML Data from URL
  113. Range in VBA to Cell Range
  114. Custom record navigation snafu
  115. Hide duplicate records in subform
  116. Search with VB
  117. SMTP truncating mail
  118. Help For Hiding Password Typing Entry Xxxxx
  119. Help with Excel code to connect to Access password database
  120. Run Code within code.. Newbie Question
  121. Help with TransferSpreadsheet
  122. stLinkCriteria Date & Text
  123. code to export form pivot table to spreadsheet
  124. Code won't convert date
  125. Expression Builder Q
  126. FindFirst Problems With Apostrophe '
  127. Determining Night Shift or Day Shift
  128. Where claus in openreport
  129. Open database with password
  130. Adding a new record with certain fields filled
  131. Updating a list box
  132. Working With Lotus Notes Databases
  133. Call Database Name
  134. Logging database changes
  135. For Each...Next Statement.
  136. Update Records based on Criteria
  137. How to browse sorted/filtered ADO recordset?
  138. Create Controls Real-Time
  139. Option Group/ Message Boxes
  140. Call sub from another form and pass parameters
  141. Access ERROR Runtime error '429' - HELP
  142. How do I used a form query with secure workgroups for mail merge
  143. Compact a MDB file on Form button
  144. Office automation : Current character position in Word with VBA
  145. Better Mousetrap with Subform
  146. Variable as Control Name for Setfocus
  147. More efficiant code for mousemove text highlighting.
  148. Environ
  149. Updating Database Problem
  150. #Value while exporting to Excel
  151. listbox Run-time error '7777'
  152. 2002 vs 2003 check version ?
  153. Auto save Excel file on exit
  154. Help with opening a sub form with code
  155. dynamic range autofill in Excel
  156. Looping thru fields in tables in tables collection
  157. Auto Increment Letters and Numbers
  158. Implement logic in a module
  159. automatic re-indexing for sorting purpose
  160. delete values from combobox
  161. Newbie Question - Paste method error
  162. Run macro every 20 days
  163. Sorting a list box with VBA
  164. Autokick When Idle Code
  165. Using a string or variant as a field name?
  166. Open a .doc based in a template (by code)
  167. Printing DYMO Labels from Access
  168. Get user's groups from Active Directory
  169. Exclusive access to Access???
  170. Beginning/End Series
  171. List Data
  172. Help!!!
  173. Difficulty selecting a range with variables
  174. Creating/Editing Tables
  175. Help Creating an Apend SQL Statement
  176. Updated Record using ADODB
  177. Detect "names" in combobox
  178. Inrementing a field on a new record.
  179. Enlarging Adobe ActiveX control
  180. SIMPLE VBA Open Form depending on Yes/No reponse
  181. linear interpolation
  182. highlight field function
  183. highlight field function
  184. SQL Server record key
  185. HELP! Passing Parameters to Queries With VBA
  186. PLEASE HELP! Exporting Access objects!
  187. Troubles with data synchronization
  188. Please help with error message
  189. Connect String, Visual FoxPro
  190. Make a report run for each month end in a range
  191. coding error
  192. "Like" problem in SELECT Statement
  193. Perform SQL on Recordset
  194. keeping user out of visual basic
  195. Not in List - Questions
  196. My Calendar control button stopped working.
  197. Text from URL
  198. 'Mail to all' button
  199. String to Number
  200. Problem entering code in VB
  201. setting a reocord set
  202. Couple of problems. May be simple...
  203. Insert Object in Table
  204. Trying to un/hide subform
  205. error for sort button using ACCESS
  206. Setting each query entry to separate strings
  207. Startup Problem
  208. Creating Tables...
  209. Trying to figure out someone elses code
  210. Updating Table
  211. Accessing the 'User List' with a split DB
  212. Updating mainform from subform
  213. "x-files" problem...
  214. Get control name
  215. Query as LinkCriteria
  216. Scrolling records with wheel...
  217. Problem with .Addnew method
  218. ComboBox Limiting Rows Shown
  219. Me!
  220. Choosing values from a list box
  221. Smart Tag Manipulation
  222. Combo box losing focus when populated
  223. Querydef question
  224. find if day or evening from time
  225. Date in unbound textbox - format issue?
  226. Combobox VBA question
  227. Search for previous record based on id
  228. recordset loop
  229. Export query to Excel-files
  230. Identify motherform in subform
  231. Finding parent with most child records
  232. Connection String
  233. Filtered Subform Exported to Excel
  234. Variable length array function-Query help needed
  235. BeforeUpdate and "Run-time error '2115'"
  236. Retrieve Password
  237. Linked Table Attributes
  238. MsgBox, Save Changes, yes/no
  239. Closing A Spreadsheet On Another Users Machine
  240. Use of < and >
  241. autonumber field in txt format
  242. Stopping Duplicate Value Entries
  243. Me. and DCount
  244. @@IDENTITY keeps returning 0
  245. update query in SQL
  246. How do you access an open Excel app
  247. Replace a word in a Word Document
  248. VB Script Help!
  249. Help with Word Automation in Access 2003
  250. how to execute a module from a macro?