in data report, is it possible to sum the value of a rpttextbox and rptfunction, like :
piolo ravales
san juan, manila
balance forwarded 2,000.00 ---> rpttextbox in group header
inv 1 1,000.00 ----> rpttextbox in detail section
inv 2 500.00 ---> rpttextbox in detail section
sub...
jojopangit
Last Activity: Oct 27 '08, 08:39 AM
Joined: Feb 27 '07
Location:
-
yes, driver properly installed and printing from word/excel works properly. -
mail merge
sir,i want to send a mail merge of outstandings of various bills to a list of customer. One customer may have more than one bill. I do not want to send many mails to the same customer. each mail merged page should countain the complete list of the bills and the total outstanding amount of each customer.
how do i do that using visual basic 6 and sql server 2000 as my database.
sample data :
tblproduction... -
printing using usb
i have a new pc without parallel port only usb port and since my printer is EPSON LQ2180 i use usb to parallel cable.i have the following code in vb6 that does not work with my current pc:
open "lpt1" for output as #1
print #1, "PRODUCTION REPORT FOR THE MONTH"
print #1, "SORT BY ASSURED"
close #1
the above code works well in my laptop with parallel port.
... -
yes sir, if its possible, because i need to have a comparative analysis of the result of the two tables, so i can trace which region lacks ctpl or ppai since they should be equal in terms of production. where can i put the string name in the query ?
thanks for your reply.Leave a comment:
-
query
need help very badly,i have two tables ppai and ctpl in sql server 2000:
PPAI
REGION PRODUCTION
CAR 1
CAR 1
CAR 1
R02 1
R02 1
CTPL
CAR 1
CAR 1
R02 1
R02 1
R02... -
Crosstab Query
hi, im am newbie in sql 2000 server and appreciate any help on my problem.
i have this data :
COC_DATE POLICY NO PREMIUM
01/02/2007 CEN001 750.00
01/02/2007 CEN002 750.00
01/02/2007 NCR001 750.00
01/03/2007 NCR002 750.00
and i need to produce the following result having each day... -
hi, tried this one but no luck again. it gave no error but my computer does not have any activity.
With oMainDoc.MailMe rge
.MainDocumentTy pe = wdFormLetters
.OpenDataSource Name:="", _
connection:="Pr ovider=SQLOLEDB .1;Integrated Security=SSPI;P ersist Security Info=False;Init ial Catalog=pami_db ;Data Source=JLU", _
sqlstatement:=" select...Leave a comment:
-
how to create mail merge with word 2003 and sql server 2000 as database
hi, i have the following command and generated an error :
"word was unable to open the data source"
any help will be greatly appreciated.
Thanks in advance.
Jude
Private Sub Command1_Click( )
Dim oMainDoc As Word.Document
Dim oSel As Word.Selection
Dim sDBPath As String
'Start a new main document for the mail merge.... -
thanks for your reply, it works well, but when i add another *row to my tbl_pay table,
CAR000001 1500
CEN000001 1000
* CEN000001 900
i got the result :
CAR 1150.0000 1500.0000
CEN 3000.0000 1000.0000
R01 900.0000 NULL
instead of :
CAR 1150 1500
CEN 1500 1900
R01 900 NULL
...Leave a comment:
-
sum from two tables with two columns
hi, im jude, im new in sql and still learning, please help me with my problem
i have two tables, tbl_pbp and tbl_pay with the following data :
tbl_pbp
policy no. premium
CAR000001 750.00
CEN000001 750.00
R01000001 900.00
CAR000002 400.00
CEN000002 750.00
tbl_pay
policy no. claim amt
...
No activity results to display
Leave a comment: