Visual Basic :: Help Needed In Calander Control 9.0 In Userform.

Timer/calander Control Problem
Ok, I don't understand why this doesn't work. I know every single person on this forum will, but It's not clicking for me.

I'm going to post two scenarios here.. one that works, and one that doesn't. I don't see how they are different, except for the fact that I'm using the timer control in the one that doesn't work, and I must be using it wrong. But the timer is so simple, i don't understand how even I can screw it up...

Code:
Private Sub Form_Load()
Dim DtDate As Date
dtDate = Date

Calendar1 = Date

This shows the calendar control with the correct date, everything is wonderful.

Now, I throw a Timer into the mix to keep checking the date so if the user is using the application before and after midnight, it will change the calendar during runtime. Maybe that is where my problem is?? Maybe that control can't be changed during runtime? I can't find much information about the calendar control, so I don't know. Is there something wrong with my logic ?

Code:
Private Sub Form_Load()
Dim DtDate As Date

Timer1.Enabled = True

End Sub

Private Sub Timer1_Timer()

Timer1.Interval = 1
DtDate = Date
Calendar1 = dtDate

End Sub

Error To Use Calander Control In Window XP, Development In Using VB 5.0
My Development Environment is as Below
OS : WIN 95/ WIN 2000
Development Tool : VB 5.0
Application Setup Programme (For Installation) : Toolkit Setup given with VB 5.0

When I install my application in WIN 95 or Window 2000 it work ok but when install in Window XP, Application work properly in but when I try to use calander control graphically it will not show properly and some time generate error but same application work in other OS properly.
To Soleve above problem I do remove calander control Window XP and also Remove refrence from Registry then install my application Now it works fine with same calander control. (In XP system higher version control make problem for me)

Is there any way to solve this problem ?
Is there any way without remove higher version of calander control from window XP system ?

Error To Use Calander Control In Window XP, Development In Using VB 5.0 And 6.0
My Development Environment is as Below
OS : WIN 95/ WIN 2000
Development Tool : VB 5.0
Application Setup Programme (For Installation) : Toolkit Setup given with VB 5.0

When I install my application in WIN 95 or Window 2000 it work ok but when install in Window XP, Application work properly in but when I try to use calander control graphically it will not show properly and some time generate error but same application work in other OS properly.
To Soleve above problem I do remove calander control Window XP and also Remove refrence from Registry then install my application Now it works fine with same calander control. (In XP system higher version control make problem for me)

Is there any way to solve this problem ?
Is there any way without remove higher version of calander control from window XP system ?

Help Needed Changing UserForm Code
Hello everyone, thanks in advance for viewing my question..
I have a User form, and data from it goes to just one sheet.
I need the data to actually go to separate sheets, named after each Customer in my cboCustomer list.

Here's a part of the code that states what sheet to go to,
and it's one of the parts that I need help changing so that it works the way I need it to._________________
Private Sub cmdOK_Click()
Dim rw As Range, wsData As Worksheet
Set wsData = ActiveWorkbook.Worksheets("Data")
Set rw = wsData.Cells(65536, 1).End(xlUp).Offset(1, 0).EntireRow
With rw
.Cells(1, 1) = Date
.Cells(1, 2) = cboCustomer.Value
.Cells(1, 3) = txtOrder.Value
-------- cut------------

Here's a part of the code that is the Initialize event.________
Private Sub UserForm_Initialize()
With cboCustomer
.AddItem "Orion"
.AddItem "Hathaway"
--------cut-----------

If someone would be willing to help me rewrite these so that when the combobox for Customer is clicked, that all information in the User Form goes to that Customer's sheet, I'd dearly appreciate it!
Thanks in advance,
Pem

Userform Control
I am trying to control a userforms properties based on worksheet settings. Form currently hides/shows columns based on checkbox input. At the same time, a text box is displayed in form indicating checkbox status. Is there a way to cause form to display current status of worksheet in the userform when it loads? or store the settings when last closed? Thank you in advance for your time.
Code for the Checkbox currently is:

Private Sub CheckBox1_Change()
With Me

If .CheckBox1.Value = True Then
TextBox1.Visible = True
Range("B1").Select
Selection.EntireColumn.Hidden = False
Else
TextBox1.Visible = False
Range("B1").Select
Selection.EntireColumn.Hidden = True
End If
End With

End Sub

Listbox Control In A Userform
Hello,

In a userform i have 7 listboxes. 5 of them i want to be filled with data on initialize of the userform. With ADO recordset i want to fill each listbox.

What i could do is write 5 procedure to fill each listbox. Is there a way to write only one procedure to fill 5 (or more) listboxes.

There is sometthing like

Code:
userForm.Controls.Item(i).AddItem result.Fields(0)
How do i know which "i" is the listbox i want to fill

Thanx in advance

Is There An Arrow Control To Use On Userform
I need to create an arrow on a userform. Is there an arrow control?

HEH Calander
OK next question new thread..... im using the vb calander component ......... i have it now so that if a date is clicked it brings up frmdates.... on frmdates they are able to put there daily tasks or what ever they feel like is there a way to save that text to that day so that if they click on that day it comes up again with that text?

Can't Access Code For Control On Userform
In an vba project i can't get to the code of a control added to a userform created a couple days ago. I can add a control but, when i double click on the new control I can't get into the private sub to write code for it. (I can get to the code of the controls that were created the same time the userform was.) I feel so stupid!! I can't figure this out, I've seached everywhere. Someone please help me!!!!

Date Control Userform Formatting
Hi,

I am having trouble getting the date to format in a textbox on a user form. The date ideally will be formatted as dd/mmm/yyyy with dots sepearting instead of the /'s.

I have tried the following as code to adjust the formatting and it doesn't recognise any including .numberformat

Me.txtdate.Value = Format(txtdate.Text, "dd/mmm/yyyy")

Me.txtdate.NumberFormat(txtdate.Text, "dd/mmm/yyyy")
but numberformat doesnt spring up as an option

txtdate.NumberFormat = "dd/mmm/yyyy"

I always get the number not date format. Eg.

2-may-2005 will show as 38474

I also need it to insert to the textbox that the cursor was last focused in. Instead I seem to have one textbox tied to the control.

I am using code like this to print the value selected on the control

txtdate.Value = CDbl(Calendar1.Value)

How would I change it to add the date to the last textbox with focus?

Thanks
Rob

Using A Spreadsheet Control In An Excel Userform
Hi

Can someone help me? I want to use a spreadsheet control in an Excel userform and I want to load into it the data I have in one of the sheets in the same file where I am creating the userform. Is it posible? How? Thanks.

Check If Mouse Over Control On Another Userform?
Attached is my code which for the life of me, I can't get to work. I'm trying to detect if the mouse is over the command button on Form1 with code in Form2, but the mouse co-ords are no where near the command buttons co-ords and I can't figger out why!

Thanks.

|
+--JDMils
|
+--VB6
+--VB Dot Net
|
+-- Navman GPS Forums @ http://forum.jdmils.com
|

Count Control Objects In UserForm
Hi,

How do you cound how many TextBox in the UserForm?

I try the VB code
Code:For Each TxBoxObj In TheUserForm
It gives me error...

Is there another way to do such thing?

Userform Commandbutton Color Control
I have stumbled over how to change the colour of the userform command buttons within VBA (see below), but is there some defined structure as to the colour assignments? I managed to find a range of colours, but cannot seem to make a logic pattern from them. Any ideas guys?

Code:Private Sub CommandButton1_Click()
   With UserForm1
         .cb1.BackColor = &HFFA080
         .cb2.BackColor = &HFFA8C0
         .cb3.BackColor = &HFFC000
         .cb4.BackColor = &HFFD000
         .cb5.BackColor = &HFF0000
      .Show
   End With
End Sub

Weekly Calander
Well, I did a little searching around.... what I'm after is a weekly calander based on either Now or other user input.

So therefore, An array of 7 labels that will have from sunday to saturday with dates for either the current week (now) or any other date the user enters.

