Solved

Object Title is a Long

Posted on 2003-10-27
5
142 Views
Last Modified: 2010-08-05
I have a Long variable called ImageName that can go anywhere from 0 to infinity. It works with the following code that is designated to make a new image:

Set myImage = FormName.Controls.Add("VB.image", ImageName)

There is one problem though; ImageName must be a string, therefore an error is present if it is a Long. So basically, my question is, how can I do it so ImageName is a long?
0
Comment
Question by:blizzdek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 5

Expert Comment

by:fantasy1001
ID: 9631498
Have you try str(ImageName)?
0
 

Author Comment

by:blizzdek
ID: 9631534
yes I have, but when I write str(imagename) it returns the number but with a space at the beginning, which then makes it an invalid image control name. How can I fix that little space?
0
 
LVL 3

Accepted Solution

by:
pg_india earned 50 total points
ID: 9631575
do trim(str(imagename))
0
 
LVL 3

Expert Comment

by:pg_india
ID: 9631578
or u can use trim(cstr(imagename))
0
 
LVL 5

Expert Comment

by:fantasy1001
ID: 9631639
if there is only leading space at the beginning, then

ltrim(str(imagename))

Cheers
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Exit a vb6 apps when a calling it apps closes 15 63
How to make an ADE file by code? 11 111
VBA - If Bookmark = "XXBOOKMARKXX" then 15 67
Problem to line 23 81
I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

752 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