Form Difficulties

[TH]

I'm running Access 95 (is this too old of a version to get help with here?
hope not). The first form I create is visible in the database windows.
However, when I try to create a second (third etc) form, exit the program,
and then get back into the database in question, the second form is not
visible. If I go to the Database Properties under the File menu and select
the contents tab, the second form is visible here. I go to Tools, Options,
View and select Hidden Objects, click apply and this still doesn't show the
second form. I'm puzzled.

Second and final question. When I get back into the database and try to
edit in design view or even display the first form I get the following
message "The form name 'Main Screen' you entered in either the property
sheet or a macro is mispelled or refers to a form that doesn't exist." I
can't for the life of me figure what's wrong. I can't even get into design
view to try to figure it out. I have no idea what I did. I can't think of
any property that I changed to cause this.

Any help would be appreciated. Thanks.

[Allen Browne]

TH, this sounds like your database is corrupt.

Access 95 as originally released was very buggy, and there were a number of
patches released. If you don't have them, you really need them.

You could try creating a new (blank) database, importing the objects that
are visible. Then see if you can create new forms in the new database.

Although it would be possible to loop through the Documents in the
Containers to see if the forms are there, or to query the MSysObjects table
for them, I doubt that would be a productive route.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
Reply to the newsgroup. (Email address has spurious "_SpamTrap")

"TH" <niagara94@bluefrog.com> wrote in message
news:urX1bGpRDHA.3192@TK2MSFTNGP10.phx.gbl...

> I'm running Access 95 (is this too old of a version to get help with here?
> hope not). The first form I create is visible in the database windows.
> However, when I try to create a second (third etc) form, exit the program,
> and then get back into the database in question, the second form is not
> visible. If I go to the Database Properties under the File menu and

select

> the contents tab, the second form is visible here. I go to Tools,

Options,

> View and select Hidden Objects, click apply and this still doesn't show

the

> second form. I'm puzzled.
>
> Second and final question. When I get back into the database and try to
> edit in design view or even display the first form I get the following
> message "The form name 'Main Screen' you entered in either the property
> sheet or a macro is mispelled or refers to a form that doesn't exist." I
> can't for the life of me figure what's wrong. I can't even get into

design

> view to try to figure it out. I have no idea what I did. I can't think

of

> any property that I changed to cause this.
>
> Any help would be appreciated. Thanks.

[TH]

Thanks for responding. I checked Microsofts website and I didn't see
updates for Access 95. Where can I get the patches?

TH


"Allen Browne" <abrowne1_SpamTrap@bigpond.net.au> wrote in message
news:eBZFu9pRDHA.2676@TK2MSFTNGP10.phx.gbl...

> TH, this sounds like your database is corrupt.
>
> Access 95 as originally released was very buggy, and there were a number

of

> patches released. If you don't have them, you really need them.
>
> You could try creating a new (blank) database, importing the objects that
> are visible. Then see if you can create new forms in the new database.
>
> Although it would be possible to loop through the Documents in the
> Containers to see if the forms are there, or to query the MSysObjects

table

> for them, I doubt that would be a productive route.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
> Reply to the newsgroup. (Email address has spurious "_SpamTrap")
>
> "TH" <niagara94@bluefrog.com> wrote in message
> news:urX1bGpRDHA.3192@TK2MSFTNGP10.phx.gbl...

> > I'm running Access 95 (is this too old of a version to get help with

here?

> > hope not). The first form I create is visible in the database windows.
> > However, when I try to create a second (third etc) form, exit the

program,

> > and then get back into the database in question, the second form is not
> > visible. If I go to the Database Properties under the File menu and

> select

> > the contents tab, the second form is visible here. I go to Tools,

> Options,

> > View and select Hidden Objects, click apply and this still doesn't show

> the

> > second form. I'm puzzled.
> >
> > Second and final question. When I get back into the database and try to
> > edit in design view or even display the first form I get the following
> > message "The form name 'Main Screen' you entered in either the property
> > sheet or a macro is mispelled or refers to a form that doesn't exist."

I

> > can't for the life of me figure what's wrong. I can't even get into

