Search Result

Hi All,

I have been creating a database that basically searches for data based on the SQL string created. So far, I was successful until I received -- Error Number 3270 - Property Not Found -- when I click on the button to trigger the search.

I modified a database which I found on line for my purposes.

See code below. How do I resolve the error message? What object is VB referring to when it says "property...

I have been using access for years but only recently have I been getting more serious and as a result I have been playing around with the different options / settings access offers.

It seems to me I have changed some setting because the set up of my error messages has drastically changed.

I used to get the standard error messages that has the options of "end" "debug"...

As of a few...

I had an Access 2007 database with 75,000+ records and 60 fields in a table created from data imported from Excel spreadsheets. When a select query was run which counted the totals for each entry in the Manufacturer field, an error message - "Record is deleted" and the option to click on OK or HELP - was received. Of course clicking OK was really the only option and when this was done records, not a single record but several, were gone...