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 just sent it.

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 10:32 PM
Subject: [MS_AccessPros] Re: Issue passing InspectionID from one dialog form to another using a macro.

Sure Art. You can send me an email at pwood 57 at gmail dot com.

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:
>
>
>
> Still not working! Would yo be willing to take look at it?
>
>
> 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 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]
>

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