Hello wes,
first add data bound combobox to your form.
Simply drag the combobox onto the form and adjust the datasource
to the right table. Make the id the bound column and display the
employee name.
You can display several columns if you wish.
Secondly you create for example a button which is to be pressed when
you have choosen the right employee. Attach an click event to it.
In this event you can build your sql string to insert the new item
into the table
"CNC log table".
Yes. You can open, create and modify excel tables from within access
vba or can im****t excel
tables as tables into your database.
Hope this helps,
da8
INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2,....)
On 8 Mai, 22:53, ber...@[EMAIL PROTECTED]
wrote:
> Hi
> I'm working with an exsisting database in 2007. I would like to add a
> control(?) to a form that would display information from a different
> table.
>
> The form is a simple way of inputing information into a table called
> "CNC log table". I want to use a combo box input ("empoyee name")
> that would pull info ("employee number") from the same table and
> display it on the form and then input it into the "CNC log table".
>
> Would it also be possible to gather this input info from an .xls
> spread sheet.
>
> Thanks
> wes
|
