Is it possible to debug an append query ?

  • Thread starter Thread starter Tony Girgenti
  • Start date Start date
T

Tony Girgenti

Hello.

I'm trying to figure out why my append query is not getting any records based on a < date from a from field.

I can watch the form field in debug mode of VBA, but i dont know how to watch the append query field defined as DateValue([TIMESTAMP]). I want to be able to see if the query date is in the same format as the form date field.

I use this to run the query "DoCmd.OpenQuery "ArchiveAppend"".

Thanks,
Tony
 
In the query designer, if you click on the Datasheet view icon(left corner),
it will show you what records will be appended, without appending them.
Press the execute icon(Red Exclamation Point) is the go button.

It is not uncommon to create a select query to ensure that everything is
correct. Once it is correct, change it to an Action query. This is
typically very helpful with Update Queries.


--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html


Hello.

I'm trying to figure out why my append query is not getting any records
based on a < date from a from field.

I can watch the form field in debug mode of VBA, but i dont know how to
watch the append query field defined as DateValue([TIMESTAMP]). I want to
be able to see if the query date is in the same format as the form date
field.

I use this to run the query "DoCmd.OpenQuery "ArchiveAppend"".

Thanks,
Tony
 
Back
Top