Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Shaz1
  • Content: Threads
  • Order by date
  1. Shaz1

    using audit code for more than one form

    Good Morning, I currently have working code which stores changed information into a table. This code uses an autonumber [EquipID] field that applies to an EQUIPMENT table. Now I would like to include the code for other forms with another autonumber field [DwgID]which updates the changes from...
  2. Shaz1

    Audit Trail

    Hello, I have no experience with VB or programming. I have copied some code from Candice Tripps link which is called Audit trail. I've added the modules as she shows in her example database and modified to suit. What I would like to do is on the form after a new record is inserted copy user...
  3. Shaz1

    Identifying Revisions In a Report with Bolding

    Hi all, Does anyone have any suggestions for a recent new user? In Access 2000 I am designing a report to show revisions or changes. Example: Multiple revisions of a record added to a table with different revisions (A, B, C ect;) In the report I need to print the the latest revision...
  4. Shaz1

    Finding Unused Tables

    Good Morning! I was wondering if there is a quick way of finding out which tables are unused or not used as a control source in any of the modules of a database. I have many, many Queries, Forms and Reports that have been modified on a frequent basis by many users. I was wanting to clean up...
  5. Shaz1

    Form/Subform on a split database

    Still stumbling....... I have a split database with several forms for user data input. In trying to create a new form with subform found that there weren't any relationships. Re-created the relationships so I could create the form with a subform data from two tables. The option (Form with...
  6. Shaz1

    Admin User - Unknown

    Hi there any help with this would be greatly appreciated. A workgroup was created on my database, Admin user disabled and database was not backed up. Ooops+@#!! I've created a new database and imported all the tables, queries, macros, pages and modules. Unfortunately, I was unable to restore...
  7. Shaz1

    Show List of Multiple Reports to Print/Preview with Command Button

    Hi, I'm looking for some help on showing a list of reports with the click event procedure of a Command Button. Code Used:Private Sub Preview_Report_Click() On Error GoTo Err_Preview_Report_Click Dim stDocName As String stDocName = "R-Equipment List" DoCmd.OpenReport stDocName...

Part and Inventory Search

Back
Top