Search results

Thanks for all the help and suggestions guys.

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

Rock on.:cool:

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!" -...

Figures. chergh - rock on brother.

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...

That's because: myDb.OpenRecordset("SELECT Trigger FROM Reports") is returning a recordset, not a string. Try using a DLookup function instead.

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.

FYI. The closing semicolon is NOT required

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...

Anyone, and I mean anyone (Mr. Branson included) who knows they are incorrect, but chooses to ignore it because they perceive that it is not that important or because they can't be bothered by trivial matters is not only lazy, but being a bit disrespectful and quite frankly, pompous. If we all...

So, if I am in Italy, speaking broken Italian, and in my effort to ask, "Where is the movie theater?", I instead ask, "What is dog instead my poop, sir?", is the helpful Italian man I have stopped to ask my query of supposed to read my mind and direct me to the movie theater? I know I have no...

For those of you who might be wondering why you can't get a response to a question you have posted, I thought I might at least post a few reasons why I don't respond to a post, even if I know the answer: 1) It is apparent from the question and it's REALLY simple solution that the questioner...

Retrieving the newest file is not a problem, but will require that you reference the file scripting runtime and look at all the files in the directory to determine the newest. Since you asked the question, "where must I input this code?" I can assume that any explanation of how to reference and...