Hi Art,
I got the email. Change the name of the control in the LotsGroundsDetail Form Load Macro from InspectionID to txtInspectionID. It should look like this:
SetProperty
ControlName txtInspectionID
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 MS_Access_Professionals@yahoogroups.com, Art Lorenzini wrote:
>
>
> 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@...
> “Only those who will risk going too far can possibly find out how far one can go.â€
>
>
> ________________________________
> From: patrickawood
> 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]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (10) |
Tidak ada komentar:
Posting Komentar