Form design for novice

[bermaq@multifab-inc.com]

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

[dghebrehiwet@gmail.com]

Re: Form design for novice

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 import 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...@multifab-inc.com 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