View Full Version : Modules & VBA



  1. How does Windows distinguish DLLs?
  2. VBA Text Transfer for files with non standard extensions
  3. Table Description
  4. Creating a text File
  5. Unknown Function 'Environ'
  6. Change Form Height
  7. Message Box
  8. How to create a Spreadsheet from MS ACCESS 2003
  9. Year Expression
  10. VBA Print Button... 2 copies instead of 1?
  11. copy file to windows mobile
  12. DoCmd.OpenForm vs. Form_MyForm.Visible
  13. how would you do this?
  14. A problem....communicating with the OLE Server or ActiveX Control
  15. typemismatch error in vba code
  16. Regular Expresssions
  17. Insert into
  18. OptionButton linked with CommandButton
  19. FileDialog - Window Position and Size
  20. Invalid Use of NULL
  21. Make Table New Database
  22. Dlast Error looking at linked table separate to form
  23. Consolidate
  24. ADO error. . . simple recordset . . . Error -2147217904
  25. Function to convert fraction (text) to decimal
  26. display query on startup?
  27. Counter/AutoNumber in query
  28. disable shift open key
  29. Multiple Required Fields Behind Button
  30. Configure 2 buttons with VBA
  31. refreshing a field on a tab on a form
  32. How to connect VB to MySQL
  33. Help exporting to multiple sheets with VB
  34. Long Running VB Codes...
  35. Problems with FindFirst Method
  36. db.Openrecordset(query) - too few parameters
  37. My query runs in DAO but not in ADO
  38. updating code..
  39. Import multiple excel in access
  40. Importing Multiple Text files using VBA
  41. Dynamic Subform
  42. copy data to new field
  43. Error 3061
  44. More commitment!
  45. Check box After_Update error will not advance to next record
  46. Help With LinkMasterFields/LinkChildFields
  47. parameters and functions
  48. Listbox value to other listbox
  49. binding collection error
  50. Method For Catching Key Violations when Appending Data to A Table
  51. WorkingDays2 Question
  52. Importing csv to Access, ignoring header file part
  53. Use textbox to show ALL values in a query
  54. Run time error '3075'
  55. Remove selected item from a combobox
  56. Access Queries not running properly in VB6
  57. How to clear up listbox in VBA 6.5
  58. VB gui in Access 2007 question:
  59. concatenate string using loop
  60. VBA Code Examples
  61. Using an IIf Statement in an SQL
  62. quick If isnull & DCount line
  63. List box column widths
  64. Instr() ?
  65. VBA and SQL Error Message
  66. Export to Excel
  67. Capturing Key presses
  68. How to get listbox item to value list?
  69. Help on variable to call form field
  70. Loops the easy way
  71. Create Records automatically on specific times
  72. Get all data in a column
  73. Insert a Row in an Excel Object
  74. Subquery Or VBA Loop through recordset
  75. Import CSV with wildcard?
  76. Help needed getting number generator working.
  77. excel function in access
  78. Problems with SendObject
  79. Clear an excel sheet
  80. Client side cursor improves performance?
  81. Enter username/password into a pop up outside of Access?
  82. VBA module to import data from a specific Excel workbook tab
  83. Automail from Access
  84. Help - why doesn't it work
  85. No grid shown on form! Missing an OCX?
  86. XP Developer Executable Program Gives Runtime Error
  87. How do I make a login with the use of a table.
  88. Form_Load
  89. Search from a text box
  90. Using a public or a global variable
  91. How do you reference the value in a text box
  92. Converting to date
  93. Folder making with vba
  94. Cancel button - stop code & close form
  95. Place VBA Code in Form or in Module?
  96. DAO...testing for empty query results?
  97. change password form
  98. Control or Row Height
  99. Clear then Delete Code
  100. Remove Quotes within Data Values
  101. Adding a function to the expression builder
  102. Type Mismatch/"Binary" in listbox
  103. Afffecting Directories and their Files with VBA
  104. Convert Access report to PDF from Access via VBA code
  105. trouble appending records to a table
  106. The easiest problem you'll probably have to deal with!
  107. InputBox function
  108. Filtering A ComboBox
  109. Working with dates in VBA
  110. Can this be done in a vba function?
  111. Strings and Form controls
  112. Form Groups??
  113. unc path via text box doubleclick
  114. VBA assistance to allow sub-form to grow ("can grow" does not work)
  115. vbProperCase with Address Field
  116. Linking a front-end to a back-end using UNC
  117. Cumulative sum in Listbox using Static Variable in a UDF
  118. Problems referencing control on subform after changing source object of subform
  119. Listing everything in a column
  120. If & Select Case Codes
  121. Database security
  122. Where Command
  123. Set row source of Listfield in main Form
  124. BeforeUpdate form event, validation of data
  125. Filling Combobox with message if the query returns no values
  126. Referring to Control on a Subform
  127. Code for number field....
  128. Select Case of If Then Statement
  129. Select Case or If Then Statement
  130. ACSaveRecord
  131. Updating VBA when control name changes
  132. Add/Update Subform VBA code
  133. ADO problem when database is open
  134. Checking for Duplicate Employee Names (2 Fields)
  135. Formatting fonts prior to email
  136. Reworking data in a table
  137. Selection of a column
  138. Outputting multiple files
  139. Runtime error 13 on DLookup
  140. combobox default value
  141. Changing the Dictionary Language
  142. stLinkCriteria - simple problem?
  143. Textbox with percent and null values
  144. File Selection
  145. Show multiple attributes and records in one textbox
  146. Using string to set value
  147. Item not found in this collection error
  148. combo to filter a from by set dates
  149. Windows Image and Fax Viewer (Preview 1.0) problem
  150. Changing BackColor of a Subform's Header
  151. Trying to record the NAME of a checkbox control if its value is yes.
  152. Count Weekdays Between 2 Dates
  153. Highlight multiple date ranges on a calendar
  154. Switchboard options disappear
  155. DAO parameterized query problem
  156. Arguments in Sub
  157. VBA WHERE code in Combo box not working when using Subform
  158. Wan to pass the values from two diffrent table into one table
  159. Round value
  160. updating all records
  161. Sorting - Bubble Sort?
  162. qdef.Execute options??
  163. Combo Box/Recordset Issue
  164. Form recordsource as data source for mailmerge
  165. Importing Word Forms to Access
  166. Positioning your RecordSet at a Specific Record
  167. additional mouse pointers
  168. Hiding a record
  169. run time error '3075'
  170. Snapshot
  171. Override Query with VBA
  172. E-mail automation and Ms outlook object library?
  173. Append Value in ComboBox to table
  174. automating export of XML
  175. Create Outlook mail + attachments disappears
  176. Continuous form and checkbox
  177. Automating Table Save
  178. Code on Button
  179. OVC Appointment Item Event
  180. Two few Parameters Expected 1 Error
  181. Print dialogue box
  182. Error in Format
  183. Tracking the changes made to data
  184. OnClick Combo Box Making a List Box Visible
  185. Access to VB Converter?
  186. excel to access problem
  187. Runtime Error help
  188. Code help
  189. outputto challenge
  190. Access ignoring some lines of code ??
  191. newb - use R1C1 reference to select cell
  192. Dynamic Subform
  193. How to read a kml file (utf-8)
  194. How to check if a parent record has any child records
  195. SQL in VBA
  196. Copyfromrecordset character limit?
  197. Change List Box Row Source using combo box
  198. how to use the select case
  199. VBA Access - How to make Access wait.
  200. Dir /S in DOS - Dir all files in all sub dir's
  201. Add a Lotus Notes To Do using VBA
  202. Help with SetFocus code
  203. Alternative Error Message
  204. Transfer Spreadsheet - Use Captions Not Filenames
  205. Retrieve of the control's name that the cursor is upon
  206. simple questions about loading data from dropdown
  207. Auto Store Automated Emails
  208. Insert into table using VB
  209. Add a field to a table in another database
  210. auto fill txt box
  211. Mail Merge?
  212. Cancel keydown event when editing textbox
  213. How do I change the SQL Statement
  214. Type mismatch Error Running A Query
  215. MsgBox Function - How to Modify vbYesNo ?
  216. HELP!! Copy and paste data from subform to the main form
  217. SendObject Help please!
  218. Pdf
  219. How to change .Value of multiselect ComboBox
  220. Add a row to a table via VB?
  221. Query with Current User Criteria
  222. Unable too update text box
  223. Error 13 type mismatch
  224. VBA code to populate an access database
  225. Tree View- "No object in this control" Help
  226. loops help!
  227. Virtual Tables / Recordsets
  228. Update query to concatenate values into a string field
  229. Export query to CSV & export specification
  230. Checking More then One field
  231. Formatting of exported Excel file using Access.
  232. How to detect when query returns no values?
  233. need help with select all script.
  234. Run-Time Error 3049
  235. where do i wrong?
  236. Copy - paste function
  237. filtering usefull data
  238. Welder Qualification Database
  239. Access to outlook 2007 calendar (code mod)
  240. Font in Exported Spreadsheet
  241. export to text but only certain number of records
  242. Please help in Form to Report
  243. get data file path from ODBC DSN
  244. Select case
  245. Code to check for data in a table
  246. Goto page
  247. Updating subform controls
  248. Allreports properties
  249. Validate Phone Number
  250. Passing objects as parameter?