Basically, copy the SQL from each of the other queries and join with the word "UNION" between them on the new query.
All work and no play...
and all that. But still, you gotta work. So, here I am working. This is where I record the cool things I learn that I may need in the future when I've forgotten them. Like ten minutes from now. Cause I have the brain of a gnat.
"Work is either fun or drudgery. It depends on your attitude. I like fun."
"The heights by great men reached and kept
Were not attained by sudden flight,
But they, while their companions slept,
Were toiling upward in the night."
"Work is either fun or drudgery. It depends on your attitude. I like fun."
"The heights by great men reached and kept
Were not attained by sudden flight,
But they, while their companions slept,
Were toiling upward in the night."
Private Sub Form_Load()
On Error Resume Next
CurrentDb.Properties.Delete ("PublishURL")
End Sub
On Error Resume Next
CurrentDb.Properties.Delete ("PublishURL")
End Sub
Private Sub Form_Current() [field name].SetFocus End Sub
Add an onload event for the form with this code:
Private Sub Form_Load()
Call DoCmd.GoToRecord(, , acNewRec)
End Sub
Call DoCmd.GoToRecord(, , acNewRec)
End Sub
© Copyright Whit's Working. All rights reserved.
Designed by FTL Wordpress Themes | Bloggerized by FalconHive.com
brought to you by Smashing Magazine