B busterg New member Local time Today, 17:24 Joined Mar 8, 2002 Messages 6 May 14, 2002 #1 Is it possible to have a command button in a form to output the details of the current record on that form into an excel spreadsheet instead of all of the records in the database?
Is it possible to have a command button in a form to output the details of the current record on that form into an excel spreadsheet instead of all of the records in the database?
C chrismcbride Registered User. Local time Today, 17:24 Joined Sep 7, 2000 Messages 301 May 14, 2002 #2 Sure Use a query that selects the correct values and use it as a property of the TransferSpreadsheet method... HTH Chris
Sure Use a query that selects the correct values and use it as a property of the TransferSpreadsheet method... HTH Chris
P Pat Hartman Super Moderator Staff member Local time Today, 12:24 Joined Feb 19, 2002 Messages 47,635 May 14, 2002 #3 The query needs selection criteria that refers to the currently displayed record. Where YourKeyField = Forms!YourFormName!YourFieldName;
The query needs selection criteria that refers to the currently displayed record. Where YourKeyField = Forms!YourFormName!YourFieldName;
