View Full Version : Modules & VBA



  1. Swiftness of code and evaluation of strings
  2. code needed
  3. E-Mailing list of recipients
  4. I can't update a field through VBA
  5. Charts!
  6. Open HTML Document then Search It
  7. Which employee has the record?
  8. Determining if project is .mdb or .mde
  9. Access to Excel export with proper formatting
  10. Excel code locks process
  11. Reading dat file from CD
  12. convert access report to pdf file?
  13. runtime error when there is no data on rpt
  14. Combobox Selection
  15. object String array issue
  16. What if one string in concatenation is null; instantiation and defining string
  17. Importing to Access without opening it.
  18. Count columns to query
  19. Trying First Function Not working!
  20. Adding or Deleting binary file (jpg) to a folder
  21. finding reference from VBA script
  22. Printing Report
  23. Copy contents of field to another field
  24. ADO Recordset Find Method Behaviour
  25. put items from table into a string
  26. Changing from Sterling to Euro at run time
  27. import from excel worksheet straight to table
  28. Problems implementing known automated mail merge need help
  29. refreshing from subform
  30. sending values from a form
  31. add a 2nd field in a cascading combo box
  32. How do I Replace '.' with '/'
  33. problem with outputto and reports
  34. Open template, tranfer data and run macro.
  35. Unbound Recordset
  36. SQL Replace
  37. Anyone willing to provide some "replication code for dummies" assisatnce?
  38. Combating apostrophes
  39. Export to specific Cells
  40. count populated row in spreadsheet for import to table
  41. Delete a Database
  42. Request for expert tips
  43. Appending data to Existing Excel Data
  44. Importing attachments from multiple emails
  45. Asking for library reference
  46. Create the link
  47. Controlling a form in vba
  48. Median module run-time error
  49. Looping thru 2 differetn CtrlTypes
  50. SavePicture Command Problems
  51. Dcount with number criteria
  52. Presenting Time in Hours and tenths
  53. Copying an access file to a laptop
  54. Isloaded...........
  55. Standard INI files functions
  56. Create a function using expression
  57. Variable Values Not Showing
  58. Importing Repeating Row Record Text File Data into ACCESS?
  59. VBA Copy memo field from one table to another.
  60. too many pages of a report
  61. Copying Photos
  62. COPY selective address details to new record
  63. Order By [field] ="blah" (put those first)?
  64. problem while send fax
  65. Updating Linked Tables
  66. 2.0 to 2000 Conversion Issues
  67. report footers displayed as subreport?
  68. Converting a File within Access
  69. Hyperlink does not appear correctly
  70. How do you define a field as memo in code
  71. "Filtering" a recordset
  72. Pause code until form is opened & value set
  73. Replication Command
  74. "set" control value and pass to module
  75. Using NetWorkDays in Access?
  76. Stopping update to form if value is already present
  77. Wacc
  78. send e-mail via query search criteria from access
  79. Selecting multiple records in a form and associating them to a record in another tabl
  80. Criteria Problem
  81. VB Code Problem
  82. DateList as separate values.
  83. How to determine last selected row in subform
  84. Syntax question - using OR in an IF statement
  85. Reset Read Only Property with code
  86. Shell Command Problem
  87. Select Rows in Listbox
  88. Missing Database Object
  89. End of record set error
  90. SQL Statement problem
  91. How to set a reference to the 'Microsoft Scripting Runtime'
  92. Combining to 2 word documents into 1
  93. Format length of invoices in a textfile
  94. Right Click permanently diabled
  95. Unticked VB References?
  96. Shred a deleted file
  97. Can no longer call String$() or Left$() in my DB ...
  98. Validation Rules In VBA
  99. Automatically link an image to record - possible?
  100. How to place a return in a memo field
  101. Controling Cash Register With VBA Code
  102. Access can't find text file to import
  103. Error in SQL Where Statement
  104. Displaying different record numbers? Me.CurrentRecord somehow?
  105. Counting the number of results from a query
  106. Error Deleting File or Folder
  107. compact and repair back end db
  108. Disable the warning message from Outlook
  109. VBA Form-Opening Question (How to set acDialog)
  110. Show in cascading combo records only where a field = true
  111. VBA routine that would organise my messy table
  112. access on a wireless network
  113. SQL statement in report not working for all years
  114. Enconding in RecordSet
  115. Simple OpenForm / acFormAdd problem
  116. Note quite VB I suppose its Maths really
  117. Import if timestamp is new
  118. All queries not working in a code snippet
  119. adding a numerical value to a field
  120. Refreshing of list box
  121. Looping through Table Catalog causes Access to crash
  122. Join doesn't appear to work
  123. queries aren't loading
  124. Combo box filling in address fields?
  125. Import Excel - add sheetname as a record in access
  126. Debug a problem
  127. ButtonPress displays Context Menu
  128. Sending Email
  129. Modulo in SQL expression
  130. Evaluate to last entry in columns of table
  131. User-Level Security
  132. Downloading from the World Wide Web
  133. Need Code to download file
  134. Populating tables from another Database
  135. Custom vs. Shortvut Menu?
  136. Help with control
  137. Open Excel then return focus to Access
  138. Open Excel then return focus to Access
  139. How to print twice
  140. SQL "Where" statement.
  141. Code to return domain name?
  142. System date Format
  143. Clear List Selection Error
  144. FileDialog InitialFileName "My Computer"
  145. Problem with SQL & VBA
  146. List of Functions
  147. Calculating years, months and days from 10 start and end dates on a form?
  148. Painting graphs using MSGraph in word from access 2002
  149. NotInList Fails to Fire
  150. Windows API compatibility
  151. Troubles with replicationid<=>uniqueidentifier relation in a SQLServer<=>Access Query
  152. Exporting/Publishing a macro to Word Document
  153. How to launch a count in current database
  154. Coding Table Properties
  155. Call Help Files
  156. XML output code not working :confused:
  157. Referencing another DB
  158. Better method to stop bloating the FE Database
  159. Working with MemoField
  160. Help finish multiple export
  161. Auto code generation
  162. No more than one record
  163. Quiting an external Access Database
  164. Conditional formating based on user input
  165. How to convert and private subroutine into a public one
  166. data dump from .TXT to access
  167. NoMatch doesn't seem to be working??
  168. Automatic Compact and Repair
  169. Checkbox to show field from query
  170. linking table with diff names in frontend
  171. multiple email body problem
  172. Sending Emails
  173. null empty "" 0 ......
  174. access not recognising default printer through module code
  175. Combo Box Debug
  176. Problem with importing dbf flat file
  177. Scanner Guns
  178. VBA / Excel problem
  179. Output to Text File using VBA
  180. set form visable
  181. replace a comma with a point
  182. Does a Form Field Exist from VBA
  183. Specify Outlook 2003 preferences when sending reports
  184. DAO to ADODB - I have no clue, please help
  185. Table Properties
  186. Table Properties
  187. Clearing a database...
  188. Clearing a database...
  189. how to check if docmd successful
  190. QBF Probs - minor progress
  191. Are there any hash functions available in VBA?
  192. Insert PDF doc in a table
  193. INSERT statement not working for one field
  194. Open a form as acDialog
  195. Opening Access from VB - Can't Set Warnings True
  196. 3219 Invalid operation - why?
  197. Simple msgbox question
  198. use other table to calculate values
  199. limit access to query
  200. running SQL from VB
  201. Access and OLAP
  202. omitting msgboxes by deleting-query
  203. officexp Acces/Word vba
  204. adding a new record
  205. Filename picker
  206. Filename picker
  207. Form opened on new record - cant pre populate field
  208. Help with TransferText importspec
  209. Dynamic Object Frame
  210. How to change an Outlook appointment
  211. 2 GB needs to be compacted to continue
  212. Help with using VBA to create a table from a pass-through query
  213. Output to .txt nightmare
  214. Logging Usernames
  215. Is it numeric?
  216. can someone please take a look at this code for me
  217. two stage validation module - having trouble
  218. Export Format question...
  219. Filter out imported excel data from table
  220. Simple VB Question ( I R Noobaloo)
  221. Not able to change decimal places as per code!
  222. Shell Command
  223. Unconventional Database, Mapped GIS
  224. Email Problem
  225. Importing Spreadsheet
  226. runtime error 2302
  227. But what IF
  228. Excel, Comment
  229. listbox add remove
  230. Programming checkbox value!!! Fun & fruity challenge
  231. Importing from Word '97
  232. I am unsure how to close an application..pls help to chk my codes..
  233. Function wont function or save!
  234. Time Calculation
  235. transferspreadsheet
  236. sql in vba doesn't work...resulting string does work in query builder
  237. Export Yes/No Value to Word Checkbox
  238. Linking Table
  239. a dynamic barcode label
  240. Creating webpages with
  241. icon remains on the notification area
  242. Help with FileSystemObject and text files
  243. Regular Expressions
  244. Mail Merge To All Customers Using VBA Code
  245. Extract al values from a field in a table
  246. How to find the MAX value in one table and return the linked table results?
  247. Mousemove on ListView: What Col/Row??
  248. Subform - Select All
  249. Merge many test files?
  250. Moving in a recordset