Search:

All sorted! In the end I created a macro within the apreadsheet with the following code:



Sub RenameFiles()
Dim SourceName As String
Dim DestName As String
Dim row As Long

For row = 1 To...

Hey DataMiser

Thanks for the reply. Will try that out and let you know how I get on :)

Hi dglienna

thanks for the reply. I think a bit overkill for what I need. All I need to be able to do is compare the filename with values in Column A in the spreadsheet. If it exists in that...

Anyone??

I think the countrol you are looking for is now called the TrackBar in VB.net

Or

there is also the HScrollBar depending on what you are trying to achieve :)

Hi people

I have around 1300 jpeg's that need to be renamed based on the value in an excel spreadsheet.

What I need to be able to do is parse each jpeg in a directory, compare the filename to a...

Hi Hannes

Thanks for the great info as usual ;) It works a treat!

It was a mistake on my part. I took the code form an old VB6 prog I wrote years ago and forgot I couldn't just copy and paste...

Hi people

I am trying to allow the user to launch the Windows Screen Saver by clicking on a button. I have the following code:

Option Explicit On


Public Class Form1
Private...

Hi

Sorry - I am using MSAccess

ComITSolutions - thanks for the reply

I get the error:


pointing to your line of code.

Any ideas?

Ah yes - didn't think about that. Will give it a go and let ya know how I get on.

Cheers for suggesting that ;)

My code is now:

Dim ukCulture As CultureInfo = New CultureInfo("en-GB")
Dim ukSDate As DateTime = DateTime.Parse(SDate, ukCulture.DateTimeFormat)
Dim ukFDate As DateTime =...

komalo

Thing is, I need the whole date though :(

Dglienna thanks for the help so far :)

I get the error 'Parse is not a member of String' for this part:


and also the error 'Value of type 'System.Globalization.CultureInfo' cannot be...

Hi DGlienna

Thanks for the reply. I can convert most of the code you gave me but not all of it. Any chance you can help me out??

Thanks

Just tried that and selected the dates: 01/05/2009 and 07/05/2009 but when the DataGridView is populated, the dates range from 05/01/2009 up until the present day!!

Something is swapping the dates...

Hi Hannes! :)

Cheers for the reply. I have tried this:



SDate = sDateTime.Value.ToString("dd MM yyyy")

and also changing the Format to custom and entering dd/mm/yyyy in the CustomFormat...

I am using a DateTimePicker to allow the user to select dates between which, info from a database is selected and displayed in a DataGridView.

This works fine exept that the dates selected by the...

That's great - thanks ComITSolutions ;)

Yep sorry shouuld have mentioned that - they are variables!

Will give that a go now . . . .

Cheers

Hi

I have a small problem with the SQL statement that returns the information from an Access 2003 table based on the dates input by the user. IT works fine if I manually code the dates as below:
...

Cheers for the reply. Believe me, if this if Homework as you suggest then I must be the oldest student in Britain at 31!!

I was just very tired just like yourself after a 10hr shift then coming...

Hi people

I am creating basic slideshow form to finish off an app I am writing. I have been at it all day finishing off the main app and am getting very tired now!!

Anyway, I have a form...

I couldn't agree more!!! :)

Forget it - my Brain just switched back on!!