Buttons on form to update Query criteria

[wanderanwills]

Hi Everyone,

I am developing a Task database.
Table: TaskT
Fields include; Description, Action, DueDate, Priority, Precinct, Recurring and Employee.
Query: TaskQ
Form: TaskF and TasklistF

The forms are fed by the TaskQ query.
I have sort and filter on all fields except date field which i would like to have 3 buttons which will dynamically update the criteria in the TaskQ DueDate field.
Is that possible or the way to do it??

The buttons would include 'Due today' 'Overdue' 'Next 7 days' and they update the criteria in the TaskQ query and hence filter with the following;


Date()
<Date()
Between Date () And Date()+6
I am only a beginner with SQL and VBA.

Your help would be greatly appreciated as i have spent days looking for answers and trying different ways.

Regards
Stephen

[ssanfu]

Is that possible or the way to do it??

Certainly.

Would you post your dB? I need to see how you set the sort and filter. Doesn't need any records.

Do a "Compact and Repair", then zip it.

The basic idea is to get the current filter string, append the date criteria.
You should have/would need a fourth button to remove the date filter.

[wanderanwills]

Hi Steve,

The database is too large ~ 245Mb is it has several other aspects to it, dont know why it has got so large??
I tried to export all the Tasks tables, queries, forms, reports and macros and it does not work.
The queries are now just SQL and not in the table format and even though the forms are pointing to the correct query it does not like them.
Any suggestions??

Regards
Stephen

[ssanfu]

Maybe make a copy of the dB, delete all but a few records (for testing) then "Compact and Repair" and zip it.

[ssanfu]

The forms are fed by the TaskQ query.
I have sort and filter on all fields except date field

What is the SQL of the query "TaskQ"?

[wanderanwills]

Hi Steve,

I have been able to get the 'Overdue', 'Today', 'Next 7 Days' and 'Month' buttons to work as VBA. I would prefer SQL to feed into the TaskQ query, so i can also report the same results ie the reports use the same TaskQ to report?
Clear button was set but it was causing problems so i removed the code.
When i filter Employee (Filter boxes at bottom of lists), I cannot reset to '*' to see all the records, is there a way around this?

I have tried a couple of times to upload database, i will try again, it keeps on failing.

Regards
Stephen

[wanderanwills]

Uploader is not working properly, it does not even show the progress of your file upload. Is there a limit on the size of the file?? The zipped database i am trying to upload is only 8 MB.
Any known problems??

[ssanfu]

Maybe make a copy of the dB, delete all but a few records (for testing) then "Compact and Repair" and zip it.

Yes, there is a size limit, even with Zips. I cannot find the sizes, but I think there is a 2m size limit for Zip files.