Welcome to SPN

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

Sign Up Now!

Command Button Question!!!

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

  1. Kwgame

    Kwgame
    Expand Collapse
    Guest

    I was wondering if my dream can be a reality or am I using more imagination
    than Dorothy (Wizard of OZ) lol. What I want to do is kind of create an
    "invisible command button" . I have a chart and what I want to be able to do
    is allow the user to click in a certain area on the chart and that action
    pulls up a report. I am creating this chart in Form also. I don't want the
    actual command button on there but if I have to I will use it. So is there a
    way to create this "invisible button"?
     
  2. Loading...

    Similar Threads Forum Date
    Commandments Blogs Jun 29, 2016
    General Meet Hari Singh Nalwa - The Sikh Commander Who Was The Most Feared Warrior In Afghanistan History of Sikhism Jun 23, 2016
    Opinion The rescue operations of Delhi’s Love commandos Breaking News Feb 2, 2013
    SPECIAL for Guru GOBIND SINGH JI's Gurpurab- The Greatest Commander-Unparralled. Sikh Sikhi Sikhism Jul 12, 2012
    Canada First Canadian Sikh Soldier Takes Command of BC Regiment Breaking News Sep 14, 2011

  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    You can use a lable, with this properties

    1. In the Caption Property set few spaces, other wise the lable will be
    removed
    2. Set the BorderStyle Property to "None"
    3. On the MouseDown event write the code that open the report


    --
    Good Luck
    BS"D


    "Kwgame" wrote:

    > I was wondering if my dream can be a reality or am I using more imagination
    > than Dorothy (Wizard of OZ) lol. What I want to do is kind of create an
    > "invisible command button" . I have a chart and what I want to be able to do
    > is allow the user to click in a certain area on the chart and that action
    > pulls up a report. I am creating this chart in Form also. I don't want the
    > actual command button on there but if I have to I will use it. So is there a
    > way to create this "invisible button"?
     
  4. Kwgame

    Kwgame
    Expand Collapse
    Guest

    what is the code for opening a report? I didn't use any code, I was using the
    wizard to set what to open. I am not a VB guy!

    "Ofer Cohen" wrote:

    > You can use a lable, with this properties
    >
    > 1. In the Caption Property set few spaces, other wise the lable will be
    > removed
    > 2. Set the BorderStyle Property to "None"
    > 3. On the MouseDown event write the code that open the report
    >
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "Kwgame" wrote:
    >
    > > I was wondering if my dream can be a reality or am I using more imagination
    > > than Dorothy (Wizard of OZ) lol. What I want to do is kind of create an
    > > "invisible command button" . I have a chart and what I want to be able to do
    > > is allow the user to click in a certain area on the chart and that action
    > > pulls up a report. I am creating this chart in Form also. I don't want the
    > > actual command button on there but if I have to I will use it. So is there a
    > > way to create this "invisible button"?
     
  5. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    The command to open a report is

    Docmd.OpenReport "ReportName"

    Check this link on "Printing the Record on the Microsoft Access Form to a
    Report"

    http://www.databasedev.co.uk/report_from_form_record.html

    --
    Good Luck
    BS"D


    "Kwgame" wrote:

    > what is the code for opening a report? I didn't use any code, I was using the
    > wizard to set what to open. I am not a VB guy!
    >
    > "Ofer Cohen" wrote:
    >
    > > You can use a lable, with this properties
    > >
    > > 1. In the Caption Property set few spaces, other wise the lable will be
    > > removed
    > > 2. Set the BorderStyle Property to "None"
    > > 3. On the MouseDown event write the code that open the report
    > >
    > >
    > > --
    > > Good Luck
    > > BS"D
    > >
    > >
    > > "Kwgame" wrote:
    > >
    > > > I was wondering if my dream can be a reality or am I using more imagination
    > > > than Dorothy (Wizard of OZ) lol. What I want to do is kind of create an
    > > > "invisible command button" . I have a chart and what I want to be able to do
    > > > is allow the user to click in a certain area on the chart and that action
    > > > pulls up a report. I am creating this chart in Form also. I don't want the
    > > > actual command button on there but if I have to I will use it. So is there a
    > > > way to create this "invisible button"?
     
  6. Kwgame

    Kwgame
    Expand Collapse
    Guest

    Thanks!

    "Ofer Cohen" wrote:

    > The command to open a report is
    >
    > Docmd.OpenReport "ReportName"
    >
    > Check this link on "Printing the Record on the Microsoft Access Form to a
    > Report"
    >
    > http://www.databasedev.co.uk/report_from_form_record.html
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "Kwgame" wrote:
    >
    > > what is the code for opening a report? I didn't use any code, I was using the
    > > wizard to set what to open. I am not a VB guy!
    > >
    > > "Ofer Cohen" wrote:
    > >
    > > > You can use a lable, with this properties
    > > >
    > > > 1. In the Caption Property set few spaces, other wise the lable will be
    > > > removed
    > > > 2. Set the BorderStyle Property to "None"
    > > > 3. On the MouseDown event write the code that open the report
    > > >
    > > >
    > > > --
    > > > Good Luck
    > > > BS"D
    > > >
    > > >
    > > > "Kwgame" wrote:
    > > >
    > > > > I was wondering if my dream can be a reality or am I using more imagination
    > > > > than Dorothy (Wizard of OZ) lol. What I want to do is kind of create an
    > > > > "invisible command button" . I have a chart and what I want to be able to do
    > > > > is allow the user to click in a certain area on the chart and that action
    > > > > pulls up a report. I am creating this chart in Form also. I don't want the
    > > > > actual command button on there but if I have to I will use it. So is there a
    > > > > way to create this "invisible button"?
     

Share This Page