Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 44
Search took 0.01 seconds.
Search: Posts Made By: tbriers
Forum: VB Databases Basics August 27th, 2004, 02:33 AM
Replies: 2
Views: 596
Posted By tbriers
Hi, To get the number of records you can...

Hi,

To get the number of records you can execute the following statement:

"Select count(id) as numberRecords from TableName"

To get the highest id you can execute the following statement:
...
Forum: VB How-To August 10th, 2004, 02:18 AM
Replies: 5
Views: 2,430
Posted By tbriers
Hi, To list the content of a folder you can...

Hi,

To list the content of a folder you can use the 'Dir' command in VB or you can have a look at the 'FileSystemObject'.

To delete a file you simply use the 'Kill' command with the full path....
Forum: Pro VB Databases July 2nd, 2004, 02:18 AM
Replies: 1
Views: 1,568
Posted By tbriers
Hi, Did you try using an InlineShape? ...

Hi,

Did you try using an InlineShape?

.InlineShapes.AddPicture()

I also had some problems with shapes. Once in a while it said "Method or object not found" and with an inlineshape it...
Forum: Beginning VB 6 June 30th, 2004, 02:23 AM
Replies: 3
Views: 1,150
Posted By tbriers
Is the ActiveX installed on the Window 2000 PC? ...

Is the ActiveX installed on the Window 2000 PC?

If not you can try and use the packaging tool that comes with vb6 to create a simple installer with all the components.

Greetz

Tom.
Forum: VB Databases Basics June 29th, 2004, 03:45 AM
Replies: 10
Views: 4,625
Posted By tbriers
What I do in your case is that I create a listbox...