> design

> > view to try to figure it out. I have no idea what I did. I can't think

> of

> > any property that I changed to cause this.
> >
> > Any help would be appreciated. Thanks.

>
>

[TH]

Thanks for answering. Do you happen to know where I can get Access 97 (even
if it is a part of Office 97 Pro) for a reasonable price? I noticed that
even this version of access/office is expensive.


"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:pm6rgv0ooqroc6uj5im5jl5cvpufla5fen@4ax.com...

> On Wed, 9 Jul 2003 23:16:04 -0400, "TH" <niagara94@bluefrog.com>
> wrote:
>

> >I'm running Access 95 (is this too old of a version to get help with

here?

> >hope not).

>
> It is the worst version of Access ever released... buggy and unstable!
> I don't know MS's qualifying-product list for upgrades but you should
> really consider upgrading, preferably to A97 (not from Microsoft but
> possibly available on the used software market) or to XP. It'll be
> worth the money in reduced aggrevation.
>
>
> John W. Vinson[MVP]
> Come for live chats every Tuesday and Thursday
> [url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]

[TH]

Thanks for sending me the updated dll file. I haven't had a chance to
create a new database to see if it works. If it doesn't work do you have
any other ideas?


"Allen Browne" <abrowne1_SpamTrap@bigpond.net.au> wrote in message
news:#m5QpquRDHA.304@tk2msftngp13.phx.gbl...

> Hm. MS doesn't support Access 95 any more.
> I'll see what I can find.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
> Reply to the newsgroup. (Email address has spurious "_SpamTrap")
>
> "TH" <niagara94@bluefrog.com> wrote in message
> news:u9MDIDuRDHA.304@tk2msftngp13.phx.gbl...

> > Thanks for responding. I checked Microsofts website and I didn't see
> > updates for Access 95. Where can I get the patches?
> >
> > TH
> >
> >
> > "Allen Browne" <abrowne1_SpamTrap@bigpond.net.au> wrote in message
> > news:eBZFu9pRDHA.2676@TK2MSFTNGP10.phx.gbl...

> > > TH, this sounds like your database is corrupt.
> > >
> > > Access 95 as originally released was very buggy, and there were a

number

> > of

> > > patches released. If you don't have them, you really need them.
> > >
> > > You could try creating a new (blank) database, importing the objects

> that

> > > are visible. Then see if you can create new forms in the new database.
> > >
> > > Although it would be possible to loop through the Documents in the
> > > Containers to see if the forms are there, or to query the MSysObjects

> > table

> > > for them, I doubt that would be a productive route.
> > >
> > > --
> > > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > > Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
> > > Reply to the newsgroup. (Email address has spurious "_SpamTrap")
> > >
> > > "TH" <niagara94@bluefrog.com> wrote in message
> > > news:urX1bGpRDHA.3192@TK2MSFTNGP10.phx.gbl...
> > > > I'm running Access 95 (is this too old of a version to get help with

> > here?

> > > > hope not). The first form I create is visible in the database

> windows.

> > > > However, when I try to create a second (third etc) form, exit the

> > program,

> > > > and then get back into the database in question, the second form is

> not

> > > > visible. If I go to the Database Properties under the File menu and
> > > select
> > > > the contents tab, the second form is visible here. I go to Tools,
> > > Options,
> > > > View and select Hidden Objects, click apply and this still doesn't

> show

> > > the
> > > > second form. I'm puzzled.
> > > >
> > > > Second and final question. When I get back into the database and

try

> to

> > > > edit in design view or even display the first form I get the

following

> > > > message "The form name 'Main Screen' you entered in either the

> property

> > > > sheet or a macro is mispelled or refers to a form that doesn't

exist."

> > I

> > > > can't for the life of me figure what's wrong. I can't even get into
> > > design
> > > > view to try to figure it out. I have no idea what I did. I can't

> think

> > > of
> > > > any property that I changed to cause this.
> > > >
> > > > Any help would be appreciated. Thanks.

>
>

[John Vinson]

On Fri, 11 Jul 2003 14:10:35 -0400, "TH" <niagara94@bluefrog.com>
wrote:

