Search:

Thank you for reply.
but what i want is to create new vpn connection using visual basic 6 code

Hay,
I want create VPN cnnection in visual basic 6 and give these program to my friends and they after run the program they will find the connection already created in thier pc , is there any idea...

hay all
i will give example for data
values
1
2
3
4
10
11
12

Visual Basic 6 Sp5
SQL Server 2000
--------------------------
i want to make sql select to select items between two words like

select * from items where itemno >=ab and itemno<= dr

itemno is...

Hi,
first
Program language visual basic 6 +SP5
Crystal Report 8.5
SQL Server2000

Day2(Namr of report)

the problem
i use these code so when any one click print in report view he can select...

Hay,
when i open report from visual basic 6 using viewer its give me only printer icon which only print direct to deafult printer without any option to choose another printer.
How i can choose...

Hay i want explain the report first
i have report get data from table ad also i have 5 parameters .
my question is:\
How i can make the report when the parameters enter he get only record how meet...

Hay,
I want ask how i get the value of output parameteres in visyal basic .
i write code to send input parameteres and its work fine but i want to return 3 values
1-invoice Number
2-ID of...

Which better recordet or SQL direct to insert in Multi User program to avoid any repeat numbers or conflicts ?

thank all for your replies.
About make seperate tables for each invoice type its will be make many tables instead of 2 tables can handle all.
-----
Thread 1:
1-If i use direct sql statment its...

these good idea and i want ask
1-when there is dublicate can i handle that from visual basic and who i can do these (code)
thank

My knowledge about index not too much,as i told you have dublicate value for invoiceno field and also for type field how i can make index here to accept thier dublicte values and also is it possible...

But is Index only help for fast search only or its gone help here

First thank you sotoasty to your replies.
But about dublicate values must thier is in the table becuase i will explan to you
all purchase and sales and reyurn saved in same table and each one of...

Hay all,
for first soultion from sotoasty & JP may be easier but why i need to make refresh while i get the invoicenumber from the function and in next line i save it to database.
Iand i cant make...

I will explain the procedure of open and save invoice
first
Myrec1.Open "Select * From Bill order by invoiceno", DB, adOpenStatic, adLockOptimistic


so after that the user will click new...

my invoice system used in network (20pc's)
i use visual basic 6 + SQL server2000 +Crytsal Report 9.5
Problem:
Some times when there is many clients save new invoices they get same invoice number...

Hay,
I want make report that give me details of balance periods
like some one his balance 5000 since more than 1 year,
before 5 says he take 1000
so now his balance =6000
but the report give me...

i but thes connect when call report (i have 2 servers seperate )
Report22.Database.LogOnServer "P2soledb.dll", server1, stockbase

but when i run my program its give data link properities box to...

1-The code i use to connect visual basic to SQL Database

DB.Open "Provider=sqloledb;Data Source=server1;
initial Catalog=stock;Persist Security Info=False;
Integrated Security=SSPI"


then i...

I have reports in my visual basic project and i but database oben by code in project to example server1
and also when create reports i assign server1 to report in my project
but how i can change...

STILL SAM PEOBLEM BECUASE EX
MB100021
MB321344
TR121111


I WANT RECORDS FROM MB100021 TO MB323333

i do it as you say but and works fine but when i change the numbers in where line from number to parameter its return out of range data again



Declare @fromitem varchar(15), @toitem varchar(15)...

Declare @fromitem varchar(15), @toitem varchar(15)
set @fromitem=10
set @toitem=60
select categoryid,categoryno ,@fromitem , @toitem from category
where categoryno>=10 and categoryno<=60
...

Hay
I have report connected to stored procedure(with parameters) (sqlserver2000)
, and thes stored procedure have to option first one return 4 fileds and
the second return 5 fileds .
When i run...