Search:

Hi,

I'll give you fishing pole not a fish: try to play with InStr and Mid functions.

Regards,
Sebastian

Hi,

You can use below code to validate all combobox controls on current page:



Dim nPage As Integer
Dim oControl As Control

' check current page

Hi,

How are you trying to insert date into table?
Are you using VBA? If yes do you put "#" signs around date?
What data type is field that you are trying to insert date to?

More information...

Hi,

You can access ActiveX controls on sheet using OLEObjects collection:


Dim strButtonName As String
strButtonName = "cmdButton2"
...

Hi,

To measure time in seconds (and parts of seconds) you can use Timer function. This function returns seconds from Midnight.



Sub TestTime()
Dim sStartTime As Single
Dim sEndTime...

Hi,

You can use below procedure to create folder. Before creating folder it checks if it exists.



Sub CreateFolder(strFolder As String)

Dim objFSO As Object
Dim strPath As String

Code that I provided consists of 4 procedures:
- ListXlsx - iterates through provided as an argument direcory and its subfolders and it lists in column "A" in active worksheet file paths to excel...

Hi,

Create in new excel file new module and paste below code. Than just execute RefreshPivots procedure. Below code lists all xlsx files from folder and subfolders in current worksheet. Than it...

Hi,
Can You show whole code that is executed in form?
It looks like you are trying to assign value of wrong datatype to one of element.
Regards,
Sebastian

Hi,
Check below code. Add it to click event of command button



Private Sub CommandButton1_Click()

Dim oControl As Control

For Each oControl In Me.Controls ' Loop through all controls on...

Hi,

Your iQuery function looks like custom function. Go to Visual Basic Editor (ALT+F11) in your old spreadsheet. Then check in all objects visible in project explorer (window should be located at...

Hi,

It depends. If tables are related and you only want to retrieve one record but depending on whether value exists in both tables using join seems to be solution.

If you want to retrieve two...

Hi,

To eliminate duplicate rows You should use DISTINCT clause:



SELECT DISTINCT UserId, Folder
FROM File

Hi All,

I am looking for opportunity to work for non-profit organisation.
I have 2 years, hands-on experience in creating applications based on MS Excel and MS Access.
Just send me PM with Your...

try this:

Dim number As Integer
number = 2
lblnumber.text = (number.ToString("0.00"))

I don't know if I understood what you mean. But you can place one lable on another and change their Visibile property: True - to show label, False - hide label.

For example:

lbl1.visible=true ...

Hi,

I suggest you should read this articles:
http://www.devcity.net/Articles/94/1/multipleforms.aspx
http://www.devcity.net/Articles/100/multipleforms2.aspx...

s2002h69,

If you want to place some controls on MDI container you can use Panel control. On this panel you can place other controls. I think this will be much better that using option box.

As...

Hi,

If you want to remove all selected rows:

For Each row As DataGridViewRow In Me.DataGridView1.SelectedRows
Me.DataGridView1.Rows.Remove(row)
Next

regards,
sweet_dreams

Hi all,

I have such a problem: I wrote sub to copy text form one doc to
currently open document. I attached this sub to button I would like it
to insert text form another doc in the selection...

Hi,

If I understood you well, this should do:

Private Sub ShowMessage(ByVal sender As Object, ByVal e As System.EventArgs) _
Handles RadioButton1.CheckedChanged,...

You can read about this control here:
http://msdn2.microsoft.com/en-us/library/3a1tbfwd.aspx
http://www.codeproject.com/Purgatory/LayoutPanels_VS2005.asp
Hope this helps.

Regards,
sweet_dreams

What is it table tool??? Can you give proper name of the control you use???

Hi,

If I understood you well this should do:

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
...

Thanks jmcilhinney for your reply. But I have another problem: how can I avoid validating cell it isn't containing any value. I was trying to use such a code:

Private Sub...

Hi,

How can I valide value in DataGridViews cell? I was trying to do it like that:

Private Sub DataGridView1_CellValidating(ByVal sender As Object, ByVal e As...

Hi,

In your case code should look for example like this:


Dim text As String = ""

Select Case Me.ComboBox1.Text
Case "yellow"
text = "yellow"

Hi all,

Is it possible to make user unable to navigate through rows on DataGridView control, so that user can not go to next or previous row. Regardless of how user is trying: using mouse or...

Hi all,

I wanted to copy content of one .doc file into another including text formatting. I am using late binding:


Dim oApp As Object
Dim oDoc As Object
Dim oRange...

Hi all,

I need some suggestions about automating MS Word using VB.NET. I searched this forum to find some information about programming word with Vb. I found many interesting things but still I...

Hi all,

I have such a problem with RichTextBox control:
Imagine I have a text like that: I have some text. I would like to select text press the button and make it written in Italic: I have some...

Hi all,

How can I make visible vertical scrollbar on ListView control?

Regardsm
sweet_dreams

Thank you a lot Kleinma it works perfect

Hi all,

Is it possible to programmatically select row of specified index on ListView control? Any code will be appreciated.

Regards,
sweet_dreams

Ok. This is full code I use to add the data

Dim ds As New DataSet
Dim number As Integer

'here comes data from xml file
ds.ReadXml(Application.StartupPath & "\2.xml")...

Hi all,

I have such a problem with datagridview control:
I have 3 forms: frmParent, frmChild & frmChild2. frmChild & frmChild2 are child forms of frmParent.
On frmChild2 I have DataGridView...

Hi all,

Is it possible to set image as a ListBoxs background??? ListBox doesn't have BackGroundImage property, so is it possible to be done?

please help,
sweet_dreams

Hi EROC,

if you want to get the first hit you can use for example such a code:


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
...

please remember to tick as RESOLVED (if it is resolved of course) :wave:

Hi,


if IsDBNull(recordset(1)) then
bla bla bla
end if


this should solve your problem,