>Thanks for answering. Do you happen to know where I can get Access 97 (even
>if it is a part of Office 97 Pro) for a reasonable price? I noticed that
>even this version of access/office is expensive.

Not really; you'ld have to do some websurfing for secondhand software.
Be sure you get a legitimate copy if you do!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]

[TH]

I tried to construct a new database and it didn't work :(



"TH" <niagara94@bluefrog.com> wrote in message
news:ukSOT29RDHA.3768@tk2msftngp13.phx.gbl...

> Thanks for sending me the updated dll file. I haven't had a chance to
> create a new database to see if it works. If it doesn't work do you have
> any other ideas?
>
>
> "Allen Browne" <abrowne1_SpamTrap@bigpond.net.au> wrote in message
> news:#m5QpquRDHA.304@tk2msftngp13.phx.gbl...

> > Hm. MS doesn't support Access 95 any more.
> > I'll see what I can find.
> >
> > --
> > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
> > Reply to the newsgroup. (Email address has spurious "_SpamTrap")
> >
> > "TH" <niagara94@bluefrog.com> wrote in message
> > news:u9MDIDuRDHA.304@tk2msftngp13.phx.gbl...

> > > Thanks for responding. I checked Microsofts website and I didn't see
> > > updates for Access 95. Where can I get the patches?
> > >
> > > TH
> > >
> > >
> > > "Allen Browne" <abrowne1_SpamTrap@bigpond.net.au> wrote in message
> > > news:eBZFu9pRDHA.2676@TK2MSFTNGP10.phx.gbl...
> > > > TH, this sounds like your database is corrupt.
> > > >
> > > > Access 95 as originally released was very buggy, and there were a

> number

> > > of
> > > > patches released. If you don't have them, you really need them.
> > > >
> > > > You could try creating a new (blank) database, importing the objects

> > that

> > > > are visible. Then see if you can create new forms in the new

database.

> > > >
> > > > Although it would be possible to loop through the Documents in the
> > > > Containers to see if the forms are there, or to query the

MSysObjects

> > > table
> > > > for them, I doubt that would be a productive route.
> > > >
> > > > --
> > > > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > > > Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
> > > > Reply to the newsgroup. (Email address has spurious "_SpamTrap")
> > > >
> > > > "TH" <niagara94@bluefrog.com> wrote in message
> > > > news:urX1bGpRDHA.3192@TK2MSFTNGP10.phx.gbl...
> > > > > I'm running Access 95 (is this too old of a version to get help

with

> > > here?
> > > > > hope not). The first form I create is visible in the database

> > windows.

> > > > > However, when I try to create a second (third etc) form, exit the
> > > program,
> > > > > and then get back into the database in question, the second form

is

> > not

> > > > > visible. If I go to the Database Properties under the File menu

and

> > > > select
> > > > > the contents tab, the second form is visible here. I go to Tools,
> > > > Options,
> > > > > View and select Hidden Objects, click apply and this still doesn't

> > show

> > > > the
> > > > > second form. I'm puzzled.
> > > > >
> > > > > Second and final question. When I get back into the database and

> try

> > to

> > > > > edit in design view or even display the first form I get the

> following

> > > > > message "The form name 'Main Screen' you entered in either the

> > property

> > > > > sheet or a macro is mispelled or refers to a form that doesn't

> exist."

> > > I
> > > > > can't for the life of me figure what's wrong. I can't even get

into

> > > > design
> > > > > view to try to figure it out. I have no idea what I did. I can't

> > think

> > > > of
> > > > > any property that I changed to cause this.
> > > > >
> > > > > Any help would be appreciated. Thanks.

> >
> >

>
>

[Allen Browne]

Sorry, TH.

If you cannot create a new database and import the existing objects, the
database is probably beyond rescue unless you are prepared to pay someone
such as pksolutions.com

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
Reply to the newsgroup. (Email address has spurious "_SpamTrap")
"TH" <niagara94@bluefrog.com> wrote in message
news:uBv44wHSDHA.2248@TK2MSFTNGP11.phx.gbl...

