Simple problem, but I've checked the newsgroups and couldn't find an
answer.
On the main swithboard is a command button to open a report. The
report I built is based off a query, and the query is now restricted
by the simple "Between [Enter Beginning Date:] And [Enter Ending
Date:]". What I want to do is pass the values of the two parameters
into some textboxes in the heading of the report (so if 12/1/03 and
12/31/03 are the parameters, I can display the entered dates in the
report). Feel free to include solutions with Getz\Litwin's
TaggedValues classes. 4 3342
The easiest way may be to use a pop-up form in the report's open event to
query for these values. The query and the report could then refer to the
values on the form. Open the form with the acDialog window mode argument to
halt the code on the report. The code will resume when you hide the form.
You would then close the form when you close the report.
--
Wayne Morgan
Microsoft Access MVP
"Greg Iocco" <gi****@kub.org > wrote in message
news:42******** *************** **@posting.goog le.com... Simple problem, but I've checked the newsgroups and couldn't find an answer.
On the main swithboard is a command button to open a report. The report I built is based off a query, and the query is now restricted by the simple "Between [Enter Beginning Date:] And [Enter Ending Date:]". What I want to do is pass the values of the two parameters into some textboxes in the heading of the report (so if 12/1/03 and 12/31/03 are the parameters, I can display the entered dates in the report). Feel free to include solutions with Getz\Litwin's TaggedValues classes.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You can put the query's pop-up parameters in a report's Text Box's
ControlSource property like this:
ControlSource: =Format([Enter Beginning Date:], "d mmm yyyy")
When the report runs the Text Box will display a date string like
this: "20 Jan 2004"
HTH,
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQA2E7IechKq OuFEgEQKW8ACdHF SvZ/nWY2n9acw2Qp4uX v6t+QgAnjhp
1M6LFMJe05yFSwR Eo3NRSGsN
=nLNy
-----END PGP SIGNATURE-----
Greg Iocco wrote: Simple problem, but I've checked the newsgroups and couldn't find an answer.
On the main swithboard is a command button to open a report. The report I built is based off a query, and the query is now restricted by the simple "Between [Enter Beginning Date:] And [Enter Ending Date:]". What I want to do is pass the values of the two parameters into some textboxes in the heading of the report (so if 12/1/03 and 12/31/03 are the parameters, I can display the entered dates in the report). Feel free to include solutions with Getz\Litwin's TaggedValues classes.
How about having the query read directly from the text boxes on the
form and take the pop-ups out of the query? the user has to type the
values into the form instead of into pop-ups.
for example let's say you name them txtFromDate and txtToDate and your
switchboard form is called Switchboard.
your criteria might look like: Between #forms!Switchbo ard!txtFromDate #
and #forms!Switchbo ard!txtToDate#
HTH
Pachydermitis
your criteria m gi****@kub.org (Greg Iocco) wrote in message news:<42******* *************** ***@posting.goo gle.com>... Simple problem, but I've checked the newsgroups and couldn't find an answer.
On the main swithboard is a command button to open a report. The report I built is based off a query, and the query is now restricted by the simple "Between [Enter Beginning Date:] And [Enter Ending Date:]". What I want to do is pass the values of the two parameters into some textboxes in the heading of the report (so if 12/1/03 and 12/31/03 are the parameters, I can display the entered dates in the report). Feel free to include solutions with Getz\Litwin's TaggedValues classes.
> You can put the query's pop-up parameters in a report's Text Box's ControlSource property like this:
ControlSource: =Format([Enter Beginning Date:], "d mmm yyyy")
That's what I was looking for. Thank you everyone for the help. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Kevin |
last post by:
When I run the query (please see below) between 08:30:00 and 17:29:59, I
get the data from row 1; if I run the same query between 17:30:00 and
08:29:59, I get the "empty set."
Can anyone explain why?
Many thanks!
Table SQL:
|
by: Bernd Hohmann |
last post by:
Hi there,
we're currently convert an old ISAM application to Java and DB2.
Among the load of problems we found the reports which have user
selections like "select all data between mm/yyyy and mm/yyyy".
Means: if the user enters "10/2004 - 10/2005" everything between
"2004-10-01" and "2004-10-31" is selected.
|
by: Jaycee66 |
last post by:
Access 2000 "Between" query question:
I am relatively new to MS Access and everytime I think I have a basic
concept of the program it pokes me in the eye with something I think
would be simple to create.
I want to create 2 separate queries for a label. I would like to have
the query prompt me for the date I choose to start from until the
present date and the other to prompt me for the date I choose to start
from and 2 additional numbers...
|
by: CrystalDBA |
last post by:
I usually design applications in SQL Server and Crystal Reports. I
now need to create a crystal report on an MS Access database.
I have two tables:
Services:
Date datetime
Entry text
Amount number
(should be 4 records)
|
by: John Baker |
last post by:
Hi:7
Newby here to ASP, and using the ASP.NET Web Matrix development tool. While that tool
looks great for a Newby, I have run into a snag. I have an HTML Text Box which I have
named HireInput, and a table (Access Table in fact) that has on it a field called HIREID.
I wish to select records where the two match! It sounds simple, but I am having trouble
setting up the text box name so that it is recognized in the query.
Can someone...
| |
by: Chris Strug |
last post by:
Hi,
I'm working with VB 2005.net and have managed to get my head around passing
values between forms by creating properties of the relevant form classes.
However, say that I have a number of values which I wish to exchange (for
example, an employee record, name, position, etc). At the minute I'm using a
seperate property to for each "field".
I was wondering, is there a way to collate all the fields into one "object"
|
by: cryptotech2000 |
last post by:
I am trying to filter this query based on date ranges but it don't seem to be working correctly, its probably something really simple if anyone can help me with this
select ReceivedDate,orderstatus WHERE RecieveDate BETWEEN ''20071101' AND '20071231'
,count(case when dcoc = '88' then 1 end) as cnt88
,sum(case when dcoc = '88' then ordertotal end) as sls88
from orders
group by ReceivedDate,orderstatus
order by...
|
by: JLeitner08 |
last post by:
I have a report that has criteria in the query, that will ask for a starting and ending date, a location, and a type. Alone, the parameters work great for the report. Now I want to add a subreport for a summary, and I want the subreport to use the same criteria as the original. Right now I do not have any criteria in the subreport query, only in the original report query. When I link the subreport to the original report, using those fields that...
|
by: anwest75 |
last post by:
Hi, I'm not a newb to Access but have recently migrated to 2007 and suddenly my method doesn't seem to work. I'm generating a service award report where I need to show only those employees hitting a milestone during a certain period of time. I've had Access calculate the appropriate milestone date, and now I want to pull only those records where the milestone date is within a range of dates that the user enters. Here is an example of my WHERE...
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |