Dell Notebook: Inspiron 630m

jackyap84 — Thu, 15 Feb 2007 21:39:23 +0800

Just want to double confirm here, is it the Dell notebook Inspiron 630m has the built in Bluetooth? I can see that is the indicator light for Bluetooth. The problem is, I try to go to Dell official website to download the Bluetooth driver for it, I able to download the driver but I failed to install it.

Anyone has any idea? Or better driver for it if it has a built in Bluetooth technology??

Linksys AM300 ADSL Modem

jackyap84 — Sat, 18 Nov 2006 05:01:51 +0800

May I know is it this ADSL router only allow 1 particular PC to login for the setting page via web? I have facing this problem now. I connected AM300 to a switch. One I login using 1 of the PC to setup it, after that I try using another PC which connected to the switch to access it, it not allowed.

Anyone can show me on this?

Sound Driver For Asus Motherboard P5RD1-V

jackyap84 — Tue, 11 Jul 2006 07:26:31 +0800

I just brought a new Asus Motherboard P5RD1-V. I have installed all the driver included sound driver. But unfortunately, system still can't detected sound driver and prompt errors. Any body can guide me?

Transparent Barcode

jackyap84 — Wed, 31 May 2006 23:23:15 +0800

Is it there is transparent barcode available? Mean that the barcode label is transparent, it is possible to read it using barcode reader too.

Print Function In VB6

jackyap84 — Mon, 20 Mar 2006 02:32:45 +0800

Attach is the form which i desired to print. What is the simple command to print the form?

SQL Command

jackyap84 — Sat, 18 Mar 2006 19:56:00 +0800

How to group the date in Month for the below details:

3/10/2006 , profit = 150
3/15/2006 , profit = 210
3/21/2006 , profit = 300

4/11/2006 , profit = 110
4/26/2006 , profit = 120
4/30/2006 , profit = 200

I need to get the total profit for each month and group it with month. Outcome should be like below:

March = 660
April = 430

So anyone can show me the SQL command?

SQL Command Problem

jackyap84 — Fri, 17 Mar 2006 07:45:45 +0800

DB stored information for daily profit. What is the SQL command to deal with MSchart in VB6 so that the chart will show all the daily record inside the DB?

The chart should be like below:

(what is SQL command to get profit depend on the date?)
(profit)
|
|
|
|
|
| |
| |
| | |
| | |
| | |
| | | |
| | | |
________________________________ (all the date inside the DB)
(what is SQL command to date?)

SQL Server 2000

jackyap84 — Sun, 12 Mar 2006 00:41:51 +0800

How to share a database with others? I mean the other PCs have to use database in that particular PCs. How to connect to the database? Is it using service manager? But i try to using service manager, but it prompt "access denice", how to set the permission for other PCs so that can use database?

SQL Command Problem

jackyap84 — Fri, 10 Mar 2006 19:26:23 +0800

I have using VB6 to save date & time using [x] = Now. So definately will store the value into DB in "1/16/2006 12:36:27 AM" format. I want to get the date only instead of both of them. what is the SQL command to separate it so that i only get "1/16/2006 " ?

Computer Graphic

jackyap84 — Tue, 07 Mar 2006 03:24:58 +0800

Anyone can explain the coding below?

#include <gl\glut.h>

void init(void); //the initialization state function (include settting perspective and lighting)
void displayDraw(void); // all the drawing vertexes
void keyboard(unsigned char, int, int); // keyboard handler
void MenuEvents(int); // menu handler
GLfloat bred=1.0,bgreen=1.0,bblue=1.0; // plane's body color
GLfloat wred=1.0,wgreen=0.0,wblue=0.0; // plane's wing color
GLfloat bwred=0.0, bwgreen=1.0, bwblue=0.0; // plane's back wing color
GLfloat bared=0.0,bagreen=0.0,bablue=1.0; // plane's balancer color

