Database Window Shows After Printing Form

Feb 16, 2005

Hello team,

My database window is hidden.

I have a form with data about an article. When I click a button, another form opens showing a sales graph of that article.

On the form with the graph, I have put another button to print it. The code behind that button is:

Private Sub printpriceevolution_Click()
On Error GoTo Err_printpriceevolution_Click

Dim stDocName As String
Dim MyForm As Form

stDocName = "frm_priceevolution"
Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, stDocName, True
DoCmd.PrintOut
DoCmd.SelectObject acForm, MyForm.Name, False

Exit_printpriceevolution_Click:
Exit Sub

Err_printpriceevolution_Click:
MsgBox Err.Description
Resume Exit_printpriceevolution_Click

End Sub

The funny thing is that after the printing (which works fine) my database window is shown, where it is supposed to be hidden.

Any idea what could trigger this? Does it have to do with pop-up dialog box settings?

Thanks

View Replies


ADVERTISEMENT

Button Shows Verify Window Before Update?

May 17, 2006

I would like to have a button on my form that would update a record to a closed status, but I want to have an "Are You Sure?" window pop up first. I did a search on "verify," "verification," "sure," and several others but haven't found what I need. I looked through my Access bible, with no luck.

Any help is GREATLY appreciated. Thanks!

View 3 Replies View Related

Modules & VBA :: Way To Grab Text From The Window That Shows Location Of File

Jun 18, 2015

I want to find a way to grab the text from the window that shows the location of the file using vba in Access.

View 3 Replies View Related

Toggling Linked Subform Shows Parameter Entry Window Twice?

Mar 9, 2014

I have two subforms in a main form. book_sub and book order subform. there are various subforms which i toggle in book order subform window by changing their properties with command button on main form. here is the code -

Code:
private sub billq_click()
Me.BOOK_SUB.SourceObject = "BILLQ"
Me.BOOK_SUB.LinkMasterFields = "[BOOK ORDER SUBFORM].FORM![ORDER ID]"
Me.BOOK_SUB.LinkChildFields = "[order ID]"
private sub stock_click()
Me.BOOK_SUB.SourceObject = "stock"
Me.BOOK_SUB.LinkMasterFields = "[BOOK ORDER SUBFORM].FORM![BOOKCD]"
Me.BOOK_SUB.LinkChildFields = "[BOOKCODE]"

Now the problem is when i change billq to stock it shows parameter entry window with caption [order id] twice. after clicking ok it does toggle the form to stock. then when i click button for billq again it shows the same thing.

the code works fine except showing parameter entry window twice with every toggle.

View 2 Replies View Related

Modules & VBA :: Form Window To Popup On Opening Database

Dec 4, 2013

How I configure my Form Window to pop up as soon as I open my Access Database?

View 3 Replies View Related

General :: Database Window Becomes Inactive And Cannot Open Another Form / Report

Aug 17, 2014

I have just noticed when I open one of my forms . the database window becomes inactive and I cannot open another , form , report etc.

View 2 Replies View Related

Forms :: Set Form Property To Window In Database Set To Use Tabbed Documents

Oct 16, 2013

I'm using access 2010.

How to set a single form's property to act as it's own "overlapping window" in a database that is set to use tabbed documents. I want most windows to have the tabbed layout but there are a few that I would like to have pop out and be their own windows.

I noticed that the Northwind database did this somehow. if you click on one of the products from the home screen a form pops up in its own window. I tried reverse engineering it, but no luck so far.

View 2 Replies View Related

Database Window Help

Mar 12, 2006

hi

ive been disabling the database window from the startup tab in MS access, just now when ive tryed to show it on startup it appears but its stuck in the top left hand corner and i cant move it! so i cant access the tables

help any1 pleassse

View 1 Replies View Related

Database Window

Mar 13, 2007

I've imported somebody's access db which hides the database window by default. When I click the db window button in the toolbar, the db window pops up high up and is somewhat hidden by the toolbar. I can't pull it back down as the top is hidden and when I try to move the toolbar,the db window simple moves up so I can't grab it and move it. Any suggestions?

scratch

View 1 Replies View Related

Database Window?

Apr 14, 2008

This may seem silly and I've seen no mention of it in this forum yet but the "Database Window" from previous versions of Access is now called the "Object Browser"? I had code to hide the database window on startup but can't seem to find a way to hide the object browser on startup. Any ideas? Also, is there another way to view my objects in ACC07 because this way is slowing me down tremendously! It's much more difficult to find the objects I'm trying to work on and visually see where I left off. Any help would greatly be appreciated! Thanks in advance.

View 6 Replies View Related

How Unhide Database Window

Sep 13, 2006

Dear Friends I made my a stupid mistake and I don't know how to rectify it.

There is a inventory software built in access xp. In order to protect database I've cleared all the options from that is

a) Display Startup form
b) Display status bar
c) Allow Full menus(Changed with Custome Menu)
d) Allow Default shortcut keys
e) and foolish thing cleared Use special key also

I've given a task to modify program where I may have to add New form. I don't know how to unhide database window. pls suggest me what to do....

View 2 Replies View Related

Database Window Not Opening

Dec 13, 2006

I have a weird problem with one of my databases. Out of a sudden, when I wanted to open that database the databse window did not show up anymore. With this I can not access my forms, tables etc. any longer. However, when I click on View->Databaseobjects and choose e.g Forms than I can click on the code icon and I can access my code as well as the corresponing form in the design view. I can not access the tables but when I click on the "show fields" in the design view the list of fileds is showing for the corresponding form.

