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 3 2376
"Tim Marshall" <TI****@antarct ic.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
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****@antarct ic.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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
TempID to be String, but this does not work either.
I have also tried
|
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
concatenate the data with delimeters (",") between the fields. Then in
the Form_Open( ) procedure I would parse the data and fill some "global"...
|
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.
Private Sub Form_Open(Cancel As Integer)
If Len(Me.OpenArgs & "") > 0 Then
Dim i As Integer
Dim s As String
|
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 Form_Load()
Public vFrm As Form
If Openargs = "subfrmProjects" then
|
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
Dim stDocName As String
Dim stLinkCriteria As String
| |
by: Tanis |
last post by:
How do you pass more than one argument using OpenArgs?
|
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 had just resolved itself. I can believe that. I have a similar problem in a VBA program, using Access in Office XP. The problem seems to have a mind...
|
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 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
It's really easy to connect to those tables in A97. I'm having
difficulties in A2003. I'm trying to follow the instructions in...
|
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 default values for certain controls.
FormB is a continuous form. For this reason, I can't assign .Value -- it has to be .DefaultValue. Otherwise...
|
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...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
| |
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...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |