Search results for query: *

On Nov 11, Microsoft pushed out a security update for all versions of MS Access and inadvertently introduced a SERIOUS bug which could affect all current users of Access. This bug will occur for an Update query that: - Updates a single table (i.e. it updates a table, rather than the output of a...

Thanks, All. Not sure how I missed this all these years. "Never too old to learn", eh?

Thanks, Duane Wow - been doing this for 45 years and cannot believe I have not run into this before. Any 'official' explanation / link from, say Microsoft, or any IT group that you know of? Bummed out, but still looking...

Hey, Gang - Have a simple table with a text field which has the following data - sorted ASC: CH2-(Cb,S) CH2(CN)-(C) CH2-(CO,=C) It appears to ignore the dashes. I cannot find any reference to this issue anywhere. Weird. Any Help?

Figured it out ... After 23 other attempts I finally used: lSQLExStr = "EXEC spMyProc '" & lData1 & "', '" & lData2 & "'" DoCmd.OutputTo acOutputStoredProcedure, lSQLExStr, acFormatXLS, MyFileName & ".XLS" Tricky, tricky, tricky... Hope this helps somebody. vbprgmr

I am using Access 2000 and SQL 2000. I want to use a stored procedure (with 2 paramters) as the source for exporting to a spreadsheet. This is similar to a post by GShen thread: 707-496426. GShen found the answer to this, but I cannot get the code to work. It works fine if I use: lSQLExStr =...

Thanks, Mark. I'll give it a try and let you know. I'll be out of town for a few days, but will let you know ASAP. Thanks again! vbprgmr

Need help! I'm looking for the ADO equivalent of the following DAO code (which interrogates the 'Database Properties' collection). Ex: lStr = gfGetDBSProp("Summary","Author") ' Public Function gfGetDBSProp(lpDoc As String, lpPrp As String) As String Dim dbs As Database, cnt...