View Full Version : Modules & VBA



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