Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Customized Forms That Mimick Parameter Queries

Discussion in 'Information Technology' started by Roger Tregelles, Jul 28, 2006.

  1. Roger Tregelles

    Roger Tregelles
    Expand Collapse
    Guest

    I just read a great tutorial on Martin Greens terrific website on how to
    create forms that behave as a Parameter Query dialog box but with the
    benefit of having a drop down listing to select from. It can be found here.

    http://www.fontstuff.com/access/acctut08.htm

    I have gone through the article word for word twice and created the
    database, forms, etc in Access but I cannot get it to work properly. I
    emailed Martin looking for guidance but he hasn't responded (must be too
    busy with paying customers). Has anyone tried this exercise and got it to
    work properly? I'm using Access 2003 here at work. If anyone has gotten this
    to work and could provide me with the file I would be forever grateful.

    Roger Tregelles
    Quality Engineer
     
  2. Loading...

    Similar Threads Forum Date
    USA Akaal Takhat Forms Committee to Represent US Sikhs Breaking News Sep 13, 2013
    India Poll reforms on crash course Breaking News Sep 7, 2013
    General A Conversation about the Grammatical Forms of Raam and Simran Hard Talk Dec 1, 2011
    India Anna Says Fast Only "Suspended", Wants Electoral Reforms Breaking News Aug 28, 2011
    India India Announces $5 bn Aid for Africa, Seeks Support for UN Reforms Breaking News May 24, 2011

  3. BruceM

    BruceM
    Expand Collapse
    Guest

    Can you be more specific about what isn't working? Were you able to create
    the query and use the parameter form to provide the query parameters?
    Regarding allowing null values, I'm not sure I see the point of OR LIKE. I
    think I would have just used OR. Again, details needed.

    "Roger Tregelles" <roger.tregelles@respironics.com> wrote in message
    news:%23G30lGhmGHA.4700@TK2MSFTNGP05.phx.gbl...
    >I just read a great tutorial on Martin Greens terrific website on how to
    > create forms that behave as a Parameter Query dialog box but with the
    > benefit of having a drop down listing to select from. It can be found
    > here.
    >
    > http://www.fontstuff.com/access/acctut08.htm
    >
    > I have gone through the article word for word twice and created the
    > database, forms, etc in Access but I cannot get it to work properly. I
    > emailed Martin looking for guidance but he hasn't responded (must be too
    > busy with paying customers). Has anyone tried this exercise and got it to
    > work properly? I'm using Access 2003 here at work. If anyone has gotten
    > this
    > to work and could provide me with the file I would be forever grateful.
    >
    > Roger Tregelles
    > Quality Engineer
    >
    >
     
  4. Roger Tregelles

    Roger Tregelles
    Expand Collapse
    Guest

    Bruce,

    I finally got it to work as described in the article. However when I tried
    to implement it into one of my databases it comes up with blank results. I
    think the problem is that the field I'm searching on is a child record and
    that table has a ID number that is the primary key which is not what I want
    to search on. I'll just have to stick with the old Parameter query for now I
    suppose as I have this tied to a report and I don't see a way to use this
    technique which yields only datasheet query view results. Thanks for the
    help anyway.

    Roger Tregelles
    Quality Engineer
     
  5. BruceM

    BruceM
    Expand Collapse
    Guest

    I would have stayed out of the conversation if I had known you need to use
    the parameter on a child record. I believe it can be done, but I don't know
    the technique. If you can get the parameter form to work with a parent
    record (even though that's not what you want, it will let you test the
    system), then you can post back with a question about using a parameter on
    the child records. You have already demonstrated a willingness to seek
    answers on your own, which tends to encourage people here to be more
    helpful, I think.

    "Roger Tregelles" <roger.tregelles@respironics.com> wrote in message
    news:OJ41r9hmGHA.2204@TK2MSFTNGP03.phx.gbl...
    > Bruce,
    >
    > I finally got it to work as described in the article. However when I tried
    > to implement it into one of my databases it comes up with blank results. I
    > think the problem is that the field I'm searching on is a child record and
    > that table has a ID number that is the primary key which is not what I
    > want
    > to search on. I'll just have to stick with the old Parameter query for now
    > I
    > suppose as I have this tied to a report and I don't see a way to use this
    > technique which yields only datasheet query view results. Thanks for the
    > help anyway.
    >
    > Roger Tregelles
    > Quality Engineer
    >
    >
     

Share This Page