PDA

View Full Version : Modules & VBA

  1. Going loopy
  2. multiple recordsets
  3. Cancel Event in Public Function?
  4. Verify character is in string
  5. DoCmd.OutputTo destroys DAO.Recordset
  6. insert into with vba
  7. Display User name
  8. Training
  9. Delete all the characters on the left of # in a recordset
  10. Printing Control via VBA
  11. Help with converting Access 97 to 2003
  12. Transpose Table - modify MS KB method
  13. SendObject
  14. If statement value
  15. Query result into one field
  16. Please Help With This Code
  17. code for QBF
  18. Password Protection
  19. Error - Object dowsn't Contain the Automation Object "ExperationDialog."
  20. select query with VBA & exporting
  21. Chart Field Totals
  22. Important Dynamic Range from Excel
  23. need help with complex data validation
  24. Custom Error Messages
  25. scrolling thru a text box
  26. A little programming theory crafting
  27. Excel crashes when same report is run again
  28. Data type mismatch
  29. Recordset not looping
  30. Aaarrrggghhh!!!
  31. Where to find VBA programming basics ?
  32. Copying data between lists with value lists as recordsource
  33. Stepping into the Code
  34. Problem with Loop
  35. TableDef
  36. Help with Click event and If statement
  37. Windows Current User function
  38. Import SpreadSheet Specification
  39. Subform control is zero when saving
  40. Strange Problem II
  41. Error 3125
  42. Cursor placement
  43. HELP! -Runtime error issue -Trying to automate Excel import to Access
  44. Ontime Method?
  45. Get Current Control on Mouse over
  46. How to run a query from a comboBox event?
  47. Access 2003 Evnet Not Workig With Access 2007
  48. Detect whether RecordSource data comes from a query
  49. Checking for File Presence
  50. Split Address Data
  51. Me.Undo problem - no current record
  52. Output to Excel blues
  53. Finding a field in VBA
  54. Insertion, deletion, updation through bounded form
  55. Extracting Reports To Excel
  56. VBA code for Scroll Up
  57. Pass-Trough query by VBA procedure
  58. importing html-page
  59. Ongoing Problems With 'DoCmd.RunCommand acCmdSaveRecord'
  60. Spell Check Problem in sub-Form
  61. Import all excel files within a given directory?
  62. desktop path (again, sigh...)
  63. Can't assign a field's Description property in VBA
  64. Import Data in Access from txt file
  65. Obtaining The Windows User And Password
  66. Quotation being added to a variable
  67. creating passwords
  68. Save a variable between runtimes
  69. CommandBars and controls
  70. Calling A DOS program from VBA
  71. Setting and Keeping Focus Issue (on the edge here!)
  72. Displaying RTF Document after writing Blob File
  73. Archive old records
  74. Put string into Form field
  75. Alter permissions to an external mdb
  76. Empty a folder
  77. Select Case Sub within module not working
  78. connect using ODBC?
  79. app can't connect on some PCs but can on others
  80. Option button to disable tabs on page
  81. Search and update specific records
  82. Display Image
  83. Save data on form to table
  84. onclick don't run macro
  85. debugging with e-maill through access
  86. Too many rows to export to Excel
  87. Error with.LastModified
  88. Changing the allowEdit Property on forms
  89. AutoExec - check Environ("USERNAME")
  90. AutoExec - check Environ("USERNAME")
  91. Reporting on data in a changing Linked Table
  92. Waiting popup instead of hourglass
  93. Access Crash when accessing VBA Window
  94. Confirmation message when empty fields are submitted?
  95. Calculating Last day of Month
  96. Renaming report when emailing using SendObject code
  97. Update Excel Pivotcharts from Access?
  98. DAO looking at 2 tables in 2 mdb's and then running sql
  99. Resize ME
  100. Application.Quit
  101. Access 2007 - Chart Updating Issue
  102. Include .DLL with FrontEnd
  103. Help with some syntax
  104. VBA or SQL?
  105. Where to insert the Where clause
  106. cascading combo box code
  107. Warning Banner Check box makes accept button visible
  108. Customer dispay on com port
  109. Need help with listboxes
  110. Command Help
  111. VBA code doesn't seem to work for cascading combo box
  112. Problem with subform
  113. DOB to AGE calculation
  114. magic function (convert bmp to long binary data)
  115. BE DB Connection problem
  116. Go to next record problem at last record
  117. Need to create variable for use in query
  118. ComboBox Erratic for Displaying Filtered Data
  119. can't get data into recordset
  120. Search through mods and cbf
  121. reg file for dsn
  122. Cvs?
  123. data type mismatch
  124. problem with subform requery
  125. Post Data into ASP page
  126. JDBC DoCmd.CopyObject
  127. Automate new reminder in MS Outlook ??
  128. If file exists update boolean field
  129. code not working 2007
  130. Open a document from Access
  131. ADO Connection Open failure
  132. show users in the database 97
  133. pass through query with parameter
  134. Selecting a background on a report
  135. Open a word file from a form
  136. Simple Date Field Update
  137. Convert entry to non-standard date
  138. Emailing Reports Based off of Criteria
  139. Auto create record based on date and criteria in another record
  140. How to create a query programmatically using vba?
  141. How to get the generated id of previous insert query
  142. Compile error, when using debug window
  143. Calculate difference between dates in years and months
  144. Add Spaces to String
  145. Create link or reference with ADO dll during startup
  146. Sending Emails with different criteria in Access
  147. Problem Saving Data
  148. Use a comma in a RowSource
  149. DMAX and Linked tables
  150. Updating Subform
  151. Out Of memory
  152. Date Time Difference, Excluding Holidays & Weekend
  153. Word Won't Close After Merge
  154. Problem Update-FE-Utility
  155. Choosing different records and filling in missing information
  156. FormFields Populate in Outlook 2003
  157. change ODBC DSN to DSN-less
  158. Use code to determine value written to record from combo
  159. Use VBA or Macro to Change Data Type
  160. Disable Startup Menu
  161. Help with Variable
  162. summing fields
  163. MouseMove Issue
  164. Autofilling a field, based on other fields
  165. Making static files avaliable in a database based on auto.gen. paths
  166. record loops
  167. Applying a Query to a Form AND a Report with one click
  168. help with vba code..
  169. Close Button
  170. Dynamic SQL Query using Custom Function
  171. Trouble with HTML Email
  172. Set Properties in combo box and get the key field value in VBA
  173. Addditions to a Module
  174. Problem summing a recordset
  175. syntax check?
  176. Copying from one spreadsheet to another
  177. SQL Problems....
  178. Silly SQL End of statement prob
  179. Supressing error code 2619
  180. Show asterisk in password field
  181. GO TO TODAY button
  182. Best way to chek for a value in a list
  183. Password prompt for ODBC
  184. Help Needed
  185. confused!
  186. what autonumber did i just generate?
  187. Compacting Access for Office 2007 users
  188. QueryDef
  189. Headache with # in field name
  190. Debug Window Opens
  191. Checking duplicates in a table with composite key
  192. Access 2007 command not available in 2003
  193. Searching Images Problem
  194. Wildcard problems inside If statement.
  195. How To Use
  196. Another "word doc from a button" thread
  197. Object variable or with block variable not set
  198. FileCopy problem
  199. Verify if user has DSN connection on their system ?
  200. Filling and using an array
  201. string to varian conversion
  202. Verify numbers are in sequence
  203. Convert Text File
  204. VBA Module Update Query, Null Values etc..
  205. Searching for files on a drive
  206. Allen Browne DirListBox Module
  207. Creating invoice
  208. Display images on a continuous form
  209. VBA DIR() Locks Directory
  210. Export FieldNames From Query
  211. Date Time difference in Days, Hrs, Mins
  212. a few syntax problems in my equations
  213. Automate importing/linking data from ODBC to Access
  214. Number vs Text in sql query
  215. Need Help: Open File List and then Copy Selected File
  216. Possibility to rollback data on subform
  217. Docmd.sendoject("query A") where [query A].[Invoice number] = SearchInvNr
  218. Order Items in Row Source
  219. optional array arguments / perl style splice
  220. view form VBA without events> etc
  221. Text export results in "
  222. IF, THEN - single event condition
  223. Change selected/select an item in a list on a form
  224. Why use a class module in Access?
  225. Weighted-average Interest payment
  226. Problem with ODBC call via ADO
  227. Help Retrieving the System (computer) name
  228. Putting a password on the after click of the command button
  229. Current User in Workgroup code retrieval???
  230. Too few parameters??
  231. Check table for existing record
  232. Terrifying Error in VBA! Need Help!
  233. DDEExecute
  234. Create New Record on subform through Main Form
  235. Help with VBA code that was working but now is not
  236. 1899 Date
  237. Can Not Decrypt Data
  238. Insert statement - I give up...
  239. how to fill textboxes according to selection in cbobox1
  240. Select Count
  241. Concatenation of categories - stuck
  242. Missing a record at end of module run
  243. DateAdd, DateSerial, problem with months and days
  244. Disabling INTERRUPT when code is running
  245. need help, getting syntax error in INSERT INTO statement
  246. Optimising Excel VBA database calls
  247. New line in a Message Box
  248. Get list of field names from all queries
  249. Relink tables on Startup and catch ms access error
  250. Populate table using vba