View Full Version : Modules & VBA



  1. How to search an SQL Table
  2. FileDialog object
  3. Peter Answers website
  4. VBA Table Lookup
  5. Lookup value from other table ONLY IF there's a match
  6. If... empty fields give MsgBox?
  7. Inserting UNBOUND textbox into a Table
  8. Emailing within Access - 'From' Field?
  9. Clearing a Query using VBA
  10. "If" condition on button action
  11. Else-Userinput
  12. Display Title on Datasheet View's Title Bar
  13. increment variable with loop?
  14. Color as field
  15. Emailing A HTML Report Problem
  16. Change Qry/Tbl Name Tool
  17. Whats wrong with me code!!!
  18. Command-Line Switches in URL
  19. whats wrong with this?
  20. 7952 You made an illegal function call.
  21. Form Open Delay Problem
  22. Run command based on Option Button
  23. Data Access Page Problem
  24. Conversion HELP!!!
  25. How to format a field on a form as date ?
  26. Public Variable Reset
  27. Beginner -How to create a table with VBA?
  28. Help needed to modify my OnOpen Filter
  29. The Only Thing I Like About VBA
  30. prnadmin issue
  31. What is wrong with my Code?!
  32. Linking Excel file to a table, instead of importing it
  33. Driving me crazy: is null problem
  34. retrieve textbox Handle
  35. overiding vba code
  36. Filenames on Sendobject
  37. Copying excel worksheet using Access VBA
  38. Export to excel - Simple?
  39. Regular Expression reference?
  40. loop through recordset
  41. Delete Outlook Calender Entries
  42. Urgent Help!!
  43. Referencing a value in a table
  44. made ADP file, how to run sproc on linked tables
  45. Environ() Object
  46. Parse a string
  47. Listbox question - copy values from one lstbox to another
  48. If statement
  49. umbrella name for a group
  50. Customizing Autonumber
  51. Editing data in SQL Server
  52. Check if Query has entry's
  53. Recordset Not Updating
  54. Question: How to copy a date
  55. Question: programming the subform
  56. if.. table is empty then...
  57. error 3055
  58. Combo Box and add new
  59. Front-End Back-End Password
  60. Autonumber automaticcaly?
  61. Calculate length of string
  62. HTML email creation from scratch
  63. Making MDE error
  64. Question: Editing Excel file from Access
  65. Masking password through code
  66. XMLHTTP30 Problem - Caching?
  67. Form Load Where
  68. Vba code using a query
  69. Trigger Update Query
  70. VBA SQL Troubles
  71. Using Expressions in the QBE grid
  72. Define how Access opens using VBA
  73. automate creating graphs in excel from access
  74. Date Range Filter
  75. Incrementing ID
  76. Application Closes when accessing VB
  77. msgbox to show missing parameters
  78. ORDER BY not working
  79. Split A Value and then perfom Test
  80. Append Records - Please Help
  81. Dim ... As Parameter
  82. Copying forms complete with code? Access 2k
  83. Select unique record
  84. "Refreshing"??
  85. Duplicate client records
  86. Color in a field
  87. get text from command line?
  88. Disable control when another control has input
  89. VBA RunTime error 13 data mismatch error
  90. Help creating various flatfiles
  91. array problem
  92. Retreive the server name and share
  93. Time adding/sustracting
  94. cant save into a specific pc from citrix
  95. Code not running at Medium security setting
  96. Which recordsets open
  97. Simple Question...code formatting
  98. Custom Menus Not loading
  99. VBA to Open A Record In A Listbox
  100. SQL in VBA
  101. Saving an Excel file using SaveAs with no confirm
  102. Automate SaveWeb PageAs *.mht
  103. Virtual Queries
  104. How do I Seperate the Time() function into hh:mm:ss
  105. End of file??
  106. Rotate Text boxes
  107. Specify a Printer
  108. Word Email feature with Mail Merge
  109. Brain Teaser Spectacular!
  110. insert sql is inserting multiples of the same row?
  111. Module to modify text box on a report.
  112. Swap
  113. Time addition with numbers
  114. Add Formating Info to words/numbers in a field
  115. Error 13: Types don't match ?
  116. Import data from Excel. Can this be done?
  117. Any ideas why this doesnt work?
  118. Count of columns
  119. Picture Db
  120. Pull data from Access with SQL---Urgent
  121. Instantiate Objects on FormLoad
  122. Automation - Access to Outlook
  123. Using TransferSpreadsheet With Parameter Query
  124. TransferSpreadsheet - import xls using second row as field names
  125. INSERT into + null
  126. Hyperlinks.add
  127. Print Report Error
  128. Character Limitations and Do.CMD RunSQL "Insert ... "
  129. Run-Time error 3027 on Xp but not NT
  130. Unbound form fields won't initialize
  131. Need help with form coding - Validation
  132. Refresh with several criteria
  133. Outlook Object Libraries
  134. Checking Network Drive status
  135. Enumerate (List) All Controls, All Forms
  136. Save Picture In Table Through Vba
  137. Command returning NULL for some columns
  138. Sending proxy Groupwise 7 emails problem
  139. Dynamic VBA Command Creation
  140. Password Criteria Validation
  141. email module - wrong number of arguements
  142. Multiple conditions with stLinkCriteria
  143. Store Picture In Access
  144. Backup In VBA
  145. report sent with SendObject has query name rather than report name
  146. VBA Error trapping question
  147. Macros Won't Run
  148. Add Field
  149. long text field
  150. Trim or Mid Function
  151. dont know how to open a db from citrix
  152. Populate multiple controls from recordset
  153. library not found
  154. export from file
  155. Replace all null-values in a table to zero-values at once?
  156. How to insert a table into the form (Like with MS Word)
  157. Update form from subform
  158. Copy records with empty value
  159. WhosIP from within Access, is it possible?
  160. How do i save files to specific folder
  161. Click form buttons remotely
  162. Wait for Sync!
  163. Grouping For Output to Email
  164. Round() - Can I round DOWN?
  165. Looking for OCX/OLE plug in
  166. Defining the types of fields that are created by a make-table query.
  167. Store Picture Name And Extension
  168. Change Control's Caption (Perminately)
  169. Syntax for FindFirst criteria
  170. How to populate a new column and set as key?
  171. finding how many values of a user in a table that the user is not shows in the table
  172. Sub form option group not upadting
  173. Application.Printer is Missing
  174. Save as PDF in Access 2007
  175. Import Excel file using Dialog Box
  176. Exporting CSV Data
  177. Send and Receive Email in Ms-Access
  178. Sending HTML Emails
  179. How do I make " appear in a string?
  180. Object Frame
  181. Importing CSV data
  182. adding new field to a table
  183. Help ... I've done a very stupid thing!
  184. List all append queries in a database
  185. Insert Into + DLookUp + IF criteria
  186. Output file to location specified in a textbox
  187. Link Between Navigation Button and List Box
  188. Filter Data Within List Box
  189. Importing files
  190. Getting data from other databases
  191. Disabling text boxes until a combo box selection is made
  192. Access the values of a value list listbox
  193. AreThereRecords
  194. Hi There StupidStudent Again here
  195. Picture Size
  196. array help
  197. Dynamic textfields and a combobox
  198. Declaring and Using Variables with combo boxes
  199. Access Input Forms - field validations & password over ride
  200. Unique ID starts with 111
  201. Open Picture with Windows Picture and Fax Viewer
  202. Refreshing a text box
  203. Define Security Access Level
  204. Join tw Fields
  205. Sorting
  206. Reset DMax count for each new record or SSN
  207. Active X controls Date/Time Picker
  208. Using Hyperlink.Follow
  209. record sequence changes
  210. Add n number of months to a date
  211. Annoying canceled previous action : error 2001
  212. Records
  213. Function in Nested Query
  214. Open Access db on insert flash drive or CD
  215. Permission denied on Kill
  216. Problem with piece of code (updating field)
  217. Checking Time Field
  218. How to print all the Form (Like a print screen way)?
  219. pseudocode for my coursework
  220. Validation of a caluculated field.
  221. Keep getting Error 91 For Loop not initialized error
  222. Passing Object to Word
  223. how to
  224. "if not null" not working?
  225. Counting Records From Underlying Query With Unbounded Fields
  226. Ado
  227. Navigation Problem through List Box
  228. Compact and Repair through VBA
  229. Advanced Filter And Search
  230. Sorting Using OrderBy
  231. Mail Merge Module
  232. Passing inputbox value
  233. MDB to MDE
  234. How to increment the autonumber (Record Number) after that some fields were filled?
  235. Client/Server Architecture
  236. Take hyperlinked images and resave in different folder
  237. Formatting exported Excel sheet
  238. Checking for duplicate before inserting
  239. Exporting results of a filtered query to excel
  240. When going to next record with Images - i get an error
  241. Linking Back end to Front end once Database is split
  242. Help importing excel spreadsheets and deleting them.
  243. After Update Event
  244. Need Module Help
  245. Hyperlink problem
  246. Mulitple IF Statements within an IF statement
  247. How to connect to Access Database using VBA programming
  248. Complex DLookup (well it is for me!)
  249. Opinion of VB.Net with SQL Server
  250. Thread in vba