I have been looking at DateDiff and DateAdd etc... just wondered before I re-invent the wheel if I should be using some kind of control for this?

any ideas would be much appreciated.

Thanks

Max.

Import Into A Calander
I am a little rusty in VB 6.0 but I am getting back into it
and I am trying to create a calader project. I will not be
using VB's calander. I created my own calander with 31 labels
boxes in an array . What I am trying to do is, I am tring to
import a file, txt would be fine and the data will be populated
into each date. Each date will have 4-5 events
Example
8/1 John 8:30, Mary 10:30, Alice 10:30, etc
8/2 Mary 4:30, Bill 6:00, Larry 1:00, etc.

This list will continue for the entire month. Once the events
are added they will be printed on paper. Any ideas or help
will be greatly appreciated thank you

A Reminder Using A Calander
Hi
Can anyone help me with the syntext needed to use the calander.
i Want to write code for the following.
On the form I need the calander , button and inputbox.
I want to fill in a date and on that date a message box pops up to remind me of certain appointment. In effect a electronic diary.
Thanks in advance
Rob

Calander Program
<VB noob here

Im trying to make a calander-ish program

but i suck.

I need it to look like this.

[text box-month][text box-day][text box-year]
[command button]
[textbox-day of the week]

What I need it to do is you can enter any date(9-12-1988, 10-23-1623) and it will tell you what day of the week it is(wednesday, Tuesday, ect)

So if you put in 9 12 2004, it will say Sunday when you click the command button.

thanks

Calander Problems
I am having problems with the microsoft vb calander. I can add the component to the tool bar but when i try to add it to a form the program crashes with out any reason. I as well currently have a vb program that has a calander on it that i did at school(where it works fine) and i can open the form and even run it but as soon as i click on it, it crashes. Im not sure if their is a confilict with another program or maybe a reference that i need to make with in vb. Not sure....... Any Answers

Permission Denied On Spreadsheet Control In Userform?
Hello,

I have a userform with a Chartspace 11.0 control (chRevenuesChart) and a Spreadsheet 11.0 control (shRevenues). I want the chart control to use the data from the spreadsheet control, which is hidden.

I'm using this code:

Code:
chRevenuesChart.Charts.Add
chRevenuesChart.DataSource = shRevenues
When I run it, I get an error on the second line: "Run time error 70, Permission Denied".

I've doublechecked the name of the spreadhsheet control, and it's shRevenues. I'm not sure if this is relevant, but I just installed the MS Office Web Components controls, because I used to run this program in MS Office 2000, and I'm now I'd like to get it working in Excel 2003. I used to have 9.0 controls in the userform, but they wouldn't open in Excel 2003 so I installed the Web Components update and then added in the new 11.0 controls to the userform.

Thanks for any suggestions,
Rina

Store UserForm Control Information To Different Sheet
What is the code to store the informations from a UserForm Control into a sheet (different from the one that I have the macro working)?

Thank you.

Microsoft Standard Calander
I am in a class called EAST lab in school. I am doing a project that records journal entries for the day. I have a calander control and a rich text box. I need to know how to let the users click on the date and a command button and have the program save the entry with a file name that corresponds to their user name across the network and the date of the entry. Also I will need to access the files from a different program. I am very new at this so I probably sound stupid. If you can help or just want to call me stupid go ahead.

Month's Calander In Vb6 Code
month's calander in vb6 code ...?

Pause Vba Userform, Manual Intput In Excel And Then Again With The Userform ??
hello you all, It's me again

I have had many probs, but the most are gone now, thx to you guys.

Next problem is this:

I use userforms to collect data from files and also user entries.
After a while the user should be able to enter some data manualy in the sheet, but the userform should be still active, because there are some global and other values i would like to keep.

Is it possible??

I would like to put some pause button in vba-userform and on the sheet a button to continue.

Thx 4 the help

Handling Parent Userform Events From Within VB 6.0 ActiveX Control
Hi there I have a slightly unusual requirement.

I have an ActiveX control coded in VB 6.0. The control needs to be capable of being sited within VB 6.0 Forms and Microsoft Office Userforms as well. I have disabled the close button when the control is running a method within a VB Form, but have not been able to do the same when the control is sited on a Userform.

