Re: triggers opening an Access Form

From: Eric Sabine (mopar41_at_mail_after_hot_not_before.com)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 16:11:36 -0400

In the Access database, which I am assuming you (not the 3rd party you
mentioned) are the author, in your code is where you would execute the
stored procedure. It would be something cheesy like

dim StoredProcedureReturnedVariable as Int
.. execute your sproc here, store the ret val in the local variable
if (StoredProcedureReturnedVariable = 1) then
    docmd.openform formName, modal

That's about all I remember from VBA.

hth
Eric

JOE wrote:
> and there lies the problem. I do not know how to open the
> form.
>
> Thanks,
> Joe

Relevant Pages

  • Re: Do I need Delegates?
    ... Secondly, what I provided was pseudo code, simply to describe the solution I ... Joe, I need to study the code you provide and think about it. ... >> the next Step for Failure is. ... > processed calls execute and returns true, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Whats the difference pipe vs redirection is the following case case.
    ... Welcome to PARTY! ... m-net% party | /dev/null ... because it instructs the shell to start the program /dev/null ... The execute permission bit tells the OS ...
    (comp.unix.programmer)
  • Re: Exception comes from where?
    ... After granting execute permission on the sp to my user, ... As long as you believe the java looks correct, I guess I'll focus on some ... > Joe Weinstein at BEA Systems ... >> Java servlet code is calling a MSSQL stored procedure, ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Authentication Error VB6 WinXP
    ... I have a strange problem that I'm really having a hard time fixing. ... My project runs on a PC and uses an Access database on the same PC. ... There is a datagrid connected to the database via an ADODC data control. ... Then later in another part of the code I execute the following code I ...
    (microsoft.public.vb.database.ado)
  • Re: Whats the difference pipe vs redirection is the following case case.
    ... Welcome to PARTY! ... m-net% party | /dev/null ... I get permission denied. ... A file with no execute permission cannot be executed as though ...
    (comp.unix.programmer)
Loading