PDA

View Full Version : Microsoft Access VBA Modules

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 [51]
  1. Attach a PDF or JPG file to an Email
  2. access 97 module for dde
  3. Page break problem with sub report
  4. VB String Function$
  5. ERROR: ByRef Argument Type Mismatch
  6. Pass Field Value and Loop (Urgent Help Need)
  7. kick users out !
  8. inserting an rs into a table
  9. query
  10. Returning a single value to a variable from a recordset
  11. JET 4.0 sp7 breaks old vba code!
  12. KeyCode to ASCII code/character
  13. Re: Check if a table exists using VB
  14. Unbound forms in access project
  15. Unbound forms in access project
  16. update right away
  17. common dialog
  18. Re: Check if a table exists using VB
  19. Re: Retained Breakpoints
  20. Re: Detecting networked BE file
  21. Record sets reading from tables for functions.
  22. Re: CallByName from commandbar control
  23. Re: Disable mouse wheel in code?
  24. Re: Disable mouse wheel in code?
  25. Error 49 bad DLL-call
  26. Re: Can VBA Detect Data Integrity Violations?
  27. Re: Active X Control Licience
  28. Automatically insert a row in a table
  29. Data source fail-over
  30. Declaring a database ?
  31. how to chopp off two final comma
  32. Why Report fails to open ?
  33. How to make a Form/Report open quickly ?
  34. Re: stringTokenizer in VBA???
  35. Re: replace function
  36. Calling a function in opening a form
  37. Re: query (Repost)
  38. Re: the use of .Pattern in access
  39. passing arguments byref in VBA
  40. Padding zeroes to a decimal field
  41. Re: Delete Records
  42. RE: Update Statment
  43. Re: Detecting networked BE file
  44. Re: Adding subtotals in a child form together to appear in main form
  45. Assistance requested with reproducable GPF in Access 2002
  46. Re: Append query using DAO
  47. Export to text file with Trailer Record
  48. Need to Pad Zeros
  49. VBA Code in a Module not recognized
  50. Code to duplicate tables
  51. Re: Pre-defined formats
  52. Re: Can VBA Detect Data Integrity Violations?
  53. Creating, naming and browsing for location of save of new excel file
  54. Exporting multiple reports through VBA
  55. TransferText to mailmerge file doesn't work
  56. Pre-defined formats (Repost)
  57. How to get full path to linked tables
  58. Re: Pre-defined formats
  59. Windows Logout
  60. Opening Non Office Files
  61. Where Clause in OpenReport Method
  62. Re: String comparison, percentage the same?
  63. Export a report
  64. Green Eggs Report
  65. Use of .LEFT property
  66. update SQL
  67. Re: query
  68. Inserting data from Access to an EXCEL spreadsheet
  69. Make big bucks easy
  70. Deleting a report's recordsource
  71. MDB File Version - NOT Access Version
  72. How to change printer via VBA?
  73. Re: Set Form = Recordset
  74. Read-Only linked tables
  75. Re: FIND/REPLACE DIALOG
  76. Close Database
  77. Recordset Source
  78. Suppress SQL Login Failure dialog?
  79. Re: Tab control
  80. Run Macro
  81. DAO record size 2K limitation in Access 97
  82. Access MDB Version
  83. Re: Deleting an Open Database Object
  84. Set Form = Recordset
  85. Re: commenting large sections
  86. Backup Button on Desktop
  87. Calculations with time values
  88. Visual Basic Out of Memory
  89. ! Recordset Close !
  90. A file Word within a field
  91. "...pending changes exceeds limit."
  92. Re: form properties - which ones to use?
  93. Re: Sending Outlook Email In Access 2000
  94. MS ACCESS Switchboard Runtime Error 3001
  95. adding data to two tables simultaneously
  96. delete/update record
  97. How can I get the username from workgroup information file.
  98. Export to queries to Excel
  99. subForm allowedits problem
  100. Stopping the escape key being pressed.
  101. Re: Validation Rule
  102. drawing functions in VBA?
  103. Re: deleting queries
  104. Path property
  105. Export multiple tables to Excel
  106. problems when adding field properties via dao
  107. Where is Table 'Hidden' Property?
  108. How can I change the appearance of a field if certain conditions are met?
  109. Dynamic Crosstab Report in Access 2002
  110. Module linked to table
  111. Re: send an e-mail notification
  112. Linked tables
  113. why does macro menu come up when one runs a module
  114. Re: "file already in use"
  115. Microsoft Windows Common Control 5.0 (SP2) not working in Ms Access 2000
  116. Access 2000 Recordset issues
  117. Text Box Search for Inside a Database
  118. Triggering events just before close of database?
  119. Generate a calendar in Access
  120. Code for picking out file names in directory listing
  121. Adding ActiveX controls to Access
  122. Referencing a query in CurrentDB
  123. Re: What Does This Mean Please?
  124. Assuring that update by "database.EXECUTE sqlQuery " was done
  125. Re: What Does This Mean Please?
  126. What Does This Mean Please?
  127. How do I make the program to wait?
  128. Override system error with own message
  129. Opening a Secured mdb with Automation
  130. money - try it!
  131. Code to delete table if it exists
  132. Question re: code text
  133. ! DAO Equivalent of DMax !
  134. ms access 97 vba collection.item(strKey) gives error 3021
  135. Re: Converting Foxpro to Access
  136. Re: deleting queries
  137. Re: deleting queries
  138. Code for Creating Table
  139. Re: VBA, Access, and Letter Case
  140. Delimiter
  141. Re: send Eudora or MAPI email from VBA
  142. So close...please help!
  143. VBA data connections within a function
  144. Windows API SendMessage
  145. Email Word Document in Access
  146. /wrkgrp Command Line option
  147. Cannot expose a class
  148. Where is Access going?
  149. send email with attach file
  150. Listbox need help
  151. Finding most recent record
  152. Unrecognized Database Format
  153. Re: #Error only on two machines
  154. Pass-Through Query
  155. Autokeys
  156. Open Outlook from Access
  157. Re: VBA, Access, and Letter Case
  158. Exporting MSFlexgrid to Excel
  159. Refreshing Treeview Data
  160. Fax document within Access
  161. Re: exporting date data type to text files
  162. Re: Convert Access Database to Visual Studio
  163. Open Access Application
  164. Querying a website using URL
  165. Re: Converting Foxpro to Access
  166. Print report for each record in database
  167. OutputTo Excel Using Filter or Recordset
  168. Re: send Eudora or MAPI email from VBA
  169. Calculate rolling 12 mo period
  170. Access does not close
  171. Module for Showing Error Message in Query
  172. Visual Basic error message
  173. Error Executing the command
  174. Checking for Network Connection?
  175. Re: Setting CurrentUser to %USERNAME%
  176. Re: Access/Outlook
  177. Updating table in outside database
  178. When to Dim, Private or Public
  179. supress the decompile msgbox
  180. Re: pass a value to a query
  181. How to suppress the delete confirm box and go on?
  182. Data Validation
  183. Re: Count number of Users
  184. import excel function for use in queries
  185. Controlling keyboard actions
  186. Updating table in outside database
  187. Using variable as recordset field name
  188. Modifying the path to linked OLE Objects
  189. Access closes app but process remains open
  190. CASE statements using wildcards
  191. Transpose data
  192. VB Code for Copy/Paste
  193. Generate Unique Passwords
  194. Compile Error: Can't find project or library
  195. Re: If an object exists then...
  196. Building MDE Programmatically
  197. Re: Meaning of [<Non-Basic Code>]
  198. Type Mismatch
  199. How to Draw Line on Last Record
  200. Re: .wav files
  201. Re: display query with code
  202. Re: AllowShiftByPass
  203. Re: Column Width
  204. Find on a field that contains quote(2)
  205. display query with code
  206. Find on a field that contains quote
  207. Validating form
  208. VBA PASSWORD HELP
  209. Recordset only returns first record, when Query SQL returns 51 records
  210. printsize vba
  211. Re: Source for VBA syntax help
  212. question on class modules
  213. ADO: Tweak Field Properties
  214. Exporting Email Addresses from Access to Outlook
  215. Form's BOF?
  216. Object not defined Runtime error
  217. Re: Open a Database send userid and password
  218. Line Method
  219. Sometimie Error Message
  220. Pause code for 2 seconds...
  221. Re: Find Out Location of Access.exe File
  222. import multiple files
  223. Size of string
  224. replace function in Access 2000
  225. Hyperlink
  226. Error trapping fails in XP
  227. after_Update problem
  228. Re: Recordset has only one record?
  229. Untrappable error
  230. usa ghost!
  231. Table Description
  232. Problem w/ references
  233. windows xp home edition in windows network
  234. Force MS Graph to retrieve records
  235. Change field format with VBA
  236. Len(str)
  237. Deleting records.
  238. How to read a Word Document from Ms Access
  239. ! Checking for value in Textbox !
  240. Unknown Function Name when calling VBA function from a query
  241. ! DAO Record Locking !
  242. Recordset contains only one record - should contain more
  243. Search 'current procedure' reverts to module-level search
  244. Re: Printing Report
  245. DOS Command Line Syntax
  246. Detect Version of Access
  247. Camera Sale -Nikon , Canon, Minolta , Sony ,Xcam2 , Fujifilm ,
  248. Restore Form
  249. Returning database location/path
  250. Calling functions on a Form Class Object from a Module
  251. add record to subform
  252. FileSystemObject
  253. Slow database on Network - Large Front End
  254. Convert Hex to Number
  255. Question???Querydef
  256. Re: Can't import through VBA
  257. Variables and passing between forms.
  258. Search Files
  259. Duplicate the Zoom feature
  260. Can't Update Table
  261. yetqwyrt
  262. Publish to PDF
  263. EARN EXTRA CASH!!
  264. Re: How to empty out a date memvar???
  265. Screen Updating
  266. Re: How to stop Access from changing class names
  267. Re: Missing references won't go
  268. Re: How to empty out a date memvar???
  269. Re: How to stop Access from changing class names
  270. Re: How to stop Access from changing class names
  271. Repeated data count in form entry???
  272. Adding calculated field to crosstab query
  273. Re: db.execute action query created in QBE
  274. Re: db.execute action query created in QBE
  275. Re: Creating a New Form
  276. Re: exporting multiple tables to single excel sheet
  277. Coding
  278. How to run an external batch file
  279. Binary To Decimal Conversion
  280. Binary to Decimal Conversion
  281. Re: db.execute action query created in QBE
  282. missing DAO350
  283. how do I detect if a field is an autonumber field?
  284. MSFT Access Geneology template problem
  285. Re: DLookup with multiple search criteria
  286. JPG files
  287. Adding items to a shortcut menus via VBA
  288. Date()
  289. Re: Adding Record when form source a query
  290. Re: DLookup with multiple search criteria
  291. fiding specific data
  292. Counting Consecutive Hours
  293. Cursor Always moves back a character after space
  294. Call Stack.
  295. copy/paste
  296. How to code for different versions!
  297. Serial ports
  298. Run -time error '13': type mismatch
  299. Re: fiding specific data
  300. Help with code to generate primary key
  301. Point of Failure in Procedures
  302. Use a Report to print VBA results
  303. auto send report
  304. Re: capture keystroke
  305. Re: Delete table from closed database (Urgent help need)
  306. Re: field properties
  307. Re: .mdb file just keeps growing
  308. ADV: Free games for life
  309. OT: New reporting tool
  310. Access Shell statement
  311. How to insure a loop finishes before closing the procedure/app
  312. Re: SQL Sum function not working in vba
  313. Oracle 9.2.0.2.0 ODBC link
  314. Re: How to put Date from Table on reports
  315. How to put Date from Table on reports
  316. Re: Missing references when opening database in XP and 2000
  317. MS Outlook 10.0 Object Library Question
  318. "Staring" an input box
  319. Re: Unusual Compile Error
  320. Open a seperate database
  321. Urgent help, RIGHT JUSTIFY leading zeros
  322. Accessing table and/or form fields from VBA
  323. Re: Delete content of the clipboard in VBA
  324. Query output with criteria to another Office application
  325. Re: timeout
  326. Trim Function
  327. Using the My! keyword???
  328. Re: running sum in a form
  329. Pulling value from table using VBA (ADO)
  330. DISABLING THE REPLACE TAB IN FIND/REPLACE DIALOG
  331. how to programatically add a refernce
  332. Unrecognized Database Format in VB6.0
  333. Can a database expose a class?
  334. Re: Option Compare Database
  335. creating a stand alone application from access
  336. Re: How to use Save as Common Dialog box in Acces
  337. Print dialog box in VBA
  338. Re: How to verify if a table exists
  339. Checking for NoData in Report
  340. OutputTo method hangs
  341. Re: How to verify if a table exists
  342. HELP: Problem with exporting Access Report data to Excel
  343. Clipboard
  344. Database won't work in Runtime Version
  345. Tabbing through a Form
  346. How to save username and password to login to Orcale database
  347. Declaring an setting a "public" variable
  348. HELP: Using FileDialog within Access 97 - TIA
  349. linking database to network login
  350. Re: Commenting Out Code in Bulk
  351. Update hyperlink in VB
  352. Re: Connecting Access db to a mysql server
  353. Run time errors
  354. Calculation problem fromSQL
  355. Can I make a sub form pop up/modal
  356. Trim Function
  357. NoData Report property
  358. Loop
  359. Re: SytemRoot
  360. Opening a standard 'File open' dialog box.
  361. Table of Contents Report
  362. Coding in Access
  363. save current record in VBA code
  364. Programatically identify Access version
  365. EOF
  366. Slow Performance of VBA Code
  367. Coding in Access
  368. DNS
  369. Function results not read by others
  370. OpenRecordset on Linked Table
  371. Suppressing Error Messages
  372. Re: Copying Info in Form
  373. Re: Error Accessing File. Network Connection May Have Been Lost
  374. Error Accessing File. Network Connection May Have Been Lost
  375. Re: Open a form in a specific mda library
  376. Re: Using FileDialog within Access 97 - TIA
  377. Re: Using FileDialog within Access 97 - TIA
  378. recording outside data
  379. Re: OpenRecordset
  380. Using recordset with outputto?
  381. Compiler error at "ConnectDb"
  382. Open another instance of Access
  383. ImageList Control
  384. Errors
  385. Re: access/word/vba
  386. Sum in Query Values
  387. trolling for spam
  388. Recordset as Form's Recordsource
  389. Access Query Result from Another Program
  390. Runtime on winn2000 sp4
  391. Need help with QueryDef
  392. Tool Tip Formating
  393. Re: Find Directory
  394. CurrentProject.Connection
  395. Functions
  396. Access memory leak?
  397. Re: Problems with arrays
  398. Computer name in vba
  399. VB and Access
  400. Expert needed: Passing textbox contents to new form
  401. Re: Problems with arrays
  402. ACC2000: Requested type library or wizard is not a VBA project
  403. split a variable or extract part of it?
  404. VBA diagramming tool?
  405. Problem with an updating query in a VBA of Access 2002
  406. SaveAs with default filename
  407. Code to refresh Excel PivotChart and PowerPoint
  408. Assigning returned SQL to Variables
  409. Change background color
  410. Re: Query filter
  411. Searching RTF docs for values
  412. Puzzler-ranking
  413. Field Comparison
  414. Function to Sum Values With Same Characteristics
  415. Re: Editing a Word template from Access VBA
  416. Re: Help with VBA
  417. Re: Replacing control characters (' and ") in strings for INSERT statements
  418. Re: FAST reattach tables
  419. Re: Replacing control characters (' and ") in strings for INSERT statements
  420. Re: Replacing control characters (' and ") in strings for INSERT statements
  421. Re: Add column to existing table
  422. Re: A table to auto. update
  423. How to get rid of a message box that keeps popping up
  424. set focus to subform?
  425. Put Data to a subsquent new record?
  426. Broken Application.CurrentProject.Connection
  427. Why doesn't this VB code compile?
  428. Query in a Recordset w/Filter
  429. Wanna buy a Cigar?....
  430. Overflow error in Debug window
  431. Private DBEngine Problem
  432. How create a Word Document from Access?
  433. Check Directory (Urgent)
  434. Re: module not found, access forms
  435. Get data from main form?
  436. Northwind example does not work? (!)
  437. Qualify DAO referance
  438. Deleted the form - the module's still there. How do I get rid of it?
  439. Re: using outputtable to export select fields
  440. Deleting Records FROM VBA
  441. concatenating files
  442. Re: Setting recordsource for combobox
  443. Updating a table with a query
  444. Re: Which button was clicked in detail area of endless form
  445. Printing Reports
  446. Problems calling HTMLHelp from Access 2000
  447. Setting recordsource for combobox
  448. create a dynamic form
  449. The Daily Warezfaq - Thursday Edition QYPXVNNKC
  450. naming convention
  451. date functions
  452. backup
  453. VBA Password and Importing
  454. Re: How to loop through all keys of a collection?
  455. Re: Need HELP with Access97 RunTime
  456. Stand alone app
  457. Converting RTF eventually to Access
  458. automation in sending an email
  459. ftp file automation
  460. Re: => Loading Option value based on Form Query
  461. Sum of a Field
  462. SubForm - Data Entry
  463. look up record on form using set criteria from another form
  464. How to retrieve data from a password protected website/ftp = HTTPS
  465. Passing Arguements to a function
  466. Networkday Function
  467. Public Function Q
  468. accessing to tables in db2
  469. => Clear Text boxes on Master Form and linked SubForm
  470. Pause code
  471. => Clear Text boxes on Master Form and linked SubForm
  472. How To Set Time On Outlook Task
  473. code module stoped working
  474. => Display a bit value as a Text 'Yes' or 'No' on a form
  475. Hiding the Formatting (Form/Report) toolbar
  476. can't find word97 object..
  477. Autonumber after huge record deletion
  478. hWnd Property Help Example gives Run-time error 2475 in Access but not in VB6
  479. Code Corruption Problem
  480. Re: How Do I Run This Random Selection Code
  481. Date Time Picker
  482. Compile error in a sub when converting to 2002
  483. Call a msgbox on a specific error
  484. Public Variable Question
  485. How can get Access to work with 2 Word Documents at the same time?
  486. Re: html help links not available
  487. Movefile method
  488. Please help with this function
  489. Help Files
  490. Access XP -> 97
  491. tracking
  492. Using ME keyword to close a form
  493. Cycling Through Records in a Table
  494. SMTP Email
  495. sharing Modules
  496. Re: Index of a combination of two fields
  497. Overwriting queries in code
  498. Change Registry Setting? (MVP)
  499. Createing a table through code
  500. Re: Code Corruption Problem
  501. Array Dilemma
  502. Weird Data Type Error
  503. Re: path to back end
  504. Finding open Excel workbooks from Access.
  505. Re: Why does the Recordset not contain anything?
  506. RST After the Query
  507. Error on Modules
  508. Table level validation
  509. Converting Access to SQL Server backend - How do I control linked tbl ODBC Cxns?
  510. Re: Why does the Recordset not contain anything?
  511. 2002 to 2000 compatibility--help please
  512. Query Problems for Recordset
  513. Dlookup doesn't work
  514. using query in modules
  515. Add text to the beginning of an existing string
  516. Open embedded object problem
  517. ADO .Open problem (posted on general news too)
  518. Expressions in Queries
  519. Can't compile databse - why
  520. pull down menu in Access-VBA
  521. Re: Why does the Recordset not contain anything?
  522. Ms Access 97 created Username and Password on the Network
  523. Re: Mail Merge
  524. filecopy function
  525. receive returned value from doCmd.openquery
  526. Re: receive returned value from doCmd.openquery
  527. Re: Converting VB Code from Access 97 to Access 2002 or higher
  528. Re: Changing value of a function in a module
  529. Re: How to draw a line every 5 lines
  530. Getting a file name
  531. How to draw a line every 5 lines
  532. Re: code module stoped working
  533. Inserting a record, error message appears.
  534. Conditional Formatting
  535. Append Query Message Box
  536. SQL
  537. reading from a table cell?
  538. Where's the Recordset..Edit
  539. Re: Format Spreadsheet When Using SendObject
  540. Alternative to Vlookup in Access 2002
  541. Insering a record using VB
  542. Adding a record to a table
  543. Re: Exit Database On Timer
  544. Re: Exit Database On Timer
  545. RepairDatabase
  546. IF statement and tables in VBA
  547. selecting in listbox with vba
  548. Questionnaires-Scoring
  549. Provide VBA Password Programmatically
  550. Re: How to wiat (need code)
  551. Accessing tables via VBA
  552. Re: read-only access to a database
  553. Re: Compact Database
  554. Recordsets and mail merging
  555. RE: defining ADODB.xxxxxxxxxx
  556. File Location
  557. Trouble removing Class Object from Code Editor in Access
  558. barcode integration help please
  559. Re: defining ADODB.xxxxxxxxxx Type
  560. Invalid use of object with .Find method??
  561. Re: Problem Removing References
  562. Re: Access crashes after creating Outlook/Word document
  563. Automating Excel to remove VB Code.
  564. Re: Geometric Mean?
  565. email message options
  566. Referencing Form Controls from a Module
  567. Solver functionality?
  568. Error 430, Class does not support Automation, Windows 2000 sp4.
  569. Re: Converting seconds to time format
  570. computer name
  571. Stop Multiple Instances Of Program
  572. HOW I BECAME WEALTHY
  573. Re: Append Query in VBA
  574. Re: Difference between trim and trim$
  575. Re: How to wiat (need code)
  576. Re: Ceate Email in code message (using MAPI?)
  577. Re: Q: how do I interrupt a loop when click a CANCEL button on a form?
  578. Re: Problem with NotInListEvent (ignore previous posting)
  579. Re: How to refresh the list of modules
  580. Viewing HTML preview on a form
  581. Re: How to Keep Access Open
  582. Re: COPY FILES
  583. Dirty Event
  584. type database doesn't exist?
  585. Re: protect password
  586. Re: How to Keep Access Open
  587. Quick Question - acOpenForm
  588. Re: How to Retain Data In Form
  589. Re: Adding progress meter in my import procedure
  590. Re: Clock or timer
  591. Output to a fixed-width text file