Open in Design View

[Steven]

Is there code that will open an existing form or query or table in Design View?

For Instance:

Dim vObject As String
vObject = "fAdministrator"

DoCmd.OpenFormInDesignView vObject <- Made up for example

And then the Form be opened in Design View.

Is there anything like that?

Thank you,

Steven

 

[Marshall Barton]

Is there code that will open an existing form or query or table in Design View?

DoCmd.OpenForm "fAdministrator", acDesign

 

[Steven]

Marshall,

Thank you very much. Can you please take a look at my post on 07/12/08
"returning more than one variable on Call retValue(). The item is addressed
in my 3rd posting of that issue.

My question is, is that the best way to get the value of the 4 variables?
ie by walking through the recordset, or is there a direct function here?

Thank you,

Steven

 

[Marshall Barton]

Thank you very much. Can you please take a look at my post on 07/12/08
"returning more than one variable on Call retValue(). The item is addressed
in my 3rd posting of that issue.

My question is, is that the best way to get the value of the 4 variables?
ie by walking through the recordset, or is there a direct function here?

Using a recordset is rarely a good way to get data from
multiple records. Most of the time, you should use a query
like:

SELECT Co, Sum(IIf(CoOpen=0,1,0)) As TestCo,
Sum(IIf(AcctOpen=0,1,0)) As TestAcct,
. . .
FROM thetable
GROUP BY Co

Then you can open a recordset to retrieve each value.

 

[Steven]

Thanks again. That is much easier.

Using a recordset is rarely a good way to get data from
multiple records. Most of the time, you should use a query
like:

SELECT Co, Sum(IIf(CoOpen=0,1,0)) As TestCo,
Sum(IIf(AcctOpen=0,1,0)) As TestAcct,
. . .
FROM thetable
GROUP BY Co

Then you can open a recordset to retrieve each value.