Recent content by theDBguy

Hello. I really have nothing to contribute. I only want to share an experience regarding the same dilemma not too long ago. We have several Access databases at work that use Leban's API popup calendar. It worked very well. Unfortunately, it also died when we converted our system to 64-bit...

It's one of those things you'll find out only by accident. But as the documentation shows, it's not guaranteed to work forever. Cheers!

Check out the RunCommand method. Something like: DoCmd.RunCommand acCmdManageAttachments (untested) Sent from phone...

You said "code," but did you actually mean to say "data?"

Oh, I guess I responded to the wrong info then.

I wonder if it's a permission issue.

Hi. Welcome to AWF!

Hi. Welcome to AWF! Are you saying if you run the same query in SSMS, you get values but get empty when ran in Access?

Hi. Welcome to AWF! Not sure you can do this using a Calculated Field in a table, but you might be able to use a Calculated Column in a query.

Good work!

We'll see. I'll keep an eye on it...

You might try using the OpenArgs argument and the Open event of the main form to filter the subform.

Hi. Welcome to AWF! Better late than never, right?

Glad to hear you got it sorted out. If you did managed to create a new db and tried your code, you would have found out for sure that your code was causing the problem, because you would have run into the same issue, which would rule out corruption. Good luck with your project.

It may not, but it could also be a combination of both. So, I was just saying it's safer if you simply create a new blank database, create a new table in it, and then try your code there as well to see if you still get the same problem. Just a thought...