[AccessD] Excel Data Dump

[Rocky Smolin]

(Oops - sent to the wrong thread)

Solved!  The problem was a corrupted record in the Tenant table. Three
fields had #Error in them and could not be modified.  So I deleted the
record and the code worked as planned.  I'll have to advise the client to
delete and re-enter that record.

Thanks all for your help and suggestions.

r

On Wed, Mar 30, 2022 at 10:33 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Are you sure that ""qryProperty_Tenant_Data_Dump" exists?
>
> On 30 Mar 2022 at 22:20, Rocky Smolin wrote:
>
> > I have another simple export to excel filtered by the property that's
> > being displayed.  No problem with the date format.  But I eliminated
> > the date format from the file name.  Still craps out.
> >
> > I've had this problem before referencing a query in a transfer
> > spreadsheet command, and worked around it by substituting the SQL
> > string itself.  This time, there's too many fields to accommodate the
> > SQL in a string.
> >
> > brst,
> >
> > r
> >
> > Thanks
> >
> > r
> >
> > On Wed, Mar 30, 2022 at 10:02 PM Stuart McLachlan
> > <stuart at lexacorp.com.pg> wrote:
> >
> > > am/pm and AM?PM force the time to be displayed as 12 hour times.
> > >
> > > HH says to use leading zeros,
> > >
> > > so 2:00 pm (14:00) would display as
> > >
> > > 03-31-22 02_52_00 PM
> > > Personally, I always use ISO8601 instead of region specific formats.
> > >  That way, files sort correctly by date and you don't get
> > > potentially problematic spaces in file names.
> > >
> > > I'd use:strDT = Format(Now, "YYYYMMDDTHHMMSS") & ".xls"
> > >
> > >
> > > On 31 Mar 2022 at 3:28, Paul Hartland via AccessD wrote:
> > >
> > > > Hi Rocky,
> > > >
> > > > Just an idea what does strfilename produce, you have the datetime
> > > > format to show am/pm yet the hours are 24 hour when using capital
> > > > HH so not really required anyway, but apart from that when the
> > > > debug passes strfikename have you looked at it ?
> > > >
> > > > strDT = Format(Now, "MM-DD-YY HH_MM_SS AM/PM") & ".xls"
> > > >     strFileName = gstrFrontEndPath & "Property_Tenant_Data_Dump_"
> > > >     & strDT
> > > >
> > > > Paul
> > > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>