I obly want to call the specific data only that is A,B & C. If i input either one a ,or b it will call out thre data of all the ABC one

Ho guys i got question need to ask about the if else statement:

Can i write like this

IF CUST= "A" OR CUST = "B" OR CUST = "C" THEN CUST = "A , B ,C "

Then statement i pal is if i key either...

Thank anyways

Still not understand. Cause i so stupid can you write out the source code for me. So that i can refer from it? Please Help me thank you

Can you write out the example instead of explain it. thank you

But i not understand can you explain in detail to me

Hi guys need your helps. Now i doing the update part for my program. How to i get data from two table after i type the badge id and employee id then i will show other detail in the same form. So how...

Hi guy i'm writing a program using vb the main page when the user choose in the combo box active = yes then insert into table1 then active=no then insert into table2

Here is my code please check...

Hi guys i'm using the join statement and then display it into the data grid. the problem is table 1 and table 1 info display it together like this

Badge_ID Emp _Name Active Badge_ID Emp _Name...

1. How to create temp table?
2. sql statement insert into can give example?
3. Can you simple your word i cant understand?

Hi guys i need help on this can help me can help me to correct it. I want the inner join table 1 & table 2 not show a row in the data grid in the vb6


my sql statement is like this:
sql = "...

I don't understand what you said can you write the example for me and correct me on the sql statement

Hi guys i'm writing a vb program which got using the sql statement

i know the sql statement is using method insert

but my one is much different. The code concept is like this

If ...

Hi guys i got a problem with this i can get data from the table by using sql :-Select * from staff_badgeTracking inner join staff_badgeTrackingNew
On staff_badgeTracking.Badge_ID =...

I solve the problem already now i have another problem with the data grid

my sql statement is like this:
sql = " Select * from staff_badgeTracking " _
& " inner join...

yes the recordset i need to assign it into the data grid

Hi still have problem need you to check why like this i using the data grid but the data grid did not show anything? Came out error


ption Explicit
Dim rsTrack As ADODB.Recordset
Dim rs As...

still can not work can you write a full example and dun use the fieldname use something real like fieldname1= name or something like that?

I follow you advise give change to lost focus and set the length but i did not use the cmd search only.
the code is run fine until it go to the .open sql then is said got error.
I already declare...

Why cant move into table1 to table 2 got error in query analyzer
said syntax near error INTO. Here the code:


SELECT INTO staff_badgeTracking (400001, '12345', 'nana')
SELECT...

Hi guys i need help i want to move the existing data from table 1 into table 2 how i need to write the query. I tried the select into statement but it did not work at all. So how to do it . Please...

Here is the new code i do please help me to check this ok


Private Sub txtFBadgeID_KeyDown(KeyCode As Integer, Shift As Integer)


If txtFBadgeID = "" Then

Exit Sub

Hi guys i dont know why i can get the datas from the sql 7.0
Can help me check this code>>>
If txtFBadgeID = "" Then

Exit Sub

Else
sql = "select from...

which thread?? can explain it here

Hi,

the two table most of the detail same but one table contain new user info that badge id is active and other table contain old user that badge id is non active.

FYI: One badge id will have...

1.So the badge ID is the Main Page of my program so when user type it then it will show on the data grid which use the ADODB. connection.

2.The employee also will display at the data grid. Data...

So the code mean i can just move the data no need to write if else statement then only the sql statement ah ??

The update form will automatic get the data from sql table 1 & 2 so what code i need...

Hi guys can you all help me with this. I need to sure will the this idea can be make in vb6. I have a update command button. When click then type the badge id , it will automatic get the data and...

Hi guys i have a question need to ask. I create an application for filling up information. After filling if he want to update when press update and fill up active = from yes to No then it will remove...

Regrading to the topic can anyone help me about this and give me some example code for add and update data to ms sql 2000. I'm using the ADODB connection for the vb program!

Help me i newbie on...

Hi guys i need to ask if i have create a table then display it on the data grid on the vb program but the table have many Same ID number but different people so do it got any problem if i do like...

Datagrid Adding Columns

this is a really silly question, but i seriously dont know how to do it. How do i add a new column to a datagrid. It starts off with two, and all i want to do is add two...

Hi can i use the if else statement to decide on the information go to specific tables that i create?? The form that have fill up will be send to the table 1 or table 2 that i created at ms sql 2000...

Hi guys do anyone know how to add column inside the data grid i open the data grid properties why only got two column i want to add more also cant help me please?

It is need to using the code to...

Hi do any one know how to add info into two table.
I hava a page call add page it will add the info into one of the two table base on the active account or non active account ?

Do anyone know...

Hi guys i need some advise on do this system.
I create a system called badge tracking system the system need to display the latest or the old information that having the badge. Inside the program...

Hi guy it is possible two table information with same information expect the badge ID display it on one vb datagrid???

Hi guy i need some help on checking this table structure is right or wrong. PLEASE CORRECT id i'm wrong

tblBadgeNew
iBadgeID (Foreign Key)
iEmpID (auto number)
iActive
iRecycleStatus...

I'm a newbie in VB i want to ask if have a vb form 1 if i press the command button "ADD" it will call out the form i do vb form 2

so what is the coding for it ah??

Help me thank you

I create two table in the MS SQL server so I need to retrieve file from this two table into one datagrid in the vb programming will it be work. I have a unique key that is badge id. So when I key it...