Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: scollins
  • Content: Threads
  • Order by date
  1. scollins

    duplicate entries in table

    I would like to be able to submit data from my form into the table but if it is already in the table then create a new entry. So at times, the advisor will be the same along with other fields but I want each entry to be its own and not overwrite other entries. Here is some of the code: If...
  2. scollins

    bound object Frames - I need help!!!

    I want to use a bound object frame and put 3 option buttons in this frame. I then want to say if this option button is checked update the rst with a value of true and if this optino button is checked, update the rst with a value of true etc. However, I want the users to only have the ability...
  3. scollins

    Clearing Field Values in a form

    Is there anyway to clear all field values in a form in one statement? thank you -
  4. scollins

    I need help with my CODE!!!!!!!

    I am trying to find out if the customer id is already in the table: Set dbs = CurrentDb() str = "SELECT [CUSTOMER DATA].* FROM [CUSTOMER DATA];" Set rst2 = dbs.OpenRecordset(str) If Me![CustAcctID] = rst2!CustAcctID Then MsgBox "This Customer already exists in...

Part and Inventory Search

Back
Top