API Code suitable for MS access


Can somebody direct me where I can get the API code materials suitable for MS access I need to learns some of them, so far some of the code I use sorted out some of my challenges , I still think If I peruse through I might again get some which may help.


Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
There is a good resource of APIs for use in Access on the Access Web
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
You can get API information on the access web ( http://theaccessweb.com ) and, specifically, APIs are here:

note, this is the same thing Dale mentioned, but a new link -- everything has been moved since we were told the old link was going away

here is another link for you

Microsoft API and reference catalog

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
What is it exactly that your looking for?

 My suggestion would be that rather than scoop up a bunch of API's that you may never use, you look for the required API's when you hit a specific situation.

  In general there are a few that you can always use (getting the computer and logged in user), but there are others that hardly ever get used (turn window painting off).

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Also be aware that many of the API's have changed with the advent of 64 bit.  For dealing with that, you should look at the following:

Compatibility Between the 32-bit and 64-bit Versions of Office 2010

Make sure you read the section "Introducing the VBA 7 Code Base" carefully.

These are the 32 bit calls modified for 64 bit:


There is also a code inspector for 64 bit:

Microsoft Office Code Compatibility Inspector user's guide

and here's a list of all the calls that are new for 64 bit:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.