473,396 Members | 1,755 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Passing date parameter from Form to Query

doma23
107 100+
Hello everyone,
I didn't use Access some time and now I'm struggling for couple of hours already with something that I used to know...

I need to pass the parameter (date) from a comboxes on a form to a query.

This is what I have in the query for particular date field:

Expand|Select|Wrap|Line Numbers
  1. IIf
  2. ([Forms]![frmOutput]![cboStartdate] Is Null 
  3. Or [Forms]![frmOutput]![cboEnddate] Is Null;
  4. [tblConsensus].[ReportDate];
  5. [tblConsensus].[ReportDate] Between 
  6. [Forms]![frmOutput]![cboStartdate] And 
  7. [Forms]![frmOutput]![cboEndDate])
On the form I have a RUN command which the user should press after selecting StartDate and EndDate in the combobox.

The problem is that nothing is shown after pressing RUN button, although the date range exists.
It seems to me that there is a problem with the format of the date, maybe it's not adding ## signs, I dunno...

Help!!
Thanks!
May 2 '11 #1
1 2956
Narender Sagar
189 100+
Although your query is about two months old, but since I newly joined this group, I am wondering your issue is resolved or not. If you can attach sample database, may be I'll have a look into the issue in that.
regards
Sagar
Jul 20 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Dalan | last post by:
I have attempted to resolve a problem regarding erroneous output using a Between And parameter on several Access 97 queries, but to no avail. The queries are used for report output and...
0
by: Liz Malcolm | last post by:
I have created a db for a non-profit, contacts, volunteers, donors, etc. Our statistical year ends on the last Sunday of September and starts on the first Monday following. Our statistical...
4
by: Andy Davis | last post by:
I have developed a number of reports that are based on parameter queries where the user enters criteria such as a date range and a sales rep say. I want to be able to show a graphical picture in...
0
by: lewindha | last post by:
Hi all I am new to ASP.Net and Crystal Reports. We have VS.Net 2003 and Crystal 10 where I work. I have successfully been able to view reports in a web page. My problem now is that I have a...
3
by: IntraRELY | last post by:
I have the following function, Notice how I am passing the dateInterval as a string. What is the correct way to pass "DateInterval.Year" as a variable to a function? TIA, Steve Wofford...
2
by: vaibhav | last post by:
Hi I am writing a wrapper over the XALAN XSLT engine, for transforming XML documents. My problem is that I need to pass date as a parameter ( with format mm/dd/yyyy hh.mm.ss) to the XSLT engine at...
3
by: Jahangir | last post by:
Dear Fellows, I m in in Access VB, and working on a small project. Problem is that In main form (called search )I have made a textbox name text34, and a search button, which responsiblity is...
2
by: de_ja | last post by:
Hi, If, for example an access database that concerns insurance claim investigations. The database comprises only one table containing data - investigation reference number, referral date,...
3
beacon
by: beacon | last post by:
Hi everybody, I have a form for every report in this latest database that I use to accept parameters for the underlying query. On the form, I have a command button that launches a calendar module...
1
by: Meerakhanna | last post by:
I am getting error when debugging a project. The error is as below, "FormatException was unhandled String was not recognized as a valid DateTime." Highlighting the following line
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
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
0
BarryA
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...
0
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...
0
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...
0
Oralloy
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,...
0
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...
0
tracyyun
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.