Search results

That would be a dreadful mistake to think that way. To suggest that benefits depends on the ruling party is not taking in the full picture. The fact is that it actually matters very little who's the ruling party, what policies they are pursuing. The only thing that matters is that they are...

Actually, I think we should be more worried about the fact that lambs are still bleating over whose turn it is to be the dinner as opposed to disposing of wolves. Another take on this is that lambs has taken to cannibalism. It doesn't matter who is the dinner as long they each get their turn at...

First, when you get a "ODBC-call failed", this is merely a generic error and to find out the specific errors, you need to enumerate all of errors in the DAO.Errors collection. Second, have a look at Doug Steele's DSN-less connection sample.

I dunno. Balanced or not, it still feels too much like a group of wolves voting on whether to have the lamb roasted or stewed while white lambs are claiming it's black lambs' turn to be the tonight's dinner while black lambs counter that there's more of white lambs and it's fair that more of...

Right - whether it's month names or month numbers, you don't want to "repeat" the column that would contain same kind of data but differs only in attributes (e.g. the motnh this data is for). That's why you want a column "BudgetMonth" to identify which month this budget is for. Same thing with...

Caveat: I tend don't download files so my answer is based on the post and apologies if this is off... If you mean that your table has this ... Jan | Feb | Mar | Apr | .... | Dec then this isn't the best way to design the table. This is definitely useful format as a *report* but not for the...

The part about "Par1" and "Par2" concerns me somehow as this suggests that the table may not normalized. If Par1 and Par2 are fundamentally same measures that happens to measure a different aspect (e.g. length and width as example), then it may make more sense to split those column into their...

Perhaps, but was that really a new song? They've been singing the same old song. They just changed the name of song but not the lyrics.

Personally, it's too bad it didn't actually shut down. I think that would be a good thing™. Maybe by then, everyone will come to the terms that morality simply can't be legislated and we're all better off without the armies of bureaucrats controlling every minutiae of our lives yet are never...

You got the right idea, but I think you only need this: DataLoggerLocationSWN for your child field links. Brackets are object identifiers and only required when you have a name that has characters that would be ambiguous. An example is when you have a table named "My Table", spaces makes it...

IMNSHO, there's no point in using a calculated field for Access 2010 database if it's not going to be used in web. This feature was given as addressing issues associated with deploying a web database. Frankly, the whole thing is questionable because for starter, you can't index it. At least in...

This line: Me.SubFormDataLoggerLocationComments.LinkChildFiel ds = Me.TextBoxSWN.Value Seems to be incorrect. it should be just the column name of the foreign key for your subform. As a reference, have a look at FMS Inc. synchronized subform.

FWIW, the same thing Galaxiom mentions was available in prior versions so not just 2007-onward. Just in a different place (Tools -> Startup Options). I actually prefer this over AutoExec anyway because when it's in a Form_Load procedure, then it get the benefit of a *DE file preventing it being...

Just to be sure, you should use backtick character ( ` ) and not single quote character ( ' ) as an object identifier for MySQL. If that's what was actually used, then I'm glad you solved this. BTW, another alternative: you can set sql_mode to allow ANSI and therefore allow you to use the quote...

I'm pretty sure (but I have no actual proof!) that macros should continue to work as before in 2010. If nothing else, at least, I do think macros are pretty nice in 2010. It's sort closer to how you'd write VBA and has some error handling capability so there's that going for 2010.

Well, code may get uncompiled if you are using *DB files sot to ensure it's always compiled, distribute *DE files. That said, I can kind of see how macros would be *slightly* faster than VBA since the underlying code would be running at much low level and would be reading only the inputs from...

First of all, does this CCURE in fact support ODBC? It doesn't sounds like it's a kind of software that would typically support ODBC. Secondly, if it does support ODBC, then you'd need to obtain the ODBC driver for CCURE and install it on all users' computer where they need to link to CCURE tables.

Here's one problem with the comparison: How do you open a recordset? In order to open a recordset, you have to pass in a SQL statement. Sure, you can just drop in a name of query (which is just SQL), or table (which is of course, just "SELECT * FROM <tablename>;"). In short, there's no...

Sure, you're right that everything has their set of "features" that are anything but a feature. I guess my objection was primarily over the degree rather than actual differences. It's bad enough to give novices a gun. Why insist on giving them knife and a rope, too? ;) Also, to be fair to Pick...

No, more than that. 1) Ability to add new columns to table in datasheet view. (we all know better to not use tables directly and only via forms but when novices see this feature, what do you expect them to think? Give them a button to push and they will push it. This only means more worse...