Home

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
Davy1
New 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?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies