-
dataenvironments
i have created a dataenvironment and i can navigate through it no problem
dataenvironment1.rsplayers.movenext
if dataenvironment1.rsplayers.eof then
dataenvironment1.rsplayers.movefirst
etc
i need a button that can add data entered into text boxes into the database ??
thanks in advance
-
Re: dataenvironments
If you have the Professional Edition, you can use the data aware form wizard to create text boxes connected to your recordset. You can also set the data source and field properties of your textboxes.
-
Re: dataenvironments
Try something like this... :)
Code:
dataenvironment1.rsplayers.addnew
dataenvironment1.rsplayers!fieldname = Text1.Text
dataenvironment1.rsplayers!fieldname = Text2.Text
dataenvironment1.rsplayers!fieldname = Text3.Text
dataenvironment1.rsplayers.Update
-
Re: dataenvironments
thanks, i havnt tested ywt as im at work but i had something simular with slightly wrong syntax, i knew it was easy i have done things like it in the past but i have had a lot of problems with connecting to my database since sp2 really
ps i have the enterprise edition
ill resolve it when ive test :d