Re-freshing form

[hitesh_asrani_j]

Hi,
I have a form which is opened by many users using a UserPass form.. So the username is used to save the data under the particular person's name.
Now suppose a particular person updates 7 orders is it possible to view the same thing in the same main form....
and also that it refreshes as the persons updates another and then the other.. so it keeps increasing..
I want it to be viewed on the form itself.

[Toyman]

Hi,
I have a form which is opened by many users using a UserPass form.. So the username is used to save the data under the particular person's name.
Now suppose a particular person updates 7 orders is it possible to view the same thing in the same main form....
and also that it refreshes as the persons updates another and then the other.. so it keeps increasing..
I want it to be viewed on the form itself.

Yes, all you have to do is create a query for the table in which the data is being entered, set the criteria to the employee's user's name and bound the form to the query. This way, only his records and subsequent entered records are displayed.

[hitesh_asrani_j]

can this query be used in the Form as a text or a label because i cannot use the button to show the number of orders the person is worked on that day....

[Toyman]

can this query be used in the Form as a text or a label because i cannot use the button to show the number of orders the person is worked on that day....

Are you saying you just want to show the tally of the records entered by the person? Give me description on what you need

[hitesh_asrani_j]

I want to show the number of orders a person has done on that particular day till that time...

So once he updates a new Record the nnumber should also change with it...

so something like "=count(order numbers)" like we do in ms excel


Thanks in Advance

[Toyman]

I want to show the number of orders a person has done on that particular day till that time...

So once he updates a new Record the nnumber should also change with it...

so something like "=count(order numbers)" like we do in ms excel


Thanks in Advance

You can set up an unbound text box in the form to receive this data. In the after update event for the form, use a DCount function to count the data based on the criteria and have the value inputted onto the unbound text box.

Lets say your unbound text box's name is "OrderNumbers". So, in the after update event of the form, put the following:
Dim sUser As String

sUser = Me.UserName 'subsitude this for the field where the user name is located
Me.OrderNumbers = DCount("*","tbl_YourOrderTable", "UserName = '" & sUser & "' And OrderDate = #" & Date & "#") 'subsitude "tbl_YourOrderTable" with the name of your table and "UserName" with the field name of the user's name field

[hitesh_asrani_j]

So suppose my user name is already saved under GetUser() can i use that?

and for the date i can use the Date() function?

[Toyman]

So suppose my user name is already saved under GetUser() can i use that?

and for the date i can use the Date() function?

yes to all

[hitesh_asrani_j]

I tried everything you said, but it is not working :'(

[hitesh_asrani_j]

Dim sUser As String

sUser = "GetUser()" 'subsitude this for the field where the user name is located
Me.Text239 = DCount("[Order Number]", "[Table]![Data]", "Agent = '" & sUser & "' And OrderDate = #" & "Date()" & "#")
End Sub

[hitesh_asrani_j]

I somehow solved the issue..
I created a query which actually updates a Report...
This report is generated when the user clicks on the logout button which show him/her how many orders she has worked on..