Search results for query: *

I have been given a copy of a report (Crystal 8.5) that is used solely as a means of users extracting data to read into excel. The report on screen has, say, 20 columns, but on export to excel a further 10 columns are also present. Ideally I would like to add another column, and rename the...

I have a form and want to display a value in a text box that depends on the value selected in a combobox. This value can be found from a query, using the combobox entry. Can anyone advise me on how to do this? Cheers Les P

In our corporate environment we have some reports that are written in Crystal with data coming from an Oracle database. These can be run in two ways either within an application or alternatively directly through Crystal Enterprise. In either case if the export to pdf option is used the files do...

Can anyone tell me how I can use VBA from MS Access to locate the row in Excel that holds a particular value? My recordset will have as one of the columns a code e.g. OT1. A particular column in the receiving excel spreadsheet will have this value, and what I need to do is locate the row this is...

I have a form set up with a subform, when I enter a contract number into a text box the form ReQueries and shows contract specific data in subform (the subform shows relevant items with blank volume fields). A month is entered into another text box on the main form, then data is entered in the...

I have a report that has a group total of a Formula Field. I would like to add a field into the group header that is based on these group totals, e.g. (sum of formula field 1)/(Sum of formula field 2). Can someone advise me of how to do this.

Can anyone advise me if there is a way to define a report that will show e.g. current months figures and a total for the year in the same report. Data is along lines of: Month StockCode VolumeOrdered VolumeSold Report would look something like: StockCode Month VolumeSoldinMonth...

I have two Access databases. In order to link the two tables I need it is necessary to join on three columns/fields. The three fields are jointly Indexed in the relevant tables. When I link in Crystal, clear the smart links and then manually link on all three fields and preview the report it...

I have a Datasheet subform to a main form. The subform picks up data from one table, user adds values where necessary, then I need to add records to another table based on the values entered on the subform. I have no problems updating a recordset from the main form but not sure how to go about...