Welcome to SPN

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

Sign Up Now!

hiding forms

Discussion in 'Information Technology' started by Halocarbon, Nov 12, 2005.

Tags:
  1. Halocarbon

    Halocarbon
    Expand Collapse
    Guest

    I am making a database in which my users will add data to a form then they
    will click a command button that runs a macro to view the information on a
    report. How can I get the form to hide while they are viewing the report. I
    did this in Access 97 with the send keys function and using "%W"h, then
    opening the report. But in Access 2000 this does not work. Any ideas? I have
    sort of fixed it by having two separate send keys functions; one to press %,
    and the other to press wh. But sometimes this works and sometimes it doesn't.
    Anyone know why?
     
  2. Loading...

    Similar Threads Forum Date
    Christianity Ex-bishop In Sex Abuse Scandal, Goes Into Hiding Interfaith Dialogues Sep 12, 2010
    Christianity Roger Vangheluwe, Ex-Bishop In Sex Abuse Scandal, Goes Into Hiding Interfaith Dialogues Sep 12, 2010
    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

  3. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    Set the Form's Visible Property to False?

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "Halocarbon" <Halocarbon@discussions.microsoft.com> wrote in message
    news:1C55D02E-F9E0-4BF7-8B64-2E5EAF4EE6A7@microsoft.com...
    >I am making a database in which my users will add data to a form then they
    > will click a command button that runs a macro to view the information on a
    > report. How can I get the form to hide while they are viewing the report.
    > I
    > did this in Access 97 with the send keys function and using "%W"h, then
    > opening the report. But in Access 2000 this does not work. Any ideas? I
    > have
    > sort of fixed it by having two separate send keys functions; one to press
    > %,
    > and the other to press wh. But sometimes this works and sometimes it
    > doesn't.
    > Anyone know why?
     
  4. Halocarbon

    Halocarbon
    Expand Collapse
    Guest

    I only want the form to go away while the report is being viewed. Won't
    setting the visible property to false make the form be hidden all the time?
    Once they close the report I want the form to reappear. I just do not want
    them to be able to click and bring the form to the front while they are
    viewing the report.

    "Van T. Dinh" wrote:

    > Set the Form's Visible Property to False?
    >
    > --
    > HTH
    > Van T. Dinh
    > MVP (Access)
    >
    >
    >
    > "Halocarbon" <Halocarbon@discussions.microsoft.com> wrote in message
    > news:1C55D02E-F9E0-4BF7-8B64-2E5EAF4EE6A7@microsoft.com...
    > >I am making a database in which my users will add data to a form then they
    > > will click a command button that runs a macro to view the information on a
    > > report. How can I get the form to hide while they are viewing the report.
    > > I
    > > did this in Access 97 with the send keys function and using "%W"h, then
    > > opening the report. But in Access 2000 this does not work. Any ideas? I
    > > have
    > > sort of fixed it by having two separate send keys functions; one to press
    > > %,
    > > and the other to press wh. But sometimes this works and sometimes it
    > > doesn't.
    > > Anyone know why?

    >
    >
    >
     
  5. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Halocarbon wrote:
    > I only want the form to go away while the report is being viewed.
    > Won't setting the visible property to false make the form be hidden
    > all the time? Once they close the report I want the form to reappear.
    > I just do not want them to be able to click and bring the form to the
    > front while they are viewing the report.


    In the Close event of the Report set the visible property of the form back
    to true.

    --
    I don't check the Email account attached
    to this message. Send instead to...
    RBrandt at Hunter dot com
     

Share This Page