Yes have change it and use transferdatabase and send email using smtp CDO and problem solved.
Thanks
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Hmmm. Don't know what to tell you. I just did a simple test using Access 2003
> and Northwind, and it insists on sending in Excel 95 format. I even tried using
> acFormatXLSX, and got the same result! The only workaround that comes to mind
> is to use TransferSpreadsheet acSpreadSheetType9, and then use Outlook
> automation to build a message and attach the exported file. Looks like an old
> bug in 2003. Because that version is so old, it won't get fixed. Any chance to
> upgrade to 2007?
>
> 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 ivanleon77
> Sent: Thursday, August 09, 2012 2:11 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] AcformatXLS produce Error
>
> Sorry John, I will leave the entire thread intact,
>
> Yes I have excel 2003 installed on my laptop, BUT
>
> I will run the MDE apps on the pc that only running access 2003 runtime and no
> excel installed.
>
> Thanks
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> >
> > Do you also have Excel 2003 installed?
> >
> > It helps if you leave the entire thread intact - I had to go back to an old
> > message to see your original problem.
> >
> > 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 ivanleon77
> > Sent: Wednesday, August 08, 2012 11:36 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] AcformatXLS produce Error
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> > >
> > > 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.
> >
> > I try to open it from Thunderbird and save as, it shown that have version
> excel
> > 5.0/95. I still want to use docmd.sendobject...acformatxls, how to save it as
> > excel 97-2003 ?
> >
> > Yes I am using AcformatXLS not XLSX and I am using access 2003.
> >
> > Thanks
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar