Recent content by Louis1017

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

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

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

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...

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

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...

Wow........ I swear I have tried that syntax in the expression and it didn't work, but I probably had written something else different with it when I used the quotations. You have no idea how happy I was to see that work when I tried it! Thank you so so so much!!!

So I'm trying to add a field with an expression on a report. The current layout has a "Certificate Number" and a "Certificate Date", and I need to add an "Expiration Date" which will be one year after the "Certificate Date". If I use =DateAdd(yyyy, 1, [CertificateDate]) I typically get a...