I tried that database on 3 different PC's with the same effect.

Does anybody have an idea what could have caused that the database window is not showing anymore and/or how could I bring that window back.

Thanks for any help and advice

Josef

View 2 Replies View Related

Hide Database Window

May 9, 2006

I need to find a way to not allow users to access the backend by using the database window. Is there a way I can password protect this?

Thanks

View 5 Replies View Related

Hiding The Database Window.

Jun 20, 2006

Think I've seen this posted on here recently but cant find it.

Is there a way to hide the database window so that only a form is visible?

Then if you need to view the database window you can press F11 to make it appear?

View 1 Replies View Related

Database Window Missing

Mar 29, 2006

Hi,

Can anyone tell me how to display the database window that shows all the forms, queries, tables etc in a database?

I have an Access database with startup restrictions and startup login screen. I can open the database by holding down the SHIFT key to bypass the startup options but when Access opens there appears to be no Database Window. I can create new objects in the database ok its just that there is no main database window from where I can browse objects. This is driving me mad - i know it's probably something simple but I rarely work with access

thanks
Maracatu

View 5 Replies View Related

Hide Database Window

Feb 23, 2007

I am looking to minimize the access window when my database is opened. I already set it to do that from the startup menu, but all that did was open my specified form on open. I want it to actually only show my form w/ acces on the startup tray. Any suggestions?

View 14 Replies View Related

Get The Database Window Back After Hiding It.

Aug 31, 2005

Hi,

I have a question;

If I hide the Database window and uncheck the Allow Full Menu checkbox from Tools--> Startup


The next time I open the application how can I get them back?

Any help will be very appreciated,
Thanks,
CS.

View 1 Replies View Related

Password Protect Database Window??

Sep 6, 2005

Hi,

How can I hide the Database window with password protection?

For example, if someone attempts to access the Database Window, they would be promted to enter the password before they can see the tables and queries...


Thanks for your help

View 1 Replies View Related

Preventing Access To Database Window

Oct 13, 2005

I have an Access FE app with an Access BE.

I need urgent suggestions as to how to prevent access to the database window even when the SHIFT key is pressed when loading the app.

This is very important so as to increase data security and prevent unauthorised data change by users.

Thanks for the expected response.

Peter
Nigeria

View 2 Replies View Related

Start Up Database Window Problem

Jan 18, 2006

I recently created a database to be posted on a network. In order to eliminate users prying into the mechanics of the database, I unclicked some menus on start up. The database is also password protected. I did such a good job that now I can't get into the database window myself. I used shift while opening the database, which used to work, but now I get the password box which brings me to the switchboard form. F11 doesn't work either.

Does anyone know how I can reverse this process so I can get into my database window and get full menus again?

View 3 Replies View Related

Please Help, How To Stop Database Window Poping Up

Mar 22, 2006

Hi
We have recently upgraded our computers and therefore reinstalled Office on the new machines. The opreating system is Win XP + patch 2. The version of MS Access is 2002

For all our databases I have chosen to hide the database window, so other user don't accedentally change tables and queries etc. Now the problem is, with the new computers, whenever I minize the database and then open it, the database weindow pops up right on top of every thing else automatically.

I have no idea why this happens and how to stop it. Could any one please shed some light. Your help would be apprecialted.

Regards

Airdesign

View 3 Replies View Related

Database Window Not Coming To Front

Sep 15, 2006

This is I think a very simple query.

with a number of forms/ queries etc open and you click on at the back it is not coming to the front for amendment.

It is probably an indicator somewhere but I just can't find it

any help appreciated

Ta

humph

View 3 Replies View Related

Database Window Showing Problem

Feb 21, 2007

Hi All,

I have a database that is locked down with user-level security, and also have my startup settings set so Display Databse Window is unchecked.

This all works fine, and when the user opens the database, the form I want them to see appears, and everything else is locked down.

EXCEPT - if anyone minimizes Access, then maximises it again, the Data Window appears in the windows taskbar!! So anyone can click on it to display it in Access and can view all the macros, forms, tables etc that I've tried to prevent access to! :confused:

Anyone come across this before??

Thanks in advance, dglover

View 2 Replies View Related

Show The Database Window When Closing

May 31, 2007

Hi,

When the user open the database, the database window will be hided. But, when the user close the database with one form opening, it will show the database window for a while, and then close it.

How to prevent the database window to show at the moment?

View 1 Replies View Related

My Database Window Has Half Disappeared!

Aug 2, 2007

Can anyone help with this ANNOYING problem?!

The Database Window within Access on my computer seems to have kinda half disappeared under all the toobars at the top of the screen. Each time i open it it seems to have moved further up. The problem is, that because it is underneath the toolbars, I can't click on the window of it to drag it back down! Now, its got so far up that i can't even select any of my tables, forms, queries or reports because i can't see them!

Its SOOO annoying! and i have no idea what to do about it!

Help please.....:confused:

View 3 Replies View Related

Unable To Access Database Window.

Oct 2, 2004

I have a .mdb that opens up to a form (a splash screen I would assume). However, I can not access the form design view or even get the database window. I thought limiting access to design view was done with .mde, even then you have access to the database window. Any explanation on this or help??

Thanks

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved