Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2009
    Posts
    2

    Unanswered: Multipule Appointments

    I have created a DB sor a small shop, it has many technicians, I have found out how to create appoints for a customer that this is only for 1 technician. Is it possible to have a drop down list shere I can select who's appointment diary I want.

    Any help would be great

    Thanks

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    You'll need to supply a bit more information to get an answer (ie. what do your table relationships look like, how do you have the forms setup?)
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Is it possible to have a drop down list shere I can select who's appointment diary I want.
    Yes.

    Everything is possible, it only depends on how much time/effort/money you want to throw at it!

    Specifics? Not a chance, as PK said, you need to provide a lot more details -- help us to help you!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Quote Originally Posted by cheryl_uk(via PM)
    Is it possible to insert an external excel workbook into a DB which would get over my problem of multiple appointments as I could have 12 sheets and then monthly dates an individule thechnicians. Can this be done by maybe a Hypelink.

    Thanks Cheryl
    Yes.

    You can quite easily link to an external file. All you need is a path to the file to open, stored in your database.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •