Solved Access not displaying properly

[isladogs]

@LarryE

I wonder if we have a terminology or symantics issue here.

A2003 has a database window ...not the navigation pane which was introduced in A2007

 

[AccessShell]

I never use the cloud.
I am the only one that installs programs on both computers. I never used, or sae A2007.

 

[AccessShell]

Here you go

 

[mike60smart]

Here you go

Was able to open using Access for 365.

Saved in 2000 Format attached

 

[LarryE]

@LarryE

A2003 has a database window ...not the navigation pane which was introduced in A2007

The OP stated they were using Windows 10. Would the Windows version make a difference? I don't know.

 

[mike60smart]

I know that someone with 2003 version needs to open the Db but I opened with Access365 to look for anything unusual.

 

[AccessShell]

I already said that on another WIN10 computer I was able to open the DB properly. i.e. the DB window opened.

 

[isladogs]

As expected, no problems here in A2003

Access 2003 is not officially supported in Windows 10 but it runs without any serious issues.
See Microsoft Access Version Features and Differences Comparison Matrix (fmsinc.com)

 

[Gasman]

Someone with A2003 will need to open the database to let us know what he sees.

I was going to suggest another person opening the db on the other site, but the O/P has already done that with the other user in their organisation.
So it looks like it is down to their computer.?

 

[Gasman]

Have you tried out the code in post #15?

 

[AccessShell]

I tried it, but I was not sure where to put it. Also, I never put code like this in any other DB I wrote.

 

[AccessShell]

This is what the DB window should look like. You are missing 3 lines before the table name

 

[Gasman]

I tried it, but I was not sure where to put it. Also, I never put code like this in any other DB I wrote.

Just run it from the immediate window.
It just changes a setting one time only.

 

[AccessShell]

I cannot get to an immediate window unless there is a DB Window showing!

 

[isladogs]

This is what the DB window should look like. You are missing 3 lines before the table name

View attachment 113308

That's only because I didn't check the option below

Please can you confirm that you have all these options ticked

Also to repeat my earlier question from post #20 which I think was overlooked...
When you open an existing database, do you see a horizontal or vertical scrollbar as in my screenshot from post #3

I cannot get to an immediate window unless there is a DB Window showing!

Sorry but that's not tue. Click Tools...Macro...Visual Basic Editor

 

[AccessShell]

OK, I can get to the immediate window via Click Tools...Macro...Visual Basic Editor.

But I lost the Docmd. Please resend it to me

 

[AccessShell]

I do have all the tick marks checked on the Startup screen

 

[Gasman]

OK, I can get to the immediate window via Click Tools...Macro...Visual Basic Editor.

But I lost the Docmd. Please resend it to me

It is in the link?

Does Alt+F11 not work in 2003 or ctrl+G ?

 

[AccessShell]

I just tried the DoCmd.

 

[Gasman]

I just tried the DoCmd.

View attachment 113314

Hmm, if you cannot do it, then the system also cannot.

I am out of ideas, sorry.
I might try a sc /scannow on a windows command line, as it appears something seriously wrong with your computer.
I would even try removing Office and resinstalling, and I have already suggested that on the other site.