Search results

Scenerio: Invoice table --- invoice detal table based on invoice number 1 to many relation Have the main report that show invoice information. Within main report in detail section I have the sub-report. The sub-report will print all the invoice details info. Could be many detail lines. In...

That is what I did to make the left outer join. The main table is the Invoice table So I should get all the invoice rows and any addresses that match up on the link Don't understand it

have a report with ex: Invoice table (invoice_no, cust_no), Address_table (cust_no) Need to print invoices along with the customer address. I put a link on Invoice table (cust_no) ---> Address table (cust_no) All I get is 1 row printing. I take the link off and I get all the...

Distributing reports What about if the repor has prompts and actually go retireve data depending on these prompts. If you save it as a PDF than it is a static report at that particulare time The user wants to be able to run the report but I don't want them to go into Crystal itself where...

I am new at Crystal Reports. I have donea few reports now. I see they are stored as an .RPT files. When I click on them they opn up in Crytsal under Preview Mode. Users can than go to Details and change the report. I would like to just distribute the report out. Have them see the report or...

I havd created an OBDC connection for a Pervasive database. In my access application in one of the events I was able to access the tables in this databse. (It is a btree database). In the event all I did was to code the select stmt for the specific table I wanted. It would go and...

Okay, except the Return Date field has values in it, when it is blank then I want to replace it with the Date out field + 15 days

I would like to fill in on a report the field say: Return Date. Return Date has values coming in from a query, but if the query value is blank, then I want to show Return Date as: 15 + [Date Out] which is another field on the report How can Ichange the control source to say put an if...

Thanks guys. Here I was trying to do a recordset and some other weird stuff

Can somebody point me in the right direction for some VBA code to delete all records in a table. I know I can create a macro and call the macro, but like to do it in VBA Thanks for any help

I tried to import a spread sheet with some code. Here it is Private Sub Command0_Click() On Error GoTo Err_Command0_Click DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ImportTable", "c:/Tony.xls" Exit_Command0_Click: Exit Sub Do you know what I have...

Okay thanks for the suggestion. Will try that. Also I tried to import a spread sheet with some code. Here it is Private Sub Command0_Click() On Error GoTo Err_Command0_Click DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ImportTable", "c:/Tony.xls"...

have setup a link to an Excel spreadsheet. When I open the table which is linking to the spreadsheet in Access I see some cells with values of #Num! in them. I noticed that Access thinks they are numbers. The spreadsheet has a variety of values for that cell. Went back to the...