J jetson Registered User. Local time Today, 02:53 Joined Jan 10, 2003 Messages 18 Feb 4, 2003 #1 I'm wondering if it's possible to export an access form into an excel userform?
L llkhoutx Registered User. Local time Today, 02:53 Joined Feb 26, 2001 Messages 4,013 Feb 5, 2003 #2 Look at "Excel Automation." in the Access printed matter resource of your choice and I the Access menu. I think that you'd have to export your data into one sheet and then display it in the manner desired in another.
Look at "Excel Automation." in the Access printed matter resource of your choice and I the Access menu. I think that you'd have to export your data into one sheet and then display it in the manner desired in another.
L llkhoutx Registered User. Local time Today, 02:53 Joined Feb 26, 2001 Messages 4,013 Feb 5, 2003 #3 "Docmd.TransferSpreadsheet" with various arguments will do it. I think that you'd have to export your data into one sheet and then display it in the manner desired in another. Last edited: Feb 5, 2003
"Docmd.TransferSpreadsheet" with various arguments will do it. I think that you'd have to export your data into one sheet and then display it in the manner desired in another.
J jetson Registered User. Local time Today, 02:53 Joined Jan 10, 2003 Messages 18 Feb 5, 2003 #4 Actually, I just want the form - no data. This is an unbound form and I don't want to have to rebuild it in excel!
Actually, I just want the form - no data. This is an unbound form and I don't want to have to rebuild it in excel!
L llkhoutx Registered User. Local time Today, 02:53 Joined Feb 26, 2001 Messages 4,013 Feb 5, 2003 #5 You can't do it.
