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 Wanet Telecoms Ltd 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: bookenz
  • Content: Threads
  • Order by date
  1. bookenz

    Setting up user heirachy, security

    I am creating a Data Base for a customer management system. It will allow users to log customer requests. It will have multiple user access. Users belong to teams (eg. Team 1: Accounts payable; Team 2: Accounts recievable; etc.). I have a table called "tblRequests" containing: 1. Request ID...
  2. bookenz

    requery a control in a subform

    I have a yes/no control in my form called "RequestInitiator" linked to: "tblRequests.Request_Intiated". "tblRequests.Request_Intiated". is default: "no". At the start of a new request, some code turns "tblRequests.Request_Intiated" to "Yes" when the request's date & time are set. in the...
  3. bookenz

    Setting the recourd source of a subform

    I have a form named "frmCustomerRequests" which contains a sub form: "subfrmRequests" (linked via Customer_ID). On "frmMain" I have 2 command buttons 1. "Display All Requests" & 2. "Display Open Requests. The coding for "Display All Requests" is as follows: " Private Sub...
  4. bookenz

    Identical forms that use slightly different subforms

    Howdy all. Pertaing to a customer requests DB I am designing. "frmMain" form lets the user select a customer from a combo box. Then user either clicks command button: "Display All Requests" or command button: "Display Open Requests". When user selects "Display All Requests" the...
  5. bookenz

    Adding an item Not in list combo box and calling a query

    This pertains to my "Customer Management" DB. I have 2 tables: tblCustomer, and tblCompany. and 2 forms: frmCustomer, and frmAddCompany In frmCustomer I have a combo box called cboCompany. cboCompany requires the user to select a company (the company that the customer belongs to (row source...
  6. bookenz

    Not In List event procedure that creates a new record.

    This pertains to my "Customer Management" DB. I have 2 tables: tblCustomer, and tblCompany. and 2 forms: frmCustomer, and frmAddCompany In frmCustomer I have a combo box called cboCompany. cboCompany requires the user to select a company (the company that the customer belongs to (row source...
  7. bookenz

    Creating a query that returns the last record in a table

    I want to create a query that returns the last entered record in table. How do I do this. Not sure how to use "Max" in query design.

Part and Inventory Search

Back
Top