In my report in section Details I use a formula field like this:
NumberVar A := A + ..Any Calculate..
it work great and another formula field in Report Footer with this:
WhilePrintingRecords;
NumberVar A;
and it work's!
How I get SubTotals in my Group Footer #1 from formula field in section...
with DAO, I want to save and read pictures.
I use this
CommonDialog1.Filter = "Bitmap (*.bmp)|*.bmp|Jpeg (*.jpg)|*.jpg|"
CommonDialog1.Action = 1
Image1.Picture = LoadPicture(CommonDialog1.FileName)
<< this work great >>
.......
<< but, when run this >>
MyDS.AddNew
MyDS!YourPic =...
I send a variable string from VB6 to a report made in Crystal 8.5
when I do this send me this message
"The matching " for this string is mising."
help me to fixed!!!
I have Win2000 and Panasonic Printer KX-P1150.
I'll have to print a voucher with this dimension:
width = 9 inches or 22.86 cm
heigth = 5.5 inches or 13.97 cm
I create a custom papersize in "Settings\Printers" on Windows, but, when I use in VB6
Printer.PaperSize = vbPRPSUser...
I use CRW 8.5
I have 2 tables in my report
TABLE 1 TABLE 2
ID ID
DATE DATE
ORDER ORDER
NAME AMOUNT
... ...
Links are (ID, DATE and ORDER), my report use all fields from Table2 and field NAME from Table1, when I do a preview, field NAME is blank.
How...
When I do
"SELECT SUM(Table1.Field1) as VariableSumField1 " _
& "FROM Table1, Table2 WHERE Criteria"
this work great!
Now I want use other fields from both tables. I try this
"SELECT SUM(Table1.Field1) as VariableSumField1, " _
& "Table1.Field2...
I have the follow line in my code:
Set SN = DB.OpenRecordset("SELECT * FROM Sales WHERE ID LIKE " & ID_Temp, dbOpenSnapshot)
When Table Sales have 1 record, SN.Recordcount return 0 and my application send error 3021.
How solve this?
The follow code works, when I search a complete names like "MARK", but when I search names that begin with letter "M" (for example), DataGrid Control is in blank
this is the code:
Dim con As ADODB.Connection
Set con = New ADODB.Connection
Dim rs As ADODB.Recordset...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.