Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
|
|
|
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
Resolved · High Priority · Version 2007
Reply Tue 3 Mar 2009, 15:36Delegate Samantha said...
Samantha has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access
I have designed a form and would like to change the navigation pane and move it onto the actual form or make it more visible (larger text) so it shows how many records a query has brought up for this form i.e. record 4 of 4.
I need this to stand out rather than be in the small print at the bottom of the page, can you help?
For upcoming training course dates see: Pricing & availability
RE: Access
Dear Samantha
Thank you for attending Access Courses!! I hope you enjoyed the courses and benefited from them.
If you want some customized buttons on your form you can simply do this in the design view of the form.
I believe that your query is specific to Access 2007.
You go to the Design view of the form.
On the ribbon click on the Design sub tab of the Form Design Tools Contextualised Tab.
Click on the command button and drag and draw the size you'd like the button to be.
You should be able to see a Command button wizard dialog box
From the categories section choose the record navigation and then from the Actions choose the relevant action.
Press Finish and the button will have the desired action attached to the button. Go to Form view test the buttons to see if they work.
The second part of your query is bit complicated and it will require you to do some VBA coding:
The following link should be able to help you out but I can't guarantee that it will work. I have a very limited knowledge and experience with VBA so unfortunately I would not be able to help you further. But please let me know if it doesn't work for you so that I can refer your query to a trainer who has more understanding of Access VBA.
http://www.databasedev.co.uk/navigation-record-count.html
We are running Access VBA two day course. May be you might be interested in attending it. Please refer to the link below for course content as well as the schedule:
http://www.microsofttraining.net/ms-access-training-courses-in-london-2003-vba.php
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
Reply Wed 18 Mar 2009, 16:40Delegate Samantha said...
RE: Access
Hello Thank-you i've managed to get the buttons working, as you described, however the link you provided did not work, please could you re-send the link for me? Thank-you for your time.
RE: Access
Dear Samantha
Thank you for your response!
The link seems to be working fine on my computer.
http://www.databasedev.co.uk/navigation-record-count.html
I think the best thing would be if it doesn
Wed 25 Mar 2009: Automatically marked as resolved.
|