M$ Access

[Eidron]

I have to do a database in crappy M$ Access. Normally I use MySQL with a php interface but I cant here.

Is it possible to use some VB code to validate some information? I have some code to validate an ISBN number but no idea how to get it to work with the db. Any help would be appreciated. Thanks.

Also, how can I set a yes/no field in another table to yes when a record is created in another table?

[Eidron]

I am playing with running SQL statements in macros after an update. Is it possible to use UPDATE so that it sets the value of "IsOnLoan" in table bookCopy to yes (I can do this) WHERE BookReference = (The value in a field on the form running the macro). Any help would be much appreciated. Thanks.

[Eidron]

I have the following SQL statement in the macro:

UPDATE bookCopy SET IsOnLoan =Yes WHERE
the WHERE staement is where I need the help. I want to tell it to update the record where "BookReference" = the value held in the textbox "BookReference" on the form Im using. Anyone?

[Supernova9]

Originally Posted by Eidron

I have the following SQL statement in the macro:

UPDATE bookCopy SET IsOnLoan =Yes WHERE
the WHERE staement is where I need the help. I want to tell it to update the record where "BookReference" = the value held in the textbox "BookReference" on the form Im using. Anyone?

Doing this as VB code on the form?


set db = currentdb
strSQL = "UPDATE bookCopy SET IsOnLoan = Yes WHERE BookReference = " & Me.BookReference.Value & ";"
db.execute strSQL