Type: Posts; User: brjames32
Search took 0.01 seconds.
August 5th, 2009, 09:00 AM
All sorted! In the end I created a macro within the apreadsheet with the following code:
Dim SourceName As String
Dim DestName As String
Dim row As Long
For row = 1 To...
August 4th, 2009, 08:24 AM
Thanks for the reply. Will try that out and let you know how I get on :)
August 4th, 2009, 05:16 AM
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...
August 3rd, 2009, 05:29 PM
August 3rd, 2009, 08:08 AM
I think the countrol you are looking for is now called the TrackBar in VB.net
there is also the HScrollBar depending on what you are trying to achieve :)
August 3rd, 2009, 04:50 AM
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...
June 24th, 2009, 04:55 AM
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...
June 24th, 2009, 02:46 AM
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
Sorry - I am using MSAccess
ComITSolutions - thanks for the reply
I get the error:
pointing to your line of code.
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 =...
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...
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??
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 . . . .
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:
February 26th, 2009, 01:27 AM
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...
February 25th, 2009, 02:30 PM
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...
February 25th, 2009, 09:19 AM
I couldn't agree more!!! :)
February 25th, 2009, 08:44 AM
Forget it - my Brain just switched back on!!
Click Here to Expand Forum to Full Width