Search results

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.

Just to answer dfenton's question - basic SharePoint edition (which is free with any Windows Server product, IIUIC) supports the capability to synchronize data. I believe the ability to synchronize Access objects does require more expensive version but I've not found the ability to synchronize...

Correct. I tend to prefer using implicit evaluation for where I expect a boolean evaluation because it more closely resemble the behavior of other languages and thus is useful for cases where we may not get the expected True value. For example, if you call an API that returns (in theory) a...

It's termed "Conditional Compilation" which basically allow you to write different code and select one of them for different use. If you google, several people wisely suggest that one use late binding for maximum compatibility when using other libraries especially when you distribute Access...

Yes, if the project wasn't written for SQL backend in mind from start.

Right. With first two cases, Jet is smart enough to first evaluate them and translate them into a hard constant and send the query as such. With last case, nothing Jet can do about it but just suck it up and evaluate each row one at a time. BTW, just to be explicit - this isn't just true for...

Well, if the function does something like this: WHERE myFunc() = True; or WHERE myCol = myFunc(); Then Jet can optimize it away. The real trouble come in this: WHERE myFunc(myCol)=True; This require re-evaluation of function for every row, and thus cannot be optimized away so Jet has no...

Here's what I do when I need to hook into Outlook and create Outlook if it's not already running: In its own module: Option Compare Database Option Explicit #Const EarlyBind = 1 'Set to 0 & remove reference before distributing! #If EarlyBind Then Public Function GetOutlook() As...

As SQL_Hell alluded, SQL Server is your backend now. In Access, you had two files, one front-end and one back-end. You enforced RI in Access back-end. You replace the Access back-end with SQL Server... but RI still stays in the SQL Server. Access front-end (or indeed, ANY front-end clients)...

Be careful about which backend you're doing this with. Giving 0 to MySQL will return the incremented value, IIRC. I would be wary toward messing with the autoincrementing behavior because this is one of least portable aspect of SQL.