View Full Version : Modules & VBA



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