View Full Version : Modules & VBA



  1. Cancel Key Breaks Out Of Code
  2. Can't obtain the value from a control
  3. At Wit's End with Recordset
  4. Using Dynamic SQL versus Parameter Query
  5. unable to detect zip files
  6. Adding formatting to "E-Mail"
  7. Help me format my form:)
  8. how to call modules in a form
  9. Insert a New Record at the top of a subform
  10. Help with Runtime Error '3075'
  11. Showing/ Hiding controls at runtime
  12. How do you specify to open another database in the SAME folder
  13. Update end date to next record's beg date
  14. Error 91 - With block or object variable not set.
  15. Problem with printing report
  16. Punctuation, baby
  17. Username & Password
  18. INSERT INTO and VALUES
  19. What am I doing wrong? How should the code be written?
  20. Changing forms background colour
  21. shift key
  22. Unbound Listbox (for each row problem, un- and checked items)
  23. Runtime Error 3075
  24. Deleting file in a certain location
  25. Locating the orphaned object and destroy it.
  26. Refering to a Text Box using a string
  27. password protected login
  28. Error 2001 - You cancelled the previous operation
  29. Access 2003 doesn't understand MSXML2 variable type
  30. Problem with code
  31. Macro balloons mdb past 2G
  32. Importing from Excel
  33. Date from to criteria to filter records
  34. Use Word as template to edit Memo fields?!?!
  35. In need of fast help--Access 2003
  36. null is query's 2003 access
  37. Cint function
  38. 2002 -> 2007 dao ado argh!
  39. Programmatically List All SQL Servers And Their Databases
  40. Backup And Zip Database
  41. Pass Combo Box and Option Values using Insert Query
  42. Permission to allow setting the StartUpForm
  43. Too few parameters (Error 3061) problems
  44. How to put pictures into Tables, Forms, and Reports
  45. Simple VBA help required please.
  46. Convert minutes and seconds to decimal
  47. Help with VBA Report Filtering Syntax
  48. One More Report Filtering Question
  49. Calculator
  50. Alter Linked Table
  51. DoCmd.RunSQL Efficient?
  52. Creating a collection of User-defined types.
  53. Equivalent Recordset code for 2003 vs Access 97?
  54. Using filtered data from A Form
  55. Disable "X" - Access 2007
  56. Add column to table of linked backend
  57. VBA DLOOKUP Function
  58. VBA Display Footer
  59. Sum one field with itself from multiple records?
  60. 'No value given for one or more required parameters'
  61. Function identifying calling object
  62. Batch script workgroup file problems
  63. problems converting from 2003 to 2007
  64. trouble with recordsets
  65. Current Year help
  66. Disconnect and connect table backend
  67. Searching a SubForm
  68. Access 2003 VBA If Then Help
  69. Switchboard problem
  70. Update query
  71. Control source based on List box value
  72. SQL Help!
  73. How do I add "All" to ComboBox and use as report criteria?
  74. Whats wrong with my if statement
  75. Sql
  76. Cascade Problem
  77. Export To Excel 2003 Version
  78. ListBox and SQL
  79. Search one table based on another (not joined)
  80. Open a site clicking on ListBox
  81. Treeview request
  82. SQL Satement Wont Execute
  83. Access ecuviant for Excel Date Function
  84. Dynamic Update message help
  85. VBA SQL Requery
  86. Iterate through numbered variables
  87. Google Earth- Making KML files
  88. Determining a report schedule from a combo box selection
  89. Transposing data from one table to another using DAO recordset...
  90. Form and code issues
  91. Select custom number format from table for report
  92. SQL in Access
  93. Question on Message Box Icons
  94. Using ComboBoxes to Insert Multiple Records
  95. Before Form_Load
  96. Concatenating rows together
  97. DCount my month of date
  98. Code for populating text fields based on a combobox
  99. NULL issue...
  100. Access Data to Excel using range.value
  101. move cursor to end of text in textbox after setfocus
  102. Simple question
  103. Code to Send Values to Table from VBA
  104. Appending XML data to tables - Code Help
  105. On Current Event Procedure (on form) - Access 2007
  106. VB code to create and export several queries
  107. VBA Export Sub Query To Excel
  108. Parsing text string function
  109. How does a save button handle the record?
  110. Checking that a record exists in a different table
  111. Problem with preventing duplicate entries
  112. Error handling code problem
  113. Subform filter issue
  114. HELP how do i compact and close -07
  115. Vba
  116. Need Syntax Help
  117. DLL Help. VB.net to Access
  118. How to set the Record Source for a Report using VBA?
  119. Mass Update Query, Need Vb Help
  120. I am unable to send my email out.
  121. Using Access just to organise data?
  122. Blank field problem when exporting with bookmarks
  123. Access Form fails to reload
  124. ADO filter problem with spaces
  125. Export table to a New File and Drop
  126. Search problem searching for the " Char
  127. access vba alter table
  128. Sort and Display record code
  129. convert an existing query into its sql
  130. How to replace textbox's control source with hard-coded text?
  131. Lotus Notes Error Trap
  132. Code to maximise word on opening (Access 2003/Vista
  133. Copied database does not open VBA
  134. How do I cancel a report from opening?
  135. conditional programming
  136. Better way to hold a permanent instance besides using public variables?
  137. Updating a Public Variable stored in a table
  138. VBA For Dummies!
  139. Create Records Macro / Loop
  140. Information on optimizing ADO transactions?
  141. Simple VB Question
  142. ADODB.Command problem???
  143. Help for VBA module code in MS Access 2003
  144. Run time error 3075 - syntax error (missing operator) in query expression
  145. Export to Excel - Lookup Field ID vs Value
  146. missing link/references
  147. What Method for conditions in a record
  148. Getting Attachments from Unread Emails in Outlook
  149. visual basic and check boxes
  150. VBA code to loop and modify duplicates
  151. FileDialog and New Attachments in 2007
  152. type mismatch - 13
  153. Get id of record just added
  154. How to remain original RecordSource
  155. Challenge!! Search function....
  156. Opening a fabricated query from VB
  157. Closing open files
  158. Make control wizard produce VBA code not macro
  159. Code to match employee records
  160. Shell Function
  161. Record selectes the Node
  162. Query to get the hours worked in a day Access
  163. Data type mismatch in criteria expression
  164. using recordsets with Dynamic queries
  165. Complicated VBA I don't know how to do
  166. Delimited Excel Data to Access Table
  167. Clearing a list selection and value stored against it
  168. Filter By Form by using VBA
  169. Help w/ printer settings in Word from Access using .ActiveDocument
  170. Export to excel specifying an exact cell
  171. Even more automated?
  172. Run Time Error 3075
  173. VBA update module-urgent!
  174. After update combobox question
  175. Adding a Message Box
  176. Accessing and Displaying Field Description
  177. Event Procedure Now Erroring with data type mismatch
  178. Storing the VALUE of a selected item in a list box
  179. Cntrl " VBA Code for Access Form
  180. Need some help with my code/code syntax
  181. Field number as variable
  182. Concatenate strings together
  183. Renaming table fields on the fly
  184. Print Listbox Contents
  185. Help with SQL statement
  186. Default Value with VBA on a Form
  187. Funk with the ListIndex property
  188. Help with changing info on a table
  189. Using VBA to determine which program to use
  190. password protecting a backend
  191. Code Replacement for SendKeys {Down 2}
  192. Prevent user from saving a record in if statement
  193. Recordsets not closing on 1 machine???
  194. Multiple CSV Files
  195. Error: User-Defined type not defined
  196. How to add an indent to a paragraph
  197. Error handling with function, not possible?
  198. Question in regards to function
  199. Simple Invoice System. Help Please!! :(
  200. How to declare a range object with late binding
  201. Working with userID of format givenNameLastName but not with....
  202. Reference Without Focus Problem
  203. Open Form using IF Statement Not working
  204. Change chart image
  205. Are there any other VB Editors available?
  206. Need some serious form managment help
  207. .Attachments in visual basic
  208. VBA Module with SQL help
  209. OnOpen form error
  210. Extract data from file
  211. Filtering records displayed in a listbox
  212. Error handling strategy
  213. Help with Access to Word Automation
  214. Creating a table with VB
  215. DLookup problem
  216. Code Module to open multiple .csv files then save them as .xls
  217. Question about MouseWheel
  218. Too few parameters
  219. Some Help please - Rolling back changes / cancelling
  220. DoCmd.TransferText
  221. Calling UserGroups
  222. Dao.recordset
  223. How to get the scrollbar position of a subform
  224. Adding references to Libraries
  225. Inventory Code
  226. E-Mail Report Thru ISP Mail, without Outlook
  227. Listbox based on SQL (code looks sloppy)
  228. Help please with Dates
  229. save 5 last status and show only the latest in a form
  230. Open a form from two different forms.
  231. HELP! Problem importing Excelsheet due to length of tab name
  232. ReRun function from time to time
  233. Call procedure error
  234. How to use Screen.Fonts Collection in VBA?
  235. Open From From Subform Where Condition
  236. Please help with IF statement
  237. RibbonX date control
  238. Save me from the compile errors!
  239. Multiple MultiSelect Listbox Help
  240. Error 2001: Operation Canceled
  241. How do you run a function AFTER a filter has been applied?
  242. Initialize Attachment Manager in 2007
  243. Display values when stepping through function
  244. Nodes and records
  245. enable or disable a text box after checking if its null or not
  246. Calculate Value From .csv and Return it to an .xls Using Function/Module
  247. Outlook mail to access
  248. import large CSV file(more then 80k records) to MS Access table
  249. VBA Lock Textbox
  250. Pass-through SQL error :/