Lost the ability to enter dates in an OLE on report dialogue box (1 Viewer)

[Louis1017]

The DB front end opens with a switch board, and one of the buttons is supposed to open a service report within a specific date range. Yesterday the dialogue box wouldn't let me enter dates anymore and I'm not sure what to adjust to make it work again. I'd be happy to share what I need to to get some assistance, just let me know what to do.

Thanks in advance, this community is amazing.

 

[June7]

To provide db for analysis, follow instructions at bottom of my post.

 

[theDBguy]

The DB front end opens with a switch board, and one of the buttons is supposed to open a service report within a specific date range. Yesterday the dialogue box wouldn't let me enter dates anymore and I'm not sure what to adjust to make it work again. I'd be happy to share what I need to to get some assistance, just let me know what to do.

Thanks in advance, this community is amazing.

Hi. Welcome to AWF!

You didn't happen to upgrade to a 64-bit version of Access, did you?

 

[Louis1017]

Hi. Welcome to AWF!

You didn't happen to upgrade to a 64-bit version of Access, did you?

Yes the 32 bit won't run on the computer we have it on. But this just happened yesterday, and I switched over to 64-bit only a couple months ago

 

[June7]

Why would 32-bit not run?

 

[Louis1017]

Why would 32-bit not run?

I don't really know for sure, but the VB code running had both 32 bit and 64 bit scripts for the db, and I kept getting errors anytime I clicked something that referred to needing 64 bit VB code. So I removed the 32 bit and everything ran smoothly after that.

Forgive me if my lingo is a little off, this is the only db I've worked with so I'm kind of a rookie

 

[Louis1017]

To provide db for analysis, follow instructions at bottom of my post.

The file is still too big after compacting and compressing. Would a google drive link work?

 

[June7]

Wait, you switched to 64-bit Access by preference?

Some won't download from outside forum.

 

[arnelgp]

Make a backup.
Remove all except the form/reports, modules, classes that has an API declaration on them.

 

[Louis1017]

Wait, you switched to 64-bit Access by preference?

Some won't download from outside forum.

If db runs fine now and don't need help any more, then don't bother posting link.

Sorry for any confusion, switching to 64 bit only fixed the errors I was receiving a couple of months ago - separate problem. My current problem is not being able to add dates in a a dialogue box I use to run a report.

Here are some screenshots of the object I'm having trouble with

 

[arnelgp]

Maybe the activeX came from vb, you need to acquire a 64 bit for it.
Otherwise use an ordinary textbox control.

 

[Louis1017]

Maybe the activeX came from vb, you need to acquire a 64 bit for it.
Otherwise use an ordinary textbox control.

Changing to text box doesn't work exactly. I need to figure out what it's connected to I think. Thanks for the help so far, I'll keep trying to get it right