Using an A03 mdb in A07

[Neil]

I have an Access 2003 database that I need to be able to run on a machine
that's running 2007. Theoretically, it should work in both versions of
Access.

However, an associate of mine has reported that he had problems running his
A03 mdb in A07. Apprently, whenever he opened a form using the acDialog
property, the form opened as a single horizontal line (a "slither," as he
called it). He then resized the from in A07 and saved it in A07, and then it
opened fine with the acDialog property.

Has anyone else come across this behavior of A07? Are there any other issues
when using an A03 mdb in A07?

Thanks!

Neil

[Tom van Stiphout]

On Sat, 05 May 2007 15:42:39 GMT, "Neil" <no****@nospam.netwrote:

This is not generally the case. I'm running several A2000 and A2003
apps in A2007 without ever seeing this problem.

Perhaps you have some resize code in this form that is failing?

-Tom.

>I have an Access 2003 database that I need to be able to run on a machine
that's running 2007. Theoretically, it should work in both versions of
Access.

However, an associate of mine has reported that he had problems running his
A03 mdb in A07. Apprently, whenever he opened a form using the acDialog
property, the form opened as a single horizontal line (a "slither," as he
called it). He then resized the from in A07 and saved it in A07, and then it
opened fine with the acDialog property.

Has anyone else come across this behavior of A07? Are there any other issues
when using an A03 mdb in A07?

Thanks!

Neil

[Neil]

I don't know; I'll ask this associate, since he was the one experiencing it.
That's good to know that others aren't having this problem. Thanks.

"Tom van Stiphout" <no*************@cox.netwrote in message
news:in********************************@4ax.com...

On Sat, 05 May 2007 15:42:39 GMT, "Neil" <no****@nospam.netwrote:

This is not generally the case. I'm running several A2000 and A2003
apps in A2007 without ever seeing this problem.

Perhaps you have some resize code in this form that is failing?

-Tom.

>>I have an Access 2003 database that I need to be able to run on a machine
that's running 2007. Theoretically, it should work in both versions of
Access.

However, an associate of mine has reported that he had problems running
his
A03 mdb in A07. Apprently, whenever he opened a form using the acDialog
property, the form opened as a single horizontal line (a "slither," as he
called it). He then resized the from in A07 and saved it in A07, and then
it
opened fine with the acDialog property.

Has anyone else come across this behavior of A07? Are there any other
issues
when using an A03 mdb in A07?

Thanks!

Neil

[Arvin Meyer [MVP]]

I have never come across this problem. If you do again, simply resize the
form in code. Form measurements are in twips. There are 1440 twips to the
inch (20 twips to a point, 72 points to an inch), so a 3 inch form would be
(aircode):

Sub Form_Open(Cancel As Integer)
Dim twp As Integer
twp = 1440
Me.Height = 3*twp
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Neil" <no****@nospam.netwrote in message
news:PB*****************@newssvr25.news.prodigy.ne t...

>I have an Access 2003 database that I need to be able to run on a machine
that's running 2007. Theoretically, it should work in both versions of
Access.

However, an associate of mine has reported that he had problems running
his A03 mdb in A07. Apprently, whenever he opened a form using the
acDialog property, the form opened as a single horizontal line (a
"slither," as he called it). He then resized the from in A07 and saved it
in A07, and then it opened fine with the acDialog property.

Has anyone else come across this behavior of A07? Are there any other
issues when using an A03 mdb in A07?

Thanks!

Neil

[Neil]

The person having this problem is using an A02/A03 format mdb in A07 (as
opposed to an A00 format mdb in A07). I wonder if that has any bearing on
it.

Thanks for the note. I'll pass that on to him.
"Arvin Meyer [MVP]" <[e-mail] in message
news:%2******************@TK2MSFTNGP03.phx.gbl...

>I have never come across this problem. If you do again, simply resize the
form in code. Form measurements are in twips. There are 1440 twips to the
inch (20 twips to a point, 72 points to an inch), so a 3 inch form would be
(aircode):

Sub Form_Open(Cancel As Integer)
Dim twp As Integer
twp = 1440
Me.Height = 3*twp
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Neil" <no****@nospam.netwrote in message
news:PB*****************@newssvr25.news.prodigy.ne t...

>>I have an Access 2003 database that I need to be able to run on a machine
that's running 2007. Theoretically, it should work in both versions of
Access.

However, an associate of mine has reported that he had problems running
his A03 mdb in A07. Apprently, whenever he opened a form using the
acDialog property, the form opened as a single horizontal line (a
"slither," as he called it). He then resized the from in A07 and saved it
in A07, and then it opened fine with the acDialog property.

Has anyone else come across this behavior of A07? Are there any other
issues when using an A03 mdb in A07?

Thanks!

Neil

[Arvin Meyer [MVP]]

It may be a bug between those 2 versions only. I only use Access 2000 format
so that it is available in all later versions, so I don't have any files I
can use to check. The code should work in any version.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Neil" <no****@nospam.netwrote in message
news:yC*******************@newssvr13.news.prodigy. net...

The person having this problem is using an A02/A03 format mdb in A07 (as
opposed to an A00 format mdb in A07). I wonder if that has any bearing on
it.

Thanks for the note. I'll pass that on to him.
"Arvin Meyer [MVP]" <[e-mail] in message
news:%2******************@TK2MSFTNGP03.phx.gbl...

>>I have never come across this problem. If you do again, simply resize the
form in code. Form measurements are in twips. There are 1440 twips to the
inch (20 twips to a point, 72 points to an inch), so a 3 inch form would
be (aircode):

Sub Form_Open(Cancel As Integer)
Dim twp As Integer
twp = 1440
Me.Height = 3*twp
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Neil" <no****@nospam.netwrote in message
news:PB*****************@newssvr25.news.prodigy.n et...

>>>I have an Access 2003 database that I need to be able to run on a machine
that's running 2007. Theoretically, it should work in both versions of
Access.

However, an associate of mine has reported that he had problems running
his A03 mdb in A07. Apprently, whenever he opened a form using the
acDialog property, the form opened as a single horizontal line (a
"slither," as he called it). He then resized the from in A07 and saved
it in A07, and then it opened fine with the acDialog property.

Has anyone else come across this behavior of A07? Are there any other
issues when using an A03 mdb in A07?

Thanks!

Neil