Search results for query: *

Hi I am using Ms Outlook to go through a distro list and send an email to everyone on the list. For each person, on the distro list, I create a custom report using access and send that as an attachement using a different naming convention for each person. My problem is that after I have sent the...

Hi, I am building a web page which asks the user for a filename. I capture the filename but would like to feed it into the following VB command which imports the excel data into an access(2000) table. DoCmd.TransferSpreadsheet acImport, 8, "UserIDTable", InputFileName, True The...

I used an existing report to create a new one. I removed three tables and added another one. Then I changed the grouping in the report to group using the fields in the new report. The problem is that the 2 tables I removed still show up in the Order by clause of the SQL. I tried stripping those...

I have 3 subreports in my main report. Subreport 1 is in GH1 Subreport 2 in GH2 and Subreport 3 in GH3 Subreport 1 and the first page of 2 use the same Page headers. The remaining pages of sub 2 use a different page header and Subreport 3 uses an entirely different one. Since the number of...

Thanks, we need it to be generated a variable number of times depending upon how many times each customer has requested each invoice. This value is stored in a database field for each cc customer and can change in the database at any time

Hi, Thanks so much. This is exactly what I was thinking. But is there any way we can declare a variable length array in CR8. We would definitely need it because each invoice has a different number of services to be recorded. Thanks, Leena

We are generating invoices using Crystal7 and have a summary page in the beginning. Is there any way we can have something like a "Table of Contents" on the first page of each invoice. i.e a description of different services in 1 column and the number of pages the details of that...

Hi, I am using CR7. As of now I have Group1 - Account number Group 1 header - subreport for a "summary of charges of all customers" group2 - cc Customer group2 footer - subreport for 1 cc customer for 1 account number. The way this works is 1 account number can have multiple cc...