473,326 Members | 2,061 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Openargs in A2003

I am almost certain that when I opened a form in A97 that openargs was
available in that form's class module for the whole time the form was open.

Apparantly this is not the case in A2003. From some development I've
been doing, it seems that it is only available during the on open event
(and possibly other events such as on load, but I'm not sure). Once the
form is loaded (in this cae a popup property = true), openargs goes
back to null.

I know this is not the result of any untrapped errors - I've stepped
through the whole process and once the form has been opened,
?forms!frmName.openargs on the debug window gives me null. Further,
form level variables are still working and not reset (which I assume
still happens with untrapped errors in A2003?) and when I assign
openargs to a form level variable at the beginning fo the on open event,
the form level variable does not get reset.

To crown it all, there is no online nor off line help on openargs.

Is my diagnosis (openargs goes to null after form is opened) correct, do
you think?
--
Tim
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #1
3 2369
"Tim Marshall" <TI****@antarctic.flowerpots> wrote in message
news:cl**********@coranto.ucs.mun.ca...
Is my diagnosis (openargs goes to null after form is opened) correct, do
you think?
--
Tim


I just tried with me (Windows2003/Access2003) and
all works ok.
I open Form3 with:
DoCmd.OpenForm "Form3", , , , , , "Bruno"

I have in Form3 a button with:
MsgBox Me.OpenArgs
which gives me Bruno.

I've also full explanation on my Access Help.
My References: VBA, Access, DAO 3.60

I think something went wrong in your Access
installation.

Ciao
Bruno


Nov 13 '05 #2
Although I save my app in A200 format, this should make no difference -
openArgs still exists.

Perhaps there is some other proiblem with this statement?
?forms!frmName.openargs
Try repeated calls to

MsgBox Me.OpenArgs
Darryl Kerkeslager
"Tim Marshall" <TI****@antarctic.flowerpots> wrote: I am almost certain that when I opened a form in A97 that openargs was
available in that form's class module for the whole time the form was open.
Apparantly this is not the case in A2003. From some development I've
been doing, it seems that it is only available during the on open event
(and possibly other events such as on load, but I'm not sure). Once the
form is loaded (in this cae a popup property = true), openargs goes
back to null.

I know this is not the result of any untrapped errors - I've stepped
through the whole process and once the form has been opened,
?forms!frmName.openargs on the debug window gives me null. Further,
form level variables are still working and not reset (which I assume
still happens with untrapped errors in A2003?) and when I assign
openargs to a form level variable at the beginning fo the on open event,
the form level variable does not get reset.

To crown it all, there is no online nor off line help on openargs.

Is my diagnosis (openargs goes to null after form is opened) correct, do
you think?
--
Tim
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

Nov 13 '05 #3
Darryl Kerkeslager wrote:
Although I save my app in A200 format, this should make no difference -
openArgs still exists.


Thanks Darryl & Bruno. I wonder if this had something to do with my
form gone missing in another post. Bizarre or what?
--
Tim
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #4

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

Similar topics

5
by: nic | last post by:
Hi am having difficulty understanding why the following is not working. Dim TempID As Integer Set TempID = Me.OpenArgs Knowing that OpenArgs is a string I then changed the declaration of...
11
by: Susan Bricker | last post by:
Hi. I am trying to open a form using 'openargs' parameter of the docmd.openform action. The problem is that I would like to pass the form some character (string) and integer data. My plan was to...
3
by: Jim Evans | last post by:
Using code and suggestions from an earkier thread in this group, I have created the following cond for the open event of a form I am opening from the button click event of another form. ...
4
by: Barry Edmund Wright | last post by:
Hi All, I am using the code below to assign a form name to a form variable (vFrm). Is there a way to assign the Openargs string directly to vFrm, i.e. vFrm = Openargs ? Private Sub...
2
by: shumaker | last post by:
I think the problem lies in my understanding(or misunderstanding) of the scope of references. 'Code from button click event on first form: Private Sub Ok_Click() Dim strRecordSource As String...
3
by: Tanis | last post by:
How do you pass more than one argument using OpenArgs?
3
by: dou | last post by:
In searching for a solution to a current problem I ran across a thread from 2005 on the same issue, ( http://www.thescripts.com/forum/thread202473.html ). In that case it appeared that the problem...
7
by: Salad | last post by:
I am converting an application from A97 to A2003. I have 2 tables created by another application as a Foxpro.dbf. The table has no index. The connect string in A97 is FoxPro...
3
by: angi35 | last post by:
I'm having a zero-length string problem... Hoping someone can help. (This is in Access 2000.) In FormA, I have a button that opens FormB with OpenArgs. In FormB, the OpenArgs are translated into...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.