Search results

Power BI is used to create dashboard reports. It's usually used with online data sources rather than with Access. What was the context when it was mentioned?

Darn phone auto correct. 😡

When you compile a database file to ACCDE, it can only be used in the same hotness bitness as the machine that compiled it. PtrSafe only works with ACCDB files.

Hi. Welcome to AWF! I’m not sure if there is one, but I would suggest looking at the available templates to help you get started.

Glad to hear you got it sorted out. Cheers!

Try changing INNER JOIN to RIGHT JOIN.

Hi. Welcome to AWF! Copy and paste that SQL into the query designer and post a screenshot of the message you get.

I'll post the link for you. I hope this is the right one. https://isladogs.co.uk/highlight-required-fields/index.html

Not in front of a computer now, but if the back color is transparent, then the highlighting might be happening on a control behind it. Can you check that? Sent from phone…

I didn't say parent Form, I said parent Record. Is it always the same two child records, or do they at least change to reflect that you have the parent/child relationship working correctly?

Is it consistently two records no matter which parent record you're on?

It’s possible that the file got corrupted during the split process, which should be gone now and may not come back anymore.

Actually, the steps were: 1. Split the ACCDB into FE & BE 2. Make a ACCDE from the FE 3. Put the BE on a network share 4. Distribute the ACCDE to all users 5. Make design changes to the ACCDB FE 6. Make a new ACCDE 7. Replace users' old ACCDE with the new one

DLookup() should pick one for you.

Hi. Welcome to AWF!

See if you have better luck with this one. https://www.devhut.net/vba-get-a-strings-hash/ Sent from phone...

Sorry, can't download the attachment right now, I'll try it later. Sent from phone...

Not in front of a computer now, but my guess is that you may not have the .Net Framework installed or maybe it's a different version. You shouldn't need to add any references at all. Sent from phone...

Good luck!

Take a look here... https://thedbguy.blogspot.com/2025/01/sha256-hashing-function.html?m=1 Sent from phone...