What I do in your case is that I create a listbox with Checkboxes (It's a normal listbox but the style=checkbox). (makes it easier to select multiple)

Then when the user hits submit I do the...
Forum: VB How-To June 25th, 2004, 04:15 AM
Replies: 7
Views: 1,270
Posted By tbriers
Well, in VB6 you can pass commandline arguments...

Well, in VB6 you can pass commandline arguments and if you can call 1 exe on a server from all clients this might be a possible solution for you. (but I am not sure if it is possible to run an App...
Forum: VB Databases Basics June 23rd, 2004, 05:17 AM
Replies: 1
Views: 983
Posted By tbriers
maybe you can read this topic: ...

maybe you can read this topic:

http://p2p.wrox.com/topic.asp?TOPIC_ID=9436

Greetz

Tom.
Forum: VB How-To June 16th, 2004, 03:05 AM
Replies: 2
Views: 1,146
Posted By tbriers
Hi, Mod returns the remainder of a division...

Hi,

Mod returns the remainder of a division and 28/4 has no remainder so it is correct.

You just have to use '/' to make a division.

Regards

Tom
Forum: VB Databases Basics June 8th, 2004, 08:32 AM
Replies: 10
Views: 1,885
Posted By tbriers
I may have another suggestion. When I have...

I may have another suggestion.

When I have to connect to an SQL Server using VB I do not use:
PROVIDER=SQLOLEDB

But i use
PROVIDER=SQLOLEDB.1

Although I use VB6 and to be honnest I do not...
Forum: VB Databases Basics June 7th, 2004, 01:05 PM
Replies: 10
Views: 1,885
Posted By tbriers
You can also try and place an ADODC control (ADO...

You can also try and place an ADODC control (ADO Database Control) on your form and right click on that one to get the properties.

There you can create a connection using a wizard and you get the...
Forum: Beginning VB 6 May 19th, 2004, 07:21 AM
Replies: 1
Views: 3,458
Posted By tbriers
In the Form Activate event you can place the...

In the Form Activate event you can place the following code:

Form1.windowstate = vbnormal ( or just 1 )

Although I'm not entirly sure

Greetz

Tom.
Forum: Beginning VB 6 May 4th, 2004, 05:18 AM
Replies: 2
Views: 1,240
Posted By tbriers
An Image control has a Stretch property. If you...

An Image control has a Stretch property.
If you set this to true than VB will size the image so it fits in the control.

(If your picture doesn't have the same aspect ratio as your image control...
Forum: Pro VB 6 April 30th, 2004, 02:16 AM
Replies: 1
Views: 1,470
Posted By tbriers
I don't know what your exact problem is but this...

I don't know what your exact problem is but this might help:

Do While Not EOF(FileNr)

Line Input #FileNr, strLine
'do stuff with your line here

Loop

Greetz
Forum: VB How-To April 28th, 2004, 05:16 AM
Replies: 4
Views: 2,808
Posted By tbriers
I do not know if this helps but i think you have...

I do not know if this helps but i think you have to declare strField2 as a string in your function

Greetz

Tom.
Forum: VB How-To April 27th, 2004, 02:27 AM
Replies: 1
Views: 1,029
Posted By tbriers
In can add a reference to the word object...

In can add a reference to the word object library. (Project/References)

Then you can do the following:

Dim woApp as new Word.Application

set woApp = CreateObject("Word.Application")

If...
Forum: VB How-To April 21st, 2004, 06:52 AM
Replies: 1
Views: 2,290
Posted By tbriers
How about RichTextBox.TextRTF This is the text...

How about RichTextBox.TextRTF
This is the text including the rtf codes

Greetz

Tom.
Forum: Pro VB 6 April 20th, 2004, 02:18 AM
Replies: 2
Views: 981
Posted By tbriers
Or you can always store the data in global...

Or you can always store the data in global variables (declared: public)

Tom
Forum: VB How-To April 13th, 2004, 04:46 AM
Replies: 4
Views: 1,537
Posted By tbriers
Let's say you click on a button and you want the...

Let's say you click on a button and you want the exe "secondproject.exe" to start.

On the click event of the button you use the following code:

Shell GetAppPath & "secondproject"

(In my...
Forum: VB How-To April 1st, 2004, 08:47 AM
Replies: 4
Views: 1,537
Posted By tbriers
I do not think you can call another project...

I do not think you can call another project directly but you can call an exe and pass some arguments which you can use in your other exe.

I often use this method. In the Sub Main I decode the...
Forum: VB How-To March 31st, 2004, 04:22 AM
Replies: 2
Views: 1,997
Posted By tbriers
Hi ...

Hi

http://www.vb2themax.com/Item.asp?ID=353&PageID=TipBank

But if you search google for +vb6 +listbox +scrollbar +horizontal
you will find more examples and solutions.

Greetz

Tom.
Forum: Pro VB 6 March 30th, 2004, 06:48 AM
Replies: 1
Views: 956
Posted By tbriers
Validate Event

Hi all,

I have created a form with a tab strip.

This form has a lot of controls: textbox, listboxes, checkboxes and comboboxes.

I use an ado connection to get the data from the database and...
Forum: Pro VB 6 March 30th, 2004, 04:17 AM
Replies: 1
Views: 3,271
Posted By tbriers
Hi, About the Null i probably cannot help...

Hi,

About the Null i probably cannot help you. But I know that there is a vbNullString.

About the connection on the other hand: you can check the connection.state object.
If this is 1 it...
Forum: VB How-To March 30th, 2004, 04:04 AM
Replies: 0
Views: 1,036
Posted By tbriers
Enumeration

Hi all,

Does anybody know how to create an enumeration which contains string.

E.g.

Public Enum Codes
one = "aCode"
two = "bCode"
...
Forum: Beginning VB 6 March 24th, 2004, 06:30 AM
Replies: 1
Views: 702
Posted By tbriers
I think you might want to ask this question in...

I think you might want to ask this question in the ASP forum since that is a language to create dynamic websites.

Greetz

Tom.
Forum: VB How-To March 9th, 2004, 08:34 AM
Replies: 3
Views: 7,206
Posted By tbriers
You can use: adoConnection.State This...

You can use:

adoConnection.State

This returns 1 of the connection is open and 0 if it is closed.

Greetz

Tom.
Showing results 1 to 25 of 44

 


All times are GMT -4. The time now is 01:45 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.