J
jeanulrich00
Hi
I have a continuous form (MainForm) containing employe's informations
like IDEmploye, Name, Position, Salary, etc
When the user double-click on the employe's ID, a new window open.
This window (SecondForm)contains the same employe's informations + a
subform (related to the employe's ID)
The subform (EmplSub) is a continous form with 3 fields (PeriodNo,
Planned and employe's ID) and 36 rows. Each row represent a Period
(month)
How it works
User open the MainForm
Find the employe he wants to work with
Double-click on the employe's ID and another window open
Then the user have to put 1 or less (example : .5 for half of the
month) for each period the employe should work for the company. So
lets say user put 1 for period 1, 1 for period 2, 1 for period 3, and
so on (all inscriptions are in the Planned field). So if the employe
will work for 36 periods, user have to put 1 in each period that's 36
times.
Now let say user want to work with another employee and this employee
has the same patern than the first one, I want user to be able to copy
colum from the first employee and paste the colum to the second one
Right now what I am doing is.
Double-click on first employee ID. So the SecondForm opens
I have on this form a button and when user click on it, EmplSub change
for datasheetview
The user select the column of data and execute the command COPY
User close the SecondForm
Search for another employee having the same patern
Double-click new employe's ID
SecondForm opens
UserClick the button to pass into datasheet view
Select the entire column
And Paste the data
What I want is :
A button on the SecondForm and when the user clich, that would copy
with code the needed column
Then a second button that would paste with code thw column to the new
selected employee.
In fact, just the code to select a colum and copy it
and the code to select a column and paste the data residing in the
memory
Sorry for the lenght of the message, but I wanted to be clear
Thanks for helping, I appreciate it a lot
I have a continuous form (MainForm) containing employe's informations
like IDEmploye, Name, Position, Salary, etc
When the user double-click on the employe's ID, a new window open.
This window (SecondForm)contains the same employe's informations + a
subform (related to the employe's ID)
The subform (EmplSub) is a continous form with 3 fields (PeriodNo,
Planned and employe's ID) and 36 rows. Each row represent a Period
(month)
How it works
User open the MainForm
Find the employe he wants to work with
Double-click on the employe's ID and another window open
Then the user have to put 1 or less (example : .5 for half of the
month) for each period the employe should work for the company. So
lets say user put 1 for period 1, 1 for period 2, 1 for period 3, and
so on (all inscriptions are in the Planned field). So if the employe
will work for 36 periods, user have to put 1 in each period that's 36
times.
Now let say user want to work with another employee and this employee
has the same patern than the first one, I want user to be able to copy
colum from the first employee and paste the colum to the second one
Right now what I am doing is.
Double-click on first employee ID. So the SecondForm opens
I have on this form a button and when user click on it, EmplSub change
for datasheetview
The user select the column of data and execute the command COPY
User close the SecondForm
Search for another employee having the same patern
Double-click new employe's ID
SecondForm opens
UserClick the button to pass into datasheet view
Select the entire column
And Paste the data
What I want is :
A button on the SecondForm and when the user clich, that would copy
with code the needed column
Then a second button that would paste with code thw column to the new
selected employee.
In fact, just the code to select a colum and copy it
and the code to select a column and paste the data residing in the
memory
Sorry for the lenght of the message, but I wanted to be clear
Thanks for helping, I appreciate it a lot