Results 1 to 5 of 5
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Switchboard Queries (97-->)

    For some reason I feel embarrased asking this question as I teach Access!!!

    When I create databases in Access I have always steered clear of the Switchboard manager because I find it cumbersome but I was approached by a colleague in another department who is setting up a test for an interview for job applicants.

    He wants to get them to import an excel spreadsheet of data(easy) but then get them to create a switchboard which in his words:

    The buttons are to run queries that show:
    1 - Order number : Address : NMO : Issue : Work Done : All invoices Dated June 2001.
    2 - Order number : Address : NMO : Issue : Work Done : All invoices Dated July 2001.
    3 - Order number : Address : NMO : Issue : Work Done : All invoices Dated August 2001.

    Now I am reliably told that you can run these queries from a switchboard. I for one wouldn't do this as I would create a Reports reporting form running parameter valued queries but this is what he wants. For the sake of this exercise lets call the table tblOrder and the fields Address, NMO,Issue, Work, InvoiceDate.

    I am probably being thick here but I can't work how to do it with the Switchboard manager, can you help please?
    Jerry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Switchboard Queries (97-->)

    The Switchboard Manager does not offer an option to open a table or query, since the Switchboard is meant to be used by end users, and end users should never work with tables or queries directly, only with forms and reports.
    But if it is really necessary to open a query, it can be done as follows:
    - Create macros or VBA functions that open a query using the OpenQuery action (DoCmd.OpenQuery in VBA)
    - Create new switchboard items that run the macros or VBA functions (Run Macro and Run Code are the last two options in the Command dropdown list for a switchboard item)

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Switchboard Queries (97-->)

    Thanks Hans

    I knew I wasn't going mad...but I had to check. I think I need to get this clarified by the author and see exactly what he wants
    Jerry

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Switchboard Queries (97-->)

    Problem resolved

    After checking with colleague it appears that I had made assumptions that he knew the difference between a table, query, form and report....he didn't! He now wants a report instead of a query

    My fault for assuming and not checking, lesson learnt
    Jerry

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Switchboard Queries (97-->)

    Ah, who can tell the difference, they're all the same, aren't they? <img src=/S/innocent.gif border=0 alt=innocent width=20 height=20>

Posting Permissions

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