Access Help required

Copper Contributor

Cannot get access to load anything for 2020.. using Windows 7.

Any help appreciated.

 

D

3 Replies

Unfortunately, there's not enough information there to try to offer a suggestion.

 

What do you mean, for example, by "load anything for 2020"? What are you trying to load? How are you trying to load it? I assume you must have an existing accdb and you want to use that?

 

Give us the details and someone might be able to help.

 

Thanks.

When using Access. The forms does not pick up any dates after 31st December. I’ve enclosed a screenshot of one of our forms and the date required (middle of screen) is the last date it will pick up (20th is when we close for Christmas hols). The main table that the forms pick up from has dates well into next year

 

Hope this helps

@Davy1  Screenshots seldom offer any significant clues as to problems like the one you describe. That's because we can't see anything relevant in the screenshot. We see the results only, not the source.

 

Does the form have a filter applied?

Does the query which provides records to the form have a parameter?

 

Do you open the form with a filter in place?