ACCESS FEED: Re: [MS_AccessPros] Re: Issue passing InspectionID from one dialog form to another using a macro.

Rabu, 30 Januari 2013

Re: [MS_AccessPros] Re: Issue passing InspectionID from one dialog form to another using a macro.

I see what you are doing but where do I do it? Somehere in the Add section:

> If IsNull(InspectionID) then
> 'Open the form to a new record if current ID is null
> OnError(Fail,)
> Open Form
> Form name LotsGroundsDetail
> Where Condition
> Data mOde Add
> Window Mode Dialog
> Requery()

With Warm Regards,

Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
alorenzini@crhanetwork.org
"Only those who will risk going too far can possibly find out how far one can go."

________________________________
From: patrickawood pwood57@gmail.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, January 30, 2013 9:44 PM
Subject: [MS_AccessPros] Re: Issue passing InspectionID from one dialog form to another using a macro.

Hi Art,

> Now the issue is when a record does not exist. It does not pass the InspectionId from the Inspections form.

Once you open the Form in the Macro make sure you have not yet removed the TempVar.
In the Macro:

SetProperty
Control Name InspectionID
Property Value
Value =[TempVars]![Inspection_ID]

Include the "=" in the Value box.

Kind Regards,
Pat Wood
Gaining Access Technologies Founder
http://gainingaccess.net
Microsoft Access and SQL Azure Information Center for Developers:
http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx

--- In mailto:MS_Access_Professionals%40yahoogroups.com, Art Lorenzini wrote:
>
> I solved the existing record issue. I took out the form name in the where clause:
>
> If IsNull(InspectionID) then
> 'Open the form to a new record if current ID is null
> OnError(Fail,)
> Open Form
>      Form name LotsGroundsDetail
> Where Condition
>     Data mOde Add
> Window Mode Dialog
> Requery()
> Else
> 'Use a TempVar to pass a filter to the OpenForm
> SetTempVar
>     Name   Inspection_ID
>     Expression = InspectionID
> On Error (fail,)
> Open Form
>      Form name LotsGroundDetail
>      Where Condition = InspectionID=TempVars!Inspection_ID
>       Data Mode Edit
>      Window Mode Dialog
> RemoveTempVar
>      NAme Inspection_ID
>    Requery
>      Control Name
> End if
>
>
> Now the issue is when a record does not exist. It does not pass the InspectionId from the Inspections form.
>
> I use to be able to do it with OpenArgs but I don't know how to do with a Macro.
> Any ideas?
>
> With Warm Regards,
>
> Arthur D. Lorenzini
> IT System Manager
> Cheyenne River Housing Authority
> Wk.(605)964-4265 Ext. 130
> Fax (605)964-1070
> alorenzini@...
> "Only those who will risk going too far can possibly find out how far one can go."
>
>
> ________________________________
> From: patrickawood
> To: mailto:MS_Access_Professionals%40yahoogroups.com
> Sent: Wednesday, January 30, 2013 8:50 PM
> Subject: [MS_AccessPros] Re: Issue passing InspectionID from one dialog form to another using a macro.
>
>
>
>
> Hi Art,
>
> I wonder if in your Macro could it be that you are removing the TempVar Inspection_ID too soon. Have you tried to remove the TempVar after using Requery?
>
> Kind Regards,
> Pat Wood
> Gaining Access Technologies Founder
> http://gainingaccess.net/
> Microsoft Access and SQL Azure Information Center for Developers:
> http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
>
> --- In mailto:MS_Access_Professionals%40yahoogroups.com, "Art" wrote:
> >
> > I am getting a automation error when I try to pass a ID value from on dialog form to another in a web form. I have uploaded a document which contains snapshots of the process. Any ideas wouold be great.
> >
> > Thank you
> >
> > Art Lorenzini
> > Sioux Falls, SD
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]