Want to put an icon on the Access toolbar to run code

[johnbtic]

Hello all

I'm putting together a database and learning as I go along. I've written some code that runs through a table and in one particular column goes through all the numbers in that column and puts out a message box advising what the highest number is. The code works great, I'd like to add an icon to the toolbar that when I click on it it runs the code.

Any help would be greatly appreciated, and for a heads up I'll be back more and more for assistance

Many thanks

John

 

[vbaInet]

What version of Access are you using?

 

[johnbtic]

Hi VbaInet

It's 2007

Thanks

John

 

[vbaInet]

John,

It's not going to be a one minute task I'm afraid because ribbons are completely different from Toolbars (as we had it in older versions). So you will need to read up on the Access ribbon and as you go along you will see how to incorporate a button into the ribbon.

Here are some good resources:

http://www.accessribbon.de/en/
http://www.ribbon01.com/

Or you can just put a button on your form to run the code.

 

[johnbtic]

Hi VbaInet

This is fantastic, thanks so much. If I have to I'll put the button on a form, as of yet I don't have a form it's really just data at the moment.

Very much appreciated

John

 

[vbaInet]

See how it goes and let us know if you have any problems down the line.

Happy developing!