PDA

View Full Version : Modules & VBA

  1. OLMail.Body Question.
  2. User Form
  3. sorting a ranking
  4. Mail
  5. Excel 9.0 & ActiveChart.Location error
  6. Problem With Inserting a Record
  7. Problem With Inserting a Record
  8. How to get properties of .msg file saved on file system
  9. Exporting Reports
  10. Trouble
  11. Bypassing Events
  12. Query String Result
  13. Subreport Filters - AGAIN!
  14. Make MSGBOX appear over all other apps
  15. Great Function - if it worked....!
  16. Not In List - I can't get it right
  17. Closing a specific file via VBA-code
  18. Calculations in VB
  19. stLinkCriteria to match fields to form and subform on that form
  20. SQL in VB
  21. Closing rogue Excel process
  22. Open pdf-document from Access form
  23. how to detect first n last record? Thank you
  24. Filtering via vba
  25. Property Not Found of DecimalPlaces
  26. Recordset or Aggegrate Functions?
  27. Opening a file
  28. Module Creation
  29. helps for MSCOMM
  30. Basic question - For - Next loop
  31. Can I query a DAO recordset
  32. Saving new data automatically
  33. Retain memo format - Require WYSIWYG
  34. Blobs and Images
  35. function calculating ticket prices
  36. Retrieve Windows Network Password
  37. Is some wrong in code...
  38. Recreate VLookup in Access?
  39. not working, cant trace
  40. returning file info from folder
  41. create help file
  42. MailMerge and FormFields command - no documentation ANYWHERE
  43. ODBC Call Fail
  44. Export Variable Query Definition to Excel
  45. Sending E-mail
  46. SQL Return Code
  47. Search and open a pdf file
  48. convert string to object/method. see example
  49. Control properties of a chart in MS ACCESS with VBA
  50. Using VBA to replace word in a .cmd file
  51. ListBox & subform Record Select
  52. Query Calisthenics
  53. Detect Text Box Overflow
  54. Passing parameters
  55. Quick silly question - what is 'bas'?
  56. Counting lines of text
  57. Command button to open Drawer
  58. making data items invisible in combobox
  59. Automatic compact and repair with DB closed?
  60. Spec file losing data and spec fie location?
  61. Print without dialogue box
  62. Searching w/ Option Buttons
  63. Error Opening a Query With Criteria Through Code
  64. Max() vs DMax()
  65. Need help with nested loop in VB
  66. Autolinking to a SQL Server via a web connection
  67. record set to change field
  68. record set to change field
  69. Writing SQL in VBA
  70. Writing SQL in VBA
  71. Extracting data from one field in a table to another--Help!!!
  72. Deleting Records in a Subform
  73. Deleting Records in a Subform
  74. 'Sorting' a string
  75. using a control button to copy data from one form to another
  76. spreadsheettype information
  77. Error message - Chinese environment
  78. Replace, recordsets and Null values
  79. Need help: #Name? error with defaultvalue
  80. Use boolean to filter records
  81. Do loop problems
  82. calling up methods from one form to another
  83. Control Fields Assistance
  84. Referring to Variable in Code
  85. transferspreadsheet problem
  86. Run query without prompts
  87. Sql Statement in vba
  88. Combo Box
  89. Programatically creating a new field in a linked table
  90. Sql Statement in vba
  91. Trying to calculate sick days
  92. Copy Files from an FTP folder using VBA
  93. RecordSet and SQL Help
  94. update table from continuous form
  95. Appending an Access Table to an excel sheet
  96. FileDialog(msoFileDialogFilePicker)
  97. Determining if record is new or current
  98. How to hide the query by visual basic
  99. Dynamic naming of objects and variables
  100. Manipulate a text file prior to import
  101. Clueless about calling function
  102. Combo box chooses first line
  103. Querying Form's Textfield Value
  104. Setting a boolean field using code
  105. Default Values = Previous entry
  106. Help with adding a report in Body of Email
  107. Access 97 email with Lotus Notes?
  108. Export Access Report to Excel (Acces 97)?
  109. Weird code error
  110. New to Access, Not sure how to do this
  111. obtain a list of all tables in a database
  112. ADODB recordset not opening!!!!!
  113. Run SQL runt time error
  114. Run SQL runt time error
  115. RunSQL
  116. RunSQL
  117. Exporting specific fields to excel
  118. Problem with sending mail via outlook
  119. backup db on exit using vba
  120. Adding mutliple records....
  121. Simple VBA Question - How Do I Prevent A Text Box Control From Changing Focus
  122. merge to word
  123. Filtering reports dynamically
  124. SQL Server Money Data Type
  125. Creating a string
  126. Resize/Rename photo in Access?
  127. Code from Form to Report
  128. Can DLookup refer to the previous record?
  129. Can DLookup refer to the previous record?
  130. write data from report to CSV file
  131. Syntax for allow edits and addittions
  132. Exporting recordset to Excel & Powerpoint
  133. ExportXML Help
  134. Locking Question
  135. Sync Form to Listbox
  136. ANSI codes
  137. Importing in to Access 97 using vb script with jet engine
  138. Return ADODB recordset value?
  139. Pull Down Box and Locked Text Box Code
  140. Text conversion to date
  141. Hope you can help fix this
  142. Email excel attachment
  143. Delete Query Problem
  144. FormatPercent Mismatch problem
  145. Problem with search-function (.SelStart - Run-time error 2185)
  146. Inventory coding help
  147. ItemData combo box problem (Access 2000)
  148. Populating option group by recognising first 3 digits
  149. aquire image with scanner
  150. Help with ActiveCell.Offset.Activate
  151. ACCESS 97 VB Tutorial
  152. VBA for Excel Code
  153. sending email from citrix
  154. desabling word from access
  155. Combo box
  156. Can Anyone Tell Me Where Im Going wrong.
  157. Median subtotals
  158. DAO Description Values
  159. Kick Drawer
  160. How to update/cancel changes and Lock individual records?
  161. Run external program and get output
  162. Saved Query Modification
  163. Saved Query Modification
  164. Exclude hidden files from filesearch
  165. Checking Records
  166. "The expression you entered has a function name that XXX can't find"
  167. Convert Date to Hijri (ArabicCalendar)
  168. Combo Filter on sub form fails at last selection
  169. Modifying code to send attachments Access 97
  170. MS Access Form & VBA Problem
  171. Log changes using Insert Into
  172. Step Into doesn't work
  173. From text box to Wordpad..
  174. Limiting user's choices in ActiveX calendar
  175. Controls Collection
  176. create a new database and export a table in it
  177. References - Access 2000 and 2003
  178. Restrict Pivot Chart Usage
  179. Copy Recordset
  180. Not getting out of loop
  181. Coding over multiple lines
  182. Encryption in VBA
  183. Passing Dates and Integers in vb
  184. Recover deleted records?
  185. Range in Excel from Access
  186. Variable type not in list
  187. how to save Data value for each field entry on a bounded form
  188. Requery Dlookup field on subform
  189. Assign value to textbox
  190. Runtime Error (3075), not sure how to fix it
  191. Help with not null & DoCmd.OpenReport
  192. Help with not null & DoCmd.OpenReport
  193. SQL Update statement
  194. Hijri Date Problem Again?
  195. Transaction Automicity does not work.
  196. ADOX field creation - change to not required
  197. ADOX - change 'Required' property of new field
  198. Excel file doesn't open-error
  199. Disable subform from the main form
  200. Function to concatenate values into a string based upon criteria
  201. Input Box Error
  202. Challenge...Locking only a particular record!
  203. Problem Adding ActiveX
  204. SQL Update Date / Time info
  205. what is the code?
  206. some simple questions (I hope)
  207. Docmd.findrecord acSearchAll, doesn't.
  208. vb arghhh i dont understand it!
  209. vb arghhh i dont understand it!
  210. vb arghhh i dont understand it!
  211. Null insert statement
  212. Simple Code question, but cannot figure it out.
  213. Simple question: Requery form
  214. Easy Question, but not sure how to do it.
  215. from table to a template
  216. Easy question, but having a hard time to figure it out
  217. invalid procedure???
  218. I think I need a VBA code
  219. New Switchboard - Code now not working
  220. If Then statement, having trouble since two forms are involved
  221. I am stuck at step
  222. am I asking the right questions?
  223. Please Help -- "Same as Billing Address" Checkbox --- is this possible!?!?!?
  224. Do I need a temporary recordset?
  225. MakeTable qry - Checkbox Format
  226. Audit Trail and Find and Replace issue
  227. Error in my code and not sure what it is.
  228. RunningSum
  229. Working with OUTLOOK
  230. Reading audio CD table of contents
  231. Access won't let me save
  232. Detect when record has finished loading
  233. Excel autofilter selection criteria referencing the contnet of a cell on another work
  234. Obtaining Table Descriptions
  235. Form page fade out
  236. How can I suppress "paste errors" message?
  237. If between two dates not working
  238. Help With Vba Pleaseeeee
  239. How do I activate the Maximize button in code?
  240. File Searching in MS Access
  241. Code for putting current date into a field.
  242. Exact phrase
  243. Changing field values (in code)
  244. Popup Form Open/Update Issue
  245. Custom Page Number Label
  246. Check Username and Password Login Form
  247. Lookup value in table
  248. Storing a Proceedure Name in a Variable to be used later
  249. Exporting a Memo Field with a Custom Result Column giving a Data Type Mismatch
  250. Assigning event at runtime