show the user id in text box automatically.

[sarohap]

Hi All,
I am new in this forum and new in access.

I have form for the daily transactions. When a user will open the form and will fill the all fields with transaction details then their user id should show in a specific textbox...

Or when i will click on the submit form then it should update in table with other transaction details.

 

[John Big Booty]

Welcome to the forum.

Have a look at the CurrentUser() Function.

 

[sarohap]

Hi,

I have form with 11 fields. there are some fields are text, some are date format and some are memo and some of numbers. Now there is submit button to submit the all fields in table thru single click. I am new in access and in coding of such kind macros. So could you please help me to submit the all fields.

I need the coding for such kind of button.

 

[Aleni]

Hi sarohap!
Actually I am also new to access but i Have worked with such case.
You can make your user id as primary key auto number in your table.

When you enter new records in your table you do not have to enter user id it will automatically get entered.

I have pkDetailid in my table which get updated automatically as it is autonumber.
Here is the code i am using.
It may help you.

Set cnn = CurrentProject.Connection
Set rs = New ADODB.Recordset

strsql = "SELECT * FROM tblAcqDetails"
rs.Open strsql, cnn, adOpenKeyset, adLockOptimistic

With rs
rs.AddNew
!fldQty = Me.txtQty
!fldUOM = Me.txtUOM
!fldType = Forms!frmAddNew.cbo1
!fldNote = Forms!frmAddNew.cbo2
rs.Update
End With

Set rs = Nothing
Set cnn = Nothing


Hope this will help you...