98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » access training onsite uk - Go to selected record
access training onsite uk - Go to selected record
Resolved · Low Priority · Version Standard
Mon 15 Jan 2007, 13:33Delegate Mark said...
Mark has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Go to selected record
If I have a tabular form which shows several records per page which are summaries (via query) of the complete records from a table, is there any way I can select a record in this view (or other method of showing summaried records) and then obtaining the single page view of the more complete record? Ideally could just click or double click into the record row and this would go to the justified form view at the record clicked, or click into the record and press a button to do that.
Fri 19 Jan 2007, 14:18Trainer Richard said...
RE: Go to selected record
You could do this with a bit of VBA code.
In the abcense of that you may be able to create a comand button that pulls the record number you have selected and posts it to a new form, showing all the details you require. Look into the ONClick property in the event section, and see what you come up with. You may need to apply a bit of SQL thinking to get it to work smoothly.
Mon 22 Jan 2007, 08:56Delegate Mark said...
RE: Go to selected record
Is there any easier way, for instance could it be done using a macro?
Fri 26 Jan 2007, 14:41Trainer Richard said...
RE: Go to selected record
Hi Mark
If you have access to the tabular record properties, you could attach a macro that opens a form with the appropriate record detail in it.
However, remember that to create a macro, you have to be manually do each step before you can automate it.
Richard
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Remove spaces in a tableIf you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks |
