View Full Version : Modules & VBA



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