By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,068 Members | 1,734 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,068 IT Pros & Developers. It's quick & easy.

Update Access by using a text box??

P: n/a
I would like to update Access by using a txtBox.
Is it possible to update Access this way?

Example:

If I selected the txtBox and input a line of text I would like that line of
text to be sent to the right Access field in the data base when it is
updated.

--
I am a Noob!
Thanks for the Help :)
Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Using the Wizard, create an OLEDB connection and dataadapter, once you have
connected to your database ( tested it ), create a dataset by right clicking
the adapter. Bind the textbox to the table/field in the dataset and on text
changed event, call the Update method of the adapter.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Shane" <Sh***@discussions.microsoft.com> wrote in message
news:FC**********************************@microsof t.com...
I would like to update Access by using a txtBox.
Is it possible to update Access this way?

Example:

If I selected the txtBox and input a line of text I would like that line of text to be sent to the right Access field in the data base when it is
updated.

--
I am a Noob!
Thanks for the Help :)

Nov 21 '05 #2

P: n/a
Can I still do this even if i have already created the OLEDB connection and
datadapter connections?

"One Handed Man ( OHM - Terry Burns )" wrote:
Using the Wizard, create an OLEDB connection and dataadapter, once you have
connected to your database ( tested it ), create a dataset by right clicking
the adapter. Bind the textbox to the table/field in the dataset and on text
changed event, call the Update method of the adapter.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Shane" <Sh***@discussions.microsoft.com> wrote in message
news:FC**********************************@microsof t.com...
I would like to update Access by using a txtBox.
Is it possible to update Access this way?

Example:

If I selected the txtBox and input a line of text I would like that line

of
text to be sent to the right Access field in the data base when it is
updated.

--
I am a Noob!
Thanks for the Help :)


Nov 21 '05 #3

P: n/a
Sure, I was just giving you a set of instructions, pick up from where u are.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Shane" <Sh***@discussions.microsoft.com> wrote in message
news:87**********************************@microsof t.com...
Can I still do this even if i have already created the OLEDB connection and datadapter connections?

"One Handed Man ( OHM - Terry Burns )" wrote:
Using the Wizard, create an OLEDB connection and dataadapter, once you have connected to your database ( tested it ), create a dataset by right clicking the adapter. Bind the textbox to the table/field in the dataset and on text changed event, call the Update method of the adapter.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Shane" <Sh***@discussions.microsoft.com> wrote in message
news:FC**********************************@microsof t.com...
I would like to update Access by using a txtBox.
Is it possible to update Access this way?

Example:

If I selected the txtBox and input a line of text I would like that
line of
text to be sent to the right Access field in the data base when it is
updated.

--
I am a Noob!
Thanks for the Help :)


Nov 21 '05 #4

P: n/a
When I click on DataBindings in the properties menu a list of options open
up, they are Advanced,Tag, and Text. Can somebody tell me what Tag and Text
are used for?

"One Handed Man ( OHM - Terry Burns )" wrote:
Sure, I was just giving you a set of instructions, pick up from where u are.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Shane" <Sh***@discussions.microsoft.com> wrote in message
news:87**********************************@microsof t.com...
Can I still do this even if i have already created the OLEDB connection

and
datadapter connections?

"One Handed Man ( OHM - Terry Burns )" wrote:
Using the Wizard, create an OLEDB connection and dataadapter, once you have connected to your database ( tested it ), create a dataset by right clicking the adapter. Bind the textbox to the table/field in the dataset and on text changed event, call the Update method of the adapter.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Shane" <Sh***@discussions.microsoft.com> wrote in message
news:FC**********************************@microsof t.com...
> I would like to update Access by using a txtBox.
> Is it possible to update Access this way?
>
> Example:
>
> If I selected the txtBox and input a line of text I would like that line of
> text to be sent to the right Access field in the data base when it is
> updated.
>
> --
> I am a Noob!
> Thanks for the Help :)


Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.