Search results

  1. sctb0825

    Calculate a field value

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

    Solved Mask a PW field on form button

    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?
  3. sctb0825

    Solved Enter data into two tables

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

    Solved Tabbed Form

    I have a tabbed form. see screenshot img 1 My contact log in in a seperate table. see screenshot img 2 On my contact log table the agent cd and contact reason are lookup boxes (design view img 3) Originally I had created a seperate form for contact log input img 4 What I would like is to...
  5. sctb0825

    Solved Copy info

    I have on my customer form; Customer Name Remit To Address Address Address 2 Address 2 City...
  6. sctb0825

    Solved Auto Configure

    I have a table that has a field called Customer Code and another field called Customer Name. The way I assign a Customer Code is to use 1st 4 letters of Customer Name + 2 additional characters. an example would be "Jones Manufacturing Inc." would get a Customer Code of "JONEMI" 1st 4...
  7. sctb0825

    Solved Multi Select Combo Box

    I've done a lot of reading but cannot find the answer. I need to create a combo box where the user can select multiple items. Also, I would like to be able to enter the quantity of each is possible without too much work.
  8. sctb0825

    Solved Look Up vs List Box

    I have a field that I use on several forms, ie Mr. Mrs, Ms, Prof, Dr. Hon. Question? is it better to put these in a table and use Look Up on each form or to use a List box on each form?
  9. sctb0825

    Solved Lookup Wizard

    I am using the lookup wizard in a form. What I need is for the user to be able to type a value that is not in the list and have it automatically added to the lookup. example would be, I have a lookup for States, the list only has the 50 US States. The user needs to enter Alberta which is not in...
  10. sctb0825

    Solved Secure Info

    I am using a Tabbed Subform, I need a popup window that I can secure, so I can put account number information into the database. What is the best way to do this? I would like the popup or tab inside the main tab. ie tab inside another tab. (hope you understand what I mean) example: I have a...
  11. sctb0825

    Solved Form Headers

    I've created a form header with added controls and features that I want on every form in my database. How can I save this as a template to use on all my forms? It seems that saving in AutoFormat is not doing the trick
  12. sctb0825

    Solved Tabbed Subforms

    I have a tabbed sub form, I only want to display the tabs on my main form and when you click on a tab the sub form comes up as a popup. Then I want to be able to position the tabs in a location of my choice. Can anyone explain how to do this or steer me to a link for a tutorial on this? I am...
Top Bottom