Send Data

[Sunder]

Hi All,

How do I send data to database(sqlserver2005) from text box in Ms Access VBA.

I created form I took some text boxes in form, when I write some data in text box and click on save button, it will automatically send to the database.please post the code .
:hi:
Thanks in Advance

Sunder

[Imdabaum]

Why not use Linked tables? Then you only need to set the form to have the recordsource as the sqlserver2005 table (or query based on the table). The rest is taken care of automatically without additional code.

[CreganTur]

Are you working only with SQL Server tables? If yes, then build an Access project- it's a special database type that natively uses SQL Server for the backend. This won't work if you require local tables, though.