取列表框值并插入表格 [英] Take list box value and insert into a table

问题描述

我需要一些帮助，似乎无法让它发挥作用。你可以说，我对此非常陌生。



我有一个非常简单的Access数据库。我有一个空白的表出勤，有三个字段（Employee_Names，Mark，When）



我想把我的表单Roll Call有两个列表框：

List2并包含进入Employee_Names的信息

List25，其中包含进入Mark的信息

何时将是创建条目的日期



最后我们有一个提交按钮提交我想从我的两个列表中选择并点击提交，它会将该信息与当前日期一起插入进入我的表出席。然后我需要立即选择一个不同的值并单击提交。这是为了出席。我知道一些VBA编码但是还不够。



我尝试了什么：



谷歌和两天的追踪和错误。拔头发。

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.

推荐答案

花点时间用这个大规模MS Access和VBA教程。



它将帮助您掌握家庭作业。

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.

这篇关于取列表框值并插入表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！