If you are expecting letters then validate for letters, numbers validate for numbers, escape special characters. I would really suggest reading up on the hundreds of SQL injection techniques and start reading up on PDO's.
INSERT INTO statements are commonly referred to as append queries.
To add one record to a table, you must use the field list to define which fields to put the data in, and then you must supply the data itself in a value list. For example, the following statement will insert the values "1", "Kelly", and "Jill" into the Customer ID, Last Name, and First Name fields, respectively.
In turn, those design principles affect how you enter data.
Remember these facts about database objects and design as you proceed.
You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. I am trying to update a table from form values in Access 2k. Description Resume Exit_Choose_Synonym_Click End Sub I get a "datatype mismatch on criteria expression" and can't figure out why (everything is Long Integer).
This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. In the following code "tbl Catalog" is the table to be updated.
Run SQL str SQL Cheers Ray quote: Originally posted by Ray Pinnegar If the PKeys are integers try: str SQL = "UPDATE tbl Catalog" & _ " SET tbl Catalog.
When edit is clicked (page 2) the code pulls the $id and puts it in the url.
PKey] as a bound textbox in the pop-up form and it works.