Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

EXCEL USERFORM IMPORTED INTO ACCESS MODULE/FORM

Posted on 2004-11-30
6
Medium Priority
?
298 Views
Last Modified: 2011-09-20
I have 10 MS Excel forms that I imported into my access module/form. The are userforms from excel, yet, I can bring them up in form view in ms access with the run menu command or the F5 key. However, how do I code a control button on another form to use the "on-click" to open one of these forms?

thanks,
howard
0
Comment
Question by:howcheat
  • 4
  • 2
6 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 12705093
Did you try to use the Button wizard and select the Openform action with the formname of your excel form ?

Nic;o)
0
 

Author Comment

by:howcheat
ID: 12714397
They do not show up under the form wizard!
0
 
LVL 54

Expert Comment

by:nico5038
ID: 12714539
Hmm, interesting. Can you drop a zipped version this "excel.mdb" in my mailbox so I can have a look ?

Nic;o)
(Mail in my profile, click my membername)
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 54

Accepted Solution

by:
nico5038 earned 2000 total points
ID: 12721252
Hmm, took me a while, but the solution is rather simple in first instance as you just need the formname with the Show you also use in the Excel button, e.g.:

frmDamVulnerability.Show

Problem however will be that the references in the code behind the form referring to the Excel cells will be causing errors :-(

Personally I would just recreate the forms in "real" access forms, but first try to develop a descent database model and formflow to get the job done. Don't forget that Access is a real database program and by a good data structure and by using the Access possibilities the application can be as easy (or easier and more flexible) as in Excel.

E.g. you could use a combo to select a certain criterium and after the selection show just the two or three graveties the user can choose.

Nic;o)
0
 

Author Comment

by:howcheat
ID: 12723386
Nico,

Thanks for your assistance. You can't believe how excited I got when that form popped up!! However, I am also listening to your advise about recreation.

thanks again,
howard
0
 
LVL 54

Expert Comment

by:nico5038
ID: 12723792
Glad I could help and your question learned me something new about the Excel form too :-)

Nic;o)
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question