1) Create a temperory table fields are which you want to Place on data report
2) cnn.Execute "Delete * from temporary Table Name"
For i = 1 To lstvRegistratio n.ListItems.cou nt
If lstvRegistratio n.ListItems(i). Selected = True Then
j = j + 1
If rs.State = 1 Then
rs.Close
End If
rs.Open "select * from Registration...
yogesh2522
Last Activity: Feb 12 '07, 05:27 AM
Joined: Dec 5 '06
Location:
-
Set rs2 = db.OpenRecordse t("sale")
Set rs2 = db.OpenRecordse t("select sum(foodprice * quatity) from sale
where invoice = " & "'" & txtsearch.Text & "'")
Here you have written wrong Condition in query.
is Invoice is Text Field or Numeric
If it is Numeric then you write it as "& txtsearch.text &"
if it...Leave a comment:
-
Hi Friend,
Your Client Have Window XP Profession with Service Pack 2 right.
Then You Can Create package On Similar Platform.
This will Solve your Problem...Leave a comment:
No activity results to display
Leave a comment: