Check boxes in Searches (1 Viewer)

[StuartG]

Hi all,
Hoping you might be able to help as I've hit a stumbling block.

I have created a query on my DB and a user has reported that they are no longer able to select unselect all and then select a particular field.

Picture here shows what the user wants.

instead they are presented with the below and unable to select multiple.

This used to work fine but just randomly out the blue it no longer shows.

Can you advise how i can fix this without causing too much damage to my DB data.

Thanks all

Stuart

 

[theDBguy]

Hi Stuart. How many records are we talking about?

 

[StuartG]

Hi Stuart. How many records are we talking about?

Hi DBguy
There are over 1800 records in this DB now..
Could this be the reason?

 

[theDBguy]

Hi DBguy
There are over 1800 records in this DB now..
Could this be the reason?

Maybe, not sure. Try adding a criteria to the query to reduce the data set and see if the dropdown comes back.

 

[StuartG]

Maybe, not sure. Try adding a criteria to the query to reduce the data set and see if the dropdown comes back.

Do you know why it would return nothing using the below criteria?
The table column is a date/time.

I'd like for it to show a years worth as the team on a daily basis should not need to go further than that.

 

[theDBguy]

Do you know why it would return nothing using the below criteria?
The table column is a date/time.

View attachment 86205

I'd like for it to show a years worth as the team on a daily basis should not need to go further than that.

Not sure without seeing it. Try adding a criteria elsewhere. We're just testing at this point...

 

[StuartG]

Not sure without seeing it. Try adding a criteria elsewhere. We're just testing at this point...

OK, so i used the following criteria.

Between Date() and Date()-6

This then only showed 13 records and then i was able to deselect and select different fields.
Now i just need to get the query to work to show the year it is and that's all

 

[theDBguy]

OK, so i used the following criteria.

Between Date() and Date()-6

This then only showed 13 records and then i was able to deselect and select different fields.
Now i just need to get the query to work to show the year it is and that's all

Try using something like:

Between DateAdd("yyyy", -1, Date()) And Date()

 

[MajP]

It definitely is dependent on the amount of discrete records
I selected the Top 1000 and got the checkboxes. Then selected Top 1200 and did not. I do not believe 1K is the limit but dependant on other factors.

 

[StuartG]

Try using something like:

Between DateAdd("yyyy", -1, Date()) And Date()

That worked perfectly.
shows the whole year and the checkboxes are there.

 

[StuartG]

It definitely is dependent on the amount of discrete records
I selected the Top 1000 and got the checkboxes. Then selected Top 1200 and did not. I do not believe 1K is the limit but dependant on other factors.

What criteria did you use to show the top 1000?

 

[theDBguy]

That worked perfectly.
shows the whole year and the checkboxes are there.

Congratulations! Glad to hear you got it sorted out. Good luck with your project.

 

[StuartG]

Congratulations! Glad to hear you got it sorted out. Good luck with your project.

Thanks as always DBguy, most helpful

 

[MajP]

To see this. There are two queries. One returns top 1K the other returns top 1.1k. Only get checks at 1K so maybe that is some kind of limit.

 

[MajP]

Maybe 1000 is really the limit. Seems like a strange number would think 1024. But I just did 1000 and it works and 1001 and it did not. Strange.