View Full Version : Modules & VBA



  1. How to connect to text files via phone lines with VB in an Access module
  2. Save -> Refresh -> Print
  3. Determining through code if a field is unique (indexed)
  4. Date Function Help
  5. Running code that is OnClick on labels
  6. Mouse Wheel - GoToRecord
  7. Easy seek?
  8. Calculating Number of Days between two dates
  9. Combining Two Fields
  10. Printed?
  11. Who's still logged on?
  12. Outlook Personal Folders
  13. Code to open report from Combo box
  14. Problem with Inputbox
  15. Counting records ... too slow...
  16. Run-time error '-2147417851 (80010105)':
  17. Exit db Then Re-Open On The Same Frm
  18. ADODB connection Query error
  19. Line Number and Error Handling
  20. ID Primary Key in existing TableDef
  21. webforms
  22. Problem with form when used as subform
  23. Using Functions
  24. Copy a Recordset
  25. Runtime error 800401e4 (Invalid SQL) in Windows XP
  26. ODBC problem
  27. If statement problem
  28. Report field conditional format
  29. Backup
  30. Conditionally Set an Object Variable = Nothing
  31. Paste to Outlook Calendar
  32. problem merging Access to Word
  33. Function Behaves Differently In Module
  34. Extracting Info from Excel
  35. Extracting a sub string from a main string
  36. IE button
  37. Run-time error '3075' on search form
  38. Designing form at runtime including spacing controls
  39. New record line in subform to repeat field from previous line
  40. Adding Records
  41. get list of custom procedures
  42. CSV importing : need your help !
  43. Adding Records via Module
  44. creating a report thru the click of a button on a form
  45. Retrieve message when user resizes Access' mainwindow
  46. Calculate Date
  47. Names of computers on network.
  48. Using saved Outlook Template
  49. More ODBC Nightmares and Migranes
  50. Record Exists?
  51. Code to find max value of a field
  52. function to return Date/Time
  53. formatting a report
  54. Colour Change on wrong data
  55. Access 2000 ADO query under Windows XP
  56. connection with current db
  57. Can't Open A RecordSet - Please help!
  58. "you cancelled previous operation" problem
  59. Loop in an arithmetic addition statement...
  60. Set toolbar text font
  61. Small problem with the following code.
  62. Sending Data to excel for graph
  63. Incredible Bloat
  64. How to open OLE object using VB module
  65. Dmax & todays date
  66. Use Dynamic SQL in TransferSpreadsheet
  67. Counting the number of controls in a sub form!!!!
  68. Access 97 custom toolbars/menus
  69. How do I determine if user is logged onto the lan?
  70. Can I use a Do...Loop
  71. Just what is it about checking for Null !
  72. ADO connection to SQL Server
  73. Is it just me????
  74. recordok
  75. VBA access to OpenQuery result set
  76. Need to programatically link front end to backend data
  77. Field Validation
  78. Validation in VB
  79. Need help with VBA SQL
  80. Outlook sent items
  81. Same stupid error message...search command
  82. Urgent: Link to ODBC Visual FoxPro with Free Table Directory
  83. How to start a combo near the right place
  84. Result set access in VBA
  85. Navigation bar error message
  86. What is wrong with this filter code?
  87. Data Type Mismatch
  88. Startup Menu code
  89. Copy string to clipboard
  90. format to mmm-yy
  91. Export Query Results to Email Message
  92. Transfer problem
  93. Date field export - include 0 in month and day
  94. Trying to Convert Text String to Numeric
  95. Is possible to parse memo fields using VBA?
  96. First User-Defined Function
  97. CREATE TABLE query doesn't support some field types
  98. TransferSpreadSheet Without File Save
  99. Option Group Reference
  100. Long Winded?
  101. Code to make sure there is no.ldb file
  102. set orderby property for a table
  103. File Properties...
  104. Getting _Global Error
  105. Close an application that's openning via Access code
  106. Close any application from Access code
  107. Edit MultiRecords from Listbox
  108. Exporting to text file
  109. "Overflow" message at startup
  110. SaveSetting and GetSetting - How?
  111. filling a field automatically
  112. Automatic Sum for Different Objects
  113. Conversion to 2002
  114. How can I tell if Excel is installed using Access 97 VBA?
  115. Input mask question
  116. CREATE TABLE (sql) in another db - possible?
  117. Timer Code
  118. ACCESS 2000: Error Calling Sub using eval
  119. Confirm you wish to close - is it possible?
  120. Please help!!!
  121. Bad DLL calling convention
  122. Table manipulation using VBA
  123. Access 2000 E-mail Question
  124. Dealing with Null values in filter
  125. sortlist project
  126. Save outlook attachment to sub folder not working
  127. Getting Rid or Surpressing of a Warning Message
  128. checking for duplicates
  129. Making a Event after a specific date
  130. recordset problem?
  131. How can I read files in a folder...
  132. Before I start to code....
  133. complete beginner in writing codes
  134. Emailing Attachments
  135. accepting input from 2 check boxes
  136. A2K errors with XP upgrade
  137. Simple Line, Fatal Crash
  138. Insert data from other database to current database
  139. Static Variables
  140. DTPicker help
  141. FileCopy Problem
  142. Dlookup domain variable
  143. Using Listview like listbox?
  144. Report in Email body
  145. Change properties of Continuous form
  146. checking a Null entry for a form
  147. Number of rows iin a query exceeds 65,000 allowed by Access
  148. Weird Count
  149. RunSQL in VBA not working
  150. Access 2003 Runtime (Developer Edition) - startup errors?
  151. Dynamic Query creation problem
  152. "OR" criteria in subform link?
  153. Search Form
  154. Verify Outlook Message Sent
  155. Directory Stucture
  156. Loop through table - how?
  157. cmd button to find record
  158. Display data from text file using VBA
  159. Date Modified?
  160. How to open a serial port?
  161. Help with Date Code
  162. Moving from Macros to VBA
  163. I thought I was geting the hang of this SQL stuff
  164. Access to Excel-SaveAs + password
  165. in event builder... inv cosine help...
  166. randomisation help for a total beginner
  167. Show Shortcut menu on LeftClick
  168. randomisation help - a new problem
  169. should I use VBA? transaction like input
  170. ftp batch file problem
  171. Problem with Date Parameters in Recordset
  172. Find a specific record problem
  173. been stumped on this one for days
  174. Has update query affected any records
  175. Cursertype and Lock Type with Recordsets opened from command
  176. Moving files with a certain extension...
  177. Add and delete fields using VBA
  178. Parsing Memo Fields using VBA
  179. Out of Memory
  180. copying table data within same table
  181. Syntax Problem
  182. Overflow - error 6 ?????
  183. Excel Import Question
  184. whats wrong with this code??? :(:(:(
  185. not going through the table
  186. Date & SQL problem
  187. Rename and move file to an existing folder
  188. Fast help needed for Access2k/Outlook2k Code.
  189. whats going wrong?
  190. Automating an Outlook Meeting Request
  191. AfterUpdate not working
  192. Calculated value not updated on right click filter
  193. Query Results as Variable
  194. executing an equation stored as a text
  195. Sql/query Help
  196. Toolbar item disable
  197. Calling a sub in a different form in VBA
  198. Set forms recordset to a disconnected ADO recordset
  199. Execution cancelled --ODBC--
  200. Check if field exists - SQL
  201. Numeric in a string
  202. Remove Filter Event ?
  203. Form as Message Box - Button Pressed
  204. If Statement
  205. Exporting Data
  206. Creating Dynamic Forms
  207. Giving a field a value from the database
  208. Type Mismatch Error
  209. Name Splitter Problem
  210. get currentuser but how get password?
  211. Multiple Criteria DMax?
  212. Need MouseWheel.dll from MS KB278379 Article
  213. Get UMT Offset Based on Local System Settings
  214. Insert Record: Past dates only.
  215. Custom Index
  216. Failed Email Using Outlook
  217. Update record as labels print
  218. Referencing forms with a space in the name in VBA
  219. Open Table Selected in ListBox
  220. Store Multiple Booleans in an Integer
  221. RunSQL - Syntax Error
  222. Creating Function
  223. Need To Filter Graph To Only Show Current Month
  224. I know RunSQL is for action query but is there....
  225. Sql
  226. Create Excel Worksheet thru Access VBA
  227. Fetch files from Internet
  228. Error Messages when creating VB script
  229. Need help with code to prevent mde from running twice
  230. How to determine error raised in sub
  231. Simple Question: Repeat Module
  232. pkzip problem
  233. Backing up database
  234. Programatically add image control
  235. cant get past error 3251 for .findfirst
  236. Access can't find my code ???
  237. Remove Access Prompts
  238. Function returning expression.
  239. MS Access getting records from a table
  240. Error accessing file. Network connection may have been lost
  241. How to test if subform has focus
  242. Copy data from another database
  243. Populating Listbox Using VBA
  244. list filenames without path
  245. List of Printers
  246. Can I borrow your Module? Please???!
  247. Accessing query results with VBA
  248. FindFirst for multiple criteria
  249. Changing links with code
  250. Comboboxes and regional settings