Have you tried ".AddItem" with column values separated by "vbTab"?

Yomet

Another update.

After trying everything I could think of, including re-installing VB, and some things I had help thinking of, I finally decided to install the actual application on my computer.
...

OK, so after doing a bit more research I realize that DLLs created with VB and C++ behave differently when used in VB code. This explains why I am not able to add a reference to the DLL.

In the...

Hello,

I have the same problem as this poster http://www.daniweb.com/forums/thread89221.html but to summarize:

I have a VB6 project that worked fine until Sep. 2008.
I have not worked on it...

A Status update - It went away on it's own and I have no idea what caused it or what corrected it.

Thx

Yomet

Hi,

I have a weird problem with my workstation at home. All of a sudden the network connection status says "Acquiring network address", however, my computer is running on a static IP address and...

Yello,

Thanks a million, it works flawlessly.

Yomet

Hi,

I have a form of variable height. When the form grows in height I have code that verifies if the bottom of the form will come below the bottom of the screen and, if so, moves the form up - no...

Andrew,

I don't see why you could not use it in XL 2003. Just copy-paste the two conversion functions into a module and then call them from the spreadsheet.

I tested it in the attached...

Hi PVBert,

Thanks for the reply, however, I have some clarifications and a question about it.

Clarifications: The table inserted into is called tblUsers and has the following...

Well,

I found one workaround using the parametrized query stored in the database, here it is
'6th try - using a query in the access database
Dim arr(1)
cmd.CommandText = "qryInsertUser" ...

One more thing, I tried the same INSERT statement but without the variables, i.e.

conn.execute "INSERT INTO tblUsers (UserName, Password) VALUES ('Hello', 'World');", conn

Just to make sure...

Hi community,

I have the weirdest error happening in my VB6 program when I try to execute an "INSERT INTO" query. Here are the premises:

Public conn as ADODB.Connection
Public rs1 as...

Royaloba,

Like last time I will answer your question here in the public forum where everyone can use the information.

If I have understood you well you want to merge several text files into...

royaloba,

I am happy that things worked out well.

Good luck with the rest of the project

Happy coding

Yomet

royaloba,

Thanks for taking the time to convert your database into Access, it helped.

Now for what I found:
1) There seems to be some problem with the "ExecuteCommand" sub since it never gives...

royaloba,

I can see where you code is going wrong and there are two quite simple errors.
1) What you do is adding a record every time you read a line wihtout first verifying if that card has...

Hi royaloba,

Sorry to hear that things are not working out. I would like to know what is going wrong. Just saying "It's not working" does not help me a lot since there are a million things that...

Hi again royaloba,

When I said a SELECT statement I did not mean a SELECT CASE statement but rather a SQL SELECT statement.

Here is the gist of what I would do, this might not work correctly in...

kmbhat1971,

OK, let's see where we can get from here.

Have you tried to set the language in the Word document to Arabic?

Selection.LanguageID = wdArabicAlgeria

I know you might not use...

adalita_m,

Do you mean that if the customer should get $35.70 back your program needs to calculate the smallest number of coins and bills that make up $35.70?

Please confirm if this is your...

kmbhat1971,

If I understand your problem correctly you are transferring data from VB to a Word document but when you do this the text does not display in the correct font. Is this correct?

If...

setup,

See w00dy's reply to the initial posting, it is the best way to go.

In the Package & Deployment Wizard you can add files that you know are needed, i.e. database files, .ini files, etc....

santhakumar,

As I said in my reply to your PM, I will post your question and answer here for everybody to gain from the information.

There is no way that I know of for creating barcode from...

royaloba,

As I said in my answer to your PM I am posting your question and my answer here for everybody to profit from the information exchanged.

Without giving you the code I will give you the...

royaloba,

In order to parse out the data you do not want I suggest validating the input line before splitting it into the data() array.

Assuming that you only want the "Access" events in your...

royaloba,

I just saw your newly created thread and will post the answer in there

Thx

Yomet

santhakumar,

You'll need two things in order to print barcode.

1) the font for the specific barcode to print, i.e. Code 39 (or 3 of 9), Code 128, Interleaved 2 of 5, etc.

2) the algorithm...

royaloba,

Hi, I got your personal messages and I am happy that what I posted earlier has helped you.

I would like you to start a new thread so as to not interfere with this one. and post your...

Helloworld,

Please see my PM to you about this and remember that beside the project being sent to me everything else stays on the forum.

Thanks

Yomet

Iaifa,

Sorry for the late reply but my HD died on Fri night and then my Motherboard fried last night.... :(

Good to hear that you made some progress on the project it seems to be doing the...

Hi again Vish,

Happy to hear that you got your assignment in on time and that everything worked out.

For this question I suggest trying by changing
AND Grade='C';
to
AND Grade < 'C';
...

Iafa,

Could you please repost your project since I keep getting the error:
File not found: "<project path>\testing\save.frm"

It seems you made some changes to the names in your "testing"...

If you only want to see the Excel workbook opened by your program try:

x.visible = True

If you need to change data in your Excel workbook while your program is running you will need to modify...

Hi Comatose,

Thanks for the pointer about vbNullString, I had no idea that it would speed the application and will start using it immediately.

As for your other comments I could not agree more...

Iafa,

The answer to your problem is quite simple, even if not obvious. You declared all your variables in the beginning of the module. This means that they will retain their value for the whole...

Happy to hear you found another way, by using the Macro recorder it looks like - good going!!

Anyway, just to clear up your problems with my code:
The range you sould have put in the line
For...

Hi helloworld,

Your function should work fine, and it gives the correct results when I test it. So I think your problem is simply how you use it in your code.

Remember that "A" has ASCII value...

Hi Iafia,

If all you want to do is shift the letters three steps you can easily do that by taking the ASCII value of each letter add three to it and then convert it back to a character, i.e. Dim...

antioed,

The logoff of Console is the one thing they say you cannot do with this. Do you have a method of doing that?

Thx

Yomet