Opening a filtered form based on a selected date

[big-div]

Hi All,



Just trying to build a database that manages bookings and customers.

I have a form that is opened by clicking the "New Booking" Button on a datasheet next to the name.


which opens this form:


Now what I want to be able to do, is select a date using the date picker on the first field there, "Rental_date" then click the Open form button, (which should be "Check date" or something..) which would take me to a form that lists either all the records of bookings on that date or display a message saying " No bookings on this date ! " . I've tried the built in function using the macro code, but that does not do anything, all i get is a blank datasheet !


The weird thing is, if i add the same button again using the wizard to open a form based on a value using the Contact name field to open up the customer details form, it works !! So I think it may be something to do with the dates ?

Not sure guys, ive only done very basic things with access before :|


Cheers !!

[Robeen]

See if the information on this page helps you:
http://www.baldyweb.com/wherecondition.htm

[big-div]

Hi mate, seems i have a problem of formatting, if i use the date in format dd/mm/yyyy and try to search, it returns no records, but if i search in the format mm/dd/yyyy it works ! even though the records in the database are clearly showing the format of dd/mm/yyyy !? Any ideas my friend ?

[big-div]

I think it may have something to do with the system time ?? I just tried it on another pc and I noticed the date format is mm/dd/yyyy for system time, surely this shouldn't be the case ?

[Robeen]

mm/dd/yyyy is the common date format in the US . . . but not in other countries.
Are you in the US?
Regardless, can you live with mm/dd/yyyy in your searches . . . and, if you need to, display your dates dd/mm/yyyy [using formatting]?

[big-div]

Yeah, which is what i find really weird, because im in Australia !?

How would I go about formatting ? Cheers

[Robeen]

The Format that I am talking about would only serve the purpose of displaying your dates in a particular format.
Look at the info on this page and see if it helps.
http://www.techonthenet.com/access/f...ate/format.php

I'm not sure why your dates are coming out different.
I'm not sure if it has something to do with your computer - or if there is a setting in Access that you can go into and specify how you want your dates to appear.
There are a few users on here who probably can help - look for pbaldy . . . and June7 . . . and RuralGuy. You can right click on their user names and ask a private question.

[big-div]

Thanks mate, I will sus that all out. Also another problem im having, its apparently common, but Its annoying as all hell ! The Return with out gosub error ! How do you stop this from happening ???

[Robeen]

Can you post a screenshot of that error?
Just going by what you say

Return without gosub

I am inclined to think that it may be something minor to do with your code.