Access Help required

%3CLINGO-SUB%20id%3D%22lingo-sub-978102%22%20slang%3D%22en-US%22%3EAccess%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-978102%22%20slang%3D%22en-US%22%3E%3CP%3ECannot%20get%20access%20to%20load%20anything%20for%202020..%20using%20Windows%207.%3C%2FP%3E%3CP%3EAny%20help%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ED%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-978102%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-978496%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Help%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-978496%22%20slang%3D%22en-US%22%3E%3CP%3EUnfortunately%2C%20there's%20not%20enough%20information%20there%20to%20try%20to%20offer%20a%20suggestion.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20do%20you%20mean%2C%20for%20example%2C%20by%20%22load%20anything%20for%202020%22%3F%20What%20are%20you%20trying%20to%20load%3F%20How%20are%20you%20trying%20to%20load%20it%3F%20I%20assume%20you%20must%20have%20an%20existing%20accdb%20and%20you%20want%20to%20use%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGive%20us%20the%20details%20and%20someone%20might%20be%20able%20to%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-984030%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Help%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-984030%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20face%3D%22Calibri%22%3E%3CFONT%20color%3D%22%23000000%22%3EWhen%20using%20Access.%20The%20forms%20does%20not%20pick%20up%20any%20dates%20after%2031%3CFONT%20size%3D%222%22%3Est%3C%2FFONT%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%20December.%20I%E2%80%99ve%20enclosed%20a%20screenshot%20of%20one%20of%20our%20forms%20and%20the%20date%20required%20(middle%20of%20screen)%20is%20the%20last%20date%20it%20will%20pick%20up%20(20%3C%2FFONT%3E%3CFONT%20size%3D%222%22%20color%3D%22%23000000%22%3Eth%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%20is%20when%20we%20close%20for%20Christmas%20hols).%20The%20main%20table%20that%20the%20forms%20pick%20up%20from%20has%20dates%20well%20into%20next%20year%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22Calibri%22%20color%3D%22%23000000%22%3E%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22Calibri%22%20color%3D%22%23000000%22%3EHope%20this%20helps%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-993242%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Help%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-993242%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F440723%22%20target%3D%22_blank%22%3E%40Davy1%3C%2FA%3E%26nbsp%3B%20Screenshots%20seldom%20offer%20any%20significant%20clues%20as%20to%20problems%20like%20the%20one%20you%20describe.%20That's%20because%20we%20can't%20see%20anything%20relevant%20in%20the%20screenshot.%20We%20see%20the%20results%20only%2C%20not%20the%20source.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20the%20form%20have%20a%20filter%20applied%3F%3C%2FP%3E%3CP%3EDoes%20the%20query%20which%20provides%20records%20to%20the%20form%20have%20a%20parameter%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20open%20the%20form%20with%20a%20filter%20in%20place%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

Any help appreciated.

 

D

3 Replies
Highlighted

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.

Highlighted

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

Highlighted

@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?