> I tried to construct a new database and it didn't work :(
>
>
>
> "TH" <niagara94@bluefrog.com> wrote in message
> news:ukSOT29RDHA.3768@tk2msftngp13.phx.gbl...

> > Thanks for sending me the updated dll file. I haven't had a chance to
> > create a new database to see if it works. If it doesn't work do you

have

> > any other ideas?
> >
> >
> > "Allen Browne" <abrowne1_SpamTrap@bigpond.net.au> wrote in message
> > news:#m5QpquRDHA.304@tk2msftngp13.phx.gbl...

> > > Hm. MS doesn't support Access 95 any more.
> > > I'll see what I can find.
> > >
> > > --
> > > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > > Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
> > > Reply to the newsgroup. (Email address has spurious "_SpamTrap")
> > >
> > > "TH" <niagara94@bluefrog.com> wrote in message
> > > news:u9MDIDuRDHA.304@tk2msftngp13.phx.gbl...
> > > > Thanks for responding. I checked Microsofts website and I didn't

see

> > > > updates for Access 95. Where can I get the patches?
> > > >
> > > > TH
> > > >
> > > >
> > > > "Allen Browne" <abrowne1_SpamTrap@bigpond.net.au> wrote in message
> > > > news:eBZFu9pRDHA.2676@TK2MSFTNGP10.phx.gbl...
> > > > > TH, this sounds like your database is corrupt.
> > > > >
> > > > > Access 95 as originally released was very buggy, and there were a

> > number

> > > > of
> > > > > patches released. If you don't have them, you really need them.
> > > > >
> > > > > You could try creating a new (blank) database, importing the

objects

> > > that
> > > > > are visible. Then see if you can create new forms in the new

> database.

> > > > >
> > > > > Although it would be possible to loop through the Documents in the
> > > > > Containers to see if the forms are there, or to query the

> MSysObjects

> > > > table
> > > > > for them, I doubt that would be a productive route.
> > > > >
> > > > > --
> > > > > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > > > > Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
> > > > > Reply to the newsgroup. (Email address has spurious "_SpamTrap")
> > > > >
> > > > > "TH" <niagara94@bluefrog.com> wrote in message
> > > > > news:urX1bGpRDHA.3192@TK2MSFTNGP10.phx.gbl...
> > > > > > I'm running Access 95 (is this too old of a version to get help

> with

> > > > here?
> > > > > > hope not). The first form I create is visible in the database
> > > windows.
> > > > > > However, when I try to create a second (third etc) form, exit

the

> > > > program,
> > > > > > and then get back into the database in question, the second form

> is

> > > not
> > > > > > visible. If I go to the Database Properties under the File menu

> and

> > > > > select
> > > > > > the contents tab, the second form is visible here. I go to

Tools,

> > > > > Options,
> > > > > > View and select Hidden Objects, click apply and this still

doesn't

> > > show
> > > > > the
> > > > > > second form. I'm puzzled.
> > > > > >
> > > > > > Second and final question. When I get back into the database

and

> > try

> > > to
> > > > > > edit in design view or even display the first form I get the

> > following

> > > > > > message "The form name 'Main Screen' you entered in either the
> > > property
> > > > > > sheet or a macro is mispelled or refers to a form that doesn't

> > exist."

> > > > I
> > > > > > can't for the life of me figure what's wrong. I can't even get

> into

> > > > > design
> > > > > > view to try to figure it out. I have no idea what I did. I

can't

> > > think
> > > > > of
> > > > > > any property that I changed to cause this.
> > > > > >
> > > > > > Any help would be appreciated. Thanks.
> > >
> > >

> >
> >

>
>

[TH]

Thanks for all your time and help.


"Allen Browne" <abrowne1_SpamTrap@bigpond.net.au> wrote in message
news:O$zXiAISDHA.2248@TK2MSFTNGP11.phx.gbl...

> Sorry, TH.
>
> If you cannot create a new database and import the existing objects, the
> database is probably beyond rescue unless you are prepared to pay someone
> such as pksolutions.com
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
> Reply to the newsgroup. (Email address has spurious "_SpamTrap")
> "TH" <niagara94@bluefrog.com> wrote in message
> news:uBv44wHSDHA.2248@TK2MSFTNGP11.phx.gbl...

