ActiveX control error

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

Guest

Hello,

I need to create a form that houses an excel spreadsheet and would like to
use the Active X control. I have created the form and input the ActiveX
Spreadsheet control, but when I double click the form to maintain the
spreadsheet data I get the following error:

"Microsoft Access
A problem has occurred whilst Microsoft Access was communicating with the
OLE server or Active X Control"

Could you please help me overcome this... I have looked in the add ins and
it seems to allow active x controls....

thanks,
K
 
KurviousKoala said:
Hello,

I need to create a form that houses an excel spreadsheet
Click to expand...

I can't for the life of me imagine why you would want to do this. Can you
expand on what your goal is? I think there may well be a simpler solution.

Keith.
www.keithwilby.com
 
i need to 'pop-up' form that contains a table 130 rows by 3 columns

when i attempt to embed an excel 2000 object, several rows are cut off the
end - i'm not sure what else to use....
 
KurviousKoala said:
i need to 'pop-up' form that contains a table 130 rows by 3 columns

when i attempt to embed an excel 2000 object, several rows are cut off the
end - i'm not sure what else to use....
Click to expand...

Import your data into an Access table.
 
I have created a form to display the information i need and have set the
default view to datasheet to create the appropriate list, however:
- when I use showform in vba, the form loads in 'form' view not datasheet -
I have set the views allowed to datasheet (not both)
- I cannot get the header to display - I have checked the header is the
form header and not the print header.

... is this normal?!?

Thanks for your help
 
KurviousKoala said:
I have created a form to display the information i need and have set the
default view to datasheet to create the appropriate list, however:
- when I use showform in vba, the form loads in 'form' view not
datasheet -
Click to expand...

What code are you using? You should be using "acFormDS" in the View
argument in the OpenForm method.

Regards,
Keith.
www.keithwilby.com
 
Fabulous.... it's now working!!!! thx

Private Sub cmdActivity_Click()
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "InitiativeActivity"
DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria

Exit_cmdActivity_Click:
Exit Sub

Err_cmdActivity_Click:
MsgBox Err.Description
Resume Exit_cmdActivity_Click


End Sub
 
Back
Top