View Full Version : Modules & VBA



  1. generate dynamic menu structure
  2. Stupid dates again!
  3. menu stuff again
  4. No decimal places please
  5. HEEEELP!!!!
  6. Buttons dont work when converted form to DAP
  7. Echo On/Off
  8. WHERE clause & RecordSource not playing well together.
  9. Refresh / Requery another form
  10. Drawing a line with VB
  11. Global variables losing contents
  12. integrate access with lotus notes
  13. Split 1 record into array
  14. Add IF statement to converted macro
  15. DoCmd. statement in my script is bypassed
  16. Please help me!! ( I will connect my Database with Tapi)
  17. Email list of people
  18. Conver a server name to the relevant drive letter on the users pc
  19. Deleting directories and subdirectories in VBA
  20. Easy One!!!!
  21. function & syntax
  22. if query is null
  23. If-Then statements when referenceing a subform? Please help ;(
  24. "Dirty"
  25. SQL Help!
  26. Function works, but I'm not sure why.
  27. "If Exist" command in VB?
  28. Password in SQL
  29. Controlling Errors
  30. Coding a Report
  31. = Subtotal (+/- 1)?
  32. Finding path which working currently mdb
  33. FindRecord problem
  34. Date format when exporting tables to csv files
  35. Installing and Using the Access Runtime
  36. Setting Properties for List Box
  37. Sort Property of Recordset
  38. SQL in VB
  39. VBA Corrupted
  40. Make a Continuous form act like a Datasheet
  41. Scrolling Text
  42. Storing a variable
  43. Positioning Common Dialogs
  44. DAO recordset gymnastics
  45. Missing Reference??
  46. looking for more visual effects
  47. Another Issue
  48. Proper Case conversion - solution
  49. Silly question...
  50. Mouse Wheel Code
  51. import code not working.
  52. Programming form controls (combo box)
  53. VBA to send multiple reports as attachments in .rtf file format
  54. FindFirst
  55. Autolist Members playing up
  56. Need some help with an array function
  57. I am turning into a question dude
  58. Strange error when importing text
  59. Recordsets and Tables
  60. formating excel columns from access
  61. Directory of drive to a listbox on a form.
  62. Version Error?
  63. compare/sort order
  64. Connecting to external db via query to populate dropdown boxes
  65. Protect with new .mdw file
  66. Directory listed on a form :getting closer?
  67. Goto NextRecord and Working with RecordSet
  68. DOCmd SendObject problem!!
  69. create maketable query populating random records
  70. Really long line of code
  71. Report using VB
  72. Saving database on read-only media such as a CD
  73. Weird Question??
  74. Really Really Urgent Help Needed
  75. Modules
  76. ADO version of .nomatch method?
  77. Hide/Show controls
  78. Access Data into Word - Number formats
  79. Dim Problems
  80. Looking for a new approach
  81. Date Question
  82. Parameter queries not working
  83. Hide/Show again!
  84. Node trees
  85. SQL Statement Wildcard
  86. Dlookup
  87. Beginner trying to set table values from VBA
  88. Using filter with VBA
  89. How to set the Orientation of the report in VBA?
  90. Returning String from DOS
  91. Detect Screen Res?
  92. Checkbox Problem
  93. *.csv file import problem
  94. Resetting AccessPwd in VBA
  95. calling a module located in a different database
  96. Prompt for a tick box to be ticked
  97. Double Key Coding
  98. List Boxes and Arrays
  99. Save As dialog box
  100. Trying to eliminate Redundancy
  101. display all recods in report
  102. Loop to all records in a recordset.
  103. Question for Pat
  104. Returning 8 records selected at random
  105. Call Shell
  106. Rounding percents up and down
  107. Rounding percents up and down
  108. Excel
  109. How to access data in a field in a table? ("Object required" error)
  110. New To VBA with Access
  111. powerpoint movement
  112. ODBC Connection Speed
  113. Deleting and creating table relationships with VB
  114. listbox to text box
  115. help
  116. Refresh the links of tables to the SQL server backend through code
  117. Saving data to a table
  118. Delete & Re-Create an AutoNumber Field
  119. Storing a SQL String Result into a Recordset
  120. Form
  121. Timed event???
  122. Procedure too large, what can I do??
  123. Recordsets as Parameters!?
  124. Just Plain Need Help
  125. doesnt anyone know the answer?
  126. SQL help
  127. Poplulate a blank field in a query at runtime
  128. SQL Statement
  129. Errors in saving to a table
  130. Urgent-Create Link in code
  131. Ordering record list in a child form (code supplied)
  132. SQL pass through queries with access 2000
  133. yeah
  134. Can I set a recordset from a query?
  135. Counter
  136. Is there a way to tell how many times a database is open by the user
  137. help with button code
  138. Having Trouble with Time format
  139. SQL Statement to Create Query
  140. Test for Open Recordsets
  141. database/VB error "Module not found" + more!
  142. Calulate with only to decimals.
  143. Module code
  144. Importing Excel 97 spreadsheet into an Access 97 database
  145. Scope of Recordsets in a Form
  146. using vba to synchronize my replica set
  147. Module for Design
  148. Can someone take a look at this code to relink ODBC table
  149. Date format problem using INSERT INTO
  150. Code for checking link to Excel workbook
  151. VBA- SQL Server ODBC in transaction
  152. changing textbox in main form from subform
  153. SQL Select / Delete
  154. Start up
  155. Code to create query with calculated fields
  156. assigning text.
  157. compile error when calling function
  158. SQL Delete Error
  159. I need some help with global variables scope, please.
  160. populate all records showing in a subform
  161. create a appointment in outlook
  162. Import several tabs on spreadsheet
  163. Using Dsum
  164. Calendar Control
  165. processing a text file currently being brought into MS Access via macros and queries
  166. problem using CurrentDb.Execute "qryUpdate"
  167. ADODB connection to another server
  168. access tables, modify, then re-upload data
  169. ACCESS XP/2000 PROBLEMS
  170. COPY OVER
  171. SQL Delete Syntax Error
  172. Another SQL DELETE Error
  173. Sendkeys
  174. Multiple Items From A List Box
  175. Removing Access Delete Confirmation
  176. Network DB error
  177. Selector Functionality
  178. Need help ASAP
  179. NotInList response
  180. Collapse Subdatasheet Using Code
  181. How to tell if other users logged in to DB
  182. VBA and databases
  183. Long Question, short answer??
  184. Please Help!! Need help with sending buck email from Access 2000
  185. Is Option Explicit needed?
  186. Multiple function calls within a function
  187. SQL Help
  188. Simple Code Problem
  189. VBA conversion
  190. Code for Combo Box
  191. AGAIN: User defined function in statement (Access97)
  192. Refresh Linked Tables button
  193. odd things when I delete
  194. Passing a null date into a function
  195. Sub Form
  196. Line Property Change
  197. Access stored proc..... and SQL server
  198. Too few parameter error (#3061)
  199. message box
  200. SQL & VBA
  201. Date
  202. Help with error trapping function
  203. If Statement
  204. I am still getting a too few parameter error
  205. An offering: The calendar control
  206. Graphing with VB
  207. Deleting Records
  208. Code Not Working
  209. Record Count in a subform?
  210. Graphing
  211. Single Record to Email from Form
  212. Extracting Data
  213. Enabling Text Boxes
  214. Exclude Criteria
  215. sub and temp query
  216. public vs dim
  217. messy screen during runtime
  218. TransferText Question
  219. Testing in vb to see if a query is empty
  220. Despertly needing code
  221. Formatting labels report
  222. Removing Characters From a Field
  223. Run-time error on Excel 2002
  224. Tab controls
  225. Referencing a value produced by a query in VBA
  226. query a const stored in a differnt database
  227. Using Between in code
  228. launcing/restoring an application from a form
  229. Need help with import .ECR text file created by foxpro to access 2000, Pls HELP!!
  230. Performing code with an onclick event
  231. Urgent help needed with VB code!
  232. Set DB to a different DB
  233. I need examples of VBA code with Cancel Event
  234. getting rgb values from a color
  235. Help with DCount (Not Getting Correct Results)
  236. New to Access/VBA
  237. MsgBox
  238. Report - ControlSource
  239. Copy Table to Another DB (UnLinked)
  240. Finding what User is logged into the computer or domain
  241. SQL date range dilemma
  242. Modules
  243. importing excel files
  244. Memo Fields
  245. IsValid Flag Using DCount Not Working
  246. Protecting a field on a form
  247. Make Access Ignore Regional Settings
  248. Accessing Specified Recordsets
  249. Docmd.RunCommand acCmdFind
  250. socket connection