Actually, never mind, i re-worked the loop to work around it. Thanks a bunch everyone!! ;)

--Its not broken if it never worked.

Hey hey that did it!, however because i am writing to the file inside of a loop there are no line breaks now. Is there a command I can put at the beginning of the string being written to the file to tell it to create a new line?

--Its not broken if it never worked.

hmm, ok, thanks anyways!! I'll play around with it and if I figure something out I will post it here.

--Its not broken if it never worked.

Beautiful, I will try that tonight. If its not too much to ask, I have another quick question: This way of doing it leaves an extra cariage return at the end of the file, i tried writing a \b to the file once it is all done, but it literally writes a \b in the file. Print #FileHandle, "\b" Print #FileHandle, '\b' isn't a command as the ' starts a comment. Is there a way to kill that last cariage return?

--Its not broken if it never worked.

Do you know if it is possible to bring up the 'Save As' window to allow the user to select the save location and file name? I got it working allowing the user to enter the location and file name in a seperate cell, but it would be handy to bring up the dialog they are use to seeing any other time they save a windows file.

--Its not broken if it never worked.

That did it! thank you very much

--Its not broken if it never worked.

Oh, I didn't know that, thanks!. Do you know of any way to write to a file while 'scripting'?

--Its not broken if it never worked.

Hey, I tried what you posted there and got the following error. --Compile error: --Expected end of statement It happened at the first bracket of this line. sW = New IO.StreamWriter(pathToFile) If this were C# I would assume I hadn't included the right system file, but i can't seem to declare a system file, ie: using System.IO Do you know if that is the case with VB, and if so do you know the syntax for including it?

--Its not broken if it never worked.

I'll try it again, but last time I tried that it threw an error at the '=' and said it expected an end of statement.As for what version I am using I am not 100% sure, its the built in editor to Microsoft Office 2003. I'll try this in the morning and pop back on here if i still can't get it working. Thanks a bunch for the response!

--Its not broken if it never worked.

I am trying to save values to a text file using the VB editor embedded in to the Microsoft Office suite, more specifically using excel. I am fluent in C#, however I am new to VB and I can't seem to get the anything declared or working. I've searched through MSDN and google, and everything i try doesn't work. That said; Does anyone know how to create a new txt file, and write into it? (I think most of my problem is that I don't know where to declare the streamwriter). Thanks in advance Adam

--Its not broken if it never worked.

Yeah.... The DataGridView allows you to select the dataset in the "properties" window, and doesn't allow you access to the code behind it.. at least that I can find. I've tried all the datagridview.load .update and dataset.load .update combinations that I can think of, but none seem to have an effect. The program doesn't lock up, it just doesn't update the dataset.

--Its not broken if it never worked.

I have an application that loads a dataset into a drop down menu in a DataGridView. Separately you can add or remove information from the SQL server that the dataset is populated from. How do I update the dataset once the program is already running? (Assuming I have added information to the SQL table) I have played around, and it seems that the dataset may be complied when the app starts, I could be wrong. Any thoughts are appreciated, Adam

--Its not broken if it never worked.

That was for C#, which i am assuming you are writing your GUI in. The code was just a logic loop so it will only post your reminder once. I don't personally know XML, but SQL is a great program to store information. There's an excellent article on here about SQL by Matt Newman, it might be useful for your project. http://www.codeproject.com/cs/database/sql\_in\_csharp.asp Oh, and the "data and time" in there would be a string in your app... if your using SQL you may have to use the .TrimEnd( ) Command to get rid of extra spaces at the end of the saved "date and time" to make it work right as SQL fills any un-used room with spaces for you. I hope that answered your question, if not just message back. Adam

--Its not broken if it never worked.

np.. good luck

I'm sure there are better ways, but this would work.

//Declarations
int intFlag = 0;

//On timer tick
if ((date and time == DateTime.Now) && (intFlag == 0))
{
intFlag++;
Show reminder;
}

if (date and time != DateTime.Now)
{
intFlag = 0;
}

-- modified at 16:25 Wednesday 3rd October, 2007

Hey, I don't know if there is a reason your changing the order via the DisplayIndex, or what your using to write your code, but if you right click on the datagridview and go edit columns, then you can change the order by moving them up and down in the list(In Visual Studio .NET 2005). Hope that helps, if not disregard.

Hello, I am having an issue with the datagridview in C#. I have set-up the data grid view table, and am trying to set the Selected Item in a "DataGridViewComboBoxColumn" cell. I need to be able to set the selected Item manually as part of a load command (Which retreives information from a remote server). The Items list is populated from a Data Source, which works. I can load the information into a "DataGridViewTextBoxColumn" cell but not a "DataGridViewComboBoxColumn " cell. Does anyone know how to set the Selected Item in a DataGridViewComboBoxColumn cell? Any thoughts would be appreciated. Thanks, Adam -- modified at 13:56 Wednesday 3rd October, 2007