Search results

Your code does work in the query; Thank you

One sec...

My apologies. I probably should have been more specific. I want the hyperlink to work in the table/form. But when I export the data from the form, I want to have the hyperlink (#....#) removed in the exported file. I'm not sure if this is possible.

Sorry, I'm not too familiar with Query calculations

I think I understand what you mean but in my project, I'm looking for the user to do everything from the form But I'm not sure how to do this.

Hello! I have some tables. Thank you!

Yes one of the machines is using Access 2013 64 bit.

Ty. I appreciate your help!

DB is stored in a trusted location, it does seem like an issue with code execution. I just had someone with 2013 32 bit run the db and it worked flawlessly. Can someone run the db on a 64 bit access?

I tried running step into but I get nothing. I really don't know what's going on here, the code works fine in 2019 and 2016 but in 2013 32 bit the form is nonfunctional.

I just decompiled (run command line) and compiled again using the debugger. I still get no errors but the form is still non-functioning.

I went through the code but I'm not getting any errors.

Hello again! I wasn't getting any error messages but the dropdowns and the keyword searches return nothing in Access 2013 32bit.

Hello! I transferred my database from a PC with Access 2019 MSO (32 bit) to my other PC that has Access 2013 (64bit) and the form's search functions (keyword search and dropdowns) no longer work. Anyone else experience this before and is there a way to remedy this issue? Thanks again, Nikki

Thanks a bunch for your help everyone. I'll see if I can think of a few other ideas and try them out.

It's a single db. I just checked the task manager and there's no leftover instance that I see is running. I'm really at a loss for words.

Ok I compiled the project and I didn't get a error.

I'm using Access 2019. I go to File>Save As>Make ACCDE

I don't see "Compile" in my debug menu, the only thing I see is "run/searchform". Are you guys saving the Database as a ACCDE using "make ACCDE under "file". It's still not working for me.

Hello! Fixed. Ty