473,320 Members | 1,804 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to bring a commond dialog control into my user form?

I'm using excel 2007 vba.

I'm trying to use a commond dialog control in my user form, but it says that I don't have a license for it. Yet I can select it from the additional controls list.

I have a userform from Guido Geurs that I can add the control to, but when I create a new userform on a new worksheet it won't let me. Why will it let me on one but not the other? Any ideas on how I can fix this? From my reasearch I found that installing vb will fix the problem, but I don't have that option with this computer. I don't have vb installed on this computer.

thx
RRR
Feb 8 '11 #1
1 2315
Guido Geurs
767 Expert 512MB
There are different reasons: not registered, ... (see web: google for "vba No license to use this functionality").

Found also this:

There's a bug in VB5's and VB6's that prevents license
information for controls included with VB from getting written into the
Registry if a later version of that control already exists (the bug is since
VB's Setup doesn't install the file it also doesn't write the license
information).

PRB: "License Information for This Component Not Found" Error
http://support.microsoft.com/kb/177799/en-us
Feb 10 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Wanda | last post by:
Hello, I would like to create an interface which allow the user to select files from a ftp site using the common dialog contro. And after some manipulation in the program, the new output file...
3
by: S.W. Rasmussen | last post by:
With the risk of being accused of multi-posting I would like to draw the attention to a serious visual basic/windows issue discussed in the microsoft.public.vb.bugs newsgroup. As pointed out below...
1
by: Dalan | last post by:
Before distributing a database that I have developed, I thought that I would ask the resident gurus a general question regarding Common Dialogs Control. Correct me if I'm wrong, but I have read...
0
by: Wysiwyg | last post by:
I'm writing an application in C# with Visual Studio 2003. I want to put a sql server connection dialog on a form used to configure an application. This is for setting up the connection and saving...
1
by: Henry Lee | last post by:
hi , all This is driving me crazy , I use msgbox method in .net 2.0 environment and it is running fine on my IIS (Windows 2000) until today. The error is like "Showing a modal dialog box or form...
1
by: gazelle04 | last post by:
I've been looking for the Common Dialog Control in Access 2003 but I couldn't find it. Usually you can find it in the Insert - Active X controls menu. Does Access 2003 doesn't use Common Dialog...
2
by: Brad Pears | last post by:
I have some sample code that uses the print dialog, print preview and a print direct options. If I select print preview and then click the printer icon from that, the document prints. If I...
1
by: sirimanna | last post by:
I want to know how can i open some text file data using microsoft common dialog control.6 I know how to save text data using microsoft common dialog control.6 code are here, ...
2
by: maxpirate | last post by:
I have all the cmdlg32.ocx in in my system32 but im not able to add to a design view of a form.it says i don't have the required license But however im able to use an application that has Microsoft...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.