View Full Version : Modules & VBA



  1. Accessing a variables in two or more forms
  2. Smoother way to get address list names from Outlook?
  3. There must be an easier way?!?
  4. Pass parmeters to a query
  5. Using dimension as field name
  6. Display a tables 'Date Modified' value
  7. Table or Value list?
  8. GetPixel/SetPixel question
  9. Automatically entering a range of numbers
  10. Freeze pane in Excel from Access database
  11. Login Page
  12. Passing the form reference to an undo function
  13. Working with createobject
  14. What if table does not exist?
  15. Find and replace text in table
  16. Form to build a query
  17. Recommended Reference Material?
  18. Assigning String
  19. Perform task mid-sub proceedure
  20. Omit ")" at the end of a sting
  21. Date Scheduler
  22. ReDim an array
  23. open parameter query in code
  24. Excel won't refresh - Access database locked
  25. Cancel a New Record Entry With ESCAPE Key
  26. Create Table
  27. GetObject
  28. HyperlinkPart
  29. looping over reports
  30. How do I keep my value incrementing by holding down the mouse key?
  31. Module Run-Time Error 2147287036
  32. Recordset and DCount issue
  33. recordsets
  34. DB error after FMS Analyzer
  35. Drag Drop from Windows Explorer
  36. Validation of two controls
  37. Can't get code to work
  38. OLE automation Internet explorer
  39. Suggest the last
  40. windows picture and fax viewer
  41. checking a table for repeats
  42. get rid of default messages
  43. User-defined type not defined?
  44. Need timer help - Access to/from SQL
  45. Need part of a name chopped!!
  46. Copying a record from one table to another table
  47. Cannot get Sql to run in VBA
  48. command button/add new record/tab order problems
  49. Hyperlink in Menu
  50. Set db = Nothing... explanation?
  51. Referencing textbox objects with strings
  52. Cannot append new User
  53. Search several modules at once
  54. Programatically changing the table that DLOOKUP Uses
  55. Convert text field to number field
  56. How to delete multiply selected list box records
  57. Converting access 97 to access 2002
  58. Reading Data from fields on form into VB code
  59. Runningan SQL statment
  60. Update Query or Code
  61. Converting a text field to a number field
  62. SQL Statement
  63. Current Object/Event Name?
  64. Primary key and Foreign key to be in sync
  65. Select statement to vba
  66. Email Form with Several Choices for User to Make
  67. Multiple dynamic lines across detail of report
  68. Subform VBA Code
  69. creating the required property using vb code
  70. SQL parameter problem
  71. Importing tables using VB
  72. Help with Arrays needed
  73. DAO.recordset and reference
  74. Clear unbound textbox if duplicate entry
  75. DLookup and compound primary key
  76. help vba code for button in daterbase
  77. The quickest way of determining if a field is null
  78. SQL not working properly
  79. Transfer Text
  80. Summaries and Details
  81. EOF difficulties
  82. ISAM Data control error.
  83. Using "Between" in VBA?
  84. Module Help
  85. Create functions within a form
  86. need help
  87. Link to Another Database
  88. Prevent Or Disable Access Application Resize
  89. Detect if table is in use.
  90. Keypress event problem
  91. Displaying UserForm
  92. Create a Docmd.SendObject based on selections made on a form
  93. get rid of a warning box
  94. Validation on another Form Field
  95. runtime error 2465
  96. prompt user for a field
  97. variable error
  98. Call shell
  99. Calculate time lapse with exclusions
  100. VBA Validation
  101. Elementary Question: What is the purpose of DIM
  102. How do I store an IP adress?
  103. vba code needed
  104. Smarter than your average combo box
  105. align text
  106. Title Case
  107. Need code to take values from controls and pass as a record to a table
  108. Emailing in Lotus Notes
  109. Dynamic report titles
  110. Fill a subform with values from diff tables dep on listbox
  111. Accessing a SQL Server database from DAO
  112. Inserting data from a table or qry into the body of an email
  113. Followhyperlink problem
  114. Sending Tasks with Outlook Redemtpion
  115. response statement
  116. Using a variable in an update statement
  117. set visibility from another textbox
  118. Word/Access Automation
  119. public variable resetting themselves to "" ? why
  120. Problem with Saveing Record
  121. Access VB to Excel VB
  122. Massive If/End IF
  123. Split Database and lost form permissions
  124. Variables and SQL
  125. Pulling a value from a table
  126. Check if textbox is empty
  127. If DLookup IsNull - Help Needed
  128. Keycodes for FKeys
  129. Getting the HDD Serial Number
  130. Private Sub Form_Current() says syntax error?
  131. Coding Libraries And Utilities
  132. email from Access - no Outlook
  133. concatenation with this string
  134. Problems with activex and autocompletion
  135. Using ADO in VBA?
  136. Find Record using Calendar control
  137. Jumping through Loops
  138. Navigate in alphabetical order?
  139. Get IP Address
  140. Trapping the cancel of OutputTo
  141. <method 'Cells' of Object' _worksheet 'failed>
  142. Keycode values
  143. Environ("home") through dial-in
  144. Passing a date string with boolean operators to an SQL statement
  145. Day of the week?
  146. Import txt or xls file to SQL Server via VBA code
  147. Create email in Outlook Express 429 error
  148. Storing Values
  149. ado recordset missing data
  150. Transfer data between tables - problem with unique ID
  151. Getting windows login details (Windows 2000)
  152. Checking Items in a string
  153. Help my function and calling this function
  154. to output Stored Proc/View result to xls via VBA code
  155. How do I query and export all 50 U.S. states using VBA?
  156. loop to delete records doesn't quite work
  157. How do Modules created during development behave after the split db in multiuser envi
  158. Mouse event in Public function
  159. Delete Tables in External Database
  160. Test To See If Laptop Is Connected To Network
  161. Combo RowSource dependant on formula
  162. Test For Live Windows Server Connection?
  163. Application Window
  164. Delete Server Table from Access Application
  165. Data conversion error
  166. Query works, SQL doesn't???
  167. Type mismatch error
  168. rename file in DOS through Access??
  169. Date/Time comparison
  170. #Name appearing when using Date()
  171. DMax Function
  172. DAO and ADOBD
  173. References are greyed out?
  174. database location
  175. DAO\ADO RecordCount
  176. Multiple Excel sheets
  177. Error Accessing File
  178. Email Report With Details In Subject Box
  179. Press a button with another button
  180. time over 24 hours limited to a job type??
  181. time problems
  182. Report Module Help !!
  183. Navigation buttons within code
  184. Recommend Reading?
  185. Transfer Values Between Combobox and Listbox
  186. Access 2000 & CurrentRecord
  187. Could use some guidance
  188. Easy question
  189. Listbox help
  190. Access SQL Statement, Please Help, Im so stuck
  191. "You Can't Assign a Value to This Object"
  192. Text box woe
  193. CreateEventProc - How to hide VBE ?
  194. Which applications are running in windows?
  195. Display a message box for a set amount of time
  196. start secure database with a user selected username
  197. Automatically save a PivotTable as a webpage
  198. "ODBC Connection failed" in DoCMd.TransferDatabase "ODBC Database"
  199. removing subform filters
  200. Update Function
  201. Parse to remove end characters
  202. DAO.Recordset problems with query
  203. Criteria Help
  204. VBA or SQL query?
  205. Peculiar Date/Time requirement
  206. easy one i think
  207. Running VBA code stored in a table.
  208. Command and pass value to Acces from Excel
  209. DateDiff() excluding start and end date
  210. Closing A Form
  211. Autonumber Increment
  212. updating a table thru VBA
  213. Folders & Files - List / Open / Attributes / Copy / Delete / New
  214. Need help with recordset code!
  215. how do i reset dcount?
  216. Problem with fixed length of a "patchwork" string
  217. VBA and SQL
  218. Record Locking
  219. Merging Counts
  220. Sequential Number
  221. Text Box Controls in an Array - setting properties problem
  222. Dates issue
  223. A Subroutine on record fields?
  224. Current directory
  225. HOw to solve this??
  226. Data type mismatch error
  227. Calculating months
  228. Save record after updating
  229. Referring problem
  230. Variable Equal to SQL statement
  231. Search Word Files From Access?
  232. The database has been placed in a state by user 'Admin' on ...
  233. Conversion between Access 2.0 and 2000
  234. Add record if it doesn't already exist
  235. Msgbox to include textbox value
  236. Empty Query Test? & AutoNumber Test?
  237. Importing OLE objects from excel
  238. Email Problem
  239. Referential Integrity - Catching the error
  240. Field names with spaces
  241. iff statement in access query is making my data shrink
  242. Numbering lines in a subform
  243. export source code to .txt file?
  244. problem with code
  245. Importing Files W/system Date?
  246. one more small prob
  247. Delete a filtered Record
  248. Printout -prints report and form - I just want report
  249. manipulating pivot table from code
  250. Automatic email reminder