Add data to table on submit

[fluidmind]

Hello everyone!

Before i forget: Sorry about my three identical posts before :-(

Here is the thing:
I've attached a picture of one of my forms (on a very early stage). I want to save the inputs into a table1 containing all the coworkers. I want to write the value 'X' into the column selected in the drop-down menu. But only at the coworkers whose numbers are entered into the textboxes 1-6.

How is that done???

// JR

 

[MaliciousMike]

Hello everyone!

Before i forget: Sorry about my three identical posts before :-(

Here is the thing:
I've attached a picture of one of my forms (on a very early stage). I want to save the inputs into a table1 containing all the coworkers. I want to write the value 'X' into the column selected in the drop-down menu. But only at the coworkers whose numbers are entered into the textboxes 1-6.

How is that done???

// JR

there's no screenshot.

So... if co-worker1 has numbers in 3 of the textboxes, you don't want 'X' entered. But if a co-worker has all 6 numbers in the 6 textboxes, you want 'X' to be added into a different column of the table?

If Textbox1 <> "" and Textbox2 <> "" and Textbox3 <> "" and Textbox4 <> "" and Textbox5 <> "" and Textbox6 <> "" Then
mysql = "INSERT INTO Table1." & dropdownmenu & " WHERE coworker ='" & txtCoworker & "'
Else
msgbox "sorry, you need all text fields to have numbers"
End if

Hope i'm right.

 

[fluidmind]

Screenshot!

Shit, I forgot to attach the screenshot, but here it is...

Mike, nice to see you here again I think you got it a bit wrong, but that's my fault. Hope you'll check out the screenshot and post a new reply!

Even if only a few of the boxes are filled (with coworker-numbers), I still want to register in the table that theese workers have participated in the meeting selected in the drop-down!

// JR

 

[fluidmind]

Please reply

Hey guys!

I would really appreciate your help on this one...

// JR