The problem is that using my approach I need to declare a variable of the type of the parent object (which is a Userform in the case of Excel) using a Dim WithEvents statement so that I can handle the close button press event via a
Private Sub VARIABLE-NAME_QueryUnload(Cancel As Integer, UnloadMode As Integer) event handler. As stated in Excel the parent is of type Userform and I cannot declare a variable of this type within VB 6.0.

Is this impossible and can I do this a much simpler way (my humble apologies if this is as I expect the case). My existing code which works fine for Parent VB Forms is shown below:

Code:
Dim cancelObj As Object
Dim WithEvents cancelForm As Form

Private Sub UserControl_Show()
    Set cancelObj = UserControl.Extender.Parent
    ' MsgBox " Parent Type is " & TypeName(cancelObj)
             If TypeOf cancelObj Is Form Then
                If UserControl.Ambient.UserMode = True Then
                        Set cancelObj = Nothing
                        Set cancelForm = Parent
                End If
                MsgBox ("Interface Control sited on a form! " & Parent.Name)
        Else 'parent not of type Form
                If UserControl.Ambient.UserMode = True Then
                        Set cancelObj = Nothing
                        'Set cancelForm = Parent 'type mismatch
                End If
                MsgBox ("Warning Interface Control not sited on a form!")
       End If
End Sub

Private Sub cancelform_QueryUnload(Cancel As Integer, UnloadMode As Integer)
        ' Parent Form window close event captured!
        Dim Msg As String
        If UnloadMode = 0 Then
                If m_MethodRunning = 1 Then
                        Msg = "You can't close this form at this time"
                        If MsgBox(Msg, vbOKOnly, cancelForm.Caption) = vbOK Then
                            Cancel = 1
                        End If
               Else
            Set cancelObj = Nothing
                        Set cancelForm = Nothing
            ' safe shutdown code here
                End If
        End If
End Sub

Thankyou for any time that you can spare.

Handling Parent Userform Events Within VB 6.0 ActiveX Control
Hi there I have a slightly unusual requirement.

I have an ActiveX control coded in VB 6.0. The control needs to be capable of being sited within VB 6.0 Forms and Microsoft Office Userforms as well. I have disabled the close button when the control is running a method within a VB Form, but have not been able to do the same when the control is sited on a Userform.

The problem is that using my approach I need to declare a variable of the type of the parent object (which is a Userform in the case of Excel) using a Dim WithEvents statement so that I can handle the close button press event via a
Private Sub VARIABLE-NAME_QueryUnload(Cancel As Integer, UnloadMode As Integer) event handler. As stated in Excel the parent is of type Userform and I cannot declare a variable of this type within VB 6.0.

Is this impossible and can I do this a much simpler way (my humble apologies if this is as I expect the case). My existing code which works fine for Parent VB Forms is shown below:

Code:

Dim cancelObj As Object
Dim WithEvents cancelForm As Form

Private Sub UserControl_Show()
Set cancelObj = UserControl.Extender.Parent
' MsgBox " Parent Type is " & TypeName(cancelObj)
If TypeOf cancelObj Is Form Then
If UserControl.Ambient.UserMode = True Then
Set cancelObj = Nothing
Set cancelForm = Parent
End If
MsgBox ("Interface Control sited on a form! " & Parent.Name)
Else 'parent not of type Form
If UserControl.Ambient.UserMode = True Then
Set cancelObj = Nothing
'Set cancelForm = Parent 'type mismatch
End If
MsgBox ("Warning Interface Control not sited on a form!")
End If
End Sub

Private Sub cancelform_QueryUnload(Cancel As Integer, UnloadMode As Integer)
' Parent Form window close event captured!
Dim Msg As String
If UnloadMode = 0 Then
If m_MethodRunning = 1 Then
Msg = "You can't close this form at this time"
If MsgBox(Msg, vbOKOnly, cancelForm.Caption) = vbOK Then
Cancel = 1
End If
Else
Set cancelObj = Nothing
Set cancelForm = Nothing
' safe shutdown code here
End If
End If
End Sub

Thankyou for any time that you can spare.

Need To Create Form Look Like Outlook Calander
Hi,

I need to generate form look like outlook calander(attached image). i have the data(appointment timings) in my access database. is it possible to do in vb same like outlook calander?

Thanks
Balakumar

Converting Code For A Userform To Excel Sheet (control Array)
Hey. I searched the boards yesterday and found a method to create a control array in VBA using a seperate class and the .Tag property of each control. Now, searching again I can't find the link to where this was posted, but I do have the code.

It's something like this. This is the code in a UserForm.

Code:
Dim c() As New Classe1
Dim i As Integer

Private Sub UserForm_Initialize()
Dim obj As MSForms.Control
For Each obj In Me.Controls
If TypeName(obj) = "CommandButton" Then
i = i + 1
ReDim Preserve c(i)
Set c(i) = New Classe1
c(i).SetCommandButton obj
obj.Tag = i
End If
Next
End Sub

And this is the code for Classe1.

Code:
Private WithEvents cmb1 As MSForms.CommandButton

Sub SetCommandButton(ByVal cmb As MSForms.CommandButton)
Set cmb1 = cmb
End Sub

Private Sub cmb1_Click()
MsgBox cmb1.Tag
End Sub

Now, this works great, but I want to apply a similar reasoning to the actual Excel sheet and not just a popup user form. I know there is no ActiveSheet.Controls property, but ActiveSheet.OLEObjects exists instead. I tried to change the code to allow for this change, and I ran into two problems. First off, OLEObjects don't have a .Tag property, so that will have to be changed, and secondly the TypeName(obj) is always "OLEObject" and never the type of object it is.

Does anyone know how I can fix this?

Retrieving Calander Info From Exchange Server
I am interested in writing an app that will retrieve a user's information from the calander that lives on an exchange server.

App will know the following and be able to get all appointment and meeting data:
Exchange Server
Login
Password
Date to retrieve

Any Ideas?

Thanks,

Assistance Needed: How Can I Control IE From Activex Com Or Control?
We are developing a client app that will receive an account number from a phone switch. It must be developed as a client app to use the phone switch API to get actions from the switch. The app needs to pass the number into a command field on a vendor supplied web site - which we CANNOT modify. We might be allowed to load a dll or control from the login webpage.

The vendor site screen scapes mainframe data and displays the data in Internet Explorer. IE is the company standard -- we do not support netscape, opera or any other browser.

The url does not change nor can we post data to the url. The site controls user access and navigation. We believe we can access the html and insert the account number on a command line. I believe we need to create either an Activex control or com object that we would call from the client app. The object would then set the html value and submit the request. Looking for any samples/code/advise on the feasibility of this solution!

Socket Control (VB Control) Needed
Hi
Anyone knows a windows Socket control written in VB not like winsock.ocx but one declared with API calls so that my program should work on systems that don't have VB run-time (the socket should be a control for connecting to a server rather than listening for incomming connections as you will see) .
Also, could anyne point pe to a VB application (samll code so that I can understand it) that downloads files over the net via http (if one with multiple connections is even better -- bur again not too complicated).
Tanks

Control Help Needed
Using VB6, I am trying to find a way to emulate the pop-up message feature that happens (eg in WinXP) when you move the cursor over an object and a text sized boxed message appears while the cursor remains over the object and disappears as soon as the cursor moves off the object.

Is there an existing VB6 control to do this that I am completely missing or do I have to install a 3rd party control? Or do I have to write my own code/control?

