PC Review


Reply
Thread Tools Rate Thread

Converting VBA Function to Add-in

 
 
Steve
Guest
Posts: n/a
 
      21st Feb 2006
Hey all,

Can anybody point me in the right direction of how to create and call a
function in an add-in from within access?

I've written a vba function that calls a dll to execute a required task.
It essentially processes a field, and returns the processed version of
that field.

ie. in a report, i would put as the control source "=dotask([field])"
and it would show the processed field in the report.

However, given that this is a feature that people are going to use in
their existing access databases, its not much use to have a module that
they have to add to each database they create. The ideal would be the
user installs an addin, and it is accessible to the user without any
need for further action by the user.

Its easy enough to get an add-in working in excel, but I cant for the
life of me work out how (or even if) its possible in access?

Would appreciate any advice.

Cheers.

Steve
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help converting a vb6 function to vbnet. Sara Microsoft VB .NET 8 28th Jun 2010 04:30 PM
Converting a formula into an if function pctuk Microsoft Excel Programming 0 4th Jan 2010 04:00 PM
Converting code to function Dino Microsoft Excel Programming 5 16th Oct 2008 02:12 AM
Converting Text to Function Dan B Microsoft Excel Misc 3 21st May 2008 01:26 PM
Converting a Sub Procedure to A Function KevinC Microsoft Access Form Coding 8 28th Feb 2008 03:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:45 AM.