View Full Version : Modules & VBA



  1. Emboldening a string...
  2. Creating a search
  3. SQL query in VB - error
  4. Dimension Help
  5. Issues with code...
  6. On Load - sub vs. function
  7. Open and Control Clip Gallery With VBA
  8. Query in recordset, impossible.
  9. Problem Between Two Dates Report
  10. RecordsetClone SYNTAX Error
  11. Public Function DoCmd Runtime Error 2486
  12. ChChart Object
  13. Using DoCmd.SendObject, but specifying arguments?
  14. compare array values
  15. run time error 5
  16. change fonts in docmd.transfertext ?
  17. Import Question
  18. Creating document with Report
  19. 'Enter key' going to the next record
  20. "Quiet" Code?
  21. Photo Size, Height, Width Problem
  22. add a whole recordset to a table
  23. Compressing and Resizing the PHOTO
  24. Multiplication doesnt work
  25. Need to have SQL INSERT INTO statement
  26. sql Update confirm message
  27. Trimming Characters
  28. Help With Tree View
  29. SQL Count thing
  30. Double bookings (Help)
  31. The command or action Show all records isn't available now error!
  32. DLookup function - search criteria x 2
  33. Error Code when field is empty...
  34. Updating Calculated field with dsum
  35. Ident_current
  36. concatenating
  37. Using VBA to detect whether Primary Key exists
  38. Set color based on field value automatically
  39. Save as Data Access Page command
  40. Compact & Repair
  41. VBA to add a closing record in a CSV file
  42. check for "T" or "B"
  43. Kick off a non-MS Application
  44. Auditing activity
  45. Checking Time within Intervals???
  46. DoCmd.SendObject query to e-mail report generates a file for each page
  47. Combo Error caused by 'Oder By'
  48. Block If without End If?????
  49. Convert Numeric to Word for Indonesian (Rupiah)
  50. Trying to recover corrupt VBA code
  51. Report Preview
  52. Change SQL within query using VBA
  53. Export Access Modules to Excel
  54. Copying jpeg files
  55. How to do I/O write# and input# with ; as delimiter?
  56. Dynamic datasources for forms and reports
  57. Changing the Caption of a field
  58. Transferdatabase and error 3011
  59. Simple Code Help
  60. How To Stop Acces From Update The Record When The Subform Query Is On Focus?
  61. Displaying a jpg file in a field
  62. Most recent list
  63. Special Characters in Strings
  64. AutoFeUpdater RunTime Problems
  65. comparing UserID and JobDate with previous record and populate blank collumns
  66. After Update Actions
  67. Help with a piece of code
  68. link files to database records
  69. File Path
  70. And & Equ
  71. Help With a Query Please
  72. CDO Emails and Reports
  73. Take picture from Form through VBA Smae as PRINT SCREEN
  74. Getting number of records returned by query
  75. How can I optimise this code?
  76. Open a file outside Access
  77. copy data from multiple tables with SQL
  78. Dlookup Question
  79. See if a value in a control has changed
  80. Is there a way of editing a record in a table with VBA?
  81. Update a bound control
  82. Date Format
  83. alter SQL in VBA to open query based on different tables
  84. combo box
  85. Regular expressions
  86. Refreshing Linked Tables
  87. Help with Search Function
  88. Help with Existing data check
  89. opening multiple items with one button
  90. Text query
  91. report print preview opens behind menu
  92. Problem Executing Stored procdure in VBA
  93. Open form from custum menubar item using functions
  94. Access Lookup In Excel
  95. using Date with SQL statement
  96. Attaching files of different types to table field thru VBA
  97. form
  98. Index out of range
  99. Problem trimming a string.
  100. Message box question
  101. Automating using Excel...Freeze panes error
  102. Updating a recordset from another recordset
  103. Maximum of 7 calculated fields in subform
  104. Dreaded foxpro dbf importing problem
  105. Followhyperlink Method Alternative
  106. Using DLookUp to see if a row exists
  107. Concatenate 1st Two Letters + Another Field
  108. Struggling with FoxPro dbf import
  109. Struggling with FoxPro dbf import
  110. Controlling Word - Update Fields
  111. OpenRecordset on Linked Tables
  112. Open Explorer in Full screen with Shell
  113. Run-time Error '2471':
  114. short date/time check routine
  115. How to search for "contains"
  116. BE/FE - refresh links at startup
  117. Controlling Word again - the plot thickens
  118. I hope that this is simple
  119. Convert String to Date Problem in SQL statement.
  120. Export to Seperate Access Database
  121. How to avoid the following error messages?
  122. How to append?
  123. Time Calculations
  124. If Statement To Denote Value of Other Field
  125. Usual Mouse Wheel Problem.
  126. Block if without an end if error
  127. string offset
  128. Mouse Wheel Lock Issue
  129. What's wrong with this statement
  130. Referencing a Subform in VBA via SetFocus
  131. how to add in new field to a table
  132. Test Statement
  133. FoxPro dbf import solution
  134. Search Application Installed
  135. Export to an excel file problem.
  136. Printing visio documents
  137. How to Search Application Name in CreateObject MS ACCESS
  138. Subform refresh??
  139. String brainteaser - can this be done?
  140. parsing date
  141. change SQL to Vba
  142. week(date) function etal.
  143. Another time issue.
  144. the "Tilda"
  145. Case statement within a Case statement
  146. How can i eliminate the error
  147. Remove HTML code from a string
  148. Capturing a subform field value
  149. Global Variable?
  150. Returning back to current record in recordset
  151. query a recordset
  152. Opening a report from a list box
  153. error- please help!
  154. Helpfile's "OpenCurrentDatabase" method doesn't work consistently
  155. Caption in message
  156. OpenCurrentDatabase & networks
  157. can not quit access properly
  158. Insert & Union All Select
  159. parse a string and insert result into new field
  160. Field value in a table
  161. Random Sample
  162. Check Query Exists?
  163. need help with date check
  164. Cut and pasting code
  165. "WHERE" in SQL
  166. Tab Button
  167. Same Value
  168. Parse
  169. Passing parameters to the subreports
  170. CTRL+BREAK isn't working
  171. Deleting Relationships Programatically
  172. Client-Server Access database
  173. Client-Server Access database
  174. Vertical scrolling in unbound forms
  175. if then msgbox on form
  176. Using data inserted in a textbox of a form in VBA
  177. Setting the correct record
  178. Backup Backend from frontend
  179. Record Set Update
  180. Fault in SQL in some cases ??
  181. comparison query.
  182. docmd.setwarnings true not working
  183. Removing duplicate records programmatically
  184. Get rid of the record that matches
  185. Access / Excel / DAO / Data on Terminal Server
  186. MS Access with VB.NET
  187. How can i run this code?
  188. Error Checking
  189. Importing CSV data
  190. OnClose event
  191. Changing character set VBA
  192. Global Error Handler
  193. Saving a report in SNP format - problem
  194. Referencing records in datasheet or use recordset
  195. Access Combo VBA
  196. Network Application
  197. Null field
  198. Multiple subform records and MailMerge
  199. SQL in VBA Help Please
  200. Timer
  201. Run a query on an open recordset
  202. ScaleMode Problem
  203. Passtrough date when clicking subform
  204. Design Master vs Replica
  205. SQL in VBA error in syntax?
  206. Calculated values used in naming
  207. Deployment approach
  208. Replication and Union Queries
  209. Error: Can't find the field | in your expression
  210. Scroll Bar with Image Control
  211. There's got to be an easier way...
  212. Deleting table data
  213. Fault in vba code
  214. Using a reports Record Source in code
  215. FIND Speciffic record and USE it using VBA
  216. "Debug" option in custom error message
  217. Is the following code correct?
  218. Concatenate multiple values into one string?
  219. bookmarking problem with recordsetclone
  220. Type mismatch with dates
  221. Permentant VBA background table checks
  222. Retrieve default system icon based on file extension
  223. Adjusting the Height of a listbox
  224. Opening Excel File - Run-time error '462'
  225. run time error 3021
  226. Changing the position of the error message dialog box
  227. Detecting the Close Event
  228. dataset prob
  229. Recordset not working with linked tables
  230. linked tables password request
  231. Code behind command buttons
  232. GoToRecord Issue
  233. Error Trap Not Working (Permission Denied)
  234. Command Button Images
  235. Me.GoingCrazyOverForm.Visible = True
  236. FileSystemObject Copy Method
  237. Best place to store tables (BE or FE)
  238. jet database engine cannot find object 0
  239. Run Time Error 2439
  240. Compare 2 tbls, all fields, rpt non-matching
  241. Size of a text field - how to block it?
  242. distribute records to different users...
  243. Retrieve date modified of a table
  244. Parameter Query
  245. Add CR's every X # of characters
  246. SQL statement help?? Trying to refer to values in controls on a form
  247. Retrieve Path and Server name of a file
  248. Help with query!!!!!
  249. Online Examples/Samples of ADO Movenext
  250. Error handling code not working on my laptop