Search results

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

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

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

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!!!

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

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

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.

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

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

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

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.

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

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.

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?

Very good... thank you! I'll try that out.

Hi... thanks for the reply! I have a simple "Tabular" form for a table that has 6 fields. I added the "Add Record" command button with the wizard. Here's the code for the button: Private Sub NewRec_Click() On Error GoTo Err_NewRec_Click DoCmd.GoToRecord , , acNewRec...

Perfect... Thank you!!!

When I add a new record... Access scrolls all the previous records to the top and out of view. Is there a way to control this so the user can see the previous records? (w/o having to manually scroll) Thanks

I can use Ctrl-' (apostrophe) to copy the value of the same field in the previous record. I would like to create a Command Button that would do the same thing. Is there a way to do that?