OK I need help again, filling in an SQL table from an acceess form and the reverse..??

TC thanks for the help so far but I am still not getting anywhere.

In regards to linking tables I cant do this because my Access database does
not have any tables at all.

Lets say this is what I want to do.

I've got an SQL Server table "UserInfo"
in this table there are fields "ID" , "Name" , and "Phone"

I then have a couple forms in access, still my access database has No
tables, just two forms.

The first form "FINDUSER" consists of a textbox for "ID" "Name" and "Phone"
If I enter a ID into the textbox and hit my button to find I want the Name
and Phone textboxes to be populated with the correct infor for that user
from the sql table, thats all.

Another form, INSERTUSER has all of the same text boxes, now when the
Insert button is pressed on this form I want the ID, Name and Phone that are
entered in the textboxes to go over and be entered in the SQL Table.

thanks
Maybe someone has an access database somehwere that does something similar
that I could look at or how would I accomplish this?

thanks

You can link the table through by going to File - Get External Data - Link
table. Select the ODBC option in the file type drop down. Using an
existing or create a new DSN pointing to your SQL Server. Select the
appropriate table. You'll need to create a primary key on the table in SQL
server or select a unique key field during the link process. Otherwise, you
will not be able to update the data.

Once the table is linked - set the form's recordsource property to the newly
linked table. You can use the combo box wizard to create something you can
use to search the data for the specific ID.

Create a data entry form (bound to the same table) to insert new records.

"RON" wrote:

TC thanks for the help so far but I am still not getting anywhere.

In regards to linking tables I cant do this because my Access database does
not have any tables at all.

Lets say this is what I want to do.

I've got an SQL Server table "UserInfo"
in this table there are fields "ID" , "Name" , and "Phone"

I then have a couple forms in access, still my access database has No
tables, just two forms.

The first form "FINDUSER" consists of a textbox for "ID" "Name" and "Phone"
If I enter a ID into the textbox and hit my button to find I want the Name
and Phone textboxes to be populated with the correct infor for that user
from the sql table, thats all.

Another form, INSERTUSER has all of the same text boxes, now when the
Insert button is pressed on this form I want the ID, Name and Phone that are
entered in the textboxes to go over and be entered in the SQL Table.

thanks
Maybe someone has an access database somehwere that does something similar
that I could look at or how would I accomplish this?

thanks

How would I do this if the form had to be UNBOUND, this is what I need
to do, the form needs to be unbound

Orlanzo wrote:
You can link the table through by going to File - Get External Data - Link
table. Select the ODBC option in the file type drop down. Using an
existing or create a new DSN pointing to your SQL Server. Select the
appropriate table. You'll need to create a primary key on the table in SQL
server or select a unique key field during the link process. Otherwise, you
will not be able to update the data.

Once the table is linked - set the form's recordsource property to the newly
linked table. You can use the combo box wizard to create something you can
use to search the data for the specific ID.

Create a data entry form (bound to the same table) to insert new records.

"RON" wrote:

TC thanks for the help so far but I am still not getting anywhere.

In regards to linking tables I cant do this because my Access database does
not have any tables at all.

Lets say this is what I want to do.

I've got an SQL Server table "UserInfo"
in this table there are fields "ID" , "Name" , and "Phone"

I then have a couple forms in access, still my access database has No
tables, just two forms.

The first form "FINDUSER" consists of a textbox for "ID" "Name" and "Phone"
If I enter a ID into the textbox and hit my button to find I want the Name
and Phone textboxes to be populated with the correct infor for that user
from the sql table, thats all.

Another form, INSERTUSER has all of the same text boxes, now when the
Insert button is pressed on this form I want the ID, Name and Phone that are
entered in the textboxes to go over and be entered in the SQL Table.

thanks
Maybe someone has an access database somehwere that does something similar
that I could look at or how would I accomplish this?

thanks

If the form needs to be unbound.... You would need to add the appropriate
fields to it and use ADO/DAO to update the respective table programmatically.


"RON" wrote:

How would I do this if the form had to be UNBOUND, this is what I need
to do, the form needs to be unbound

Orlanzo wrote:
You can link the table through by going to File - Get External Data - Link
table. Select the ODBC option in the file type drop down. Using an
existing or create a new DSN pointing to your SQL Server. Select the
appropriate table. You'll need to create a primary key on the table in SQL
server or select a unique key field during the link process. Otherwise, you
will not be able to update the data.

Once the table is linked - set the form's recordsource property to the newly
linked table. You can use the combo box wizard to create something you can
use to search the data for the specific ID.

Create a data entry form (bound to the same table) to insert new records.

"RON" wrote:

TC thanks for the help so far but I am still not getting anywhere.

In regards to linking tables I cant do this because my Access database does
not have any tables at all.

Lets say this is what I want to do.

I've got an SQL Server table "UserInfo"
in this table there are fields "ID" , "Name" , and "Phone"

I then have a couple forms in access, still my access database has No
tables, just two forms.

The first form "FINDUSER" consists of a textbox for "ID" "Name" and "Phone"
If I enter a ID into the textbox and hit my button to find I want the Name
and Phone textboxes to be populated with the correct infor for that user
from the sql table, thats all.

Another form, INSERTUSER has all of the same text boxes, now when the
Insert button is pressed on this form I want the ID, Name and Phone that are
entered in the textboxes to go over and be entered in the SQL Table.

thanks
Maybe someone has an access database somehwere that does something similar
that I could look at or how would I accomplish this?

thanks