Find database record based on multiple criteria

[lpking2005]

Hi,

Not sure it his is meant to be on the Access message board or Excel.??

Im trying to use vba to find a recordset in an access database based on multiple criteria and then overwrite this record with data that is on an excel sheet.

At the moment i possibly have a problem with the SQL reference to the table.
When the code opens the connection it finds no record.

strSQL = "SELECT * FROM Records WHERE [Current Date] = '" & curDate & "'" & " And [MFG Vessel] = '" & curVessel & "'" & " And [Batch Number] = '" & curBatch & "'"

I think it may be failing because of too many 'And' clauses but im not sure of a way that i can use a 'WHERE' clause when trying to check a record based on multiple field data?

Any help would be appreciated.

Thank you!

 

[ScottR]

It's definitely not too many "And" clauses. You can use hundreds without issue should you so choose.

My instinct would be your issue is with date formatting and automatic date format conversion during the query. That's caused me many headaches over the years...

 

[lpking2005]

ok, Thanks for the information.

I will look into the formatting of the date first.

Thanks.