Conditionally Run Queries

Topic

New Reply

The code for the “Import from Spreadsheet” button on the startup form of the attached mdb appends the data from the attached Excel file but in case there are any modifications made to the Excel file for the same date span, I’d like to give the user the possibility to reimport the file so, in Private Sub Command142_Click(), how can I conditionally run the update query(qUpPortMazz) instead of the append query (qAppPortMazz) if that particular date span has already been imported?

Reply | Quote

Replies

Something like this ?

if Isnull(dlookup(“DATA”,”portmazz”,”DATA = #” & cvdate(format(dlookup(“DATA”,”tmpTbl”),”mm/dd/yyyy”))& “#”)) then
run the append query
else
run the update query
end if

Reply | Quote

Perfect!! Thank you Francois!!

Reply | Quote