View Full Version : Modules & VBA



  1. Where condition in DoCmd.OpenReport
  2. Insert symbols into table
  3. List Import specification files?
  4. Find Method
  5. SourceTableName and Connect Method in ADO
  6. Restoring Full Menus
  7. Code needed to open a specefic web page
  8. Check for file
  9. Run a report 50 times with different filters to output to different filenames
  10. Refer to subform
  11. validation
  12. error handling
  13. Determining Master Form from SubForm
  14. Writting a Check
  15. Where to put code for whole project?
  16. make new table
  17. case statement not working
  18. Change all the values of a field in a table
  19. extract the price from a string
  20. unwanted 30.12.1899
  21. Hide Toolbar button
  22. Emailing loop not quite working
  23. Fixing reversed Dates
  24. Requery on forms
  25. Disable submenu Menu-Menu1-Function2
  26. Enabling Full Row Select in a Treeview
  27. Start project without access interface
  28. still problem find method
  29. Reporting on Sequence breaks
  30. ctrl + f (how to search in text...)
  31. Requery Subform
  32. Problem With SQL String
  33. Paramter query, subforms and VBA...???
  34. Using info in MSysObjects to relink tables
  35. Email Attachments w/ Outlook Express
  36. Embedded Excel Workbook not behaving!! :)
  37. Menu - Dividers? Should be a simple question
  38. Execute when User hits enter
  39. "Type Mismatch" error locking down Access
  40. connecting to a passworded DB with ADO
  41. Help with expression
  42. yes/ no message box
  43. Error: Function isn't available - Relink library references through VBA?
  44. Flashing labels
  45. =IIF or VBA code?
  46. Syntax Error
  47. VBA to evaluate a report field
  48. What does this function do?
  49. Building A Filter
  50. setting default references
  51. Access crashes when trying to run specific module
  52. environ
  53. detect operating system
  54. Stupid Me or Stupid VBA One or the other...
  55. Export All Database Objects Into Text Files
  56. Dim dbs as Database not accepted
  57. Using a function in a query
  58. Enable/Diasable control
  59. Updating a field/control
  60. Read only database?
  61. Moving pages in a report from a pop up form
  62. New Records in a Table
  63. non-declared variable working
  64. Command-line from VBA
  65. SetFocus To Form[b].SubFrom[b] From Form[a].subform[a]
  66. Shift Key Disable Doesn't work
  67. Undefined Function Error
  68. Automatic validation on update query
  69. Problem building string
  70. Subforms and VBA
  71. Message Box - Number of records
  72. Specific printer
  73. Reading public variables
  74. Calculating Time At Severities, almost working! :)
  75. List box to list box
  76. Stupid A@# Question #2
  77. DB Password error
  78. Change Input mask in code
  79. Automatically goto new record by changing value in a field
  80. Refreshing Linked Table links using ADOX - New Password & Location
  81. Form Filtering options
  82. subform Append Query
  83. Not recognising my forms
  84. Compare value in 1 table to a other table.
  85. Delaring Global Databases And Recordsets
  86. ADOX - Create Table From Custom Field Collection In Class Module
  87. Retrieving current IP-address.
  88. insert date in duplicate fields
  89. Populating a field for each record in a subform
  90. need help with sub string
  91. Loop code not working
  92. standing order code for a banking program
  93. Data Has Single & Double Quotes
  94. Insert Into problem...........
  95. Code limit reached: What can I do?
  96. ADOX: Setting Prmary Key In Linked Table As Autonumber
  97. trouble deleting with code during on click event of sub form
  98. references
  99. File search returning multiple files
  100. Days between dates.... By day.......
  101. Opening files with VBA
  102. How to trap when combo has no entry
  103. WorkSpace Open Database Problem
  104. Dynamic Buttons
  105. Recalc error 2115 in 2003
  106. difference in code
  107. Last Modified Date
  108. VB Password code for database
  109. How to auto detect available positionid
  110. Trying to replicate relations from an external database
  111. Having to cut/paste/save VBA code for it to work
  112. .FileName Property
  113. Password or username is not valid
  114. Best way to duplicate a record
  115. Hyperlinks in Access 97 VB
  116. Errors
  117. Populate Rescord Set with Select Query Code
  118. null values with ado
  119. Grab text line and populate field
  120. Reference Subform Recordest From Module Function
  121. Automate Keyboard Shortcuts
  122. Code not working right
  123. Field accessing in standard module
  124. another NULL issue
  125. How to create a view via sql
  126. ADO conversion of the code
  127. Data type mismatch in criteria expression?
  128. A learning experiene
  129. Printing documents from Access
  130. Adding to another number in a table?
  131. Not Accessing Tables Records?
  132. SendObject isn't available
  133. Automatic Front End Database Updating
  134. Dynamic Update - Table
  135. Code Help
  136. Help with this code pls!
  137. Refreshing info
  138. Why do I get this error?
  139. General Code
  140. Need code help!
  141. Hiding Database Window
  142. Searching Object Properties
  143. Outlook queries automatic email
  144. Experts needed!
  145. Scanning and Populating the fields in the form through VBA
  146. OnClick Event Calls Function to Evaluate
  147. getting a record count joined tables
  148. Working within another app via vba
  149. Merge two tables and display in list box
  150. Print a form in landscape
  151. datatype
  152. Either BOF or EOF is True, or the current record has been deleted...
  153. changing outlook mail status
  154. Changing back colour
  155. Case statement not working
  156. Secure website connection?
  157. set parameter as user input
  158. Access and VBA Select issue
  159. Connecting to SQL server without DSN
  160. DoCmd.SendObject to Email syntax
  161. VBA code for checking if quantity is greater than quantity in stock
  162. kicking people out of a frontend
  163. Import problems
  164. Array, isArray
  165. Help with const
  166. User Level Security - Setting The Focus
  167. If Then stoping a string of events based on a null
  168. Is Putting Double Quotes in a String possible?
  169. Excel / Access Question
  170. Beginner VBA Needs Help - Text Problem
  171. Maximizing the ACCESS window after changing screen resolution
  172. Error 7874 in a SQL string
  173. I have no clue where to begin...
  174. From Field in SendObject?
  175. What's the Office 2003 Excel object library?
  176. A simple solution?
  177. Import multiple files
  178. Automatic emails - syntax problem?
  179. Run-Time Error 2147417851
  180. Source Code won't update properly
  181. search a string for a few strings in one go
  182. Please tell me wht's wrong with the code.
  183. Using Module As ...
  184. Convert numbers to month names
  185. dynamic form - datasheet view as subform
  186. ADO to DAO
  187. Increment in query output
  188. Change Wallpaper with Windows API
  189. Update Form dynamically
  190. Specific Record in Recordset
  191. Don't Want Field on Report to Appear if ___ is True
  192. VBA & Conditional Formating
  193. How to distribute a database ?
  194. How to change the source object of a subreport?
  195. Runing a query in code
  196. Invalid SQL Statement
  197. Invalid Reference to Rowsource??
  198. Dlookup not looking up...
  199. Dlookup
  200. Docmd.OpenReport Where Clause Problem
  201. omg Access drives me crazy
  202. Word document as body of outlook email message
  203. Access Page
  204. MSChart Line Color Problem
  205. Assign empty string to a value
  206. Getting all field contents
  207. Text Box Date
  208. Turn Off "Look In" pull-down when using Common Dialog API
  209. Where Clause Problem
  210. Saving unbound data
  211. need help with code ...
  212. return value from sql into a variable
  213. Extracting field name from argument...
  214. Insert check sign in Listbox
  215. Fresh Ideas Welcome
  216. Can't update Records via ADO
  217. picure as a btn
  218. Return list of dates with same day of month
  219. Error Message: ActiveX can't create object. . .
  220. Copy Records AND SubRecords
  221. Create Multiple PDF Files from 1 Report
  222. dont understand what this error mean?
  223. Select source tray of printer
  224. Control Array In VBA
  225. Turn string into an array of characters
  226. Insert Into
  227. ADO / DAO Writing syntax to external table
  228. Invalid SQL statement
  229. Quick question - TreeView Control - maximum records
  230. moving through records
  231. combo box to display unused data
  232. how to "findRecord" from unbound control
  233. Generate table of weekend dates through VBA?
  234. Add New Record generating unknown error
  235. Stop in the middle of an if statement
  236. Over Budget Alert
  237. VBA adding a duplicate record without event
  238. Access DB Email Validation and Update
  239. Create New Table
  240. IsOpen Not detecting Switchboard Form
  241. Open a report in Word
  242. Easy VB question
  243. VBA Path for variable name of label control
  244. Export query result to Word doc.
  245. A date issue...
  246. Need a String Function
  247. Need a String Function
  248. spliting a string in three ways?
  249. Writing String Drops Leading Zeros?
  250. Two rows in a msgbox?