Hi Marwa,
"I created a form from the query that the report is created"
I doubt this is the right thing to do ...
As a general rule, each form/subform should be based on just one table. The forms should be organized to go along with the relationships in your database.
Who set up the tables and relationships? If it was you, then you need to read about Normalization* and Relationships* and make the structure strong BEFORE you build forms or reports.
*especially read these 2 chapters in Access Basics
What does your database keep track of?
...btw, I am not a guy ;)
Warm Regards,
Crystal
Access Basics by Crystal (Bill Mosca's site)
http://thatlldoit.com
*
(: have an awesome day :)
*
--- On Mon, 8/29/11, Marwa Abo Amra wrote:
> Thanks guys, I agree with you.. I
> created a form from the query that the report is created.
> Now my problem is that I create a button that shows only on
> the screen to open that form in order to do some editing to
> the records. I put a macro on the event tab of the button to
> open the form, and I use the wherecondition to have the ID
> of the report and the form the same but it does not work, it
> either goes to the first record or it goes to an empty
> record. It doesn't go to the current record that I need to
> edit. Any ideas?????
>
> M
>
>
> --- Crystal <strive4peace> wrote:
> >
> >
> > while it is true that the later versions of Access
> have provisions for user interaction, forms are still the
> best place for control.
> >
> > It sounds like it is desired to use a report to locate
> records for editing ... a form would drive this process more
> efficiently
> >
> > Marwa, read this:
> >
> > Access Basics by Crystal (Bill Mosca's site)
> > http://thatlldoit.com
> > Free 100-page book that covers essentials in Access
> >
> > { hi Bill :) }
> >
> > Warm Regards,
> > Crystal
> >
> > *
> > (: have an awesome day :)
> > *
> >
> >
> > --- On Mon, 8/29/11, Jim Wagner wrote:
> >
> > > From: Jim Wagner
> > > Marwa,
> > >
> > > If you are using Office 2007 or higher, you can
> put a
> > > button on the report in report view. Set the
> properties so
> > > it only shows on screen. But Bill is correct
> about using a
> > > form based on your specifications. I have used
> buttons on
> > > reports to filter the report based on the
> criteria I needed
> > > by department.
> > >
> > >
> > > Jim Wagner
> > > ________________________________
> > > From: Bill Mosca
> > >
> > >
> > > Marwa
> > >
> > > Reports are not really designed for buttons. The
> more
> > > accepted way is to use a form that has the same
> data as the
> > > report. That would eliminate the need to open
> another form
> > > unless that record has more data than is present
> on the
> > > report as it stands now.
> > >
> > > You can always print the report itself as needed,
> but for
> > > viewing that includes editing a form is the way
> to go.
> > >
> > > Regards,
> > > Bill Mosca, Founder - MS_Access_Professionals
> > > http://www.thatlldoit.com
> > > Microsoft Office Access MVP
> > > https://mvp.support.microsoft.com/profile/Bill.Mosca
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com,
> > > "Marwa Abo Amra" <m.statalex@> wrote:
> > > >
> > > > Hi All,
> > > >
> > > > I have a database and I have created a form
> form a
> > > table and created a report from a query that is
> created from
> > > the same table. Now, I need to have a button on
> the report
> > > that can open the record in the form so I can
> edit or add
> > > data. I have created a button on the report
> design view and
> > > used macro action as follows:
> > > > Action : OpenForm
> > > > Argument: FormName, Form, , [FieldName] =
> > > Forms![FormName].[FieldName], Edit, Normal
> > > >
> > > > When I run it, the form opens to a new entry
> and no
> > > data are shown.
> > > >
> > > > I need to open the same record on the form
> as the
> > > record I am clicking button from the report.
> > > >
> > > > Any ideas please.. Any help will be
> greately
> > > appreciated.
> > > >
> > > > Thank you
> > > >
> > > > Marwa
> > > >
> > >
> > >
Tidak ada komentar:
Posting Komentar