Recent content by oneilldm

  1. O

    Set Default Value... From A Form

    Good point... thanks! I'll try that.
  2. O

    Set Default Value... From A Form

    Thank you for the replies! I should probably back-up a little bit. What I really want to do is automatically enter the last name of the User creating a new record. This form is just a log of numbers and descriptions with the user name that entered the record and a date. I capture the user...
  3. O

    Set Default Value... From A Form

    I'd like to set default value for a field in a table from a form. I tried: MyTable!MyField!DefaultValue = Me.myLastName But it's telling me "Object Required". I must not be going about this in the right way. I have a simple form that uses this table. When the user creates a new record I...
  4. O

    Sort Assending When Opening A Form

    Oh...Hot Dog... I figured out what I was doing wrong!!! :) Boy... the smallest thing wrong... Me.OrderBy = "ID" Me.OrderByOn = True This worked like a dream!!! Thanks boblarson!!! And thanks Mike375... I'm going to give that a try. I like having options!!!
  5. O

    Sort Assending When Opening A Form

    Thanks... I'm using the Form_Load event.... and I think I have the field in there right. (It's just called ID) If I type in me. I get a dropdown and I can select my field from the list. The me!... I don't understand. I don't know what the exclamation point is for. :o
  6. O

    Sort Assending When Opening A Form

    Thanks for your help! It's prompting me for a Parameter Value.....??? I haven't figured that one out yet.
  7. O

    Sort Assending When Opening A Form

    Thank you for the reply. I'm almost done with this project. I was hoping that I could just use a couple lines of code.
  8. O

    Sort Assending When Opening A Form

    I'd like to have a form sort by my ID field automatically, every time the form is opened. Is there an easy way to do this? Thanks
  9. O

    Read Environment Variable? v2003

    Thank you... that's perfect!!! This is the best Access help forum I've seen! Thanks to all the contributors!
  10. O

    Read Environment Variable? v2003

    Is there a way to read in a system Environment Variable? If I go to a command prompt and type "SET" the system will display all my Environment Variables. For convenience, I'd like to identify the User. Thanks
  11. O

    Add Record and Display Previous Records - 2003

    I still would like to figure out how to show the New Record at the top of the form. I like to have the new stuff at the top with preceding records in descending order.
  12. O

    Add Record and Display Previous Records - 2003

    OK... There may be a cleaner way to do it, but this is what I came up with. Private Sub NewRec_Click() On Error GoTo Err_NewRec_Click DoCmd.GoToRecord , , acLast DoCmd.GoToRecord , , acPrevious, 6 DoCmd.GoToRecord , , acNewRec Me.Family_Number.SetFocus...
  13. O

    Populate Fields with a Combo Box?

    In my Tabulated Form, I would like to make a selection with a Combo Box and have it populate 2 fields. I can get it to fill in the combo box field, but what do I do to get it to fill in another field in my form? The combo box is getting values from a separate table. Thanks.
  14. O

    Add Record and Display Previous Records - 2003

    One more thing. When adding a new record, the new row always appears at the bottom of the form. Is it possible to have it appear as the top row instead?
  15. O

    Duplicate Field from Previous Record - 2003

    Very good... thank you! I'll try that out.
See more
Back
Top Bottom