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 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@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 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]