|
Hi People
i have a problem with my Excel VBA. i have a worksheet with all my sales data, and another worksheet with customer detail. Where the customer detail do hold a foreign key of the sales data. How am i suppose to search using the foreign key. As i'm trying ti use the customer details to check what did the customer did.
Thanks
Best Regards
Veon Cheng
|
|
|
|
|
Hi,
Im relatively new to this! So hello to everyone here  .
I have been writing this code to allow combo boxes to dynamically create other combo boxes within the form, and then those ones to create comboboxes from themselves also. If this is a bit confusing here is the code I have been working on
Private Sub ComboBox1_Change()
Set optionComboBox = Me.controls.Add("Forms.ComboBox.1", newComboname)
With optionComboBox
.Text = "Please Select an option..."
.left = 100
.width = 290
.top = 125
While Not (IsEmpty(Range("'Info'!a" & Counter)))
Y = Range("'Info'!a" & Counter).Value
If InStr(1, Y, "DM|") > 0 Then
If InStr(1, Y, "DM|SH|") = 1 Then
Else
optionComboBox.AddItem (Range("'Info'!b" & Counter).Value)
End If
End If
Counter = Counter + 1
optionComboBox.SetFocus
Wend
End With
And the problem I am having is that I cannot reference something in VB that has not yet been created.
E.g. I wish to do something like this
Private Sub newComboname_Change()
While Not optionComboBox.Text = "Please Select an option..."
Set optionComboBox = Me.controls.Add("Forms.ComboBox.1", "ComboBox" & ComboboxNumber)
With optionComboBox
.left = 100
.width = 290
.top = 165
While Not (IsEmpty(Range("'Info'!a" & Counter)))
Y = Range("'Info'!a" & Counter).Value
If InStr(1, Y, "DM|") > 0 Then
If InStr(1, Y, "DM|SH|") = 1 Then
Else
optionComboBox.AddItem (Range("'Info'!b" & Counter).Value)
End If
End If
Counter = Counter + 1
optionComboBox.SetFocus
Wend
End With
Wend
End Sub
newComboname being the new combo box that was created on the Combobox1_change event.
Is there a way to reference this in a Sub? Or any other way will do really!
Any help would be appreciated!!
modified on Monday, November 16, 2009 11:22 PM
|
|
|
|
|
This looks really really messy to me. Where did this code come from ? Does it even create comboboxes ? What is the issue ?
Blake Dickson wrote: While Not optionComboBox.Text = "Please Select an option..." Set optionComboBox = Me.controls.Add("Forms.ComboBox.1", "ComboBox" & ComboboxNumber)
This is the issue ? I think you need to rework your logic entirely. Why do you need a while loop ? Does VB support do... while loops ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
The code is working no problems.
I just need to know how to reference something that is created as part of the post-process.
The example code could just be
Private sub UserForm_Initialize
Me.controls.Add("Forms.ComboBox.1","Combobox" & Randomnumber)
End Sub
Private sub (Combobox + Randomnumber)_change()
Do something
Because the combobox name is not pre-defined, i cant just make a sub for it with _change() at the back of it.
|
|
|
|
|
Why would you need to ? You can use an anonymous method, or you can write a common method that all the comboboxes call when they change.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Not with that VB6 code he's using...
|
|
|
|
|
So am I to believe that I cannot do this?
|
|
|
|
|
Oh, I didn't say that.
Two things. First, unless you say otherwise, everyone will assume you're using VB.NET. The code you get to a VB.NET project to do anything like this will never work in VB6.
Second, I don't support anyone/anything using VB6. Though, there may be other people around here who do.
|
|
|
|
|
hi there,
I am trying to create a chart in crystal report (VS 2005) and want to show mmm-yy in group axis. But the issue is that if i use date (ordered on change of every month) it shows mm-yyyy and if i use a formatted string formula it is sorted alphabetically while I want it to sort in correct month order. Please advise
Salman Sheikh
|
|
|
|
|
IIRC we used to include the additional field used for sorting in the result set from the stored proc, I think CR lets you set up 1 field for display and another for sorting. CR charts are crap, we went to reporting services so we could integrate Dundas Charts.
|
|
|
|
|
Solved it, In data section of chart expert, click on the group, click on order, select "In Original Order" from the dropdown and order the query in required order or use the group column in crystal report sort expert.
Salman Sheikh
|
|
|
|
|
I have a small project where I have a single array of names followed by phone numbers. I need to load the names into a combo box. Which I can do until I get to the end of the array where the next index is invalid. How can I test and stop the lookup?
|
|
|
|
|
You can use a loop? Arrays are 0 indexed and you can get the count by doing array.Count - 1
so you can do
Public sub ttt()
Dim array(10) As Integer
For index As Integer = 0 To array.Count - 1
Next
End Sub
If this doesn't answer your question then I have no idea what the hell you're talking about.
|
|
|
|
|
I believe it is Length and not Count
|
|
|
|
|
if you allocate a large array and then fill some of it with meaningful elements, leaving the remainder untouched, then arrays are not the best choice, you should use a generic List instead. Then you can iterate its content with a simple For Each
If all this is unfamiliar, you should look it up (Google) or better yet read an introductory book on VB.NET
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
Hi All
I am in fix of displaying the result of google search in VB(not in vb.net)
Is this possible to search any thing in google search using VB and displaying on the form using custom design.
Many many thanks in advance..
|
|
|
|
|
This would be a great time to upgrade to vb.net, as VB6 is a dead, non-supported language.
|
|
|
|
|
|
MY Support Statement:
VB6 Runtime: Not supported
Visual Studio 6: Not supported
Visual Basic 6 IDE: Not supported
* on ANY Windows platform
|
|
|
|
|
I would concur with your support statement.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Dave Kreskowiak wrote: MY Support Statement:
There's a small difference there between you and me: you're a well-known name and can make demands based upon reputation and past work experience.
I'd go with what the customer wants, and with the tools that are available. Anyway, I wouldn't be too surprised to find the VB6 runtime on Weven-machines in the next couple o' years.
I posted a link to the support-statement because VB6 questions are invariably answered in the same way, and that answer just isn't completely accurate. One cannot get support for VB6 from Microsoft, but the Operating System will support it. That might be an important factor if you had to decide whether to (let someone) rewrite a large application.
Dim I As Troll 
|
|
|
|
|
Eddy Vluggen wrote: There's a small difference there between you and me: you're a well-known name and can make demands based upon reputation and past work experience.
Not quite. I keep demanding the demise of VB6 but it just won't die, no matter how many stakes you drive through its heart!
I just refuse to support anyone asking questions while they still use VB6. If we keep supporting it in the community, people and companies will just keep using it.
|
|
|
|
|
Dave Kreskowiak wrote: If we keep supporting it in the community, people and companies will just keep using it.
If this were the official CP stance, it would make sense to add a sentence to this effect on the top of this forum.
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
Essentially, the issue as I understand it, is people in the third world whose PCs won't run .NET. Beyond that, there is no good reason for using VB6, I agree with Dave. But the site is surely not going to lock anyone out, although the absence of a VB6 forum when they are different languages suggests that there's no expectation that VB6 will need get a lot of use, going forward.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
OK, seems fair. So we probably keep things as they are (I don't expect Chris to split a forum, it is hard), and we continue to answer questions, i.e. those who can remember how things got done (or not) in VB.
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
