Have you tried the excellent tutorial at the top of the Posts page on this forum

http://www.timesheetsmts.com/adotutorial.htm

I found it gave me just about everything I needed in order to...

It seems as though you are looking for the option to create program .exe which is available in VB6. So far as I am aware in order to deploy your program as a standalone application you will have to...

Have you tried

Textbox1.BackColor = System.Drawing.Color.FromArgb(redValue, greenValue, blueValue)

obviously substituting redValue,greenValue,blueValue with your chosen integers.

I should add that there is a date/time field in the database

Hello,
Please can someone enlighten me. What I need is to fetch data back from my access database using an SQL query in order to present the data entered into the database in the last hour.

I had tried this site already.However,after the advice from a colleague at work and yourself I took a second look.

The suggested..



didn't work. I then replaced with and Hey Presto...!!
Ya...

Hi all,

Can anybody help me out with the connectionstring for connecting VB6 to a Microsoft SQL Server 2005 Express Edition. I have tried several documented varieties which do not work.
My latest...

No!! I posted as though UNTIL TODAY I ASSUMED IT WAS NOT AN OPTION!!Absolutely nowhere in the post does it say that it is a new release.
It is obvious to me how posting the knowledge can be of use...

Thanks very much for your useful contribution!!
I THINK that when you replied, it stated that 20 hours ago I posted the fact that I discovered it TODAY!!!
Congratulations on your infinite...

Just for anyone, who, like me, has got along using VB6 without the mousewheel whilst editing in the IDE.
Until today I just assumed it wasn't an option. There is a simple fix in the form of a free...

Yes , that is not quite what I was asking.
Is there any problem with keeping the connection open for as long as the application is running or should I only open and close the connection each time...

Hi again,
Can anybody tell me how to make use of the checkbox in the Listview control. I would like to make use of the checkbox box in order to indicate a finished task. This would require relating...

Hi all,
When connecting to an Access database from a VB front end usig the ADO control is there any problem caused by the connection being permanently open or am I better to open and close the...

Brilliant!! Thanks very much

SELECT * FROM user \G

worked perfect!!

I should probably be embarrassed!!

Having braved the task that is getting mySQL6.0 installed onto my machine, after listening to the preferences voiced by database users everywhere I was delighted when I finally got down to a bit of a...

Can we see some of your code to give us an idea of where you are at? And maybe a brief description of what the form contains for the purposes of displaying data?
I'm no expert, but I have spent a...

Thanks JX_MAN, I will take that as a compliment. I wonder how many of those solved threads of yours are down to blatantly copying other members replies.
Whereas copying obviously works for some ,...

http://www.daniweb.com/forums/thread119457.html

As mentioned in the original thread :-
The way I am getting around the problem for now is to have a different table for each number with a field in each table named with a constant string ie FAULT...

Each column refers to a part number.

Thanks for the suggestion RobboHort but I didn't have any luck with the square brackets.

The way I am getting around the problem for now is to have a...

The AddItem statement is the problem.
I have tried :-

Combo1.AddItem.myRS1!Text1.Text

The database connected to in order to obtain myRS1 consists of multiple fields each containing different...

Hi again,
In my previous thread regarding Combo box at runtime I had not forseen the problems I would experience introducing a variable to the code.

Private Sub Form_Load()

Set...

Hi all,
What I need to do is populate a combo box at runtime according to specific inputs from other forms.The code listed below is a seperate trial and works OK. I would like to know if I am...

Thankyou all for your time. Got a demo from a work colleague yesterday. He has VB 2005 on his PC. As soon as I got home I downloaded and installed the VB 2008 express edition. To be honest I hadn't...

This question is driving me batty!! I am currently teaching myself and enjoying the results of VB6. However, whenever I ask a colleague anything regarding VB the first reply is always the question...

I had toyed with the idea of switching off at the beginning of the 2nd half!! But I'd pay good money for that feeling when Mr Byrne scored the first and I would double it for the euphoria when mr...

http://news.bbc.co.uk/sport1/hi/rugby_union/7215056.stm

Exactly. I imagine ozzie would also agree!!

:d See What I Mean??

Why not drop in on ozzie10101's Thread

http://www.daniweb.com/forums/post519917.html#post519917

and witness the two egos trying to outdo each other. As they drift further from the original...

http://www.daniweb.com/forums/thread73876.html

At the end of the day there is still consumer choice.
If you don't want Vista then don't buy it. So far as I know there are no laws being passed on the matter.
The sad fact is that there...

Are you happy that both drives are installed correctly with any clean new drives correctly formatted. Are both drives recognised by Windows (Do they both show up in My Computer).

Hello,
I just wondered if there is a quick and simple way of disabling the touchpad on my cheap Advent 7109A laptop.(Usually I prefer to use my USB mouse)
Reason : While I am typing...

Sounds to me as though the ICH (what would have been known as the south bridge in older sysyems)on your motheboard may have dry joints underneath it.
One of the many functions of the ICH is the USB...

Is this the same as the time you tried to install a network card???

.
This might ring a bell!!

Whoa,whoa,whoa,
Now I'm more confused. Are you describing an example which includes the use of the ADO control. There is a fair bit here that I don't recognise.
I...

Nice one.Thanks for the reply.Having used this method with other types of variables I am sure this will work.I am working on a multiple form project and will try out this method on one of them.I will...

I shall pass this on. Thanks for the reply and I'll let you know how they got on.