How to Create Add In MS Access

[MUKESHY12390]

Hi Experts,


can anybody help me out with how to create Access Add In.

Any Link or suggestion most welcome.


Thanks,
Mukesh Y

 

[Micron]

Here's a couple of links that might help

Microsoft Access Add-in (Library Database) Tips, Hints and Gotchas

Creating a Simple Microsoft Access Add-in Pt.1 | Database Solutions for Microsoft Access | databasedev.co.uk

 

[MUKESHY12390]

thanks..Micron

I had visited those site earlier but didn't give close look to it. now I'm going to try all example given over there.

 

[xenou]

Why do you want a MSAccess addin? I'm not sure you would really need one generally.

 

[MUKESHY12390]

I'm working on MS Access project (which has already created by someone) . I'm being just asked to add some more options to "Add In " tab which is available in ribbon . So I was wondering If I can add some to it.

Basically it has quick Access to vba function created by developer and I believe same stuff we can do same stuff with "MACRO" feature in ms access.

thanks for reply Xenou.

 

[xenou]

You don't need an actual MSAddin. You just need to add buttons to the ribbon then.

 

[MUKESHY12390]

if we Customize the Ribbon with the help of “Access option---> customize Ribbon . we won’t get any option in “Add-in Manager” and if do “Rest Customization” it would delete all additional tab we have ever created. I have uploaded some images which show my current ribbon options and view.

https://s18.postimg.org/3luyqbea1/Addin2.png

https://s17.postimg.org/v4pghsc1b/Add_In_menu.png.

https://s17.postimg.org/fbgghsdb3/addin3.png


Please share what you think about this.

Thanks

 

[xenou]

The addin manager is for installing/uninstalling addins (I think). I'm not advising you to create an addin at all so no need to even think about the addin manager.

As far as buttons go, you can add buttons to the MSAccess ribbon. I have never heard of "Rest Customization".

I can't view your images - my browser security warns me of an authentication error.

 

[MUKESHY12390]

thanks for reply..my question was, Does creating "Add-In" require VB.net , DotNet or any other prog. Language knowledge.

BTW.."Rest Customization " option is available same place where we get option to add buttons to "MSAccess".

 

[Micron]

If the add in is application specific, then no. You could use vba or macros. Basically you're just creating a form in a separate db that you'd consider to be a tool. The reason for making it an add in as opposed to including it as part of the main db is that you could "add in" its functionality to any Access db. AFAIK, if it's an add in that could be used in any application, it would have to be written in something else (possibly a version of C).

BTW, I see "Reset" customizations, not "Rest".