Search results

The recordset is based on a query - yes. The txtAttUser is the name of the textfield with unique identifier.

Yes, it is the unique identifier I used.

still not works for the 2nd one

Hi, I have a continuous form. I am able to update the data if the continuous form has only one entry. I successfully use the code below: Set dbforms = CurrentDb strSQL = "SELECT * FROM MainData WHERE [Enterprise ID] = '" & Me.txtAttUser.Value & "'" Set rstforms =...

I know the dlookup functions, but how would the form know that it is the best time(date) to change the status from inactive to active?

How can I do this? I dont have any idea from the scratch. Thanks.

It was the one I need to input inside the Query table.. not outside the form. It was like when i select a start and end date it will generate depending on the date values. But now I need to filter the data to Group, Team, etc. I attached the screenshot where I need to input it, the code above...

I have 2 tables the attendance and the main data. In the attendance table I can enter start date and end date of the status. My problem is I need to update the main data. The attendance is connected in the profile. When the date today is equal to the start date the main data should be updated as...

I have a continuous form where when I select the dropdown it will update all the fields, then I filter team field it will only select that team then hitting the Save command, it will enter all the details in the table at once. It will record each line in the continuous form to the table...

I have a query for Master Data, then I have a form where I can select in dropdowns what will be the filters in the output file of the Master Data. I need a code in the query table where, if the 1st dropdown is empty and 2nd dropdown has value, the output file will only display the Master Data...

I already tried this but still has error.

I have a form that can be accessed once I login. So I have the code Me.txtEID.Value = LCase(Forms!frm_Main!CurrentUser) to call the textfield from the other form. I have 2 forms, the Main and the Roster. I need to login in Main so I can access the Roster. The thing is when I click the...

I got same reference and I have tried it to use: !999999" "99999999999\-9 but is it possible that if the first batch of numbers contains 5 digits instead of 6 it will display same format as to !99999" "99999999999\-9

I have a textfield that should limit its character. This field should ONLY accept numbers and the format is 123456[space]11101016913-1

This is now SOLVED. For future reference: From the Text Box Properties of the field > Data tab > Control Source is the code below: =([txtLastName]+", ") & ([txtFirstName]+" ") & ([txtMiddleInitial]+".") Thanks so much Minty for this.

Now it is working. Thanks! :)

But just need another thing coz I need to view it as: = [txtLastName] & ", " & [txtFirstName] & " " & [txtMiddleInitial] & "." LastName, First Name M.I. So since last name and MI is still blank it will display: , FirstName . it should be FirstName only without any punctuation, it will...

HELP!!! I really need it badly! :(

Hi Linq, Thank you. But just need another thing coz I need to view it as: = [txtLastName] & ", " & [txtFirstName] & " " & [txtMiddleInitial] & "." LastName, First Name M.I. So since last name and MI is still blank it will display: , FirstName . is it possible to update as without...

Hi, I thank you all for the suggestions, but I really need this requirement on how to show it visibly in that disabled field. Every time the fields are updated, the fullname is also updated.