View Full Version : Modules & VBA



  1. ADO connection to Exchange
  2. Paste Image stored in Access Table into Excel?
  3. joining code
  4. Moving the Tab Control
  5. link DLL
  6. Problem with FINDFIRST
  7. Multiple Criteria Expressions
  8. Change System Date
  9. newb question but bear with me
  10. Problem :alter primary key of table using vb code
  11. Extremely strange '2001' error
  12. DTPicker Default Value
  13. Cancel BeforeUpdate Event
  14. UnboundTextBox = ListBox ??
  15. A Simple VB problem - I think
  16. Simple 'Insert Into'
  17. cmd.openform condition
  18. Common Dialog - get the File name?
  19. Inventory problem!
  20. Set the value of a public variable whose name is stored in a string
  21. Opening Form in second access database
  22. Set the Email font face and add outlook signature
  23. Help with If Functions
  24. Email response
  25. Returning public variable as a formname?
  26. Appending Bits to a String
  27. Problems with Dmax + 1
  28. Import Empty Field
  29. Composite where criteria not working
  30. Object Orientated Programming Class Module
  31. alternative to GoToRecord not working properly.
  32. Replacing a record with one from another table
  33. Displaying a recordset on a continuous form
  34. Display Results of a parameterized SQL-Server-StoreProc in Access
  35. Call another Sub Routine
  36. ERROR:Unable to impersonate a DCOM client???
  37. Switchboard error run time error 430
  38. Something Interesting: If or Else?
  39. seems simple--If/ElseIf/Else
  40. Question - should it go in "Code Repository" section?
  41. Using chr(27) in VB
  42. Searching fields from a form
  43. SQL statement not executing
  44. VBA code to set data in combo boxes using raion buttons
  45. setting a default date in a field after clicking a command button
  46. Help with sql
  47. Computer being selective about code.
  48. Stupid Date Question
  49. Compile Error: Can't find project or library -- Help?
  50. How to set a RecordSet to be updateable
  51. Dao, Ado
  52. IP Address, Computer names and such.
  53. Is there a way to filter moving to the next record?
  54. KeyPressed Event
  55. Is Outlook already running?
  56. Escape Key Problem
  57. Is this loop possible in vba?
  58. Importing data from csv in to Complex table
  59. check boxes
  60. Auto reference number code query
  61. Format field numbers after make table
  62. appending data from form to table
  63. Outlook email for data entry???
  64. Message Box
  65. Function
  66. problems with combo boxes
  67. more combo box problems
  68. Collecting data
  69. Automatic e-mail notification
  70. Specify 'From' in VBA code for outlook mail message
  71. Disable notice when using action query
  72. Deleting a Row from Excel
  73. How to I check to see if a field exists in a table using VB?
  74. Updating Field
  75. Open Form Button Click event
  76. Button Problem
  77. End If without block If problem
  78. Tab Control
  79. Tick Boxes
  80. Type Mismatch hmm??
  81. Inserting text into a memo field
  82. Retrieve name of selected object in database window
  83. RecordSet.Source Property
  84. combo box problems
  85. Activating, Deactivating code based on reg code simulation
  86. Open Access DB from another Access DB
  87. delete certain variables from string
  88. Error message..
  89. Change Data type and name
  90. How do I set a default value for a combo box when closing a form?
  91. Common File Dialog Oddity
  92. No Split Function
  93. Download file from internet
  94. error # 2501 while trying to save a form
  95. Catching two errors..
  96. Serious Trouble. Please help...
  97. VB code to transfer from an open excel book?
  98. Run Time error 3052
  99. parameter query opening as a recordset
  100. "Forgot Password" via Lotus Notes
  101. Make form go to record using ADO
  102. Fetch properties from backend
  103. Query output to MSExcel
  104. format Month date
  105. Nested Loop
  106. Macro to VBA conversion
  107. If Then Else struggle
  108. difference between commands
  109. Properties
  110. Lotus Notes Error
  111. Renaming current database file
  112. TransferText Auto ID
  113. cc field in email from Access to Lotus Notes - not sending second recipient
  114. Removing Queries with Code
  115. Issues with SQL
  116. Automatically Send an one Email Everyday
  117. How to tell RDBMS opened by ODBC connection?
  118. Compile Error: User-defined type not defined
  119. Identical Code for multiple Forms and multiple Reports
  120. Extract currentPosition with Media Player
  121. finding vlaue in table using serach button
  122. Can't resolve simple code issue
  123. Variable control names
  124. Really simple - Date syntax for Date entered in Word
  125. insert into sql not working...
  126. Most effective way of coding
  127. Conditional Formatting & Exporting Access 97 query result to Excel 2000
  128. 2000 to 97, Please Help
  129. Retrieving all records for Quarter/Half/Year
  130. How to display filtered records list of the form in the list box?
  131. Can I notify bd admin when data is changed?
  132. Find syntax for ADO
  133. Record Set
  134. gather e-mail addresses...
  135. Leading Zero in text field
  136. VB syntax for network printing
  137. SourceDoc Excel problem
  138. Assigning values to table fields in VB
  139. Syntax Error...must fix this
  140. Simple code question
  141. Counting an ADO recordset
  142. adding date from a form to a table ( or two )
  143. Export Tables
  144. Want to have a constant array
  145. Execute another procedure
  146. Need help duplicating data
  147. Need help with this sql statement
  148. How to connect to current table within a loop while importing multiple spreadsheets
  149. How to choose a specific record
  150. Help with recordsets
  151. Condition Syntax
  152. Accessing dBase with VBA
  153. Message box structure difficulty
  154. Access2002 with Dao 3.51
  155. Cascading combo on subsidiary field
  156. Form is invisible when losing focus
  157. DCount problem
  158. Count rows, convert text phrase to array, construct SQL query using array
  159. VB Line too long
  160. Me.Refresh with Keyup event Prevents entering more then one character
  161. VBA with Lotus Note COM objects...
  162. Export to CSV File with table headers
  163. Who is log in
  164. Displaying Error Codes in the immediate window
  165. Difference between Public 'Sub' and Function'
  166. Filter a filter?
  167. ChDrive problem
  168. Find E-mail Address
  169. Error 3021: No current record
  170. Missing References (cant find project or library)
  171. ODBC--call failed: Error 3146
  172. Data type causing Complex Query Error (3701)
  173. Syntax for referring to a variable Field name
  174. How do you remove leading zeroes from a data field
  175. Simple SQL and Access problem
  176. Running Report filters Combo Boxes
  177. Relative File Path for CDROM Distribution
  178. Get value from form textbox into report label
  179. Using recordsource code more then once on a open form
  180. Problem moving code from module to form
  181. How to print and save contents of a text box
  182. Hyperlink to secured database
  183. If record exists...
  184. IIf Statement in VBA
  185. Using doCmd.openform and a Global variable in place of form name
  186. search tables
  187. Null entries on custom dialog
  188. Need to hide an image (Object doesn't support this property or method)
  189. Suntax for find on a string
  190. Securing a .RTF File for E-mailing
  191. Priority Ranking
  192. String functions not working
  193. Code Proofreading Help
  194. What is the split() equivalent in Access '97?
  195. Help with a command button
  196. Sharing classes via referenced .mdb
  197. Running SQL query from Access '97 module
  198. Loop through a table using Access '97 module
  199. Switchboard error (for only one user of 10)
  200. Common Dialog Control
  201. Multiply values
  202. Next Record Event
  203. SQL Update and date format
  204. Create Table
  205. VBProperCase with double barreled surnames??
  206. VBA sql updates too many records in query
  207. exporting report to excel
  208. Field Requires Entry
  209. (HELP) Conditional formatting
  210. Speeding up the loop
  211. Run Time error - 3001
  212. Date from dd/mm/yyyy to dd-mmm-yyy
  213. validating input box values
  214. ok, here's a simple one
  215. How to set up a word doc on templet
  216. "All" included in combobox.
  217. major virtual memory problems
  218. Requery and/or Update problem with a form and recordset
  219. IsNull vs. Len()
  220. Problem with EOF when there are returns or spaces at the end of the file
  221. unbound form SQL query question
  222. Setting default ODBC connection
  223. running subs on other forms
  224. Avoiding start up form!
  225. Header on text file?
  226. Write Conflict...
  227. Insert Into
  228. Dynamic subform
  229. addnew not adding in order
  230. Allow user control of transfertext
  231. vba to covert text field to numeric
  232. Union SQL Statement as ADO Recordset Source
  233. Word Mail Merge from access vba dates
  234. Change query criteria with visual basic
  235. DCount and unique values
  236. Current Module
  237. "Object variable or With block variable not set" (Run-time erro '91')
  238. My own date format - how to?
  239. Calling A Module Via Button In Form
  240. Bookmark for recordsets object not co-ordinating with bookmark of the form
  241. Error Handling Tips
  242. Drag and Drop from Windows Explorer to copy files from 1 dir to 2nd
  243. Selecting 1st rows of cascading listboxes
  244. Switching off Warnings
  245. Serial Port (COM-port) Communication using VBA?
  246. Stupid programmer tricks
  247. Error handling an object for multiple errors
  248. Change Data Format
  249. Help with Search and/or FindNext
  250. SQL Code Problem