Windows Registry Settings

[philcon]

In MSACCESS I wrote some code which exports the results of a query to a spreadsheet.

However when I ran the application on someone elses PC the following error message came up.

"The formats that enable you to output data as MSExcel,rtf,MSDOS, or HTML, are missing from the registry."

However, when I selected the query and used saveAS from the filemenu, I was able to export as a spreadsheet.

Any ideas would be greatly appreciated.



Philcon

 

[Shortie]

For Access 97 check the following Reg Keys:-

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Report

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Clipboard Formats

Post the code up you are using, let's take a look.

 

[philcon]

Hi Shortie,

The code is as below. (By the way thanks for your response to the dynamic export filenames, I managed to understand it and alter it to suit my needs))

I just had the thought that perhaps I am exporting to a newer version of excel than any stored in the windows registry. (I'm using office XP (saving the database as ACCESS2K) whilst the system I copied the application to was windows/access 2000).

However, when I was at the site at the tail end of last week, something even more bizarre happened.

The application runs an update query to datestamp the records which are exported. When this element was run it came up with an error saying the date() function was not defined.

I am now totally confused with the users setup and am wondering if there is some conflict (VB or otherwise) between Office 2000 and Office XP(saving databases as A2K).

Oh well the following code incorporates the export element I initially mentioned. Hope you can shed some light.

Regards


Philcon


DoCmd.SetWarnings False
DoCmd.OpenQuery "signoffupdate"
DoCmd.CopyObject "", strqryname, acQuery, "sendmail"
DoCmd.SendObject acSendQuery, strqryname, "MicrosoftExcelBiff8(*.xls)", "philip@directtechnique.com", "", "", "DTGBBF New Brief", "", False, ""
DoCmd.DeleteObject acQuery, strqryname
DoCmd.Close
DoCmd.OpenForm "f_main menu"
Exit_Command7_Click:

 

[KellyK]

Philcon,
Were you ever able to fix your problem? I've gotten the same error in my code as well. I checked the registry settings that Shortie mentioned and they look fine. Where does the .dll file need to be? I'm a decent Access developer but I'm really lacking knowledge of Windows in general. Any help is appreciated!
Thanks, Kelly

 

[philcon]

Kelly, yes,

what I did was change the code ....Biff8.... to Biff5, as it was written in the registry setting on the clients machine.

My machine was geared up for XP exports, but his was not so had to change the code to Biff5 or something which worked on both machines.

Hope this helps