Search results

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

FWIW, addressing only the point of pivottable: Access allows you to create a PivotTable Form so it's not strictly required that you have to leave Access if you want to have pivottable view. However, it's non-updatable but when I had a complex display requirement, I did indeed use a PivotTable...

Well, unfortunately, new features ≠ desirable features. I think 2007 had more undesirables than desirables, IMHO.

I do work for clients and therefore have to have multiple versions. However, I simply refuse to install them side by side. I have several virtual machines for different combinations of OS & Office version (as well few other programs) so I never have to install them side by side. IMHO, side by...

Geez, that's a big leap there. I am not the best person to answer this because I started on Access 2003 (though I used 2000 file format for long while since it was the default) and I know that Access 97 is on Jet 3.5 whereas 2000-2003 are Jet 4.0 while 2007 is ACE 12.0 and 2010 is ACE 14.0. In...

I'm for 2003. I actually prefer 2010 over 2003 but 2007 is definitely the "Access 95", IMHO and is too much quirky for its own good and really doesn't have any "must-have" features unlike 2010. So if you can't go directly to 2010, stick with 2003.

I'm going to make a wild guess here and assume that Windows 7 is 64-bit: What does the path the register.bat uses to look up the controls? If it's going in C:\Windows\System32\, then that is incorrect for a 64-bit OS. You should be using instead C:\Windows\SysWOW64\ to look up 32-bit DLLs. When...

Have a look at this post.

I think what it is basically doing is that it's acting as a simple frame into the Sticky Note application and not directly exposing the Sticky Note as a document. You'd have to look into its object model to see if it exposes any COM automation so you can then manipulate the final appearance.

Never had to work with touchscreens before, I'd have to find out how they function as an input device. I'm tempted to assume they function similarly to a mouse and if that is the case, then you need to have some kind of drawing program to take it in as a brush stroke. Obviously some applications...

Technically, MySQL questions shouldn't be in SQL Server forum - I think we have a MySQL forum somewhere (should be "PHP, Perl & MySQL" or at least under the web development)

Hmm, for some reason, it's on the top when it used to be on the bottom. If you scroll down, you'll see the edit screen underneath the "Delete this Post?" section.