View Full Version : Modules & VBA



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