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 Westi 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: *

  1. mgargUWBC

    run multiple queries in order with same parameter

    Hi! I've got a situtation and I need some advice on. I have a "set" of 15 delete queries that need to be run in a specific order. Each of the delete queries requires one parameter and it is the same parameter for each query (an ending date). I can run the queries in order, but each query asks...
  2. mgargUWBC

    linked forms - which form called this form

    THANKS! PVH put me on the right track and I ended up coding a solution almost identical to drctx. Works like a charm. Michelle
  3. mgargUWBC

    linked forms - which form called this form

    Here's some background and my question - FormA contains a button, that when clicked brings up FormX. FormB also contains a button that when clicked brings up FormX. Is there a way to tell whether FormA or FormB called FormX (from inside the code of FormX)? Basically I need to know how I got...
  4. mgargUWBC

    error - Access can't find '|' field in criteria expression

    RoyVidar BINGO! That was it. I knew it was a "duh" when I posted but I was stumped. A case of looking at it so long I couldn't see the error. A star for you! Michelle
  5. mgargUWBC

    error - Access can't find '|' field in criteria expression

    Chris153 - Tried it and same error. It worked correctly until I added the WorkPlan.ConsultantID) = " & [Me]![ConsultantID] part if that helps. Michelle
  6. mgargUWBC

    error - Access can't find '|' field in criteria expression

    I'm having a problem with the following code. Me.Project.RowSource = "SELECT Projects.ProjectID, Projects.ProjectName FROM WorkPlan INNER JOIN Projects ON WorkPlan.ProjectID = Projects.ProjectID " & _ "WHERE (((WorkPlan.ConsultantID) = " & [Me]![ConsultantID] & ")...
  7. mgargUWBC

    Force data entry based on TWO combo boxes

    Thanks Rolliee, The problem is that anyone can take any workshop, but some people have to have the fee added (those people who are registering for a workshop that is NOT sponsored by their group). So I can't restrict who can register for a workshop. We need to have the fee automatically added...
  8. mgargUWBC

    Force data entry based on TWO combo boxes

    I'm creating a database for tracking workshops that are sponsored by different groups. What I'm working on is a form in which I have 2 combo boxes (Personnel & Workshop). Users are able to pick any personnel and any workshop. When they have choosen the Personnel and the Workshop I need to fill...
  9. mgargUWBC

    Field can't be updated- error 3164 on a subform

    I'm currently have the exact same problem, and like yours it's not referential integrity. Did you ever figure out why?

Part and Inventory Search

Back
Top