View Full Version : Modules & VBA



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