void main (int argc, char **argv)
{
glutInit(&argc, argv);
glutInitDisplayMode(GLUT_DOUBLE | GLUT_RGB); // using double buffering and RGB color mode
glutInitWindowSize(800, 600); // set window set to height 800, weight 600
glutInitWindowPosition(0, 0); // set the intiatial window position to 40,40 from top left
glutCreateWindow("Aeroplane ?????????????"); // set the program name
init(); // call function init()
glutDisplayFunc(displayDraw); // display callback function
int bodymenu, wingmenu, backwingmenu, balancer;
bodymenu = glutCreateMenu(MenuEvents); // Adding menu to the program
glutAddMenuEntry("Red",1);
glutAddMenuEntry("green",2);
glutAddMenuEntry("blue",3);
glutAddMenuEntry("yellow",4);
glutAddMenuEntry("cyan",5);
glutAddMenuEntry("magenta",6);
glutAddMenuEntry("white",7);
wingmenu = glutCreateMenu(MenuEvents);
glutAddMenuEntry("Red",8);
glutAddMenuEntry("green",9);
glutAddMenuEntry("blue",10);
glutAddMenuEntry("yellow",11);
glutAddMenuEntry("cyan",12);
glutAddMenuEntry("magenta",13);
glutAddMenuEntry("white",14);
backwingmenu = glutCreateMenu(MenuEvents);
glutAddMenuEntry("Red",15);
glutAddMenuEntry("green",16);
glutAddMenuEntry("blue",17);
glutAddMenuEntry("yellow",18);
glutAddMenuEntry("cyan",19);
glutAddMenuEntry("magenta",20);
glutAddMenuEntry("white",21);
balancer = glutCreateMenu(MenuEvents);
glutAddMenuEntry("Red",22);
glutAddMenuEntry("green",23);
glutAddMenuEntry("blue",24);
glutAddMenuEntry("yellow",25);
glutAddMenuEntry("cyan",26);
glutAddMenuEntry("magenta",27);
glutAddMenuEntry("white",28);
glutCreateMenu(MenuEvents);
glutAddSubMenu("body color",bodymenu);
glutAddSubMenu("wing color",wingmenu);
glutAddSubMenu("back wing color",backwingmenu);
glutAddSubMenu("balancer",balancer);
glutAttachMenu(GLUT_RIGHT_BUTTON); // attach the menu to the right button
glutKeyboardFunc(keyboard); // keyboard callback
glutMainLoop();
}

void init(void)
{
glClearColor(0.0, 0.0, 0.0, 1.0); // set background color to black
glEnable(GL_DEPTH_TEST); // enable depth looking
glMatrixMode(GL_PROJECTION);
glLoadIdentity();
gluPerspective(45.0, 1, 1.0, 400.0); // set the looking aspect and ratio for viewing
glTranslatef(0.0, -12.0, -150.0); //set the object initiatial view
glMatrixMode(GL_MODELVIEW);
glLoadIdentity();
}

void displayDraw(void)
{

glClear(GL_COLOR_BUFFER_BIT | GL_DEPTH_BUFFER_BIT);
glColor3f(bred,bgreen,bblue); //plane body
GLUquadricObj *sphereObj1 , *sphereObj2, *sphereObj3;
sphereObj1 = gluNewQuadric();
sphereObj2 = gluNewQuadric();
sphereObj3 = gluNewQuadric();
glPushMatrix();
glTranslatef(0.0, 14.0, 40.0);
gluCylinder ( sphereObj1 ,10 , 0 , 15 , 20 , 20 );
glTranslatef(0.0, 0.0, -90.0);
gluCylinder ( sphereObj1 ,10 , 10 , 90 , 20 , 20 );
gluDisk ( sphereObj3 , 0 , 10, 20 , 20 );
glPopMatrix();

glBegin(GL_QUADS);
glColor3f(wred,wgreen,wblue);
glVertex3f(9.0,18.0,40.0); //plane right wing
glVertex3f(80.0,18.0,0.0);
glVertex3f(80.0,18.0,-20.0);
glVertex3f(9.0,18.0,40.0);

glVertex3f(9.0,16.0,40.0);
glVertex3f(80.0,16.0,0.0);
glVertex3f(80.0,16.0,-20.0);
glVertex3f(9.0,16.0,10.0);

glVertex3f(9.0,18.0,40.0);
glVertex3f(80.0,18.0,0.0);
glVertex3f(80.0,16.0,0.0);
glVertex3f(9.0,16.0,40.0);

glVertex3f(50.0,18.0,0.0);
glVertex3f(80.0,18.0,-20.0);
glVertex3f(80.0,16.0,-20.0);
glVertex3f(80.0,16.0,0.0);

glVertex3f(80.0,18.0,-20.0);
glVertex3f(9.0,18.0,10.0);
glVertex3f(9.0,16.0,10.0);
glVertex3f(80.0,16.0,-20.0);

glVertex3f(-9.0,18.0,40.0); //plane left wing
glVertex3f(-80.0,18.0,0.0);
glVertex3f(-80.0,18.0,-20.0);
glVertex3f(-9.0,18.0,10.0);

glVertex3f(-9.0,16.0,40.0);
glVertex3f(-80.0,16.0,0.0);
glVertex3f(-80.0,16.0,-20.0);
glVertex3f(-9.0,16.0,10.0);

glVertex3f(-9.0,18.0,40.0);
glVertex3f(-80.0,18.0,0.0);
glVertex3f(-80.0,16.0,0.0);
glVertex3f(-9.0,16.0,40.0);

glVertex3f(-80.0,18.0,0.0);
glVertex3f(-80.0,18.0,-20.0);
glVertex3f(-80.0,16.0,-20.0);
glVertex3f(-80.0,16.0,0.0);

glVertex3f(-80.0,18.0,-20.0);
glVertex3f(-9.0,18.0,10.0);
glVertex3f(-9.0,16.0,10.0);
glVertex3f(-80.0,16.0,-20.0);

glColor3f(bwred,bwgreen,bwblue);
glVertex3f(3.0,16.0,-35.0); //plane back right wing
glVertex3f(35.0,16.0,-50.0);
glVertex3f(35.0,16.0,-60.0);
glVertex3f(3.0,16.0,-48.0);

glVertex3f(3.0,18.0,-35.0);
glVertex3f(35.0,18.0,-50.0);
glVertex3f(35.0,18.0,-60.0);
glVertex3f(3.0,18.0,-48.0);

glVertex3f(3.0,16.0,-35.0);
glVertex3f(35.0,16.0,-50.0);
glVertex3f(35.0,18.0,-50.0);
glVertex3f(3.0,18.0,-35.0);

glVertex3f(3.0,16.0,-48.0);
glVertex3f(35.0,16.0,-60.0);
glVertex3f(35.0,18.0,-60.0);
glVertex3f(3.0,18.0,-48.0);

glVertex3f(35.0,16.0,-50.0);
glVertex3f(35.0,18.0,-50.0);
glVertex3f(35.0,18.0,-60.0);
glVertex3f(35.0,16.0,-60.0);

glVertex3f(-3.0,16.0,-35.0); //plane back left wing
glVertex3f(-35.0,16.0,-50.0);
glVertex3f(-35.0,16.0,-60.0);
glVertex3f(-3.0,16.0,-48.0);

glVertex3f(-3.0,18.0,-35.0);
glVertex3f(-35.0,18.0,-50.0);
glVertex3f(-35.0,18.0,-60.0);
glVertex3f(-3.0,18.0,-48.0);

glVertex3f(-3.0,16.0,-35.0);
glVertex3f(-35.0,16.0,-50.0);
glVertex3f(-35.0,18.0,-50.0);
glVertex3f(-3.0,18.0,-35.0);

glVertex3f(-3.0,16.0,-48.0);
glVertex3f(-35.0,16.0,-60.0);
glVertex3f(-35.0,18.0,-60.0);
glVertex3f(-3.0,18.0,-48.0);

glVertex3f(-35.0,16.0,-50.0);
glVertex3f(-35.0,18.0,-50.0);
glVertex3f(-35.0,18.0,-60.0);
glVertex3f(-35.0,16.0,-60.0);

glColor3f(bared,bagreen,bablue);
glVertex3f(3.0,14.0,-45.0); // plane back wing
glVertex3f(3.0,30.0,-55.0);
glVertex3f(3.0,30.0,-60.0);
glVertex3f(3.0,14.0,-60.0);

glVertex3f(-3.0,14.0,-45.0);
glVertex3f(-3.0,30.0,-55.0);
glVertex3f(-3.0,30.0,-60.0);
glVertex3f(-3.0,14.0,-60.0);

glVertex3f(-3.0,30.0,-55.0);
glVertex3f(3.0,30.0,-55.0);
glVertex3f(3.0,30.0,-60.0);
glVertex3f(-3.0,30.0,-60.0);

glVertex3f(3.0,30.0,-60.0);
glVertex3f(-3.0,30.0,-60.0);
glVertex3f(-3.0,14.0,-60.0);
glVertex3f(3.0,14.0,-60.0);

glVertex3f(-3.0,30.0,-55.0);
glVertex3f(3.0,30.0,-55.0);
glVertex3f(3.0,14.0,-45.0);
glVertex3f(-3.0,14.0,-45.0);

glVertex3f(-3.0,14.0,-45.0);
glVertex3f(3.0,14.0,-45.0);
glVertex3f(3.0,14.0,-60.0);
glVertex3f(-3.0,14.0,-60.0);
glEnd();
glutSwapBuffers();
}

