I have made a database in Access
I made a report criteria form on which i use to datpickers
dtpicker0 and dtpicker1
and two command button
open button is used to open the report according to dates pick by user
i made a macro to open the report
and in where clause i use the following ccommand
date between [forms]![formname]![datpicker0] and [forms]![formname]![datpicker1] and i place two text boxes on repot having caption From , To
and control source of these boxes is Datpickers respectively.
i have date field in my table . which is for inserting dates to table .
Now this is not working .
Please any expert help me .how to open report according specifed criteria in my database according to dates.
thanks
Regards
<<ARALi>>
7  2551  
I have made a database in Access
I made a report criteria form on which i use to datpickers
dtpicker0 and dtpicker1
and two command button
open button is used to open the report according to dates pick by user
i made a macro to open the report
and in where clause i use the following ccommand
date between [forms]![formname]![datpicker0] and [forms]![formname]![datpicker1] and i place two text boxes on repot having caption From , To
and control source of these boxes is Datpickers respectively.
i have date field in my table . which is for inserting dates to table .
Now this is not working .
Please any expert help me .how to open report according specifed criteria in my database according to dates.
thanks
Regards
<<ARALi>>
you need to refer to the name property of your datepickers, not the control source. See below for an example assuming your:datepicker s are named date0 and date1. Also, using Date in your expression/table is a bad idea because it is a reserved word in Access. I changed date to uDate in your expression. You also need to change it in your table.
uDate between [forms]![formname]![date0] and [forms]![formname]![date1]
you need to refer to the name property of your datepickers, not the control source. See below for an example assuming your:datepicker s are named date0 and date1. Also, using Date in your expression/table is a bad idea because it is a reserved word in Access. I changed date to uDate in your expression. You also need to change it in your table.
uDate between [forms]![formname]![date0] and [forms]![formname]![date1]
Thank for your help
I change date field to udate as you said
but still it not working .
whe i chosse same dates in both dtpicker ie 24-1-08 and 24-1-08
the report displyas nothing it remain blanck. while both values not same .then i shows all data which i store in table.ie 24-1-08 and 25-1-08
or 23-1-08 and 25-1-08 etc
i use a textbox on the report which is bound to udate and not visible.
Now please tell me how it show only the data of specified dates choose in both
datepickers.say it only show data of 24-1-08 which is store in the table on mentioned date.
And how it will show me all data when i not choose from datepickers.i.e they remains unchecked .
the datepicker which i am using both have there own check boxes when i set check box =no in propertise of each dtpicker it give me error.
And for the udate in my main form i also have a dtpicker which is bounded to the udate.And to display the current date i use the following coding in form load event dtpickername.te xt= date
this show me the current date of system .now question is ! it store date in udate? i think i does because it controlsource is udate.
I asked too many question but hopping as expert you can help me.
Thank You i will be waiting for your kind reply.
Regards
<<ARALI>>
Thank for your help
I change date field to udate as you said
but still it not working .
whe i chosse same dates in both dtpicker ie 24-1-08 and 24-1-08
the report displyas nothing it remain blanck. while both values not same .then i shows all data which i store in table.ie 24-1-08 and 25-1-08
or 23-1-08 and 25-1-08 etc
i use a textbox on the report which is bound to udate and not visible.
Now please tell me how it show only the data of specified dates choose in both
datepickers.say it only show data of 24-1-08 which is store in the table on mentioned date.
And how it will show me all data when i not choose from datepickers.i.e they remains unchecked .
the datepicker which i am using both have there own check boxes when i set check box =no in propertise of each dtpicker it give me error.
And for the udate in my main form i also have a dtpicker which is bounded to the udate.And to display the current date i use the following coding in form load event dtpickername.te xt= date
this show me the current date of system .now question is ! it store date in udate? i think i does because it controlsource is udate.
I asked too many question but hopping as expert you can help me.
Thank You i will be waiting for your kind reply.
Regards
<<ARALI>>
I am not following everything you are saying, but it sounds like you are using an activeX date picker. If that is the case, I recommend that you use one of the following date pickers instead of the ActiveX one you are using because they are native ms access forms, don't cause any conflicts with different versions of ms access, and come with specific easy to install and use instructions.
Are you interested in trying one of these free date pickers? http://allenbrowne.com/ser-51.html http://www.glump.net/dokuwiki/softwa...ss_date_picker
I am not following everything you are saying, but it sounds like you are using an activeX date picker. If that is the case, I recommend that you use one of the following date pickers instead of the ActiveX one you are using because they are native ms access forms, don't cause any conflicts with different versions of ms access, and come with specific easy to install and use instructions.
Are you interested in trying one of these free date pickers?
http://allenbrowne.com/ser-51.html
http://www.glump.net/dokuwiki/softwa...ss_date_picker
Thank for your reply
What i said is when i choose same date in both dtpicker in criteria form the
report shows nothing no recored.
But when the dates in report are not same then it show all data
even ,not that recored which is store between the spcifeid dates.
for example when i choose dates like 24-1-08 and 24-1-08
then report sows nothing.
And when i choose 23-1-08 and 25-1-08 now report show me all recored but the problem is now it show me recored of 22-1-08 ( i mean that all recoreds)
which is not according to criteria(accord ing to criteria it should show me only recored of 23 jan and 25 jan") but this is not the case.
I think i clearify what i am saying .Now you can help me betterly .
I also down load dtpicker you sujjested
thanks
Regards
<<ARALI>>
Thank for your reply
What i said is when i choose same date in both dtpicker in criteria form the
report shows nothing no recored.
But when the dates in report are not same then it show all data
even ,not that recored which is store between the spcifeid dates.
for example when i choose dates like 24-1-08 and 24-1-08
then report sows nothing.
And when i choose 23-1-08 and 25-1-08 now report show me all recored but the problem is now it show me recored of 22-1-08 ( i mean that all recoreds)
which is not according to criteria(accord ing to criteria it should show me only recored of 23 jan and 25 jan") but this is not the case.
I think i clearify what i am saying .Now you can help me betterly .
I also down load dtpicker you sujjested
thanks
Regards
<<ARALI>>
Sounds like your datefield and your datepicker are using different date formats.
1. Make sure your Windows location settings are correct? I would
have thought that if the Windows regional settings are correct, that
date formats would get handled according to your date format.
2. Try this if the above does not help.
Format(uDate,"d d/mm/yyyy") between [forms]![formname]![date0] and [forms]![formname]![date1]
Sounds like your datefield and your datepicker are using different date formats.
1. Make sure your Windows location settings are correct? I would
have thought that if the Windows regional settings are correct, that
date formats would get handled according to your date format.
2. Try this if the above does not help.
Format(uDate,"d d/mm/yyyy") between [forms]![formname]![date0] and [forms]![formname]![date1]
CAN YOU GIVE ME YOUR EMAIL ADDRESS THAT I CAN EMAIL MY DATABASE TO YOU .THAT YOU CHECK IT AND SEND ME BACK
REGARD
<<ARALI>>
CAN YOU GIVE ME YOUR EMAIL ADDRESS THAT I CAN EMAIL MY DATABASE TO YOU .THAT YOU CHECK IT AND SEND ME BACK
REGARD
<<ARALI>>
Unless your DB uses Access Version 2000, I won't be able to look at it. If it does use Access 2000, then you can get my email address by downoading the VCard in my profile.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: deko |
last post by:
I can't move a multi-page report to the last record unless I keep the popup
form (that defined it's subreports) open.
DoCmd.OpenReport "rptStandard", acViewNormal
DoCmd.Close acForm, "frmReportOptions" <== popup form
This is the error I get when I try to move to the last page of the report
*after* closing the popup:
"This expression is typed incorectly, or is too complex to be evaluate...."
|
by: Dennis Ruppert |
last post by:
Greetings
This is rather ambitious:
I have a split database that contains many different reports. I have a
form that the end user launches the reports from. They select the
report criteria from several combo boxes, click a "Go" command button
to launch the report. I then pass the report criteria to various
report "templates" as an SQL string.
|
by: pelcovits |
last post by:
I am trying to set up an unbound form to enter report criteria.
I've followed the MS Office Assistance document: "Create a form to
enter report criteria" which describes how to enter data (such as
dates) in a text box. This procedure works fine. However, I also need
to enter data from a combo box and I cannot get this to work. On my
form I've created an unbound combo box named "Name". In the query bound
to the report I've entered the...
|
by: |
last post by:
hi,
i have a form on which a user can choose specific criteria such as dates
etc, in order to filter the report that is called from the form.
i do this by using the Where section of the docmd.openreport as follows
DoCmd.OpenReport stDocName, acPreview, , strWhere
where strWhere is a string dependant on the choices the user makes in the
|
by: Bob Alston |
last post by:
I am looking for Access reporting add-in that would be easy to use by
end users. My key focus is on selection criteria. I am very happy with
the Access report writer capabilities. As far as development of
reports, it is certainly fine in my book.
But for end-users, with little experience or training, it would be nice
to have an easy way to handle various selection criteria, perhaps with
relatively stock reports. I see easy to use by...
| | |
by: lorirobn |
last post by:
Hi,
I have a report that works just fine.
Now I would like to add the capability to choose selection criteria to
limit what is displayed. I created several reports that do this, but
they used VBA to create SQL statements, then apply them. Now that I
have been using Access/VBA for awhile, I am wondering if there is a
simpler way to do this than coding these long sql statements.
My report has a query as its record source. Can I just...
|
by: rinmanb70 |
last post by:
I have a QBF form/query and a report from the QBF that shows the
results of the QBF. I would like to show the criteria on the report
that was used in the QBF to get the info on report. I can't find how
to do this except to show the "hard for users to understand" SQL WHERE
statement. Anyone have a better way?
|
by: Ceebaby via AccessMonster.com |
last post by:
Hi All
Here's hoping someone can help me with this.
I have a report based on a query where the criteria for 4 of the fields is
set from an unbound form. I want the user to be able to select any
combination of the combo boxes, some might not be selected etc etc.
ie they may want to select the area and ward to show on the report but not
the case officer or the property type
|
by: martin DH |
last post by:
Hello,
I have a report that I open that pull its data from a form that builds a where string. Opening the report first opens the form, where I enter criteria, and then pulls matching records from a table, opens the report, and closes the form. The code on the report is below.
I used this code on a similar report that also pulled its data from a form (the difference was that that form supplied criteria to an actual query - my new form...
|
by: Studiotyphoon |
last post by:
Hi,
I have report which I need to print 3 times, but would like to have
the following headings
Customer Copy - Print 1
Accounts Copy - Print 2
File Copy -Print 3
I created a macro to print the report three times, but do not know how
|
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: 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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
