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 gkittelson 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: *

  1. jeswel77

    Adding a new record with fields from an old record

    hi lupins46, the code i used (that is based on my newrecord button) is as follows: Private Sub Command203_Click() DoCmd.GoToRecord , , acNewRec Me![provid].DefaultValue = Me![provid].Value End Sub When i click that button i get a prompt that says runtime error 13 type mismatch. I'm not...
  2. jeswel77

    Adding a new record with fields from an old record

    Lupins46 and PH thanks so much for helping me out. PH- i gave this code a try and i keep getting a type mismatch error. Not sure what i should change. the field provid is numeric..does that make a difference? Again..thanks so much!!!! jessi
  3. jeswel77

    Adding a new record with fields from an old record

    I'm using Access '97 and in my Form i have a button that adds a fresh new blank record. How can i have it add a new record based on 3 fields from the current record i'm on? Thanks so much for you help Jessi
  4. jeswel77

    counting cycles in a table based on a unique field

    PH..thank you thank you thank you!! It worked like a charm!! Jessi
  5. jeswel77

    counting cycles in a table based on a unique field

    Hi, I'm trying to create an automatic feature in my table(or query...wherever it's oppropriate) to count cycles in my table. I have a provider table with dates of service and i want to count each unique providers "cycle" based on their dates of service in descending order. I'm unsure how to do...

Part and Inventory Search

Back
Top