Solved

User-defined type not defined

Posted on 2009-04-10
6
225 Views
Last Modified: 2012-06-27
Hi,

I am using an Excel file coded with VB. As it is a holiday weekend, I can't get in touch with the person who coded this file, so I am trying to figure this out on my own. I fill in the Excel sheet with the required data, then click on a 'Submit' button. What it's supposed to do is update the database with the Excel data, but instead it opens VB and gives me the user-defined type not defined error. I have seen this in some other posts on here, and have tried to go to Tools > References, but References is grayed out. I also have version 3 of the Soap Library on my workstation, which is what I think the compilation error is referencing. Please see attached. Thanks.
VB-Error.bmp
0
Comment
Question by:tatetryon
  • 4
  • 2
6 Comments
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 24118830
In the VBE make sure you press stop then tools references ought to be enabled and retry to add the reference.

Chris
0
 

Author Comment

by:tatetryon
ID: 24121756
Where do I press stop?
0
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 250 total points
ID: 24121895
See below
vbe1.jpg
vbe2.jpg
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:tatetryon
ID: 24306760
no comment
0
 

Author Comment

by:tatetryon
ID: 24306761
no comment
0
 

Author Comment

by:tatetryon
ID: 24306766
no comment
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now