View Full Version : Modules & VBA



  1. Viewing contents of a single folder
  2. Controlling the media player playhead in access
  3. How Insert Picture From Open Dailog Box into Unbound/Bound Object Frame Control
  4. Find Maximum Date Except The Current System Date
  5. Selecting enteries to export into word
  6. Saving records when opening a new form
  7. Log the date in a different table when record is displayed
  8. Mass File Rename
  9. Check to see if an access table column exists
  10. Compile Error - Comments appear after end sub?
  11. Function for file path
  12. Freeze Panes in Excel
  13. References and User-defines type not defined
  14. Insert new line in record (memo)
  15. Getting rid of "boxes" in a string?
  16. Code to turn off confirm messages
  17. Open File and Save File Dialog Boxes
  18. VBA to email merge
  19. Page break paramitors
  20. Hide Access Module, Help seriously required
  21. Filling Field Length
  22. Selection and UnSelection of Subjects By Students
  23. non zero / is null problems - Error 94 - invalid use of null
  24. Insert Text In Combo Box
  25. Combo Box
  26. remember password
  27. Combo box to populate a table
  28. Help referring to an Option Group Value
  29. Creating an excel file
  30. Check to see if Query Exists
  31. Prevent links via ODBC
  32. Hell if I know what to do with it...
  33. Resize Label/Button with listbox column
  34. How insert current record of List box to another, and Save to Table
  35. Send email using groupwise & access table
  36. Need Help With Module/VBA
  37. Email failure
  38. Call function in a dll file
  39. Please help - recordset problem
  40. Snapshot File Location
  41. Test User Name and Password
  42. Please help me to solve this?
  43. New to Forum, need help with ADO code
  44. RelationShip Among Many Tables
  45. How to Set First, Second, Third Columns of ComboBox to TextBoxes
  46. Date problems
  47. report form does not appears
  48. How Open Start Up Dialog with VBA
  49. Email using Send object problem
  50. Prevent opening another window
  51. if code help with greying out
  52. SLQ troubleshooting needed...
  53. Email from a Table
  54. Cascading (sort of) Combo Boxes
  55. LOOKUP on a Query, not an update Query
  56. Creating query with VBA
  57. Need some direction with VBA code
  58. Remove Code Not working... any ideas?
  59. characters in code
  60. Setting all loaded forms to visible=no when a report is opened
  61. simple Y/N answer required for SQL troubleshoot
  62. Export to Text File
  63. For Each Label in a form - any way to select by object type?
  64. User-Defined Variable Not Defined
  65. Calling subroutine in subform from parent
  66. AutoFillNewRecord
  67. Order by
  68. Active/Not Active button depend from condition
  69. One Query One Report Multiple Text Files Output
  70. Syntax error help
  71. Get Value from table & interpolate as module
  72. Handling NULL
  73. Listbox Question
  74. basic question.. if value is not null
  75. Handling Prohibited Characters in an SQL statement
  76. More efficient way to write "If Like OR"
  77. Conditional Format code
  78. Changing Printed Layout From Record To Record
  79. How to Close Propertysheet window at startup
  80. please help me understand this vba code
  81. Alert Messages
  82. Using bookmarks in word, what other options can be used.
  83. SmartAccess
  84. validation msgbox
  85. Closing two Recordset issue
  86. copy field to form
  87. Converting OLE Object to BLOB
  88. Copying OLE Data to External file
  89. Pictures Help Required
  90. Validation Rule
  91. Closing Microsoft Access
  92. Code not working
  93. ADO - Recordcount
  94. Local Table VS ODBC Tables
  95. Connection string
  96. Syntax Problem help needed
  97. Counting records in rcSet
  98. Why do I have to SetFocus when referencing an object?
  99. Refreshing after an update
  100. List of record number
  101. Disabling built-in Menubars and ToolBars And Creating our Own MenuBar
  102. Library database public variable definition
  103. Manipulating exported spreadsheet from Access
  104. Programmatically access the reset button in VBE
  105. Scrolling the current window using ScrollWindow function
  106. Enable/Disable button
  107. Domain User Name and PW
  108. Email attachments through Outlook
  109. Help - complicated strings extractions
  110. Delete Directory
  111. PLease help with automating excel from access vba
  112. Delete field contents
  113. Customized Autonumber
  114. What's wrong with my code? Can't figure it out.
  115. Text Box Parsing
  116. Need Help With Ok/Cancel Dialog
  117. Open Currently Installed Version of Acrobat from within Access
  118. Working hours & holidays problem
  119. Find unused code.
  120. Remove Numeric Characters
  121. Copy Method
  122. Using PING in Access
  123. Send data to excel
  124. Access FE/MySQL BE - User Roster
  125. Need Help Setting To Decimal Places
  126. Changing text color in Lotus Notes email via VBA
  127. mde file help
  128. linked table refresh links requires restart
  129. find directory of mdb file
  130. Can anyone... Help Me solve this??????
  131. Where Do I Start - HEEEEELLLP!!!
  132. Letters printed via access database
  133. A Code...
  134. Common Dialog
  135. Microsoft Note Pad
  136. Print Properties
  137. Fun with Notepad
  138. How to import XML files through form?
  139. Remove holidays from calculation
  140. Import data from DAO recordset to local table
  141. Help with combining fields
  142. Recordset changes not being saved
  143. Writing a function and using it in a query.
  144. Access Front-end Auto-Updating Utility problem
  145. Dumb question on debugging
  146. Stumped with 3rd party methods
  147. Date issues.
  148. Advanced date diff
  149. Empty Query Causing an error in the code
  150. get time from now()
  151. Confirmation on change when exit form or hit the X in corner
  152. Trying to Apply Code Upon Record Change
  153. Error 2115 BeforeUpdate or ValidationRule Error (DB example attached)
  154. Open File using VBA
  155. The code for creating a new record when using the build in record function
  156. User Defined Pop Up Warning
  157. Creating Checkboxes on subform via VBA Module programming
  158. Do not save record if null & best way to restrict data
  159. Restricting Viewable Data Based On User
  160. Help With Some VBA Programming
  161. Simple Question on VBA
  162. Problem with date portion of this code.
  163. Using modules in my Private Sub Function
  164. updating records
  165. ExportXML help - how to allow user to specify target??
  166. File Exist
  167. Convert Excel VBA to Access
  168. Writing a function that controls the contents of a text box
  169. Arrays
  170. Module help for a novice
  171. Determine All Visible Forms
  172. inserting pdf file into email
  173. DoCmd.SendObject or Case error
  174. Problems using controls within VBA Code
  175. Error when creating mde file
  176. If then else syntax problem?
  177. MS access printing
  178. A better "Better Mousetrap"?
  179. Linking textboxes from 2 different forms
  180. Check if Acrobat Reader is installed using VBA
  181. Help with bracketing
  182. Identifying hardware
  183. On Export, I get Error 3274: File Not in Expected Format
  184. Readonly Security on db objects to everyone except 3 usernames
  185. Distinguish vowels and consonants
  186. Problem with Opening Excel
  187. looping through box's on a form
  188. Listbox Columns?
  189. Quick Question on Date
  190. Problems with reading from & writing to a Word document
  191. check if form is open
  192. retrieving more then one search result
  193. cant read a linked table from oracle in access
  194. Select and Delete a specific child record
  195. Do loop
  196. OPen a specific file
  197. Function to simplify task
  198. Difference between "." and "!" ?
  199. Anyone who likes a challenge....(Calculation based on queries)
  200. Using a loop command to vary a set of commands
  201. csv
  202. "Me." question
  203. update list box from SQL
  204. Help with Access VBA sum
  205. VBA code and command buttons
  206. recordset probs?
  207. Invoking an executable
  208. ELookup vs. DLookup
  209. Trying to create controls dynamically at run time.
  210. Scheduled email based
  211. increase date() by 1 year
  212. paragraphs in email body
  213. Globals defined in a Function Module blank on MouseDown Event (from Form)
  214. Problem with Criteria in Code
  215. Concatenating List box to a Text Pox
  216. Import Excel Sheet Command button
  217. Scroll Bar Color
  218. Front-End Back-end relationship...
  219. Trying to Use Access page on Internet
  220. comparing two dates.
  221. The DoMenuItem action was cancelled
  222. Import Excel
  223. runtime error
  224. don't want to show message box
  225. Need Help with Complicated Totals!!!!!
  226. how to create menu on user form
  227. Combo Box Search Records On Sub Form
  228. how to create fields in word
  229. Run macro if table exists
  230. Disable form design?
  231. Write Conflict
  232. Filter question!!
  233. changing a file
  234. Populate form fields from Access table using VBA
  235. ApplyFilter question
  236. Sending an automated email...
  237. Attach Word Documents, PDF
  238. Combining two queries in code?
  239. Returning primary key value instead of combo box selection
  240. Creating a folder
  241. Linking Subforms
  242. Please check my code
  243. slight error in link criteria syntax code
  244. Count the number of fields in a delimited text file
  245. TransferText from a REPORT
  246. If statement based on null table contents
  247. If statement to flag a negitive
  248. Adding table field when importing multiple txts
  249. DCount - Empty Records
  250. If Statement with SQL???