How to create "Add-Ins" in MS 2016
Hi Experts,
I have two questions about the "Add-Ins" on the tool bar in Access 2016
1). How do I create an " Add-Ins" that shows in the tool bar next to the "database Tools" when you open the database.
2). I have a database that created by an co-worker who already retired. now I need to convert this DB from MS 2007 to MS 2016. This DB has an "Add-Ins" in the tool bar, when I click in the "Add-Ins", it has few options, such as file, edit, Event, under the Event, it has add new event etc. I know MS 2016 will not carry this Add-Ins and I have to re-create it. How do I know how this co-worker created this Add-Ins? Under the Event, when I click the "New Event" it actually open a new form. I just don't know how to create it. Any help will be very appreciate.
Thanks,
I have two questions about the "Add-Ins" on the tool bar in Access 2016
1). How do I create an " Add-Ins" that shows in the tool bar next to the "database Tools" when you open the database.
2). I have a database that created by an co-worker who already retired. now I need to convert this DB from MS 2007 to MS 2016. This DB has an "Add-Ins" in the tool bar, when I click in the "Add-Ins", it has few options, such as file, edit, Event, under the Event, it has add new event etc. I know MS 2016 will not carry this Add-Ins and I have to re-create it. How do I know how this co-worker created this Add-Ins? Under the Event, when I click the "New Event" it actually open a new form. I just don't know how to create it. Any help will be very appreciate.
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
add-in are stored in separate files than the database.
here is a video that shows how to make and install an add-in for Access:
https://www.experts-exchange.com/videos/61012/How-to-Install-and-Make-an-Add-in-for-Access.html
Sometimes it makes sense to make an add-in, such as when you have a tool you might want to use in other databases too. If what you are actually wanting to do is keep everything you develop in your database, it won't be necessary to make an add-in
here is a video that shows how to make and install an add-in for Access:
https://www.experts-exchange.com/videos/61012/How-to-Install-and-Make-an-Add-in-for-Access.html
Sometimes it makes sense to make an add-in, such as when you have a tool you might want to use in other databases too. If what you are actually wanting to do is keep everything you develop in your database, it won't be necessary to make an add-in
What he is describing isn't an actual Add-in, but rather the Add-ins tab that get populated with old commandbars. I'm 99.9% sure this isn't anything to do with true add-ins. It's another horrible choice of terms from Microsoft which leads to much confusion.
convert this DB from MS 2007 to MS 2016This isn't a conversion. Both versions of Access use the .accdb (ACE) database engine. A2016 should be able to run the database created with A2007 without a problem unless it is using some deprecated feature. Just compile the app using A2007 just to make sure there are no compile errors and open it with A2016. Test carefully.
The only time the "add ins" won't work is if your A2016 is 64-bit rather than 32-bit and if that is the case, you may also have to modify code if you have any API calls.
Are you sure that the developer created these addins himself? If he bought them, you might be able to get newer versions. If not, you may have to just give them up.
ASKER
sorry experts, thanks for all your answers.
@Daniel, you were right, my bad, when I look the program again, it was the old custom toolbar that add inside the Add-Ins, it was created in MS 2000 format.
Every one's comment are very helpful.
@Daniel, you were right, my bad, when I look the program again, it was the old custom toolbar that add inside the Add-Ins, it was created in MS 2000 format.
Every one's comment are very helpful.
ASKER
Thank you sooo much!!
As i said ...your best bet to do your work...find an old copy...and manipulate the Command Bars...here is a tutorial
Extract all the needed code and start planning for Ribbon
Extract all the needed code and start planning for Ribbon
If you want to work FAST then your best solution is to find a copy of Ms Access 2003 and work on it...it has all the bells and whistles to work in a snap.
So provided you will work this way ...you will be up and ready in no time but i am afraid since Access 2007 we are on a new era...the era of Ribbon...which has all the visual goodies........