Forum: VB.NET  Jul 7th, 2008 |
| Replies: 4 Views: 724 |
| Forum: VB.NET Jul 5th, 2008 |
| Replies: 4 Views: 724 Re: use data in xml file from database
Its a simple SELECT statement that formats the results in XML, I can't remember exactly what it is but I tested it on the database without the program - and it works just fine - when I get back to... |
| Forum: VB.NET Jul 2nd, 2008 |
| Replies: 4 Views: 724 use data in xml file from database
I am getting information from a database and reading it into an xml file - I've tested the SQL and it works just fine on the database I am using - but it won't return anything once I've got it and am... |
| Forum: Visual Basic 4 / 5 / 6 Jun 19th, 2008 |
| Replies: 0 Views: 460 load db info to a combo box
I have no problem getting it there in the first place - my problem lies in the fact that I cannot get it to update - I have this code:
Private Sub reloadFieldNames(ByVal tableName)
Dim da... |
| Forum: VB.NET May 19th, 2008 |
| Replies: 3 Views: 620 |
| Forum: VB.NET May 15th, 2008 |
| Replies: 3 Views: 620 |
| Forum: VB.NET May 15th, 2008 |
| Replies: 3 Views: 620 Saving settings in a VB Program
I've been looking for answers to this problem for awhile, and none of what I find seems to work. I have a program that creates a database, and a form based on that database, where the form fields... |
| Forum: VB.NET May 14th, 2008 |
| Replies: 3 Views: 1,125 Re: How to display data set.
Im not sure about this, but I think the "Runsheet Info" should be the table name that you are pulling from. According to your SQL the table is "Sheet1". Now, again I'm not sure about this, but it... |
| Forum: MS SQL Apr 25th, 2008 |
| Replies: 1 Views: 895 MS SQL insertion via VB (Query question)
I am trying to insert tables into a database that I created at runtime, I am using MS SQL Server Express, and I have tested this query and it works, in the sense that a table is created. However the... |
| Forum: Visual Basic 4 / 5 / 6 Apr 16th, 2008 |
| Replies: 0 Views: 257 |
| Forum: Visual Basic 4 / 5 / 6 Apr 16th, 2008 |
| Replies: 12 Views: 1,566 Re: Deleting A row from a List Box
using i, as you go through the loop you increment i, (0, 1, 2, 3, etc...) and that will increment the row that you are on. If you want a specific text then using the if statement you check to see... |
| Forum: Visual Basic 4 / 5 / 6 Apr 16th, 2008 |
| Replies: 12 Views: 1,566 Re: Deleting A row from a List Box
You could iterate through the list box items in a for loop, keep a variable that changes by one each time (usually i) and use lst.Reorder.RemoveItem(i), replace i with whatever you use, and if you... |
| Forum: Visual Basic 4 / 5 / 6 Apr 11th, 2008 |
| Replies: 1 Views: 851 Re: Positioning a Group Box at Runtime - Help
Goodness, This was a simple fix, something that occurs when I stare at code to long - I miss the obvious. I was only declaring the group box at the beginning and therefore using the same one every... |
| Forum: Visual Basic 4 / 5 / 6 Apr 11th, 2008 |
| Replies: 1 Views: 851 Positioning a Group Box at Runtime - Help
I am writing a program that will take input from the user in the form of a tree-view and create a form and a database based on the tree-view. I have everything working except the group-box control... |
| Forum: MS Access and FileMaker Pro Mar 7th, 2008 |
| Replies: 1 Views: 6,064 Help me with: Access CREATE TABLE() SQL
I have a program that creates a SQL statement based upon a treeview list that the user makes. The SQL statement looks like this:
CREATE TABLE Test ( Test ID PRIMARY KEY, Check1 CHAR(255), Check2... |
| Forum: VB.NET Mar 1st, 2008 |
| Replies: 2 Views: 3,577 |
| Forum: VB.NET Feb 29th, 2008 |
| Replies: 2 Views: 3,577  Treeview Child Nodes
I am trying to add child nodes to a Treeview list, I have the parent node and this is the code I have to add the child node:
parentNode = New TreeNode()
parentNode.Text =... |
| Forum: MS Access and FileMaker Pro Feb 26th, 2008 |
| Replies: 3 Views: 798 Re: SQL For MS Access?
I have tried that before but this is my problem with that:
http://www.daniweb.com/forums/thread99598.html
So I was looking to see if there was another way -- I have had this problem for a long... |
| Forum: MS Access and FileMaker Pro Feb 25th, 2008 |
| Replies: 3 Views: 798 SQL For MS Access?
I am writing a program in VB 2005 Express and I am using SQL to insert, delete, etc. I was curious if there was a SQL statement that would allow me to backup the database in Access - I have tried the... |
| Forum: VB.NET Feb 15th, 2008 |
| Replies: 2 Views: 1,986 |
| Forum: VB.NET Feb 15th, 2008 |
| Replies: 2 Views: 1,975 Re: Alignment of text in a datagridview column
This should help you out..
http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridview.columnheadersdefaultcellstyle.aspx
I believe you will want the code example second down (VB... |
| Forum: VB.NET Feb 13th, 2008 |
| Replies: 1 Views: 1,165 Re: Help with nested sql statements
Instead of nesting the queries I pulled them apart and set the Select statement to a variable and then called my sql for the insert statement. If anyone has any better ideas just let me know I am... |
| Forum: VB.NET Feb 13th, 2008 |
| Replies: 1 Views: 1,165  Help with nested sql statements
First I will show you my sql, just in case it is some obvious syntax error on my part:
"INSERT INTO tblResults(status, enthusiasm, communication, knowledge, interaction,
... |
| Forum: VB.NET Feb 13th, 2008 |
| Replies: 0 Views: 319 |
| Forum: VB.NET Feb 11th, 2008 |
| Replies: 1 Views: 499 Re: Small Database Problem
I figured it out, apparently I have been looking at it for to long, SQL statements that you want to compare and are Integers do not have quotes around them. So i checked the type in an if statement... |
| Forum: VB.NET Feb 11th, 2008 |
| Replies: 1 Views: 499 Small Database Problem
i have this code to check and make sure that I wont be inserting duplicate records into my table. i take whatever is in the dr variable and if it is 0 then I go ahead, if not I don't do anything with... |
| Forum: VB.NET Jan 30th, 2008 |
| Replies: 0 Views: 2,249 help with reading in text from a website
Hi, I have two things that if I can do one I won't need to do the other, so whichever is easiest you guys answer me either way. What I am trying to do is get text from an email and download it into... |
| Forum: VB.NET Jan 18th, 2008 |
| Replies: 1 Views: 1,661 Re: Pls. Help!!! HOW DO I IMPORT AND EXPORT
In order to interface with excel you have to make the reference to it, go to Project -> Add Reference -> under the COM tab select Microsoft Excel 11.0 Object Library (could be a different number... |
| Forum: VB.NET Jan 18th, 2008 |
| Replies: 0 Views: 361 Downloading attachments with VB
I have looked quite a bit for this so if anyone could help that would be appreciated.
What I want to do is to access a Microsoft Outlook Web email account, I have the server name, port, there is no... |
| Forum: Visual Basic 4 / 5 / 6 Dec 6th, 2007 |
| Replies: 13 Views: 2,397 Re: Finding directory of VB project dynamically
hkdani - the only potential problem I can see with that is my database is in a different folder than what app.path return, the folders that each are in are in the same location, also I can't really... |
| Forum: Visual Basic 4 / 5 / 6 Dec 5th, 2007 |
| Replies: 13 Views: 2,397 Re: Finding directory of VB project dynamically
The DB is installed to an alternate folder than the application directory for example:
Directory
Folder 1 = What app.path returns
Folder 2 = Where the database is at
All of the folders... |
| Forum: Visual Basic 4 / 5 / 6 Dec 5th, 2007 |
| Replies: 13 Views: 2,397 Re: Finding directory of VB project dynamically
That works when I debug. However when I publish it and try to work on it as an application then i get an error message - it can't find the file. I looked and figured out it was in a different folder... |
| Forum: Visual Basic 4 / 5 / 6 Dec 5th, 2007 |
| Replies: 3 Views: 1,101 |
| Forum: Visual Basic 4 / 5 / 6 Dec 5th, 2007 |
| Replies: 13 Views: 2,397 |
| Forum: Visual Basic 4 / 5 / 6 Dec 4th, 2007 |
| Replies: 13 Views: 2,397 Finding directory of VB project dynamically
If someone could tell me if there is a function or method, or some way of finding the directory that the VB project loads to when it is installed on other computers that would be great. What I want... |
| Forum: Visual Basic 4 / 5 / 6 Dec 4th, 2007 |
| Replies: 3 Views: 1,446 |
| Forum: VB.NET Sep 6th, 2007 |
| Replies: 3 Views: 3,704 Re: Backup and Restore Database
Perhaps I didn't explain well enough. I need to know how to use relative paths that will work from within the program because apparently if I try to start from outside it cannot find the path (and... |
| Forum: VB.NET Sep 5th, 2007 |
| Replies: 3 Views: 3,704 Backup and Restore Database
I am currently using a database within my program and I have no problem backing it up or restoring it when i am simply debugging. However if it is published and downloaded it cannot find the path... |
| Forum: Visual Basic 4 / 5 / 6 Jul 19th, 2007 |
| Replies: 5 Views: 4,459 |
| Forum: Visual Basic 4 / 5 / 6 Jul 19th, 2007 |
| Replies: 3 Views: 1,497 Change Button Appearances
The button changes an ugly peach color, which doesn't go well with a green theme, when they are clicked. I can't seem to find where to change this color. Any help is appreciated! |
