View Full Version : Modules & VBA



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