saving data from another table in access

devilz · February 10th, 2009, 08:53 PM

Hello readers,

I'm very new with VB6.0. Can you please help me??
There are two tables in my Access DB. Users are inputting Emp_id(PK) in Table1. Under combo_click i need to save all Emp_id from Table1 into emp_id column(FK of Table1) of Table2. It is possible to save date in both table while user inputs but in combo box month name is there, for each month i need to do it once and need to save the month name in separate column in Table2.
Please help me.

gbianchi · February 11th, 2009, 07:22 AM

Hello.

Can you please post an example of what you need.. is not very clear.

Also you need code or SQL help??

devilz · February 12th, 2009, 07:14 PM

Hello gbianchi,

I'm storing data of employee info in Table1. Emp_id is one of the column name of Table1 which will generate while users are updating employee info from a certain page. In another page i'm going to create Employee roster. in roster creation page combo box is there which consist of month name. First Iâm selecting employee id from a combo box. Now which i want is: when i'm selecting month name from combo box i want to save that specific employee id in Table2. month name will also be stored in different column after validation. if the same employee id along with the month name was stored earlier then it will prompt.

gbianchi, you help me in past. Think you wont mind to help me now also. I need sample cove in VB 6.0. Please....

gbianchi · February 13th, 2009, 07:56 AM

Still not seeing where is your problem.

In your second form, you have a combo with months (?) and you are trying to store that selection with the id you get from the first form. And the problem is??? You don't know how to do which part?

From your first form, you past the id to the second form.

(when you call your second form)

Code:

Load SecondForm
SecondForm.EmpoyeId = selectedid
SecondForm.show

In your second form you have a variable like this

Code:

Public Employeid as int

Or long or whatever you need.

When you select from the combo (I don't know if you use a buttom or something else, but...)

first you validate the data with a sql like this.

Code:

SELECT COUNT(*) FROM table2 WHERE month = 'yourselectedmonth' AND employid = theidyougetfromfirstform.

If that count returns 1 then you are trying to insert something that already exists.

Are we going good now?

devilz · February 15th, 2009, 06:29 AM

Hello gbianchi,

How could you solve without Identifying the problem??? Ha..Ha..Ha.. Truely your code resolve my problem. Thank you very much for the support.

Regards..