Connecting Tech Pros Worldwide Forums | Help | Site Map

Database window AWOL

Denburt's Avatar
Moderator
 
Join Date: Mar 2007
Location: Louisiana
Posts: 1,218
#1: Mar 15 '07
This is a front end application residing on my desktop PC at work.

It appears as though the database window has moved off to the left, somewhere in time. I tried scrolling (gave up), opened the DB using the shift key again it didn't resolve the issue. I have compacted repaired the DB, I made sure the code was compiled and I always use option explicit.

I do believe it is corrupted my most recent backup (this morning) also corrupted. My backup at noon yesterday appears to be o.k. but that is a LOT of work.

It is a resonably large front end (I have had larger) this DB has gone belly up in the past and I am currently thinking my best option may be to create a new DB and import everything, still time consuming though. Hoping someone may have encountered this before and can point out something I am missing.

I am quite fluent in VBA and I know I can reposition forms and such but I haven't figured out a way to move the Database window.

Thanks

Rabbit's Avatar
Expert
 
Join Date: Jan 2007
Location: California
Posts: 3,835
#2: Mar 16 '07

re: Database window AWOL


I can't think of anything except to use DoCmd.Maximize on a form to maximize the database window. And then exit out of the form.
Denburt's Avatar
Moderator
 
Join Date: Mar 2007
Location: Louisiana
Posts: 1,218
#3: Mar 16 '07

re: Database window AWOL


LOL, thanks that did give me a view of the database window but it went right back if I try to view it any other way. I broke down and imported everything into a new DB just trying to get everything back in place... almost there then some testing.. This really sucks!

Thanks for the assist.
Rabbit's Avatar
Expert
 
Join Date: Jan 2007
Location: California
Posts: 3,835
#4: Mar 16 '07

re: Database window AWOL


Quote:

Originally Posted by Denburt

LOL, thanks that did give me a view of the database window but it went right back if I try to view it any other way. I broke down and imported everything into a new DB just trying to get everything back in place... almost there then some testing.. This really sucks!

Thanks for the assist.

Yeah.. I shoulda mentioned that lol. Good luck.
msquared's Avatar
Administrator
 
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,885
#5: Mar 17 '07

re: Database window AWOL


BTW Denburt, welcome to thescripts. You've been posting some great answers. Always nice to see experts or your calibre joining us. I'm going to ask one of our mods ADezii to have a look at this as he's the API guru and may have an answer.

Mary
ADezii's Avatar
Expert
 
Join Date: Apr 2006
Location: Philadelphia
Posts: 5,218
#6: Mar 17 '07

re: Database window AWOL


Quote:

Originally Posted by Denburt

This is a front end application residing on my desktop PC at work.

It appears as though the database window has moved off to the left, somewhere in time. I tried scrolling (gave up), opened the DB using the shift key again it didn't resolve the issue. I have compacted repaired the DB, I made sure the code was compiled and I always use option explicit.

I do believe it is corrupted my most recent backup (this morning) also corrupted. My backup at noon yesterday appears to be o.k. but that is a LOT of work.

It is a resonably large front end (I have had larger) this DB has gone belly up in the past and I am currently thinking my best option may be to create a new DB and import everything, still time consuming though. Hoping someone may have encountered this before and can point out something I am missing.

I am quite fluent in VBA and I know I can reposition forms and such but I haven't figured out a way to move the Database window.

Thanks

I must admit that I have never seen this anomaly before. Does the following code, with just the Main Form open, bring the Database Window back on Screen?
Expand|Select|Wrap|Line Numbers
  1. DoCmd.RunCommand acCmdTileVertically
Denburt's Avatar
Moderator
 
Join Date: Mar 2007
Location: Louisiana
Posts: 1,218
#7: Mar 19 '07

re: Database window AWOL


Where you on Friday lol very nice solution worked great my Main Menu is locked down and not resizable so it worked like a champ. The database window must have been WAY out there it actually took a few seconds before it showed up. I really thought MS Access was going to crash. I have had many problems with this front end and Friday made rebuild ummmm 7 or 8 I think. MS Access has a lot of bugs, but it keeps things interesting. :)

Again Thanks
Reply