I have created a report. This report needs to display records
between two dates entered by the user. I put two text boxes on the
report so I can enter the start and end date - I set them to use an
input mask of 'short date' format. The problem is that when I enter
anything in these text boxes, as soon as the field looses focus, the
text is cleared out - thus the text box is left blank. I have a button
on the form that calls the requery method of the report and also, as a
test, displays the values of these text boxes in a msgbox, but it also
shows they are blank. What is wrong? I can set the values by code for
the text boxes in the button's click event before calling the requery
method, and the report runs with the proper data and also shows the
text in those text boxes - I just can't seem to type values into these
text boxes. Please help! Thanks!
Andrew
4  2254 
On Sep 17, 8:56 am, "Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+"
<amead...@hotmail.comwrote:
I have created a report. This report needs to display records
between two dates entered by the user. I put two text boxes on the
report so I can enter the start and end date - I set them to use an
input mask of 'short date' format. The problem is that when I enter
anything in these text boxes, as soon as the field looses focus, the
text is cleared out - thus the text box is left blank. I have a button
on the form that calls the requery method of the report and also, as a
test, displays the values of these text boxes in a msgbox, but it also
shows they are blank. What is wrong? I can set the values by code for
the text boxes in the button's click event before calling the requery
method, and the report runs with the proper data and also shows the
text in those text boxes - I just can't seem to type values into these
text boxes. Please help! Thanks!
Andrew
You did mean that the txt boxes were on the form that calls the
report, and not the report itself, right?
On Sep 17, 11:42 am, OldPro <rrossk...@sbcglobal.netwrote:
On Sep 17, 8:56 am, "Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+"
<amead...@hotmail.comwrote:
I have created a report. This report needs to display records
between two dates entered by the user. I put two text boxes on the
report so I can enter the start and end date - I set them to use an
input mask of 'short date' format. The problem is that when I enter
anything in these text boxes, as soon as the field looses focus, the
text is cleared out - thus the text box is left blank. I have a button
on the form that calls the requery method of the report and also, as a
test, displays the values of these text boxes in a msgbox, but it also
shows they are blank. What is wrong? I can set the values by code for
the text boxes in the button's click event before calling the requery
method, and the report runs with the proper data and also shows the
text in those text boxes - I just can't seem to type values into these
text boxes. Please help! Thanks!
Andrew
You did mean that the txt boxes were on the form that calls the
report, and not the report itself, right?- Hide quoted text -
- Show quoted text -
No, the text boxes are directly on the report. They are unbound. I
can click on them and type into them, but as soon as I tab out of them
or click the other text box, or button, they were cleared out.
I now have the load event of the report coded to set the value
properties of the controls to initial dates and a call to the report's
requery method, and that works fine. However, if I try to edit the
text fields, they revert back to the values set in the load event as
soon as they loose focus.
The report is based on a saved query that uses the values from the
text boxes from the report to filter the querry.
On Sep 17, 10:54 am, "Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A
+" <amead...@hotmail.comwrote:
On Sep 17, 11:42 am, OldPro <rrossk...@sbcglobal.netwrote:
On Sep 17, 8:56 am, "Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+"
<amead...@hotmail.comwrote:
I have created a report. This report needs to display records
between two dates entered by the user. I put two text boxes on the
report so I can enter the start and end date - I set them to use an
input mask of 'short date' format. The problem is that when I enter
anything in these text boxes, as soon as the field looses focus, the
text is cleared out - thus the text box is left blank. I have a button
on the form that calls the requery method of the report and also, as a
test, displays the values of these text boxes in a msgbox, but it also
shows they are blank. What is wrong? I can set the values by code for
the text boxes in the button's click event before calling the requery
method, and the report runs with the proper data and also shows the
text in those text boxes - I just can't seem to type values into these
text boxes. Please help! Thanks!
Andrew
You did mean that the txt boxes were on the form that calls the
report, and not the report itself, right?- Hide quoted text -
- Show quoted text -
No, the text boxes are directly on the report. They are unbound. I
can click on them and type into them, but as soon as I tab out of them
or click the other text box, or button, they were cleared out.
I now have the load event of the report coded to set the value
properties of the controls to initial dates and a call to the report's
requery method, and that works fine. However, if I try to edit the
text fields, they revert back to the values set in the load event as
soon as they loose focus.
The report is based on a saved query that uses the values from the
text boxes from the report to filter the querry.- Hide quoted text -
- Show quoted text -
I've never heard of anyone getting it to work that way. By the time
the report can read the text boxes, the data has already been
queried. Access expects controls on a report to display data, nothing
more. You would be better off putting the code in the routine that
calls the report.
On Sep 17, 1:50 pm, OldPro <rrossk...@sbcglobal.netwrote:
On Sep 17, 10:54 am, "Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A
+" <amead...@hotmail.comwrote:
On Sep 17, 11:42 am, OldPro <rrossk...@sbcglobal.netwrote:
On Sep 17, 8:56 am, "Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+"
<amead...@hotmail.comwrote:
I have created a report. This report needs to display records
between two dates entered by the user. I put two text boxes on the
report so I can enter the start and end date - I set them to use an
input mask of 'short date' format. The problem is that when I enter
anything in these text boxes, as soon as the field looses focus, the
text is cleared out - thus the text box is left blank. I have a button
on the form that calls the requery method of the report and also, as a
test, displays the values of these text boxes in a msgbox, but it also
shows they are blank. What is wrong? I can set the values by code for
the text boxes in the button's click event before calling the requery
method, and the report runs with the proper data and also shows the
text in those text boxes - I just can't seem to type values into these
text boxes. Please help! Thanks!
Andrew
You did mean that the txt boxes were on the form that calls the
report, and not the report itself, right?- Hide quoted text -
- Show quoted text -
No, the text boxes are directly on the report. They are unbound. I
can click on them and type into them, but as soon as I tab out of them
or click the other text box, or button, they were cleared out.
I now have the load event of the report coded to set the value
properties of the controls to initial dates and a call to the report's
requery method, and that works fine. However, if I try to edit the
text fields, they revert back to the values set in the load event as
soon as they loose focus.
The report is based on a saved query that uses the values from the
text boxes from the report to filter the querry.- Hide quoted text -
- Show quoted text -
I've never heard of anyone getting it to work that way. By the time
the report can read the text boxes, the data has already been
queried. Access expects controls on a report to display data, nothing
more. You would be better off putting the code in the routine that
calls the report.
I've not heard of that either. A report is read only.
It's just not possible to enter data on a formated report.
You should set the date criteria in text boxes on your form to use as
a filter for your report record source.
Or use [Enter Start/End Date] in your report query criteria to invoke
an Input box when loading the report. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Michael Malinsky |
last post by:
I'm attempting to create a database which will take information from
one (perhaps two) tables and utilize that information to return
queries to a report designed in Excel.
The general idea I...
|
by: deko |
last post by:
I need to create different recordsets based on queries that use data from
unbound fields in a form. I've discovered that I can't do this, and instead
need to save the data in question (usually a...
|
by: Justin Koivisto |
last post by:
I am trying to create a report that displays a name of an advertising
source and count of the number of times it was hit between certain date
ranges. The data is split between two different...
|
by: monskie |
last post by:
Hello to all,
I have a problem which could be trivial to you guys. This
concerns opening several crystal reports on the a crystal
viewer on an ASPX page by calling window.open.
My...
|
by: john |
last post by:
My report is based on a query with user input . In my report I
have a text box with the following code: =. This works when the
query outcome is 1 or more records. But when the query output is zero...
|
by: sfjnet |
last post by:
Hi
I am relatively new to Access so I hope I am not embarrassing myself with this question.
I have created a database showing contract details (contract number, contractors, dates, other...
|
by: vunet.us |
last post by:
I want to know if this practice is effective and secure:
I have been thinking about storing some data, which my users upload,
in text files rather than database, since often I do not know how much...
|
by: Joyfully |
last post by:
I and a new user of MS Access 2003, and I need help with a report created from a form. I created a form that data is inputed weekly. I created a report to display this data in putting only the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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,...
|
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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
