Take list box value and insert into a table

Question

0.00/5 (No votes)

See more:

I need some help and can't seem to get this to work. I'm very new at this as you can probably tell.

I have a very simple Access Database. I have a blank table "Attendance" with three fields (Employee_Names, Mark, When)

I want to take my form "Roll Call" that has two listbox:
List2 and contains the information to go into "Employee_Names"
List25 with the information to go into "Mark"
"When" would be the date the entry was created

Finally we have a submit button "submit" I want to select from my two list and hit submit and it inserts that information along with current date into my table "Attendance". Ill then need to immediately select a different value and click submit. This is for the purpose of attendance. I know some VBA coding however not enough.

What I have tried:

Google and two days of trail and error. Hair pulling.

Posted 6-Jul-17 14:36pm

Member 13297319

Updated 7-Jul-17 0:19am

Add a Solution

Comments

Patrice T 6-Jul-17 21:21pm

You have a secret problem in your secret code.

Member 13297319 6-Jul-17 21:25pm

No more code currently. Deleted it all so I have a fresh start. I can added items to the table utilizing the new blank record at the bottom of access form however I want this function in my start button and It only inserts the name and "Mark" I cant get current date to insert into the table. Also this site doesnt allow attachments otherwise Id post the database.

Patrice T 6-Jul-17 22:04pm

Use Improve question to update your question.
So that everyone can pay attention to this information.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

KarstenK · Answer 1 · 2017-07-07T00:19:00

Solution 1

Take the time to acquire some basic knowledge with this large-scale MS Access and VBA tutorial.

It will help you to master your homeworks.

Posted 7-Jul-17 0:19am

KarstenK