Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can startup to forms be reversed in 97? 1

Status
Not open for further replies.
jofarrell

jofarrell

Programmer
Mar 21, 2001
178
US
I have a database that was set to start up on a main form. I want to reverse the procedure so it opens in table view.. is this possible in Access 97? I am doing this because in converting to 2000 I am unable to shift open and get at my tables.

Thanks
Joanne
 
Sort by date Sort by votes
I think what you really want is to open to the database window. If so, you'll do one shift-start and on the menu bar Tools-Startup, clean out Display Form to (none) and make sure Display Database window is checked. Should do it! Gord
ghubbell@total.net
 
Upvote 0 Downvote
Actually that doesnt work :( I have tried that as well as setting forms to none. Yet it still opens in "run" mode so to speak with no option to view the tables. The only way I can is to depress the shift key as I open the database. There is no code on the opening form in either the load or open that would cause it to startup this way and when I remove the display foem I would have thought the database or table view is what I would see.
 
Upvote 0 Downvote
Do you have any "funky" code or an AutoExec Macro running when this starts and do you have permissions to change the settings above? If no and yes then try this: Make a shiney new empty database, and import in everything from your old. (Don't forget menus/toolbars). I suggest this because I have had Db's "jam" the startup form setting and could only clear it by this procedure. Try it? Gord
ghubbell@total.net
 
Upvote 0 Downvote
Oh and one more thing: If you didn't build the Db you should change Tools-Options-View tab: check off "Hidden objects". (People hide things sometimes....) Gord
ghubbell@total.net
 
Upvote 0 Downvote
Thanks Gord, that was my final option .. just assumed there would be an "easy" way to do this but no such luck. Scary thing is I just recently became the administrator to this database so I cant see not having permissions. Your advice is much appreciated and helpful.

Joanne
 
Upvote 0 Downvote
OoooOOo it was unchecked .. I will let you know how that works now that I can see "hidden things"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
6K
Andrzejek
Andrzejek
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
982
renigar
renigar
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top