Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » access training onsite uk - Go to selected record
|
|
|
Bookmark this page|
The UK's most regular 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 training onsite uk - Go to selected record
Resolved · Low Priority · Version Standard
Reply
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.For upcoming training course dates see: Pricing & availability
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.
RE: Go to selected record
Is there any easier way, for instance could it be done using a macro?
RE: Go to selected record
Hi MarkIf 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
RE: Go to selected record
Ok, that's great thank you very much
|
 |
|
» Forum post: Microsoft Project |
Is there an easy way to set up excell spreadheet reports so that actual dates can automatically be imported into Project directly, avoiding any need for manual changes within project once the programme is baselined?
