View Full Version : Modules & VBA



  1. DoCmd.OpenReport Where Syntax error
  2. How to Call Attention to Form from Other Programs?
  3. Finding the last record
  4. Store primary key but show another field
  5. Converting the Date to a String
  6. get current record in a subform
  7. Type Mismatch
  8. How to move scroll bar position to bottom or top after text box update
  9. Can you email an Access Report?
  10. How to have Currency Format in an email
  11. Excel code error
  12. strange behavior
  13. Problem with accessing ie DOM from vba
  14. Code Compatibility
  15. docmd.transferspreadsheet
  16. mystery issue with users groups
  17. Copying recordsets (kinda)...
  18. How to run macro from another database?
  19. Transfer results from queries to auto-email
  20. VBa To Find Smallest Id Value
  21. Form Open Multiple Arguments
  22. Textbox calendar - date picker - event to close after date made
  23. How to find unique (non repetitive) values in list?
  24. How to Use Lebans .pdf code access 2000
  25. listbox.requery doesn't work
  26. Altering Tables in VBA
  27. Problem with Findfirst and bookmarks - please help
  28. Referencing a control from a module
  29. Checkbox locks subform but becomes unlocked when form reopened?
  30. Add set value to field using a command button
  31. Dates .... grrrrrrrrrrrrrrr
  32. Defining Global Variables
  33. Importing multiple csv files and updating a blank column with the filename?
  34. Question
  35. another stooopid question from a numpty!
  36. How to hide column in datasheet (split form) using VBA?
  37. duplicate save query
  38. HELP! - File Browser Form Control (comdlg32 / 64 bit)
  39. Help to Refine Code for better performance
  40. Formatting recordset data into an email
  41. Why is this not working?
  42. Need help with attachment Control
  43. Exporting Query Results into multiple excel files
  44. Log in form and user level
  45. Accessing Lotus Notes Using Access 2002 & VBA
  46. access vba function to find a text in excel to return the column number
  47. remove a single item from a combobox
  48. Date Rules - text box one date leads to another
  49. who can help me
  50. IF statement help
  51. Check if list item should be selected
  52. Message box pop up upon search results
  53. Intereting challenge: Running 3rd party apps in a subform
  54. Format Listbox colum
  55. Updating records and getting Runtime Error 3075
  56. If CurrentUser="" OR "" Then..
  57. Validation rule first three letters + 8 number
  58. Random access files
  59. Object Required Question.
  60. Again 2448 error problem!
  61. How to handle unknown number of variables?
  62. ADO Execute SQL string length
  63. Updating a record using an expression for the field
  64. CommandBars/SetMenuItem help please
  65. Code test?
  66. Select records & insert to a table
  67. Manipulate Access Window
  68. form to show vba progress
  69. Dlookup in Access 2007 Problem
  70. Using Between in VBA
  71. directory of network drive
  72. Query Webpage Using VBA
  73. A Loop to Separate Different Record Types in a Table
  74. Saving files from authenticated site in IE
  75. [access 2002] - report generation
  76. Importing Issue - Read Only option?
  77. Copying a linked table
  78. Error 30026 when logged into windows
  79. recordset.FindFirst Problems
  80. Search bar in form
  81. SQL works in query but not VBA
  82. Referring to a button on a subform from a seperate form
  83. Forwarding error message
  84. Help with Outputto and parameters
  85. Using 2 recordsets
  86. using query def to export to excel, is it possible ?
  87. Code to find Database install directory
  88. Remove Quick Access Toolbar
  89. Formatting Tables with VBA
  90. Send OLE object as attachment
  91. lock table
  92. Incremental values based on Column value and row
  93. Help Comparing Data Through VBA
  94. Dlookup & Date: Validation Check
  95. INSERT INTO syntax error
  96. recordset SQL syntax error
  97. fOSUsername
  98. export to xml
  99. What's wrong with this very simple code
  100. Check Boxes Help
  101. Control a Scanner
  102. check for null in option group on continuous subform
  103. Placeing Start of month data and End of month date in Report
  104. Improve Code . .
  105. Need help with ListBox
  106. Run functions dynamically
  107. Import data from Excel to Access
  108. Create a new database
  109. Run an update query on a recordset
  110. Append Query Extremely Slow
  111. transfer text Export missing first record
  112. Sending Multiple Emails
  113. [solved] Disconnected Listbox doubleclick delete findfirst and leaves history
  114. backup button vba code
  115. Need help with VBA - Urgent!!!!
  116. QueryDefs parameters "invalad property"
  117. dlookup or is there a better way?
  118. ADODB RecordCount
  119. Can you modify module vb?
  120. Newbee Question
  121. ReminderTime problem
  122. How to Delete Windows Files from Access 2000
  123. Listbox to open different forms
  124. Issue with attachment field in VBA
  125. Access 2007 Password login
  126. Saving unbound value to table (kinda...)
  127. Picture Control to change with Browse button
  128. Bookmarks.exists always return false
  129. Excel Automation - Blank worksheet/file
  130. SQL Open Dynaset with [Forms]! reference vs variable
  131. Variable not defined on Cancel = True
  132. GoTo Next Record on a Sub-Form
  133. How to close a spreadshee without Excel message
  134. export to xml advanced
  135. SelStart problem
  136. Transactions and linked tables A2007?
  137. Yes/No Message Box
  138. Update loop not working
  139. How to make combo box populate subform?
  140. How to Transfer data from one subform to another?
  141. Form Captions
  142. Centering forms
  143. Auto Correcting Words
  144. newbie needs some help
  145. Access DB hosted on website ... is it possible to conect
  146. Error: DoCmd.TransferSpreadsheet
  147. Add Reference using VB codes?
  148. Problem with sql string, wrongly use of "'","!"...
  149. Progress bar: Error Help
  150. Help on calling a sub routine from a module
  151. Importing XLS files
  152. How to set up log inform with different rights
  153. Sending email with CDOSYS
  154. Date Comparison - VBA nightmare!
  155. Dsum 4th Critieria (can be null)
  156. Hassle with Run time 2424
  157. Programmatically create a ACCDE
  158. Unbound Combobox - change Row Source based on variable
  159. Address InStr Search and Replace
  160. odbc connection in windows 7
  161. import xml files in succession using Application.FileDialog
  162. Is there a way to add data as a new record in a subform?
  163. Getting started, accessing records etc
  164. VBA Code/Debugger Window views
  165. Need to exit Access session before Macro works again properly?
  166. How to top duplicate records?
  167. Creating Labels
  168. Zipping a file from VBA
  169. Converting multiple columns into one row
  170. syntax for number data type???
  171. VBA Access fill TextBox in Internet Explorer
  172. How to get rid of code in class module?
  173. How to compare dates and generate error?
  174. showing checkbox in an email
  175. Invalid use of Null Error
  176. Find the position of the Nth occurence in a string
  177. Bookmarks and Null values
  178. How to have Quotation Marks display in an email
  179. Very difficult and weird problem!vba RUN TIME ERROR: 80040e10 in complex query!
  180. Spell check in subform
  181. Scan for all open applications ...
  182. Problem with Optional Arguments
  183. Dynamically Change TxtBox Colour
  184. 'Copy' isn't available now...?
  185. Run Time Error 13: Type Mismatch
  186. Exchange record info between two Access dbs
  187. RunSQL Update
  188. Bloody Irish - Kidding
  189. Lebans MouseHook
  190. problems with saving text that includes quotation marks
  191. How to have Multi Choice Message Box
  192. SQL Max result passed to a variable?
  193. prepend character to text file
  194. Transfer to FTP Server
  195. automatic attachment file
  196. Delete entire row in a table from Listbox
  197. Wildcard in DLookup possible?
  198. Pivottable disappeares by refreshing in Access 2007
  199. Change format of module
  200. Problem with INSERT INTO
  201. Changing colors throughout an application
  202. Access 2007 Crashes with ADODB Recordset
  203. Set Mypath to the folder that the Database is in
  204. Totalling info from a table
  205. Listbox - Dynamically select record
  206. split a string by comma and break it up into rows
  207. Dreaded 3067 No Query error.
  208. Nothing happens when running DoCmd.RunCommand acCmdDeleteRecord
  209. DoCmd.printout
  210. Trying to read an Appointment from Outlook
  211. recordset.findfirst problem
  212. Catching Tab Control Page Changes with VBA
  213. Recurring Event/Invoice
  214. DLookup Problem
  215. .Execute query with form criteria
  216. PDF Creator VBA
  217. Flow chart from VBA IIF function
  218. trying to create a report base on the values from the current form and subforms
  219. Help needed with UPDATE and SELECT code
  220. trouble getting value
  221. Openrecordset Query NOT Working!
  222. Data From a Table
  223. Outlook Profile
  224. LDAP connections and querying help
  225. Using Month() in If Then Statement
  226. rst.findfirst problem
  227. Listbox of all open forms
  228. install Mapi ActiveX Control
  229. Accde related problem
  230. Duplicate Record and related records
  231. Create table - vba access
  232. Read saved email in vba
  233. need some help with LostFocus
  234. Correct VBA syntax for SQL statement
  235. List Box File Population
  236. How to set an object type dynamically?
  237. Reusing code
  238. Access to Excel template
  239. Percentage question
  240. Convert Measurement in Access VBA and update the same Access table
  241. Running a report by selecting different criteria from a form
  242. If statement syntax Not working
  243. On Current Code Help . .
  244. multiple recordsets - error 3704
  245. DateDiff
  246. Docmd.findrecord If record is not found then ...
  247. What is the perfect method to deal with Dat files?
  248. want to create a code to add one to a exsisting number
  249. Force a compact repair.
  250. Not sure how to retreive the information and display it?