Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 3rd, 2004, 01:29 PM
Registered User
Join Date: Sep 2003
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default user defined functions in vba

can anyone tell me how to use user defined functions in vba. front end is in access 2000 and backend is SQL server. Please help.:(

Old March 3rd, 2004, 01:32 PM
joefawcett's Avatar
Wrox Author
Join Date: Jun 2003
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts

Go to the modules tab in db window, add a new module and type in your function.

Old March 3rd, 2004, 01:59 PM
Registered User
Join Date: Sep 2003
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts

I am sry. I should have explained in a better way.

I have user defined functions on SQL server 2000. I need to call it from my VBA by supplying some parameters. Can anyone tell me how I can do it.

Also when I write user defined functions on SQL server 2000, do I have to store it at a specific place( for ex in the data sub folder of SQL Server).

Any help is greatly appreciated

Similar Threads
Thread Thread Starter Forum Replies Last Post
Indexing tables in user defined functions A17560127 SQL Server 2005 1 July 21st, 2008 03:56 AM
User-defined functions fredh Excel VBA 1 May 7th, 2007 10:28 AM
Portability of User Defined Functions (UDFs) fredh Excel VBA 0 May 3rd, 2007 06:07 PM
Number format in User Defined Functions Moose35 Excel VBA 1 February 17th, 2005 05:23 AM
User-Defined Functions - How to recalculate? kmoran Excel VBA 1 October 5th, 2004 02:45 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.