void keyboard(unsigned char key, int x, int y)
{
switch (key)
{
case 'a':
case 'A':
glTranslatef(5.0, 0.0, 0.0); //go left
break;
case 'd':
case 'D':
glTranslatef(-5.0, 0.0, 0.0); // go right
break;
case 'w':
case 'W':
glTranslatef(0.0, 0.0, 5.0); // go in-front
break;
case 's':
case 'S':
glTranslatef(0.0, 0.0, -5.0); //go backward
break;
case 'k':
case 'K':
glRotatef(3.0,0.0,1.0,0.0); //turn left
break;
case 'l':
case 'L':
glRotatef(-3.0,0.0,1.0,0.0); //turn right
break;
case 'j':
case 'J':
glRotatef(3.0,1.0,0.0,0.0); //turn down
break;
case 'i':
case 'I':
glRotatef(-3.0,1.0,0.0,0.0); //turn up
break;
case 'o':
case 'O':
glRotatef(-3.0,0.0,0.0,1.0); //swing left
break;
case 'p':
case 'P':
glRotatef(3.0,0.0,0.0,1.0); //swing right
break;
case 'b':
case 'B':
glScalef(2.0, 2.0, 2.0); //zoom in
break;
case 'n':
case 'N':
glScalef(0.5, 0.5, 0.5); //zoom out
break;
case 'q':
case 'Q':
exit(0); //exit program
}
displayDraw();
}

