Recent content by sctb0825

Thank you will try

Can you give an example with code?

I have a table with values, (see attached table snapshot) it is for calculating the current fuel surcharge example would be, if the current fuel price is between $4.85 and $4.90 the Fuel surcharge would be $0.75 per gallon. I want to calculate the value based on the following Miles divided by...

Thanks this works great. Appreciate all the help..

I forgot to mention that Admin is a sub menu not a fill form, It contains access to several Admin tasks and Records.

I have created a Main Menu, on the Main menu I have a button for the Admin section, I have PW protected the button. When I put in the PW it displays the PW for all to see. How do I mask or hide this PW so no one can see what I am inputting into the field?

I was able to get it by copy link

Wrong image here is the correct one, there are no other relationships created as of yet

I will want to do the same thing for the AgentCD

So since the only field I want to copy data is the ContactCD I would only need to list all ContactCD's in the Contacts Table. Is that correct. This is a new database and I am a novice but learning quickly.

The link did not work, Thanks for the explanation can you fix the link

I am using Access 2021. I have two tables Customers and Customer Contacts. One contact may represent multiple Customers or one Customer may have multiple Contacts. I want to be able to enter the contacts code or ID into both tables no matter which form I am entering data on, the only data that...

understood any query that uses same table I just expand query and use it multiple times

I read somewhere that too many querys was a bad practice also truth or fantacy