PC Review


Reply
Thread Tools Rate Thread

calling Subs

 
 
Jacques Proot
Guest
Posts: n/a
 
      12th Sep 2003
A> I cannot call a procedure from another object module
(within the same database) and there is no mention
of "private" nowhere. Why ?

B> How do we OPENFORM with a Visual Basic variable in the
WHERE clause ? Something like [field] = Variable. It is
not responding.

Thanks.

 
Reply With Quote
 
 
 
 
rocco
Guest
Posts: n/a
 
      12th Sep 2003
B) try [field]=" & "'" & variable & "'"
A) are you sure the called procedure is declared
with "public? like:
_____________
public sub routine.name
code here...
end sub
______


>-----Original Message-----
>A> I cannot call a procedure from another object module
>(within the same database) and there is no mention
>of "private" nowhere. Why ?
>
>B> How do we OPENFORM with a Visual Basic variable in

the
>WHERE clause ? Something like [field] = Variable. It is
>not responding.
>
>Thanks.
>
>.
>

 
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
Calling Subs in other WB =?Utf-8?B?c2FuLWF2c2M=?= Microsoft Excel Programming 4 26th Jul 2007 01:20 AM
Re: calling subs Bob Phillips Microsoft Excel Programming 0 18th Dec 2006 03:51 PM
Calling public subs ST Microsoft VB .NET 4 29th Oct 2004 02:18 PM
calling subs Mike Microsoft Excel Programming 4 8th Apr 2004 08:22 PM
Re: Calling Subs TC Microsoft Access Form Coding 0 4th Aug 2003 04:34 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:40 PM.