Search:

I have 2 tables like this (I removed a lot of fields to make it easier to understand)

tblProducts
-----------
ProductNumber
ProductName


tblProductsSold
-----------------

I have a big one for you.

I have 3 tables each describe like this (I removed some fields to be easier to understand) :

tblProducts (List the products in stock)
- ProductID
- ProductName...

The SQL statement is working when I add all fields from the Customers table. The problem now is that it only gets the customers who have orders. I would like to have value 0 in the count for customer...

I'm using Visual Basic 2015 and the database I'm using is Access 2013

I have 2 tables, one containing customers like this :

CustID
Name

And the other is containing orders like this :
...

So do I need to connect my database to my project first or I open it each time with the ADO.NET connection string ?

If I have to use the Data Connections and Data Sources (in the left pane), how...

I'm lost with database connections.

I used to code with VB6 about 10 years ago and I had to connect the database like this :

Set DB = New ADODB.Database ...

Set myRecordset =...

Is it something that can be done ?

I searched the forum for a solution and I only found basic info on this. I want to be able to list users and groups from the AD (2000 and 2003 Server) and I want to be able to :

- Add / Delete...

As a technician, I need sometimes to scan a network and find what's on it.

Is it possible to do an application that would check all IP address in a network and see if it's a computer, a server, a...

What is httCheckVersion ? An ocx control, a class module ?

If it's a control, you have to put it on your form and if it's a class, you have to declared a variable like this :



Dim...

Not than I'm aware of !

Yes, it helps ! Thank you MartinLiss

I'll have to try tomorrow at work because it was not working and at home, I try to do something similar and it's working. The timer is running even if there's a modal windows opened !

I have a timer on the main form that runs important program code that must always be runned.

On this form, there's button that opens other forms that must be in front of the main one.

If I open...

Is there a parameter that will return me false if there's no tone ?

By the way, the InternetGetConnectedStateEx always return True. It's checking for internet connection which I have. What I want,...

I have to make a call using a modem and MSComm and I would like to be sure no one is on the phone before calling.

Right now, when the phone is open, the modem is beeping like a busy line but I...

What's the differerence between the version Express, Standard and Professional ?

I'm a professional programmer who want to migrate to .Net (I'm a VB6 programmer)

What's the difference between Visual Studio Standard 2005 and Visual Studio Professional 2005 ? There's a difference of 700$ CDN.

Also, I searched the internet to find only the Visual Basic 2005...

Finally, I found an older ActiveX that fits with the older version of VLC.

What I'm doing right now is that when the position of the clip is over 99%, I set it back to 0. So, it loops until the...

I'm stuck again.. in the latest version (with the ActiveX), the window cannot be opened twice. So, if I put the ActiveX on 2 forms and start the two videos in full screen, only one is working !

I finally found an activeX for VLC in the last version of the software, but I can't manage to play a file !

That's why I want to use VideoLAN, it can be opened twice in full screen mode !

I only need to be able to open it through VB and set the full screen, the repeat, the position and the video to play...

For your information, I tried it and only 1 video at a time can be in full screen mode ! :(

I set the left of one form to be on the left screen and the other on right screen. I set the parameter...

Can I play them in full screen mode ?

Does anyone have a better ID ?

I want to show text on a screen (like PowerPoint) and photos on the other.

I tried :
- 2 PowerPoints (Only 1 at a time is working)
- PowerPoint and WMP...

I need to play 2 videos at same time on two different screen connected to one computer.

Is it possible to open a video with VideoLAN on left and right screen and in full screen mode?

I must use...

My friend have a computer company and one of his client ask him for a program. Because he don't know how to code, he asked it to me.

And by the way, I finally found how to do all I need.

I'll...

I guess this will be used to block access after 30 minutes of inactivity. I've been asked to do a timer of 30 minutes, and then change password, send it to another computer with winsock and lock the...

Actually, I don't know. I've been asked if I can do this in VB !

Is it possible with VB6 to lock the workstation with the Windows standard lock window ?

Also, is it possible to change the password before locking it ?

I found the solution myself.

If any of you wants to know, here it is :



Call otlDistList.RemoveMember(otlDistList.GetMember(iRecipient))

Call otlDistList.Save

I'm trying to delete a recipient in a distribution list but it's not working.

Here's the code I use :



Call otlDistList.GetMember(iRecipient).Delete


It doesn't returns any errors, but...

My database is an MS access database.

And Martin, I want to let users have full functionnalities for a limited period of time.

Yes, but on install, the database will be replaced with a new one

How do I create a trial version of 3 month for my application ?

I want to do it like Norton. If I uninstall the application and reinstall it, I don't want it to reset the trial.

How is it...

Your array needs to be declared public in your form in order to use it in your module.

Here's the declaration :



Public WordArray() As String

When I tried the RhinoBull example, it was not working.

I create an application like it asked to do on the page, in the List1, there's a lot of constant. When I click on one of them, it shows the...

I think I'll just checked if the folder exist with the English name and if not, I'll use the french name.

I'll be a lot easier !

Is your Kaka function in a different form that Form1 ??

If so, is your array declared Public ?