Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
vb6,dataenvironment, excepting textbox input to sql statements
Yes, but did you try: ...WHERE DATE BETWEEN #" & TEXTDATE1.TEXT & "# AND #" & TXTDATE2.TEXT & "#"- slupton1
- Post #5
- Forum: Visual Basic (Classic)
-
accessing a crystal report via MSDE (log on infos)
What you're asking is not directly related to MSDE, rather it has to do with trusted connection or id/password connection. You may be able to gain trusted connection by simply setting password and id to "" (empty string). Otherwise make the password and ID empty and add...- slupton1
- Post #4
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Table Aliasing
You're simply using incorrect syntax for CR aliasing. Don't use the keyword "AS" at all. I'm only showing a portion of one line here, but instead of "INNER JOIN "IGSVIEW".ORGANIZATION ORGANIZATION AS ORGANIZATION_1" use this instead INNER JOIN...- slupton1
- Post #5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
How to have running total through main report + subreports.
Fairly straight foreward using shared variables. Create these 4 variables: 1) In your main report section header (Where you have Section 1) declare/initialize WhilePrintingRecords shared numbervar QtyOH := 0 2) In your 1st sub report footer (wherever the total quantity is known)...- slupton1
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