void MenuEvents(int option) { // menu handler

switch (option) {
case 1 : // set body color to red
bred = 1.0;
bgreen = 0.0;
bblue = 0.0; break;
case 2 : // set body color to green
bred = 0.0;
bgreen = 1.0;
bblue = 0.0; break;
case 3 : // set body color to blue
bred = 0.0;
bgreen = 0.0;
bblue = 1.0; break;
case 4 : // set body color to yellow
bred = 1.0;
bgreen = 1.0;
bblue = 0.0; break;
case 5 : // set body color to cyan
bred = 0.0;
bgreen = 1.0;
bblue = 1.0; break;
case 6 : // set body color to magnenta
bred = 1.0;
bgreen = 0.0;
bblue = 1.0; break;
case 7 : // set body color to white
bred = 1.0;
bgreen = 1.0;
bblue = 1.0; break;
case 8 : // set wing color to red
wred = 1.0;
wgreen = 0.0;
wblue = 0.0; break;
case 9 : // set wing color to green
wred = 0.0;
wgreen = 1.0;
wblue = 0.0; break;
case 10 : // set wing color to blue
wred = 0.0;
wgreen = 0.0;
wblue = 1.0; break;
case 11 : // set wing color to yellow
wred = 1.0;
wgreen = 1.0;
wblue = 0.0; break;
case 12 : // set wing color to cyan
wred = 0.0;
wgreen = 1.0;
wblue = 1.0; break;
case 13 : // set wing color to magnenta
wred = 1.0;
wgreen = 0.0;
wblue = 1.0; break;
case 14 : // set wing color to white
wred = 1.0;
wgreen = 1.0;
wblue = 1.0; break;
case 15 : // set back wing color to red
bwred = 1.0;
bwgreen = 0.0;
bwblue = 0.0; break;
case 16 : // set back wing color to green
bwred = 0.0;
bwgreen = 1.0;
bwblue = 0.0; break;
case 17 : // set back wing color to blue
bwred = 0.0;
bwgreen = 0.0;
bwblue = 1.0; break;
case 18 : // set back wing color to yellow
bwred = 1.0;
bwgreen = 1.0;
bwblue = 0.0; break;
case 19 : // set back wing color to cyan
bwred = 0.0;
bwgreen = 1.0;
bwblue = 1.0; break;
case 20 : // set back wing color to magnenta
bwred = 1.0;
bwgreen = 0.0;
bwblue = 1.0; break;
case 21 : // set back wing color to white
bwred = 1.0;
bwgreen = 1.0;
bwblue = 1.0; break;
case 22 : // set balancer color to red
bared = 1.0;
bagreen = 0.0;
bablue = 0.0; break;
case 23 : // set balancer color to green
bared = 0.0;
bagreen = 1.0;
bablue = 0.0; break;
case 24 : // set balancer color to blue
bared = 0.0;
bagreen = 0.0;
bablue = 1.0; break;
case 25 : // set balancer color to yellow
bared = 1.0;
bagreen = 1.0;
bablue = 0.0; break;
case 26 : // set balancer color to cyan
bared = 0.0;
bagreen = 1.0;
bablue = 1.0; break;
case 27 : // set balancer color to magnenta
bared = 1.0;
bagreen = 0.0;
bablue = 1.0; break;
case 28 : // set balancer color to white
bared = 1.0;
bagreen = 1.0;
bablue = 1.0; break;
}
displayDraw();
}

Reporting In VB6

jackyap84 — Sun, 26 Feb 2006 01:06:54 +0800

What is the simple way to get the data from SQL2000 databse to generate report like graph or other?

Verification Command For VB6

jackyap84 — Sat, 21 Jan 2006 14:24:41 +0800

What is the command to verify the field for text box in VB6? If the text box only can accept characters, once the user key in numbers, it will prompt out a error msg. Anyone can show me the command?

The command below is only allow number to be key in.

Private Sub txtname_KeyPress(KeyAscii As Integer)

If (KeyAscii >= vbKey0 And KeyAscii <= vbKey9) Or KeyAscii = 46 Or KeyAscii = vbKeyBack Then
Exit Sub
Else
KeyAscii = 0
Beep
End If

End Sub

What is the command to verify only characyers can be key in into textbox rather than number?

Lowyat.NET: Latest topics by jackyap84

Dell Notebook: Inspiron 630m

Linksys AM300 ADSL Modem

Sound Driver For Asus Motherboard P5RD1-V

Transparent Barcode

Print Function In VB6

SQL Command

SQL Command Problem

SQL Server 2000

SQL Command Problem

Computer Graphic

Reporting In VB6

Verification Command For VB6