Can you help me please
And how can I search multiple records by copy and paste?
You can do it with SC. I did see the video. I think you must filter your records for then update them. same way that video you can create a grid and un buton with a form for fill the data for update the selected records.
It’s a wonderful solution, So I tried a lot and couldn’t.
Can you help me please?
I want to filter the grid application by any field, such as the employee number field, So when I copy and paste the employee numbers into the employee number field ,The program will automatically filter the grid.
Then I select these employee numbers with a check mark,
Then I choose the variables above, and based on them, the employee numbers that you specified earlier are updated.
I think you must begin to create the GRID like show this link for you can select and filter your record.
and this suggestions :
But I don’t know how to apply it
And this also:
Thanks in advance
The directions in my post are pretty clear and detailed as to how to do it…
make a Control application with a Multiple Line text box
Right I test it ,But really not working for me
Post your code and let us take a look
I changed the code in SQL like this:
SELECT
Accommodat_Emp_ID,
Accommodat_Emp_Date,
Room_IDF,
Room_IDF_Previous,
RoomChange_Date,
House_IDF,
House_IDF_Previous,
HouseTransfer_Date,
Supervisor_Name,
Supervisor_Previous,
Supervisor_Date,
EmployeeNo,
Housing_Date,
Housing_Reason
FROM
emp_accommodate
WHERE EmployeeNo IN (’[myarray2]’)
So now result