Rabu, 08 Agustus 2012

RE: [MS_AccessPros] AcformatXLS produce Error

 

Solution 1: Get an iPhone or Galaxy S III <s>

Solution 2: Make sure you're using acFormatXLS and not acFormatXLSX

Try sending the file again to yourself using SendObject, but open the message in
an email program on your computer. Open the attached file to verify the Excel
format. You can do that by doing a Save As from Excel to see what format Excel
thinks the file is. It probably needs to be 97-2003 format to be readable on a
Blackberry.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Mas Shine
Sent: Wednesday, August 08, 2012 9:51 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] AcformatXLS produce Error

I have a command to send query result to email as XLS using
docmd.sendobject, everything is running fine until one day I got a
complain from user that they can't open the xls files from the query at
their blackberry device, I try it myself yes can't open it, blackberry
said unrecognized format.

Then I try to export those query manualy to xls 97-2003 then send it
manualy to email address using Thunderbird and open it at my blackberry
device, THAT file can be openned smoothly.

So I suspect that something wrong with the sendobject command, do I
miss some reference or something ? Please advice.

Thanks

------------------------------------

Yahoo! Groups Links

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar