Gavin Davidson
|
Posted: 11/18/2003, 5:32 PM |
|
Hi,
Forgive me if this is a stupid question, but here goes.
Right now I do all my development work in Access and mainly work to do
add-ons for another software package. Once I have developed my access app I
am able to launch it from the other software package and pass information
through to it using something like this:
Option Explicit
Main
Private Sub Main
Dim appAccess, strOrder, strReceiver
StrOrder = ORDER_ID
StrReceiver = RECEIVER_ID
IF strReceiver = "" or isnull(strReceiver) then
if MsgBox("Unable to continue! Select a valid Receiver!",vbExclamation +
vbOkOnly, "Selection")= vbOk then
end if
ELSE
Set appAccess = CreateObject("Access.Application.9")
appAccess.OpenCurrentDatabase "C:\Visual\WizCode_DATCABLE.mdb", False
appAccess.Run "Do_the_job", StrOrder, StrReceiver
appAccess.Visible = True
Set appAccess = Nothing
END IF
End Sub
This basically passes the order id and receiver id to my access app so I can
use them again there without the user having to re-enter them.
So the question is, can I do the same sort of thing with a codecharge
developed app? Would it matter what language it was published in?
Thanks
__________________________________________________________________
Gavin Davidson
Cage Technologies Inc.
ICQ#: 148828879
Current ICQ status:
( Work Tel#: 416-720-5192
+ More ways to contact me
__________________________________________________________________
|
|
|
DonB
|
Posted: 11/18/2003, 7:58 PM |
|
You can have your CCS application write to the Access database and save the
data values. Or you could write some code in a before show event of a CCS
page to pull values from the database and "do something" with them. Or in
the simplest case, define a CCS page with a form linked to the table where
those values are stored and display them on the form.
In any event, you want to think outside of the "Access" model - the purpose
of CCS is to have a client web browser interacting with a database (still
can be Access) on another computer. You generate code with CCS that reads
and writes the database, forming html pages that pass out to the client
browser, altogether different from the way you are used to working with
Access applications (which execute entirely on one computer).
You seem to be describing "state" information (transient data values that
persist and get shared between applications). You can do a similar sort of
thing with web apps like CCS, by creating "Session variables" that exist for
some period of time that you determine, and these allow you to pass data
values between pages of the web application (think of a web page as being
one of your applications and you'd be pretty close to doing the same thing
in either case).
--
DonB
http://www.gotodon.com/ccbth
"Gavin Davidson" <gavin@cagetechnologies.com> wrote in message
news:bpeh76$kg3$1@news.codecharge.com...
> Hi,
>
> Forgive me if this is a stupid question, but here goes.
>
> Right now I do all my development work in Access and mainly work to do
> add-ons for another software package. Once I have developed my access app
I
> am able to launch it from the other software package and pass information
> through to it using something like this:
>
> Option Explicit
> Main
> Private Sub Main
> Dim appAccess, strOrder, strReceiver
> StrOrder = ORDER_ID
> StrReceiver = RECEIVER_ID
> IF strReceiver = "" or isnull(strReceiver) then
> if MsgBox("Unable to continue! Select a valid Receiver!",vbExclamation +
> vbOkOnly, "Selection")= vbOk then
> end if
> ELSE
> Set appAccess = CreateObject("Access.Application.9")
> appAccess.OpenCurrentDatabase "C:\Visual\WizCode_DATCABLE.mdb", False
> appAccess.Run "Do_the_job", StrOrder, StrReceiver
> appAccess.Visible = True
> Set appAccess = Nothing
> END IF
> End Sub
>
> This basically passes the order id and receiver id to my access app so I
can
> use them again there without the user having to re-enter them.
>
> So the question is, can I do the same sort of thing with a codecharge
> developed app? Would it matter what language it was published in?
>
> Thanks
>
>
> __________________________________________________________________
> Gavin Davidson
> Cage Technologies Inc.
> ICQ#: 148828879
>
> Current ICQ status:
> ( Work Tel#: 416-720-5192
> + More ways to contact me
> __________________________________________________________________
>
>
|
|
|
|