Selasa, 30 Agustus 2011

[MS_AccessPros] Re: Open Form from a Report

 

Marwa

Can you post the SQL for the query? Maybe it will give us a better idea as to what is going wrong.

Bill

--- In MS_Access_Professionals@yahoogroups.com, "Marwa Abo Amra" <m.statalex@...> 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
>
>
> --- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@> 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
> > > >
> > >
> > >
> >
>

__._,_.___
Recent Activity:
MARKETPLACE
A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.
.

__,_._,___

Tidak ada komentar:

Posting Komentar