Can i use an Excel Userform in Acces?

[Botje]

Hey there,

Can i use an Excel Userform in Acces?

I made an userform in excel. That pops-up when you start-up excel. Then you need to fill in it and the date will be transfered to a 2nd Sheet.
But it is not possible for 2 people at the same time to fill in this form and save it without have errors.

So I want to export my file to Acces, then let people fill it in in access then access should proces the information that has been filled it.

And I should (right?) not have the multiple-user problem.

Thanks for your response in advance.

 

[Norie]

No.

 

[Botje]

No.

Thanks for the short and clear response

Is it wise to use a word document as "userform".. then let people send the form to me so i can import it into access?

( I have tried with Excel but thats just way above my knowledge. )

 

[SydneyGeek]

You *can* have a Userform that interacts with an Access database. The advantage is that users don't need Access installed on their PCs. Disadvantages include:
There is a reasonable amount of code involved
Excel is *not* designed to be a multiuser environment so you will probably still have issues

You'd be better off creating a database, building a form or forms for your users, and letting them use that for their data entry. If you want to use Excel forr analysis there are several ways that you can get the data from Access to Excel.

Denis

 

[Norie]

Denis

Can you really import a useform into Access?

I've never seen that done.

Mind you I've never tried it either.

 

[SydneyGeek]

Norie

I was talking more about using ADO to connect Excel to Access. You can have a Userform as the interface in Excel.

That being said, I did read an article on vba123.com about designing an Excel-style Userform in Access. Can't remember the context but there was a perceived advantage to doing it.

Given how easy it is to build a form in Access compared to a Userform in Excel my preference is always to go the Access route.

Denis

 

[pedie]

hi Norie, hi Denis....
I really haven't tried this myself..and really don't see need for it but someone once told me that we can import Excel Userform into Access mdb as use it...

 

[Norie]

Pedie

Where did you see that?

How was the form imported?

 

[pedie]

Pedie

Where did you see that?

How was the form imported?

I really havent tried this myself, I just heard from one of the developer @work.
But I have seen the form [exactly an excel form....].
The way to import?
Right click on any form in VBA editor >> import file >> select the excel form *.frm that was previously exported from excel...


I think i'll just try it out....

 

[RoryA]

Good luck - userforms are not the same as Access forms.