a few questions

  • Thread starter Thread starter Jim VanGordon
  • Start date Start date
J

Jim VanGordon

I have a "Save" button on the form that also refreshes.
I was wondering if you could throw in a code segment to
disable the save buttons on the toolbar and menu bar.

Also, I have a union query that combines multiple tables
to search through all the tables at once. I need some
way to distinguish which table it came from though. Is
there a way to put another field on the form that shows
the table the information is coming from automatically.

Thanks,
Jim VanGordon
 
Place the table names in the select list in quotations:

Select Field1, Field2, Field3, "FirstTableName"
From FirstTable
UNION
Selct Field1, Field2, Field3, "SecondTableName"
From SecondTable
 
Thanks for answering one of my questions, Lynn. I was
wondering if any one could help me with the disabling of
the save buttons though. Just didn't want you guys to
forget about the other part. I really appreciate all the
help I've gotten here from the MVPs and everyone else.

Thanks,
Jim
 
I can't believe I didn't think of that. I was just making
it too difficult.

Thanks,
Jim
 
Back
Top