[AccessD] Excel Data Dump

[Stuart McLachlan]

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
>