473,569 Members | 2,764 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Probably A Simple Solution? EventProcedure Link to a Specific Procedure.

Hello

I'm sure the solution is simple and probably has something to do with
the VB Editor.

I want to create an EventProcedure link to an already created procedure
that exists
in my Form Code. I plan to use this procedure more than one time. I
can't figure out how to get OnUpdate to reference or PointTo this
procedure. I keep creating and making a reference in the editor to a
newly created procedure which is not what I want.

Mar 13 '06 #1
2 1433
Ap******@gmail. com wrote in
news:11******** **************@ z34g2000cwc.goo glegroups.com:
Hello

I'm sure the solution is simple and probably has something to
do with the VB Editor.

I want to create an EventProcedure link to an already created
procedure that exists
in my Form Code. I plan to use this procedure more than one
time. I can't figure out how to get OnUpdate to reference or
PointTo this procedure. I keep creating and making a reference
in the editor to a newly created procedure which is not what I
want.

You cannot link a procedure this way.
There are two alternative methods
1) convert the sub statement to a function statement.
A function can be inserted in the event property.
2) call the procedure from within within the new procedure

--
Bob Quintal

PA is y I've altered my email address.
Mar 13 '06 #2
Call your procedure from the event procedure created by the VBA editor.

--

Terry Kreft
<Ap******@gmail .com> wrote in message
news:11******** **************@ z34g2000cwc.goo glegroups.com.. .
Hello

I'm sure the solution is simple and probably has something to do with
the VB Editor.

I want to create an EventProcedure link to an already created procedure
that exists
in my Form Code. I plan to use this procedure more than one time. I
can't figure out how to get OnUpdate to reference or PointTo this
procedure. I keep creating and making a reference in the editor to a
newly created procedure which is not what I want.

Mar 14 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
18998
by: Matthew Houseman | last post by:
All, I've created a synonym that points to a package over a database link like so: CREATE SYNONYM API_MYLINK FOR USER.CSAPI_V2@INSTANCE.DOMAIN.COM I've granted execute like so: grant execute on CSAPI_V2 to scott; When I attach to the database in C# using ODP.NET and attempt to
3
16183
by: Thiemo Kellner | last post by:
Hi, we have come across the problem that the execution of a stored procedure by our scheduling tool (cronacle -> over db link) fails with the error message: ORA-04068: existing state of packages has been discarded ORA-04062: of has been changed ORA-04062: timestamp of procedure "LARA.PRC_BERECHNE_ZINSFAKTOR" has been changed ORA-06512:...
2
2074
by: nsd | last post by:
HI ALL, HERE I HAVE MADE USE OF SAME CURSOR DECLARATIONS AND USAGE IN THE FOLLOWING TWO DB2 CODES . BUT I AM GETTING AN ERROR IN THE FIRST CASE i.e CURSOR IN A SIMPLE BLOCK. SO I HAVE A QUESTION... CAN WE MAKE USE OF CURSORS IN A SIMPLE BLOCK?
5
6825
by: Yaro | last post by:
Hello I have odd problem with simple procedure (DB2. 8.1 FP10 Win32) CREATE PROCEDURE ADM.P_REORG_RUNSTATS(IN par_TabName VARCHAR(128), IN par_Reorg INTEGER,IN par_Runstats INTEGER) SPECIFIC P_REORG_RUNSTATS NOT DETERMINISTIC MODIFIES SQL DATA LANGUAGE SQL NO EXTERNAL ACTION
6
3851
by: Rod Snyder | last post by:
I'm trying to set up a page with an asp.net link button that would send a user to a certain page and on page load execute a specific stored procedure tied to the button on the previous page. The link would be in a nav area and be something like "update". It would send the user to the main page and execute the stored procedure associated with...
7
9441
by: gjoneshtfc | last post by:
Hello I want to search my database for a vehicle registration number but before i can search using the Find Record button i created i have to click in the registration field so that it is that one that is being searched. Is there any way to just click the button and by default it searches the registration field? Or... is there a way...
6
2027
by: Jim M | last post by:
I've been distributing a fairly mature, very specific MS Access application to end users in small offices of colleges for several years now. This is a part-time venture and low volume operation- this is somewhat of a hobby for me. Many of my end users are computer phobic and get little support from their IT departments. It is a split database...
4
1463
by: James | last post by:
How can I see/set the timeout for a postback? I have a button click event which loops through a DataSet and calls a stored procedure for every record in the dataset. This can be a very large number, and locally it's working fine. However, when I move to our development server, the exact same code pointing to the same database redirects to a...
7
1660
by: Dustin MacDonald | last post by:
Hi everyone. This is my first time posting to this newsgroup, and although I maintain my netiquette I might've missed something specific to the newsgroup, so hopefully you can avoid flaming me if I have :) I apologize for the length of this post but I figure the more information the better. My problem is that I'm getting a syntax error...
0
7693
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7605
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
1
7665
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7962
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6277
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5217
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3651
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2105
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1207
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.