Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / October 2005

Tip: Looking for answers? Try searching our database.

Closing form, closes the application.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BillyR - 30 Oct 2005 15:12 GMT
I have a simple inventory control application I made by modifying the Access
Wizzard generated Asset Control database.  It uses the Microsoft Switchboard.
I have Office Pro 2000 at home.  The application works great in my computer.
I installed it in a lap top with Office XP installed.  I can open the
application and the switchboard displays; but, when I open any form from the
switchboard and subsequently close it, I do not return to the switchboard.  
Access closes entirely!  No error messages or warnings.
Signature

Senior Moments

Allan Murphy - 30 Oct 2005 22:06 GMT
What is the coding used to close the form?

Signature

Allan Murphy

Email: allanmurphy@unwired.com.au

> I have a simple inventory control application I made by modifying the Access
> Wizzard generated Asset Control database.  It uses the Microsoft Switchboard.
[quoted text clipped - 3 lines]
> switchboard and subsequently close it, I do not return to the switchboard.
> Access closes entirely!  No error messages or warnings.
BillyR - 30 Oct 2005 22:17 GMT
I have no coding attached to closing the form.  The problem occurs just using
the "X" close button on a form because the switchboard form never closes.  
Normally, I would hide or close the switchboard and reopen it when the called
form closes.  This application is so small I did not think i needed to add
this code.  Thanks for looking at this for me.
Signature

Senior Moments

> What is the coding used to close the form?
>
[quoted text clipped - 9 lines]
> > switchboard and subsequently close it, I do not return to the switchboard.
> > Access closes entirely!  No error messages or warnings.
Allan Murphy - 30 Oct 2005 22:36 GMT
On the forms that I use, I place a command button which I call CLOSE that
allows the user to close the current form and return to the switchboard.
On the switchboard the last menu item on the Main menu I use for the user to
exit the application.
Signature

Allan Murphy
Email: allanmurphy@unwired.com.au

> I have no coding attached to closing the form.  The problem occurs just using
> the "X" close button on a form because the switchboard form never closes.
[quoted text clipped - 15 lines]
> > > switchboard and subsequently close it, I do not return to the switchboard.
> > > Access closes entirely!  No error messages or warnings.
BillyR - 30 Oct 2005 23:31 GMT
I normally do to.  I am still baffled that it runs perfectly in my computer.  
When I open access in the lap top, it does not look normal at all.  The lap
top is running Office XP Pro, Access is 2002.  I do not get see any way to
convert the application.  I think the lap top may have a student version.  
Could that be the problem?
Signature

Senior Moments

> On the forms that I use, I place a command button which I call CLOSE that
> allows the user to close the current form and return to the switchboard.
[quoted text clipped - 23 lines]
> switchboard.
> > > > Access closes entirely!  No error messages or warnings.
Allan Murphy - 31 Oct 2005 00:03 GMT
Sorry, I do not know.

Just a thought try the following

1. You maybe missing some references in the Laptop version.

2. Create a new database call it TEST on the laptop do not use any wizards
then import your tables queries forms etc from your inventory database and
see if you have any problems.

3. Create an Inventory database using the wizards on your laptop and see if
it works.

Signature

Allan Murphy
Email: allanmurphy@unwired.com.au

> I normally do to.  I am still baffled that it runs perfectly in my computer.
> When I open access in the lap top, it does not look normal at all.  The lap
[quoted text clipped - 29 lines]
> > switchboard.
> > > > > Access closes entirely!  No error messages or warnings.
BillyR - 31 Oct 2005 00:47 GMT
I cannot get the lap top to show wizzards or even the standard tool bars.
Signature

Senior Moments

> Sorry, I do not know.
>
[quoted text clipped - 53 lines]
> > > switchboard.
> > > > > > Access closes entirely!  No error messages or warnings.
Bob Miller - 31 Oct 2005 15:57 GMT
Try View, Toolbars and seeing if the Database one is checked.  Try
opening your database from within Access while holding down the Shift
key.  This will bypass Startup settings if there are any or try View,
Startup and see if there are any toolbars/menus that are disabled (this
is with your database open in Access.)
BillyR Wrote:
> I cannot get the lap top to show wizzards or even the standard tool
> bars.
[quoted text clipped - 93 lines]
> --
> Senior Moments

Signature

Bob Miller

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.