View Full Version : Modules & VBA



  1. .\ versus hard file location
  2. Add values to an array
  3. Accounting for SPACE in location
  4. How to convert a Access application to SQL server application?
  5. VB code to copy and rename files
  6. connectin string for sql server 2005
  7. How to generate a report from ADO recordset?
  8. Scan Database
  9. Using Excel Worksheet Function in Code
  10. Splitted MDB created problem with FindAsYouType
  11. append tables with non matched fields?
  12. Perform same operation on a set of variables
  13. VBA before update problem
  14. Problem: SUDDEN error 2465 EVERYWHERE!!!
  15. Compare two Arrays
  16. MSINET.OCX Promlem
  17. Check if database exists
  18. Using TransferText to export selected record from form
  19. Farewell, dear Intellisense (Access 2003 VBA)
  20. Newbie Help
  21. This seems a bit hard (at least to me)
  22. Database Connection Issues
  23. How to call a text box within tab control?
  24. changing subreport details
  25. Len Textbox
  26. Continuous Form: Updating display of a single cell
  27. Grabbing numbers from within a text
  28. Do Until loop possibly?
  29. Email Query Results
  30. How to export tables abd queries with VBA?
  31. Syntax Error
  32. Need Help With VBA Code!
  33. Adding pictures to word
  34. Should be a simple fix... My Code Problem (Beginner)
  35. Oft Visited Topic
  36. Pressing F5 to run code.
  37. Code won't Trigger or start, what am I missing?
  38. Open new form and apply a filter
  39. ShellExecute question
  40. fConcatFld Help
  41. Refresh network form
  42. count fields in a record that meet criteria
  43. Help on flagging up records within a time period?
  44. VBA Help - Append Multiple Tables Into 1 Main Table
  45. "Record is deleted" when doing an insert
  46. Code Issue
  47. first multiselect listbox item selected
  48. Cleaning Date Variables
  49. form open and form load
  50. Education, Education, Education............????
  51. Automation safety
  52. Record navigation based on listbox
  53. Checkbox Updating Subform Records
  54. How to AVOID / SKIP run-time error 2105 and 2499
  55. Repair Missing Library References
  56. Return the Value in a Textbox Loop
  57. Printing from access
  58. If chkbox <> null then...
  59. Word Merge
  60. button control: visible and jumpt too
  61. closing a form gives an error
  62. Newbie here - using VBA to copy and arrange fields to other tables
  63. Relation table
  64. insert rows into errors table -- Access 2003 / VBA
  65. Refresh All
  66. ActiveX component can't create object
  67. Referencing query columns in a module function
  68. Number help
  69. Birthday Warnings....
  70. VVBA Toolbar trouble!
  71. What exactly does the shift key disable?
  72. Defining global constants?
  73. Variable based on string
  74. excel automation
  75. excel automation
  76. Sql problem too few parameters
  77. If statement bad?
  78. Calculation Problems
  79. Delete Contents of Open
  80. EMail Error
  81. SHBrowseForFolder with Web Folders
  82. Option group visible and invisible numerical fields
  83. Label Properties
  84. Importing tables via a web page?
  85. screenflicker
  86. Input box question
  87. Invalid Use of Null
  88. Compile Error: Variable Not Define
  89. Count and recount
  90. Working with Recordsets...
  91. Saving records inside of FOR / NEXT loops
  92. CSV Import - Blank columns causing errors
  93. Dynamic Import of CSV files with varying names
  94. Openarg returning value
  95. IIf command and checkit
  96. SQL problem
  97. problem with refreshing oracle table (linked in access)
  98. Updating while using a Query with Totals
  99. Formatting Pivot Chart via VB code
  100. Can VBA code run when user changes records?
  101. Print excel Doc. in Access
  102. Code for Opening Query Based on User Criteria
  103. Combined field from all subform data
  104. Auto Capitalization and Autocomplete
  105. check listbox and table
  106. Search Coding
  107. Need help with Detail.. Probably error on code?
  108. importing excel worksheets into access
  109. Select and Deselect multiple times in a listbox
  110. Sending Emails via Access on Outlook 2000 and Outlook 2002
  111. Sorting records
  112. Which is quicker / better / more efficient?
  113. Applyfilter code Problem
  114. Using Vb To Dcount txtBox Value
  115. How to call a procedure usign variable?
  116. What does this do?
  117. Cut multiple fields /paste to other fields
  118. Export Graphs
  119. SQL server
  120. Summing in an SQL query
  121. Year function in VBA
  122. Importing dbf file
  123. Get Web Folder List of Files
  124. Has VBA be changed since 2003
  125. String Function
  126. Too few parameters. Expected 1
  127. Convert Rows to a Column...
  128. Last PK ID Value
  129. Table Definitions and Recordsets
  130. Opening a file
  131. How to use Access Module in query in form code view?
  132. Filter with No Records returned problem
  133. Object Library
  134. Search/Match and Display on Form
  135. Importing Data From .dat file
  136. import Directory Folder list
  137. On Change event
  138. Repaint
  139. I want to set a value using a variable
  140. ShellAndWait & Listening to an app?
  141. Conditional disabling on continuous form
  142. Time to decimal conversion
  143. Expert in VBA running Access 2003/2007 question
  144. Runtime Error 3001 on attachments field
  145. it is slow to access sql server with ms access?
  146. Access Queries based on data entered in a form!
  147. Using Dcount in VB
  148. reduce code
  149. Real Time Update List Box in Excel
  150. Recordsets
  151. NotInList function within VB?
  152. dcount - strsql
  153. Sorting Columns in Excel
  154. Specifying an Excel 'Range' when importing data to access
  155. Excel and VBA
  156. Run-time error
  157. Copying forms
  158. SQL INSERT INTO Not working???
  159. Option events
  160. Recordset / next record
  161. Compact CurrentDB
  162. Link file to another DB
  163. InputBox : Password / Asterisks
  164. List Tables and Field Names
  165. CopyFromRecordset
  166. Creating a binary file via VBA
  167. Getting Process ID By Process Name
  168. Export Table to multiple TEXT files based on grouping of one field???
  169. Audit Trail Problems
  170. accessing Outlook 2003 contacts in VBA
  171. Get IP address
  172. Syntax error in INSERT INTO?
  173. Looping through files in a directory
  174. Calculation and Send Result to Table
  175. backup using API / SHFILEOPSTRUCT
  176. How can i make access allocate random records?
  177. How to build a linked table to SQL Server view?
  178. Link csv file but with specific data type.
  179. Rename files
  180. OpenReport action canceled?
  181. Form Field populates before after code executes
  182. Using Value of Field in Form to Lookup
  183. link table by relative path in same folder
  184. Delete Files
  185. shuffle array values
  186. Create a password in VBA
  187. Word doc SaveAs, close and other VBA qns
  188. + 7 Working Days Date Function
  189. Syntax error
  190. Populate FK field with code?
  191. The expression | you entered as the event property...
  192. Assigning a variable to a form object
  193. How to change table links in MDB file using VB?
  194. Error Code 2115...with a twist.
  195. Any way to make this code run faster?
  196. openrecordset work around?
  197. Error in coding?
  198. Combo Filter
  199. Insert a record
  200. How Can I add a report to make this a sub report???
  201. Changing 'Enabled' property on a subform
  202. Send Left Arrow Key Keystroke
  203. please help to build SQL
  204. DSum with Inner Join
  205. Calculating Start & End Times
  206. Send to Oulook Works & doesnt work???
  207. Working with arrays
  208. Loop works for textboxes but not combo boxes
  209. docmd is very difficult
  210. can you simplify this code?
  211. Msinet.ocx
  212. multiple criteria for report VBA?
  213. Translate string with an "E" in it to a Number
  214. Delete Record
  215. A weekly merge of some db's
  216. Invalid use of Null
  217. Filter Help
  218. Find Record Help!
  219. Lookup keyed field data in past record and display a flag of sorts
  220. Prompt for import error
  221. Coding a BMP in to an object
  222. Type mismatch bewilderment
  223. Linking Database records
  224. Disable Page up/Page down keys not working...
  225. Auto Email help
  226. rs.Filter ???....Please Help!
  227. SQL statement on form to update table
  228. Runtime Error 3075
  229. not sure what to dim variable as
  230. Why doesn't this work? Recordset from query using form control
  231. Next Record Help
  232. I am struggling to implement this complex update query, plz HELP
  233. File Properties
  234. USer Defined Function and Backend View
  235. Can not open the code,why?
  236. Create Event for every Command Button
  237. Copying a sheet from one Excel file to another using VBA
  238. Do while loop problem
  239. Values as "Strings" vs. Properties as "Strings"
  240. How to use a function in a module
  241. Passing data from child form to the original form when both forms are open
  242. Public Function Message Box "Pop Up"
  243. Not IsNull() - can't figure it out
  244. Comparing two Tables in Access using VB
  245. Excel VBA Copy Problem (Keystrokes?)
  246. Re: Decrypting String / DB
  247. Read, write and store BLOB
  248. Calculation problem, please help
  249. Subform visible and invisible help
  250. Error in query statement in VBA