Question Can I add a link to a report on to a row of data in a table?

[CarysW]

As above really. I currently have a search facility and was planning on having a different area for creating reports and exporting data (retail customers and their stores), but I'd rather it was all in one place. Is this possible or am I just being silly?

 

[namliam]

Its possible, but why?? If you stick one "report link" on the form, the "current record" is still selected, thus you can report of it... So why add a "report link" per record?

 

[CarysW]

Its possible, but why?? If you stick one "report link" on the form, the "current record" is still selected, thus you can report of it... So why add a "report link" per record?

The database will be used for extracting information about our customers. The plan is that the user will search for a customer - they have one or more stores - and can then export the data to Excel or print off a report. I'm trying to make it as easy for the end user as possible, while seemingly making it more complicated for myself!

 

[CarysW]

What i really wanted to do would be create a report from the selected data, but I don't know if this is possible.

 

[namliam]

Yes thats possible... But WHY? make a link on each record? When a single report button is so much cleaner?? Less clutter...

Me.YourField will always return the currently (or latest) selected record...

 

[CarysW]

Yes thats possible... But WHY? make a link on each record? When a single report button is so much cleaner?? Less clutter...

Me.YourField will always return the currently (or latest) selected record...

The simple answer is I'm teaching myself as I go along! The search would sometimes give more than one record - this is what I want to report/export - the list of search results.

Sorry if I'm really annoyingly not getting this.

 

[namliam]

You can certainly "copy" the search parameters to the report... Or have the report pick up the same search as the form... No problem...
I presume the form is based of a query, simply base the report of the same query and your done.

 

[CarysW]

You can certainly "copy" the search parameters to the report... Or have the report pick up the same search as the form... No problem...
I presume the form is based of a query, simply base the report of the same query and your done.

The form is based on a table as it is just all of our customer information that I've imported.

I now understand what your saying but the question is....how do I do it? (why isn't there an embaressed smiley?)

 

[namliam]

Well how do you search now?

 

[Rabbie]

(why isn't there an embaressed smiley?)

There is

That good enogh for you

 

[CarysW]

Well how do you search now?

I have a macro set up on the 'Go' button on my search (although I will be changing this as right now it searches for several different values and some of them conflict so they're each going to get a button.)

 

[namliam]

Macro's ??? *Brrrr*

Have a search for "search form" in the references forum, see what you can do with the code and such....

Anything worth doing is worth NOT doing in Macros!

 

[CarysW]

Can someone explain this to me then?

I created a blank form, set the data source to a query I have, then created an unbound text box on the form with a command button. Then all I had to do was set the criteria for the field in my query I wanted searchable to the text box on the form, and configure the command button on the form to requery.

I've made a really functionable search facility with macros and I'm relunctant to change it - what are the problems I'm likely to encounter with macros?

 

[namliam]

Macro's are limited in their possiblities, extreemly limited... You wont be running into problems, but will (at some point) be running into limitation of Macro's