Search results

Hello Everyone!, A quick question to you folks... What would be the correct DLookup syntax to perform the following operation: I need to bring in a value from a field named "Description" from a table called "PNs and Desc". The "Description" should be relative to another field named "PN"...

Thanks again for that helpful insight. Is there a way to prevent a new line from generating after the limit?

Perfect!!!!! You're the best!

Hello All, May someone explain to me how to limit the number of entries in a subform. Thanks in advance!

Okay, my goal is to use serial numbers. System A & System B are two different components (or parts). However, a serial number can only be used once across the board. So if I issue serial number 001 to a System A, that serial number (001) can not be used by any other part. I am generating a...

Hello All, I'm trying to limit the data entered into a specifc field, but also the data must be unique with respect to other fields. i.e. Two fields: System A & System B. Data entered into System A, can not be entered into System B. Anyway to prevent this from recurring? Would I use a...

I have to track uique values of multiple parts. So, I'm trying to use the "No Duplicates" function in the "Indexed" parameters. Unfortunately the No Duplicates feature only works for data in that field, I have multiple fields. I'm thinking I may have to create a validation rule that would...

Would anyone know how to display one specific field more than once on a form? I've tried coping the field but that only transfers the data entered from the original to the copied field. Thanks in advance...