P
pk
I was looking through this group for possible answers and I found a few
that are very similar to my situation...however in my situation I have
no tables in the access database, I am just using an Unbound form to
connect to an sql server and a table in that server.
Lets say I have a form called Inventory
On this form there are spaces available for entry of InventoryID,
Quantity and Name, these will go into text boxes.
I then have an SQL Table with this information as well....
Now remember my access database has no tables. Lets say I want a
button and want the click event of that button to do something like
this.
When the button is clicked, it will look at the InventoryID I put in
the textbox and it will go out to sql and look for that row in the
table, it will then return the quantity and name of the product,
putting that information in the appropriate textboxes.
How would I code this?
Lets say I have another button Insert, when clicked will take what is
in the textboxes and insert them into the table in sql in a new row.
For example if I enter:
InventoryID: 990
Quantity: 4
Name: Widget
it would enter that data into the sql server database table.
anyone that can help I would really appricate it.
thanks
that are very similar to my situation...however in my situation I have
no tables in the access database, I am just using an Unbound form to
connect to an sql server and a table in that server.
Lets say I have a form called Inventory
On this form there are spaces available for entry of InventoryID,
Quantity and Name, these will go into text boxes.
I then have an SQL Table with this information as well....
Now remember my access database has no tables. Lets say I want a
button and want the click event of that button to do something like
this.
When the button is clicked, it will look at the InventoryID I put in
the textbox and it will go out to sql and look for that row in the
table, it will then return the quantity and name of the product,
putting that information in the appropriate textboxes.
How would I code this?
Lets say I have another button Insert, when clicked will take what is
in the textboxes and insert them into the table in sql in a new row.
For example if I enter:
InventoryID: 990
Quantity: 4
Name: Widget
it would enter that data into the sql server database table.
anyone that can help I would really appricate it.
thanks