MS Access "Forms" in Excel?

  • Thread starter Thread starter (PeteCresswell)
  • Start date Start date
P

(PeteCresswell)

Unencumbered by any real knowledge, I see them as just another
kind of object.

Any chance they can be incorporated into an MS Excel workbook?
 
Pete:

While viewing the form, try an Edit>>Select All>>Copy
if it's available and then Paste into a blank worksheet in
Excel.

It may result in nothing but junk, but I am always amazed at
what can happen between apps when you try this.
 
Pete,

What are you attempting to do? Is it to copy all the data that the MS Access
form contains, or are you trying to copy the Access form to use within
Excel.

If you're just trying to copy the data from the MS Access table -- or the
Access query on which the form is built -- just open the Ms Access table or
query in datasheet view, click on Edit | Select All (or CTRL A), Edit | Copy
(or CTRL C). Then open Excel and go to a blank Excel Workbook, click in Cell
A1 and then Edit | Paste (or CTRL V).

The contents of the Access table or query will paste into the Excel
workbook.

Alan
 
Per Alan:
What are you attempting to do? Is it to copy all the data that the MS Access
form contains, or are you trying to copy the Access form to use within
Click to expand...

The second. Excel forms look limited in functionality and
difficult to use to me - coming from MS Access development.
 
I agree with you about the forms in Excel being (and looking) limited
compared to forms in MS Access. I was an Access developer until I retired
last year.

I suppose if Excel had all the features and functionality of MS Access,
there wouldn't need to be Access. :>

Alan
 
Back
Top