Export error occurs on two computers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are currently experiencing an issue on only two computers in our office.
The users are attempting to execute a query that exports a Microsoft Excel
document from Access 2003. When one of the users performs this function they
are only able to export 30 days worth of information. The query prompts the
user for a beginning ate and end date and then exports the data. However the
user is getting the message "cannot expand named range". The other user can
not perform this export function at all and recieves the error. All other
computers in the office do not have any issues performing this export. has
anyone run into this situation or might know what is occuring? Thank you
 
I have not experienced this exact problem, but the first place I would look
would be in the References. Be sure the offending computers have the same
references set and that none are marked *Missing*
 
The references are fine and have the same listing as the rest of the
computers that work correctly. I have looked at the query itself and that
works correctly when executed on it's own. However when the query is
executed with a DoCmd.TransferSpreadsheet acExport, it works for only 30 days
worth of information. The user puts in a beginning date and an ending date.
However when the user enters in more than 30 days it errors out with the
error message that was identified in the first post.
 
Back
Top