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

CarysW

Complete Access Numpty
Local time
Today, 13:56
Joined
Jun 1, 2009
Messages
213
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?
 
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?
 
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!
 
What i really wanted to do would be create a report from the selected data, but I don't know if this is possible.
 
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...
 
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. :(
 
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.
 
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?)
 
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.)
 
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!
 
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?
 
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
 

Users who are viewing this thread

Back
Top Bottom