Type: Posts; User: fahedksa
Search took 0.01 seconds.
Thank you for reply.
but what i want is to create new vpn connection using visual basic 6 code
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...
February 19th, 2005, 08:27 AM
i will give example for data
February 15th, 2005, 07:38 PM
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
January 7th, 2005, 07:57 PM
Program language visual basic 6 +SP5
Crystal Report 8.5
Day2(Namr of report)
i use these code so when any one click print in report view he can select...
December 26th, 2004, 11:21 PM
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...
December 14th, 2004, 07:09 PM
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...
October 13th, 2004, 05:06 PM
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
October 10th, 2004, 02:08 PM
Which better recordet or SQL direct to insert in Multi User program to avoid any repeat numbers or conflicts ?
October 8th, 2004, 10:55 PM
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.
1-If i use direct sql statment its...
October 8th, 2004, 02:46 PM
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)
October 8th, 2004, 12:11 PM
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...
October 8th, 2004, 12:00 PM
But is Index only help for fast search only or its gone help here
October 8th, 2004, 11:39 AM
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...
October 8th, 2004, 11:19 AM
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...
October 8th, 2004, 09:28 AM
I will explain the procedure of open and save invoice
Myrec1.Open "Select * From Bill order by invoiceno", DB, adOpenStatic, adLockOptimistic
so after that the user will click new...
October 8th, 2004, 08:51 AM
my invoice system used in network (20pc's)
i use visual basic 6 + SQL server2000 +Crytsal Report 9.5
Some times when there is many clients save new invoices they get same invoice number...
July 20th, 2004, 09:38 PM
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...
September 24th, 2003, 04:04 AM
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...
September 24th, 2003, 03:09 AM
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;
September 23rd, 2003, 06:30 AM
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...
September 3rd, 2003, 05:04 AM
STILL SAM PEOBLEM BECUASE EX
I WANT RECORDS FROM MB100021 TO MB323333
September 2nd, 2003, 12:41 PM
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)...
September 2nd, 2003, 11:45 AM
Declare @fromitem varchar(15), @toitem varchar(15)
select categoryid,categoryno ,@fromitem , @toitem from category
where categoryno>=10 and categoryno<=60
September 1st, 2003, 03:30 AM
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...
Click Here to Expand Forum to Full Width