Search results

There is no reason why a primary key can't have "meaning" but a primary key MUST: 1. Always be unique 2. Not be changed on a record... EVER 3. May not be deleted from the table unless all child records that refer to that key (via Foreign Key to Primary Key) are deleted first. A primary key...

Heard this one on the news. "The funeral home had buried 6 dead corpses in the past week". First of all, they would not be corpses if they were not dead and second, I sincerely hope that it was "dead corpses" that they buried!

I don't disagree with much of what you say, but I will NOT vote for a third party candidate just because they are that. I will vote for any candidate that most closely matches my own ideas of what needs to be done in government and how to do it, regardless of party affliation (or lack of). The...

While jamemor's point is way to broad of a generalization to be factual (there are in fact many in Congress and the Senate who care very much about what they do and who they serve), your suggestion that we not vote for one of the two party candidates is unworkable right now for several reasons...

That is why I always: 1. include an example of exactly what I want in a field in a form, when formatting matters, such as "Date format should be 'mm/dd/yyy" 2. Validate ALL data in a module BEFORE inserting in or updating the database. #2 is important for a number of reasons other than...

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"

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.