I have a development copy of a database that I use to push changes out to a network copy when I need to make design changes (to forms, modules and other objects). Currently I have a function that I run that calls up a list of all the objects in Access from which I choose the items to push...
Could this be a clue that I'm maybe baiting you guys - fanning the flames for my own amusement?? Nothing funnier than getting folks riled up on a forum, sitting back and watching the flames flicker! Great fun when you're bored at the job.:D:D
Ah. One more for the road - made me chuckle.
http://api.ning.com/files/gVbJ9SOMCBDw9jlepvItOry7X0*vzXdkvrXsDF1-rqY2qEw-DWMgvmkdhyhRNtH*uyEQMQUU5RyInOoLwOnEtx7zni7DMLBF/CrtnBusStop.png"]
Thanks for the entertainment all - I'm off to fan some flames elsewhere, but in closing, I heard a few good ones worth sharing:
- Abstinence makes the church grow fondlers.
- Honk if your religious beliefs make you an asshole.
- "Worship me or I will torture you forever! Have a nice day!" -...
A divine creature, created by the loving hand of an almighty god with free will and a complex and intricate brain with which to learn and question who has chosen to accept, "Hey, I've got all the answers, no more need to grow or learn, no other knowledge need enter my brain because I've got all...
Aaaaaaaaagggggghhhhhhh!!!! On the one hand you profess to be a "learned" individual who can present a cogent argument, and yet on the other hand admit that your only purpose in being created is to bow down, worship and subjugate yourself to a deity for your entire existence? Hell, I can create...
Belief does not equate to proof of validity. Ultimately, no one is an authority as to what really happened in our history other than those who were there as eyewitnesses, and even eyewitness testimony has been shown to be some of the most unreliable. And before you start your reply with the...
Had a search around did you? Hmmmm? After taking about 5 sec to type "outlook VBA create folder" into Google I came up with the following as the FIRST hit: http://www.tek-tips.com/faqs.cfm?fid=6232. If you are not familiar with the acronym STFW in my sig - look it up.
As a general rule with regard to performance, temporary tables are a BAD idea - they lead to bloat and corruption and should be avoided. You can usually accomplish the same thing with a carefully designed update or append query or some creative VBA coding if you need to temporarily hold data...
When used in a query, the second argument of the Nz function should always be used. From The Access help file:
The Nz function has the following arguments.
First argument - variant A variable of data type Variant.
Second argument - valueifnull [Optional] (unless used in a query). A Variant...