GIF Control Needed!!!!!
Hi i really badly need a GIF control that i can set the speed (the rate the frames change) of and uses a mask colour. I was wonding if anyone knew where one was or could make me one (BTW if you do go to the trouble of making one I will gladly put you in the credits of the game I'm making) i have tried a few different control but they have no mask colour.

Control Needed
Hi

Is there a control in VB5, VB6 that is very similar to the Microsoft Multimedia Control (MMControl)?

I want to use one in my program so that the user can go through the database by simply clicking buttons.

Thanks in Advance

Show UserForm From Another UserForm
The scenario: A userform is on the screen and contains a button.

The goal: When the user clicks the button the currently displayed form is hidden and then a second form is displayed.

What I've tried:

Code:
Private Sub SplitTransaction_Click()
EnterTransaction.Hide 'The form currently displayed which I wish to hide
SplitTransaction.Show 'The form I want to display
End Sub

Personal Observations: When I type the name of the form (i.e. - EnterTransaction) and then add the period at the end a drop down box comes up with suggested code. Neither Hide nor Show is listed. I have successfully used the .Hide and .Show in previous macros for MS Excel 2003. However this is being written in MS Excel 2007.

If you need more information, please let me know. Thanks for the help!

Hep Needed In Mscomm Control
i have my computer connected to a siemens hipath355 switch.the switch just sends all the incoming call data into the port and i catch all those data using the mscomm control.
then i capture those information in alog file then transfer those data to a database for all the information like the time the call cae,the port no,whether it isn incoming call or outgoing call,the caller id.

03.04.0300:48:47 16 14200:0400:00:0002256386666 31

this is one of the text which i receive.the first 8 charecters corresponds to the date,the next 8 to the time,then the port no and then the time took to attend the call,then the caller id and so on.
this text is fixed to 76 charecters.
i want this text to be directly imported to the database.
once i get this text i would split it as required and save it in the required columns.thats simple.

iam now using the hyperterminal to capture the log files.
i have got the msdn sample program vbterm.vbp which does all the similar things.i tried to alter that for my use.

i just thought of passing the data as it is captured by the com port as a parmeter to my stored procedure which does the spliting and inserting into the table.

if i set the rthresold property to 1,the mscomm event fires for every 1 charecter and i cant pass every charecter as a parameter.
i set the thresold to 76 and it fires properly for the first time only.

if i could get exactly how much data is coming to the port from the switch i can make the event fire only when that much charecters are received and i can pass that data directly as a parameter.

hope my explanation got u a little idea of what iam tyring to do.or maybe i can give u more explanation.
its really urgent and iam so confused how to do this.i want to make this capturing of data online like when the data comes in the port it got to be inserted into the table instead of me importing the log files into the table.

thanxx in advance.

Better Calendar Control Needed!
So I'm writing this VB6 program. I want a nice calendar that I can select multiple ranges on.

For example:

June 2 - 7
June 9 - 11
June 28

The MonthView control let's you select a range but only ONE range.

I'd like to avoid trying to write a calendar control (because I'm short on time and plus it would look like crap). I don't mind spending a few dollars if I need to... any suggestions on a good Calendar control?

Many thanks!

--DB

Help Needed With MSChart Control....
Ok I found this code:

Code:
With MSChart1
' Displays a 3d chart with 8 columns and 8 rows
' data.
.chartType = VtChChartType2dBar
.ColumnCount = 1
.RowCount = 5
For Column = 1 To 1
For Row = 1 To 5
.Column = Column
.Row = Row
.Data = Row * 100
Next Row
Next Column
' Use the chart as the backdrop of the legend.
.ShowLegend = True
.SelectPart VtChPartTypePlot, index1, index2, _
index3, index4
.EditCopy
.SelectPart VtChPartTypeLegend, index1, _
index2, index3, index4
.EditPaste
End With
---------------------------------------------------------------
I don't know how to change each column. I need each column to hold a different value. The first colum holds the hours for week1 and column 2 holds the hours for week2. I don't have any code yet to get the total hours of each week but before i can do that I need to know how to change each columns value with these values... Thankx for any help.....

Help Needed With Updown Control
Let me set this up for you.

I have 4 labels and 4 updowns controls in arrays.

label1(0) thur label1(3) and Updown1(0) thur Updown1(3)

when I use the Updown1(3) to change caption of label1(3). it sets the values of updown1(0), updown1(1) and updown1(2) to zero (0). What am I doing wrong?

Here is a small snip of code :

