Recent content by SalemGrafix

Dan, Thank you very much for the quick response, this works perfectly, and is exactly what I was looking for. Thank you so much.

I am creating a website for a friend, and I'm not sure if this is something that can be done with HTML, Javascript, or at all: Main Page displays info from a database. If the user viewing the page clicks on "Add" to add more information, a "child" page pops up, and asks for data. "Child" page...

Okay, I found another thread on another forum, where someone was saying that if it was the form that contained the main program information, if you closed that, it would cause the whole program to close out. Not quite sure what they are talking about there either (and it seems to be an archived...

I'm assuming that what you're asking, is in "Program.cs" how is the first form (Splash screen) opened: static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); ms_frmSplash = new...

I have created a splash screen, and once the main form is loaded, I want to close (or dispose of) the splash screen. Everytime I have tried this, one of two things happens. Either the splash screen stays resident (memory leak issues) or the whole application closes. The names of the forms...

Just tested it out, it works great. I was able to update the record by placing a 0 in the value, and then updating the record using the code you provided with the NULL value afterwards. Thanks again for all your help. I'll be switching out the rest of the bound controls as time permits, but...

Good point about the bound controls. Up until your example, I was wondering how to execute direct SQL commands (such as running Stored Procedure or Direct Queries without bound controls). Thanks so much for the help, and for the time being (to get this project out) I'll stick with the bound...

The following is a snipet of the code that I'm using to save the record to the database: frmODBCMain.txtSVTViolationCode.Text = Trim(txtCode.Text) frmODBCMain.txtSVTViolationDescription.Text = Trim(txtDescription.Text) If Trim(txtAmount.Text) <> "" Then...

I'm actually using the built in ADO control (MSADO) and using text boxes with the datasource set to the ADO control. That brings up an interesting idea though, I might be able to populate the field with a number that would never be used (ie. a number out of range that a user would never use...

MS-SQL 2000, sorry should have put that in there (since I already read on other sites that Access does not allow the usage of null values). Also, as an addition to the error that I described above: If I use "" or vbNullString, I get the error: Run-time error '-2147217842 (80040e4e)'...

I currently am using VB6 where I work, and use the Visual Studio Installer for MSI packaging. It works great, and so far (other than some limited features) I have had no problems. Also, if you know the MSIEXEC switches (drop to command line and type MSIEXEC without any switches to get the...

I have been trying to save a record that I want to set the value in the field to NULL, and have been unsuccessful. I have tried setting the field (ie. txtAmount.text = Null) and saving the record only to get an error message "Run-time error 94: Invalid Use of Null". I have also tried VBNULL...

Wow, I didn't expect such a fast response, and especially didn't expect someone to understand and/or have the answer that quickly. Just tested that out, and it worked! After setting the report (using appplication.openreport(ReportName$)) and then connecting to it, I was able to parse thru...

It's probably going to be easiest to ask the question by giving a little background information, and what it is that I want to accomplish before asking the question: We have a software package that connects to the SQL Server here at the school I work for. From that software, it also can...

Unfortunately, neither would be the case in this instance. Because I'm connecting to the servers using LDAP, I do need the FQDN, I have tried to connect leaving off the "extension" for each, and no go. As for WinS, we are running that, but I have no idea how to resolve the FQDN from that...