Search results

Most likely when you deleted the relationships and messed around with your autonumber column you invalidated the data in all of your foreign keys in other tables, so that the relationships you now have (if any) are pure garbage. If that is the case, then you may have to figure out how to dump...

Here is a great link that explains the request.servervariables collection in ASP: http://www.w3schools.com/asp/coll_servervariables.asp

Thank you for the kind thoughts, Vassago. It was many years ago and though the grieving goes on (it always will), I posted this not for sympathy, but in the hope I could add a bit of understanding to the subject of autism. We hear a lot about it these days, but precious little real information.

My son was high-functioning autistic. He died 11 years ago at age 12 (from a mis-prescribed drug). There are many levels and types of autism and also many people who fit in the "autism spectrum" but are not autistic - that is, they display 3 or fewer of the common attributes associated with...

One I saw on a can of beef stew: "Open before eating"

Actually it would do little to refrain from buying something for three days if it was eventually purchased. The economy would quickly recover when the purchases were finally made. Now, if you could convince Americans not to drive at all for three days, THAT would make a significant difference.

If this is a web HTML report (and not PDF) use this: =[SchoolAddress1] & "<br />" & [SchoolAddress2] & "<br />" & [SchoolCity] &", "&[SchoolState] & [SchoolZipCode]

There are ways to encrypt and decrypt any data from any column but many add a lot of overhead to the process. I would suggest that if security of that great a concern, you should switch from an Access DB backend to a SQL Server backend, where security is much more robust.

Bob is right on, as he always is. Also, if your field is repeated in multiple tables then it should probably be in its own table, with a primary key that then becomes a foriegn key in the other tables.

That is a great tip. I always test my sql in query designer before attempting to use them in VBA. If it works in query designer then there is no reason for it NOT to work in VBA unless you make a mistake in breaking the lines.

Yep, you are right about the typo. It has been awhile since I worried about the "theory" end of things but I learned many moons ago that it is quicker and more efficient evaluate two booleans in a single if then statement (and/or, etc) than it is to call a function. Of course it probably does...

Not sure why that would be better than if (isNull(mystrng)) or mystrng="" Then mystrng="somedefaultstring" end if or if (isNull(mydate)) or mydate=0 Then mydate="#somedefaultdate# end if

Re: Department for Work & Pensions :D:) Good one! Thanks for the laugh!

Ok, you asked for it. Petard is/was an explosive used to breach walls. The name actually comes from the French word for fart (no kidding!). To hoist one on one's own petard means to blow yourself up with your own explosive. A bad (and stupid) thing to do. I think the phrase was first used...

lagbolt, there were many of us in the US at the time of the Iraq invasion that conditionally supported the decision, based on the WMD line of reasoning. I was one, but at the time I stated that should the WMD production turn out to be false, then we had no right to be there. Of course, I was...

Sure! It is called Access 2010 (or 2007 or earlier versions). The Wizards will help you. But first you need to learn a bit about db design. No software will do that for you. Just look up tutorials on Google.

Actually there is a rather large body of facts that point to the Reagan years as the root of the recession, especially the efforts at deregulation of banks and financial institutes. These continued to accelerate through following administrations. But G.W.'s administration was unprecedented in...

Restricting my answer to those I have personal memories of, I would have to say the best would be a tossup between John F Kennedy and Ronald Reagan, the worst by far would be Cowboy George Bush II.

the_net 2.0, In the US, your work has copyright the moment you create it. Putting a notice on it merely codifies it and registering makes it easier to prove. But even unregistered with no notice, you own the copyright and can take legal action if someone infringes on it. Since the burden of...

Rarely are these issues due to language. Legacy software tends to doom itself due to the piecemeal way it grows. While there may have been an original good design, it sounds like your application has gone far beyond that and is now out of control. My advice is to take the time and sit down...