Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. #16
    mreniff is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    41
    I keep getting message that "the message you have entered is too short. please lengthen our message to at least 10 characters" I had to remove the to get my response to post




    June7;455045]Are you sure nothing happens? I can't find any *xls files from today.

    I will do this: Set a breakpoint and step debug code.

    What is the listbox RowSource - show SQL statement.


    Code:
    SELECT DISTINCT [Student Flightpath lookup table].FlightPath
    FROM [Student Flightpath lookup table]
    WHERE ((([Student Flightpath lookup table].FlightPath) Is Not Null))
    ORDER BY [Student Flightpath lookup table].FlightPath;


    I keep getting message that "the message you have entered is too short. please lengthen our message to at least 10 characters"

  2. #17
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Are files saved with xls not xlsx extension?

    Why is today relevent?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #18
    mreniff is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    41
    This may be a duplicate response....

    Quote Originally Posted by June7 View Post
    Are you sure nothing happens? I can't find any *xls files from today.

    I will do this: Set a breakpoint and step debug code.

    What is the listbox RowSource - show SQL statement.


    Code:
    SELECT DISTINCT [Student Flightpath lookup table].FlightPath
    FROM [Student Flightpath lookup table]
    WHERE ((([Student Flightpath lookup table].FlightPath) Is Not Null))
    ORDER BY [Student Flightpath lookup table].FlightPath;

  4. #19
    mreniff is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    41
    Are files saved with xls not xlsx extension? The code is saving them with a .xls extension. I will search for .xlsx
    Why is today relevent?: I do not understand this question.

  5. #20
    mreniff is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    41
    Are files saved with xls not xlsx extension? The code is saving them with a .xls extension. There are no xlsx files for today. Now I understand what you meant by "today."

    I was searching for xls files that were saved with today's date.

  6. #21
    mreniff is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    41
    Access only offers to export to .xls filetype not xlsx filetype.

  7. #22
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Using what method?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 04-20-2016, 02:50 PM
  2. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  3. Replies: 1
    Last Post: 07-10-2015, 06:33 AM
  4. Replies: 2
    Last Post: 10-01-2014, 12:38 PM
  5. Replies: 13
    Last Post: 07-27-2011, 12:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums