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 MS_Access_Professionals@yahoogroups.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: 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]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (8) |
Tidak ada komentar:
Posting Komentar