Data Access Page - SQL SELECT / INSERT

[dcanfield]

I have a form in Access that displays a record from a Data Entry table.

I created a module that would select the record from the Data Entry table (as displayed in the form), and append it the Master Data table. I created a macro to run this module, and linked it to a button on the form where it was activated by ‘OnClick”. It all works fine.

I then created a "DATA ACCESS PAGE" in MS Access from this form.

I had to tweak the control on the form that has the “OnClick” feature so that it is set to run a VBScript shown below. When the user clicks on the “Submit” button, I want to append the data from the data entry table into the Master table.

It is not currently working….No error messages....just nothing happens.

Any help much appreciated.

Thanks!
David

sqlSelect = "SELECT BIA_DATA_ENTRY.* INSERT INTO BIA_MASTER FROM BIA_DATA_ENTRY WHERE ID > ' 0 ' "

 

[FancyPrairie]

Is ID a string? If not, remove the single quotes around the 0.

 

[PHV]

sqlSelect = "INSERT INTO BIA_MASTER SELECT BIA_DATA_ENTRY.* FROM BIA_DATA_ENTRY WHERE ID > 0"

How is this SQL code executed ?


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886