Search results

The type library must be registered with windows. But not every registered library is listed in the VBA references dialog. The Browse button allows you to select any such references. (They're then added to the references list for that project... while it's selected).

Have you replaced and registered it? Start > Run RegSvr32 "C:\Program Files (x86)\Common Files\System\ado\msado28.tlb" ADO doesn't necessarily use the matching component though. It's described here: http://msmvps.com/blogs/access/archive/2010/07/01/i-ve-never-quite-trusted-ado-because.aspx...

Not to labour this old point - but to address the >> if your programme crashes with any unhandled error, your stored value will clear to a space, or zero That requires a very particular scenario. You'd have to have an application which allows code to be halted. i.e. you'd need to be...

3:25 AM. Yoinks, that sounds like me before I became rubbish (i.e. stopped a substantial intake of caffeine lol). Cheers.

Cool. Fortunately, we can sort by ordinal position too, so the column aliases can be optional too. lstFriends.RowSource = "SELECT * FROM [Text;FMT=Delimited;HDR=No;DATABASE=C:\;].[Friends.txt] Order By 3" Cheers. (Edit: Sorry, hadn't realized there was a sorting requirement... Just...

There's no indication, that I can see, of the version of Access here. If this is 2007 or newer, then you can easily use the TempVars collection. Whenever you want TempVars("MyValue") = varSomething Whenever you subsequently want to retrieve it just reference it varSomething =...

Hi all. A little late to this party I realize. That's the exact format of the file from which you're pulling in values? Can't you just query it? Three column combo with the RowSourceType property back to "Table/Query". SELECT * FROM...

Yep. In this case Win 7 SP1 is not a good bit of news. http://social.msdn.microsoft.com/Forums/en-US/windowsgeneraldevelopmentissues/thread/3a4ce946-effa-4f77-98a6-34f11c6b5a13/?prof=required It's extremely disappointing. Specifically the quote: If you have to re-compile your application on...

Would this be Windows 7 with SP1 installed?

Yep, a variation on Nasa's Apollo mission motto "Ad Luna Scientia". Everything make sense in the exposition?

I agree, ODBC should perform that translation (it's largely why it exists ;-). However it's one reason why many choose to perform boolean/bit selections by comparison against the universally accepted zero for False. Set rsCompany = dbs.OpenRecordset("SELECT * FROM [Company Information] WHERE...

This debate will almost always come down to personal preference and existing practices. (Which people tend to stick to... though evolution is no bad thing usually - I for one enjoy not being an amoeba ;-) At the heart of that site the one line: >> "Developers should always be conscious of...

Rest assured I'd have already offered such information if I was aware of any. But it would require very particualr familiarity with PDF995. (Bear in mind that it is just one way of implementing PDF use from Access - and not even one of the most common.) I used Adobe's object model in the past...

It's impossible to say. If you're sure the file path is correct and all specified in the registry correctly then there's nothing else to be done apparently (except researching on the PDF995 website for changes/updates since that code). The Stephen Leban's option works fairly directly - and has...

And since that PDF is produced, then the device is specified in Software\Microsoft\Windows NT\CurrentVersion\Windows\Device as "PDF995"? If the path and file name are correct and valid (i.e. you paste the exact same value property into the prompt dialog that opens and it works) then I don't...

Ad astra... Scientia? ;-) 1 Is a View the SQL equivalent of a Query? Hmmm... Ish. Queries in a Jet/ACE database encompass both less and more than the functionality of any one server object type.... (What does that gibberish mean?) A view is analogous to a query in Access which includes no...

Have you confirmed that the registry location ("Software\Adobe\PDF995") is being written to with the file name and path that you're passing to the code? (And that the other registry locations exist - given your OS version.)

Sorry, I've not really been involved - but do you have a PDF writing application installed on your users PCs? Acrobat professional of PDFWriter (as that code snippet seems to require) etc? If not then you'll need something distributable. Stephen Lebans provides those in the shape of two DLLs...

Allen Browne? Sure you don't mean Stephen Lebans? :-) http://www.lebans.com/reporttopdf.htm It works well in a vast majority of cases. (Indeed I've only had problems when using it to combine distinct PDFs.) 2007 did indeed require the Addin. 2010 - so lucky... right out of the box. lol...

Yeah, I don't really see any other implementation which is missing. You can use a saved query (conceptually a view), create/alter one at runtime, or use ad hoc SQL wherever it's needed.