View Full Version : Modules & VBA



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