Thank you so much!!!

  • Thread starter Thread starter Vika
  • Start date Start date
V

Vika

Hi Steve 2 :)

Thank you so much for your help... I really appreciate it. I will b
back to my office tomorrow and will give it a try

Thank you again

Vik

P.S. Tables Observation and Obserbationb are linked together o
OnbservationNumber field (which is Auto Number
 
Vika said:
Hi Steve 2 :)

Thank you so much for your help... I really appreciate it. I will be
back to my office tomorrow and will give it a try.


Thank you again,

Vika

P.S. Tables Observation and Obserbationb are linked together on
OnbservationNumber field (which is Auto Number)
Click to expand...

Vika,

Try this on a backup (copy) of your database until it is working!!!

The code will not work for you as written. There are some fields I didn't use
(like ObservationNumber) because I didn't know what the field was, what fields
linked the tables and I didn't know the field types; when I made my tables I
guessed at the field types. The code *does* work for the tables I made - and
should for you after you modify it.

When you modify the SQL string "strFF_SQL", remember that numeric fields do not
require delimiters, strings need (I use) single quotes and dates need "#" symbols.

If you have questions, post back.

Good luck :)
 
Back
Top