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:

https://www.stl-training.co.uk/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