Private Sub UpDown1_Change(Index As Integer)
If UpDown1(0).Value <> Label12(0).Caption Then Label12(0).Caption = UpDown1(0).Value
If UpDown1(1).Value <> Label12(1).Caption Then Label12(1).Caption = UpDown1(1).Value
If UpDown1(2).Value <> Label12(2).Caption Then Label12(2).Caption = UpDown1(2).Value
If UpDown1(3).Value <> Label12(3).Caption Then Label12(3).Caption = UpDown1(3).Value

'First try of updown values Dont use yet --- remove when done
'Label12(0).Caption = UpDown1(0).Value
'Label12(1).Caption = UpDown1(1).Value
'Label12(2).Caption = UpDown1(2).Value
'Label12(3).Caption = UpDown1(3).Value
End Sub

Control Needed, Explaining This Will Be Fun!
Hi guys, have no idea where to start on this one so will have to try and explain it well (not exactly what i'm doing but the examples help to explain the general idea)...

I want to recreate a view similar to what you see when in datasheet view in access. I want, on a form, a table which will call data from a database, data can also be added with some of the cells being a combo box for pre-determined lists.

Imagine a 4 x 4 grid (i.e. a table) the first three rows have previous data displayed, the four column headings are, say: manufacturer, model, colour, details.

The first cell under manufacturer in the fourth row will be a combo box offering a list of all manufacturers available (e.g. ford, dodge, chrysler), upon selecting one the relevant models are displayed for that manufacturer in a combo box in the next column and so on for colours and finally a freeformat box for details in the final column. Once the row is completed another row is made available.

This wouldn't be too complicated with careful arrangement of combo and textboxes but I doubt it would look that good and be a lot of hassle for adding the next row.

Anyone know if there is a predefined control that can accomplish this? Or can anyone offer any ideas of how best to achieve this?

Sorry if this is hard to understand (and if its in the wrong thread)

Cheers VB people, (and mods/gaffers, once i've finished this project i'll definately be making a donation - not that thats a bribe or anything! )

Chart Control Needed ?
I cannot use the MS Forms group because of fm20.dll problem with Vista.

Can anybody recommend a Chart control that I can use.

Is MSChart 6.0 (SP4) OK or does it have problems also?

Sstab Control - Help Needed
hello every one,
im using sstab control in my application. im creating control arrays of frames and new tabs at runtime. but i dont know how to set the container property of the frames to their respective tabs.??? for eg: frame1(0) should be in the Tab 0 which is set at the design time. and the frame1(1) and tab 1 are created at runtime but i cant set the frame1(1) to the tab 1??

Can any body Help me... please ????

Thanks,
Chris.

What Control Needed For Splitline?
Rookie question:
What control do I need to use a splitline?

Thx in advance

SchorschM

WebBrowser Control Help Needed Please
I need to write this code to automatically loop through items in a listview and then submit each one to a specific webpage. I use the WebBrowser1_DocumentComplete method to do the submission but it only submits the last item in the listview.
How can I fix this?

Thanks in advance.

Code:
Private Sub cmdSubmitAll_Click()
Public site As String
For lngItem = 1 To lngCount
site = URLEncode(lvwUrls.ListItems(lngItem))
email = URLEncode(txtEmail.Text)
Dim googleAddy As String
googleAddy = "http://www.google.com/addurl.html"
WebBrowser1.Navigate googleAddy
Next

Private Sub WebBrowser1_DocumentComplete(ByVal pDisp As Object, URL As Variant)
Dim strHTML As String, googleAddy As String

googleAddy = "http://www.google.com/addurl.html"
strHTML = "Hi jesus4u" & "<br>" & _
"Fill in Textbox A with URl to submit" & _
"<br>" & "Then press the Start button"

If (pDisp = WebBrowser1.Object) Then
If WebBrowser1.LocationURL = "about :blank" Then
WebBrowser1.Document.body.innerHTML = strHTML
ElseIf WebBrowser1.LocationURL = googleAddy Then
With WebBrowser1.Document.Forms(1)
.All("q").Value = site
'.All("dq").Value = "This is the comments input box"
.All("submit").Click
End With
End If
End If
End Sub