Re: Update Table from Form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: fredg <fgutkind@xxxxxxxxxxxxxxx>
Date: Wed, 25 Oct 2006 18:27:30 -0700

On Wed, 25 Oct 2006 17:29:01 -0700, David wrote:

This is an easy question
I have searched around the rooms but I can't find a similar thread.
I have a text box on my form that I want to use to update a table record
when I click on 'update'

Private Sub Command12_Click()

CurrentDb.Execute "UPDATE [Library] SET [Borrower] = " & Borrower & "
WHERE [Book ID] = " & BookID

End Sub

Where am I going wrong?

You state that you have a text box on the form, yet your code is
calling for 2 text boxes.

And the datatypes of [Borrower] and [BookID] are what?
Text? Number? It makes a difference.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Prev by Date: RE: access expression using two "if" statements
Next by Date: RE: Main Menu has disappeared!
Previous by thread: RE: access expression using two "if" statements
Next by thread: Re: Update Table from Form
Index(es):
- Date
- Thread

Relevant Pages

Re: how to create a query to handle "No Such Data Found"
... values to diaplay on a form, however, sometime data of combination of ... Found" and be also direct back to combo boxes menu. ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ...
(microsoft.public.access.queries)
Re: From text box to field
... but I'm lost for the answer. ... have two text boxes in a form: one for FirstName, ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ...
(comp.databases.ms-access)
Re: How do I wrap text in a list box?
... boxes in the print preview view. ... drop-down list portion will still be just one line). ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ...
(microsoft.public.access.tablesdbdesign)
Re: Clear option group
... On Sat, 10 Mar 2007 17:37:32 GMT, Ivor Williams wrote: ... want to clear both check boxes. ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ...
(microsoft.public.access.forms)
The History Of RORT -- Example #2
... demonstrate how the hate and the vitrol among the so-called campfire ... buddies of this newsgroup simmered and exploded long before any so- ... Name calling is all you have when it comes right down to it. ... You try to wow people with faulty logic and facts. ...
(rec.outdoors.rv-travel)