I have used VBA to code the opening of a report as follows:
stDocName = "WarrantyListUn itSpecific"
DoCmd.OpenRepor t stDocName, acPreview, , "UnitType = '" & uType & "'"
DoCmd.Maximize
Form_frmUnitTyp eSelection.SetF ocus
DoCmd.Close
The DoCmd.Maximize maximizes not only the Report but also the
Switchboard with the Switchboard on top. I would like the Report on
top. Also, when the user closes the report, I want the focus to be
back on the Switchboard.
I have tried DoCmd.Restore in the Close event of the Report without
success.
Can anyone assist?
Tammy MY************* ***@wi.rr.com (remove MYEMAILIS and the 822 to get my
actual address). THANKS!!! 1  1886 
Hi Tammy,
Remove these lines from the open report procedure.
DoCmd.Maximize
Form_frmUnitTyp eSelection.SetF ocus
DoCmd.Close
Put the
DoCmd.Maximize
on the open event of your report and
DoCmd.Restore
on the close event of your report.
Your report will open full screen on top of everything and when you close it
the
DoCmd.Restore
will make your switchboard the normal size.
Regards,
Barry
"FireGeek" <fi*********@ho tmail.com> wrote in message
news:11******** **************@ c13g2000cwb.goo glegroups.com.. . I have used VBA to code the opening of a report as follows:
stDocName = "WarrantyListUn itSpecific"
DoCmd.OpenRepor t stDocName, acPreview, , "UnitType = '" & uType & "'"
DoCmd.Maximize
Form_frmUnitTyp eSelection.SetF ocus
DoCmd.Close
The DoCmd.Maximize maximizes not only the Report but also the
Switchboard with the Switchboard on top. I would like the Report on
top. Also, when the user closes the report, I want the focus to be
back on the Switchboard.
I have tried DoCmd.Restore in the Close event of the Report without
success.
Can anyone assist?
Tammy
MY************* ***@wi.rr.com (remove MYEMAILIS and the 822 to get my
actual address). THANKS!!! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Charles Crume |
last post by:
Hello;
My "index.htm" page has 3 frames (content, navigation bar, and logo).
I set the "SRC" of the "logo" frame to a blank gif image and then want to
change it's contents after the other two frames have been loaded by using a
javascript statement from the "navigation" frame, as shown below:
top.window.ccs_logo.src = 'images/ccs_logo.gif';
alert(top.window.ccs_logo.src);
|
by: Robert |
last post by:
What I would like to do is set my database so that the users can add,
change, and delete data on the forms and print the reports, but not modify
the forms, the reports, the table layouts, or use the datasheet to modify
tables. How do I do this?
Robert
|
by: Nhmiller |
last post by:
This is directly from Access' Help:
"About designing a query
When you open a query in Design view, or open a form, report, or datasheet and
show the Advanced Filter/Sort window (Advanced Filter/Sort window: A window in
which you can create a filter from scratch. You enter criteria expressions in
the filter design grid to restrict the records in the open form or datasheet to
a subset of records that meet the criteria.), you see the design...
|
by: Mike Eaton |
last post by:
Hi All,
I have a simple application that allows users to clock in and out and stores
the data for use by the payroll department. It spends most of its life as a
tray icon and when the user clicks on it, a clock-in/out form is displayed.
My problem is this:
I've added a timer to the main module to allow the user to set a time to be
reminded that they should clock back in/out. The timer works great (i.e. if
it's set to remind you at...
|
by: sara |
last post by:
I am trying my first functions in my code. I have a set of queries
that runs to create temp tables with the right data for some reports.
They can run for a long time, so I want the user to know what is in the
tables (date parameters) before running all the queries. This way, if
the data in the tables is not for the time period the user needs for
reporting, s/he knows to recreate the data.
I just want to find the data in the tables and...
| | |
by: TD |
last post by:
Hey All-
I don't think this is possible, but we'd love it if it were.
We would like to have a pane of our own design docked along the left
side of our Access application's main window. This pane might have any
number of things on it... buttons, a treeview, etc... and have a layout
we would specify. It would need to be truly docked to the main window,
like a toolbar is, and be resizable. (Some of the things we've found
for doing this...
|
by: yb |
last post by:
Hi,
Is there a standard for the global 'window' object in browsers? For
example, it supports methods such as setInterval and clearInterval, and
several others.
I know that w3c standardized several parts of the DOM, but this does
not include the window object.
Thank you
|
by: Max |
last post by:
I am editting a database created in access 2003 by another programmer.
This person has left the company for which the database was created and
no documentation. So that I could work on this database at home, I
have converted this db to 2000 which is the version I have i have on my
computer.
The problem is that none of the forms, reports, queries are visible in
the database window. The ones that have code could be accessed by
going to...
|
by: sbaird |
last post by:
Aloha from Hawaii,
I'm beating my head on the wall here. I have a recruiting contact
managment database I'm trying to create. Managers (there ar 14 of
them) have to make a certain number of recruiting calls per week, and
so many of them have to result in at least an appointment. However,
the "week" is Wednesday, 12:01pm to the following Wednesday, 12:00noon.
So here are my questions...
1) Is there a way to change the standard week...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