> > I tried to construct a new database and it didn't work :(
> >
> >
> >
> > "TH" <niagara94@bluefrog.com> wrote in message
> > news:ukSOT29RDHA.3768@tk2msftngp13.phx.gbl...

> > > Thanks for sending me the updated dll file. I haven't had a chance to
> > > create a new database to see if it works. If it doesn't work do you

> have

> > > any other ideas?
> > >
> > >
> > > "Allen Browne" <abrowne1_SpamTrap@bigpond.net.au> wrote in message
> > > news:#m5QpquRDHA.304@tk2msftngp13.phx.gbl...
> > > > Hm. MS doesn't support Access 95 any more.
> > > > I'll see what I can find.
> > > >
> > > > --
> > > > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > > > Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
> > > > Reply to the newsgroup. (Email address has spurious "_SpamTrap")
> > > >
> > > > "TH" <niagara94@bluefrog.com> wrote in message
> > > > news:u9MDIDuRDHA.304@tk2msftngp13.phx.gbl...
> > > > > Thanks for responding. I checked Microsofts website and I didn't

> see

> > > > > updates for Access 95. Where can I get the patches?
> > > > >
> > > > > TH
> > > > >
> > > > >
> > > > > "Allen Browne" <abrowne1_SpamTrap@bigpond.net.au> wrote in message
> > > > > news:eBZFu9pRDHA.2676@TK2MSFTNGP10.phx.gbl...
> > > > > > TH, this sounds like your database is corrupt.
> > > > > >
> > > > > > Access 95 as originally released was very buggy, and there were

a

> > > number
> > > > > of
> > > > > > patches released. If you don't have them, you really need them.
> > > > > >
> > > > > > You could try creating a new (blank) database, importing the

> objects

> > > > that
> > > > > > are visible. Then see if you can create new forms in the new

> > database.

> > > > > >
> > > > > > Although it would be possible to loop through the Documents in

the

> > > > > > Containers to see if the forms are there, or to query the

> > MSysObjects

> > > > > table
> > > > > > for them, I doubt that would be a productive route.
> > > > > >
> > > > > > --
> > > > > > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > > > > > Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
> > > > > > Reply to the newsgroup. (Email address has spurious "_SpamTrap")
> > > > > >
> > > > > > "TH" <niagara94@bluefrog.com> wrote in message
> > > > > > news:urX1bGpRDHA.3192@TK2MSFTNGP10.phx.gbl...
> > > > > > > I'm running Access 95 (is this too old of a version to get

help

> > with

> > > > > here?
> > > > > > > hope not). The first form I create is visible in the database
> > > > windows.
> > > > > > > However, when I try to create a second (third etc) form, exit

> the

> > > > > program,
> > > > > > > and then get back into the database in question, the second

form

> > is

> > > > not
> > > > > > > visible. If I go to the Database Properties under the File

menu

> > and

> > > > > > select
> > > > > > > the contents tab, the second form is visible here. I go to

> Tools,

> > > > > > Options,
> > > > > > > View and select Hidden Objects, click apply and this still

> doesn't

> > > > show
> > > > > > the
> > > > > > > second form. I'm puzzled.
> > > > > > >
> > > > > > > Second and final question. When I get back into the database

> and

> > > try
> > > > to
> > > > > > > edit in design view or even display the first form I get the
> > > following
> > > > > > > message "The form name 'Main Screen' you entered in either the
> > > > property
> > > > > > > sheet or a macro is mispelled or refers to a form that doesn't
> > > exist."
> > > > > I
> > > > > > > can't for the life of me figure what's wrong. I can't even

get

> > into

> > > > > > design
> > > > > > > view to try to figure it out. I have no idea what I did. I

> can't

> > > > think
> > > > > > of
> > > > > > > any property that I changed to cause this.
> > > > > > >
> > > > > > > Any help would be appreciated. Thanks.
> > > >
> > > >
> > >
> > >

> >
> >

>
>