One of the requirements in a new project in VB is that 'it should good look'. Naturally the client doesn't have any clear idea about 'good looking apps' but wants it to look 'real good'. I can give...

You mean you want to create several users for Oracle ? Use the connection string method given above and change the username and password as required. For example

For User1
ConnString =...

As you can see, my last post in this thread was more than 2 years ago. In the meantime, of course this particular problem has been solved though I can't recall exactly what solution I used. And I...

My project needs to read records from a CSV file. The file contains 3 columns of data. Record is continuously being appended to the file by another application (about once every 6-8 seconds), and my...

Pritkoff
1. The last post was almost 3 yrs ago. Do u really think I am still bothered about it ?
2. I made it clear in my first post that I can't use any other third party software, so no need to...

Not really sure what you are looking for, please give more details. You can create a countdown using a loop. If you want to add or subtract a number from a date, use dateadd() function.

For MS Access, use * (asteriks) instead of %

"Select * from <table> where <field> like '" & text1.text & "*'"

For other databases, it will depend on the database. Oracle uses "%" (IIRC, not...

Please give the line of code where u r connecting to the database

It would certainly be more useful if you tell us what the problem is.

If the 2 records are identical in all respects, then any change to one will affect the other. If there is some field (say Address or City) where they differ, you have to include that field in your...

Since row is actually representing a record, shouldn't it be
set row = PayrollDatabaseDataSet.Allowances_Pay_Table.Rows(current_row)
?
Since you have just declared row as a variant, there might...

I gave the solution for rolled paper, not pages (fanfold or otherwise). For rolled paper, there is naturally no concept of next page. If you are printing to pages of fixed height, using a data report...

When I am trying to connect to a MS Access database to display a data report, I am getting a dialog-box pop-up showing the different parameters for the connection string. Clicking on either the 'OK'...

Don't use the & immedietly after the = . (I suspect that's just a typo). Otherwise yes

Use the Row and Col values to specify a cell.

Flex.Row = 10
Flex.Col = 5

Will select the cell in the intersection of 11th row and 6th column. Remember the Row and Column values start from Zero

Most probably Excel is trying to compute "3/21/2005" as a number or date. Then it is finding some text and getting messed up. If possible, try putting the 3/21/2005 part within quotes : "'3/21/2005'...

If the form2 is not showing, try

form2.show
form2.setfocus

This should bring the form2 window in front.

Is there any utility that allows you to develop card playing games (like go fish, bridge, etc) ? Where can I get the playing card pictures and how to understand which card has been clicked ? Does...

I am not sure if there is a direct way of getting the path of another app. One way could be having the 2nd app write it's path somewhere (in a text file for example) when it's launched. Then the 1st...

You haven't really specified what problem you are facing so it is difficult to offer any suggestions. For copying files in VB, you can use the FileCopy function.

FileCopy <SourcePath>...

I am sorry, but I don't really understand your statement. What is a 'record' property ? And 'Primary key' property applies to a field in a database table, not to a text box. Do you mean the field...

I am sorry, I don't get you. Do you know VB programming ? How to connect to a database and retrieve records etc ? If not, it would be better if you read up on that first.

Use the datediff function.

TimeDiff = DateDiff("n", Time1, Time2)

will give the time difference in minutes. For difference in seconds, use "s" instead of "n". Look up the datediff function in...

Sorry to say, I won't. The purpose of this forum is to HELP a fellow programmer WHEN he is stuck with a problem, NOT to provide coding. You should try writing the program yourself. Of course, I or...

Do You want to do the program and coding in MS Access 2003 ? Then sorry, I cannot be of any help. MS Access uses VBA (Visual Basic For Applications) for programming and I do not know VBA.

Putting data into Excel File is not a big problem. In the VB project Refernces add the "Microsoft Excel X Object Library" where X will depend on whatever version of Excel you have in the computer.
...

You can place a Command Button in the form and set it's Cancel Property to True. In the Button_Click Event write
Unload Me

To give the illusion of the Escape Key working directly on the form, set...

How can anyone give you a solution when you haven't mentioned what error you are getting ??

Use ExitWindowsEx API function

Storing & displaying words using Tamil fonts in a VB program will require a lot of quite high level programming. I don't work in related field so don't really have much knowledge or experience to...

Your program is not really complicated, but I don't think it ill serve any useful purpose. First, how to do the program

Use any database (Access, Oracle, whatever) you are comfortable with....

I am not sure whether this is possible, unless u write TSR or something like that to read the keyboard events. When any other application (like notepad) has the focus, ur program loses focus and no...

If you want to play a sound file (*.wav), you can use the PlaySound API function.

Thanks, Great resource site !!

Does anybody know how to extract the tag information (Title, Artist, album etc ) from a .mp3 file ? And how to edit the information from VB ?

Regards

Dim db as database
Dim rs as recordset
set db = opendatabase("Access_Database_Path")
set rs = db.Open("Table_Name")
Dim mTotal
Do until rs.EOF
mTotal = mTotal + rs("ColumnName")
...

You can connect to the Excel sheet using an ODBC connection or using ADO, whichever you feel more comfortable with.

For connecting to SQL server with a server name and database name, you can use...

Your description of the problem is almost incomprehensible. Please specify correctly, using correct grammer and sentences. If You get a reply like this
"take access table then like open sql , and if...

That would of course depend on your tables and fields.

For example, if you have a table called Table1 and want to print records where the column Field1 contains the value 'ABC', your SQL will be...

As far as I know, you cannot use a child window hwnd for opening a separate program. ShellExecute will launch the associated program with the file specified (Adobe Acrobat usually for pdf files). You...