473,323 Members | 1,589 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

standard view in database window

Hello,

I'm developping a new application (btw: I'm not a real specialist but
more or less a newbie). Now I have the following problem:
Each time I leave the main form of the application Access shows the
tables collection in the database window (I don't know why). How can I
force Access to show the forms collection in the database window without
selecting it manually. I'd prefer to select the forms when the main
applicatiion form is closed. Later on (when the application seems to be
finished) the database window will be hidden, but in the development
phase I want to see the database window.

Thank you for your kind assistance
Michael
Nov 13 '05 #1
2 1857
"Michael König" <br******@gmx.net> wrote in message
news:d7**********@online.de...
Hello,

I'm developping a new application (btw: I'm not a real specialist but more
or less a newbie). Now I have the following problem:
Each time I leave the main form of the application Access shows the tables
collection in the database window (I don't know why). How can I force
Access to show the forms collection in the database window without
selecting it manually. I'd prefer to select the forms when the main
applicatiion form is closed. Later on (when the application seems to be
finished) the database window will be hidden, but in the development phase
I want to see the database window.

Thank you for your kind assistance
Michael


Create a new module and paste in the following:
' Code Start
Option Compare Database
Option Explicit

Public Function DoStartup() As Boolean

On Error GoTo Err_Handler

DoCmd.RunCommand acCmdAppMaximize

DoCmd.SelectObject acForm, , True

DoStartup = True

Exit_Handler:
Exit Function

Err_Handler:
MsgBox Err.Description, vbExclamation, "Error No: " & Err.Number
Resume Exit_Handler

End Function
' Code End
Then compile the code and save it as modStartup. Then create a new macro
named AutoExec which should have a single step with action RunCode the
function name should be DoStartup() Then whenever you start the application
the forms tab is selected.


Nov 13 '05 #2
Michael König wrote:
Later on (when the application seems to be
finished) the database window will be hidden, but in the development
phase I want to see the database window.


Then you're wasting a lot of time on an issue of no importance to your
application.

If you opened a form from the form tab of the database window then that
tab remains active. But again, who cares? Why waste time on something
that your users aren't going to see, anyway? Focus on the important
stuff! 8)

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Corrie Meyer | last post by:
Announcement: SwiftReports standard edition 1.0 for Visual Studio ..NET 2003 released by UniSwift. We are pleased to announce the first release of a fully-managed reporting tool for the...
12
by: Neil | last post by:
I previously posted re. this, but thought I'd try again with a summary of facts. I have an Access 2000 MDB with a SQL Server 7 back end. There is a view that is linked to the database via ODBC...
2
by: Stan | last post by:
I want to make two pages interact through a controller. 1. Page A has a grid and Add button. 2. When Add button is clicked Page B pops up. 3. User enters information and clicks Save 4....
23
by: Nishant Saini | last post by:
Dear All, We have a database which contains many tables which have millions of records. When We attach the database with MS SQL Server 2005 Standard Edition Server and run some queries (having...
3
by: mnjkahn via AccessMonster.com | last post by:
I'm running Access 2003, modifying a query that has over 45 fields. When I right click on the field name in Query Design View, and then click Build, Access crashes before the Build window...
1
by: Farhaad Faaique | last post by:
Dears, how can i enable a from's design view when it is disabled? (the database doesn't have any passwords to be accessed but it has password for vba codes). thanks in advance, Farhaad
3
by: Jeff Couch - Academy Roofing | last post by:
In my office everyone has access to a database. All the computers/ users work well with it. One computer, no matter who is signed in, defaults to design view when opening any database. We don't...
2
by: bobh | last post by:
Hi All, Anyone have code to share that would detect if a database was opened to database window view??? and since holding the 'you know which key' down, no form is loaded, the autoexec marco...
12
by: MNNovice | last post by:
I have a database in Access 2003. All of a sudden I am unable to open the property window for reports (in design view). Although the property window is visible for other objects such as, forms. ...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.