Newbie Needs Help!

[Northwest_Guy]

Hi All, I'm new to not only the site but in reality Access aswell. I have a basic knowledge of Access but I am trying to enhance that and teach myself with the aid of a few good books etc.

I'm trying to find out if it is possible to create a data access page (or other form) that will enable me to collect data from a query between a specific date range.

I have used the used the old WHERE (((table9.LeadDate) Between #8/1/2007# And #8/31/2007 23:59:0#)); and that works under the query but I am trying to develop it so I have a drop down box to select the date range i.e. from start of September - end of September to allow me to run monthly reports.

I've been told the only way I can do this is using VB which in honesty I know nothing about. Your help would be really well appreciated.

Guy

 

[Zigzag]

Hi Guy,

If you create an unbound form with two Texts called "fromDate" & "toDate"
Add a subform to this unbound form and base it on a query.
In the query under "LeadDate" set the criteria to be between "datefrom" and "dateto".
Set an event procedure (on change) for "fromDate" & "toDate" to ME.refresh (VBA)
This should achieve what you are looking for.
If you have any problems shout and i will post an example.

Garry

 

[Northwest_Guy]

Garry your a star!

Could I ask you to post an example though as the VB is confusing me. I'm currently developing this to make my life easier but eventually there will be other users allowed.

Many thanks for your help so far

Guy

 

[Zigzag]

Example

Ok.

Here is quick example, its not pretty but it its a start.
If you can get to the stage of applying this to your application then you can change the text boxs for Date/Time pickers, which will display a nice calander that you can select from giving you more flexibility with your reporting and a touch more proffesional.

Not available for a couple of hours but can help more later if you still need it.

Garry

 

[Northwest_Guy]

Garry,

Once again thanks. I hope you don't mind helping but I will no doubt be giving you a shout later tonight.....I'm going grey already!

 

[Zigzag]

Try Again

Sorry, I forgot to attach the DB.

 

[Northwest_Guy]

Ahh thats why I couldn't find it! thought I was being a little too thick then