Recent content by dan54

Yes, but each type of item (the records, CDs, and paper items) all have fields that are not relevant to the other items (for example, the field Record Code will not be relevant to the paper items).

Cheers for the help

because they have different fields can you give me any help??

Here is my problem: i have three tables, each containing stock for a music shop (one containing the stock of records, one containing the stock of CDs, and one containing the stock of paper items). I also have a 'Orders' table. When a new order comes in, i enter it into the Orders table using a...

Here is my problem: i have three tables, each containing stock for a music shop (one containing the stock of records, one containing the stock of CDs, and one containing the stock of paper items). I also have a 'Orders' table. When a new order comes in, i enter it into the Orders table using a...

Thanks

Hi Jack, i have tried the web site you suggested, and it looks like what i am after. However, i have not used Visual Basic before and havn't a clue on how to work it. Here is my problem in more detail: i have three tables, each containing stock for a music shop (one containing the stock of...

I am trying to add up values in fields from a main report and two other sub reports in one expression in the same report as the other (sub)reports are located. I have been told this will require complex visual basic code. Can anybody help. please.

Cheers for the help

Does anyone know how to change the background colour of a command button (the default of which is a blue colour) without making the 'Picture' property a filled in block of colour imported from a paint program. Any help will be much appreciated. Cheers.

Can anybody write complex VBA code???

Ive used sub reports to put data from different queries into one report (each query representing a different table). Now i want to add up values in fields from the different sub reports and the main report in one expression. Is this possible?

How can i use multiple record sources in one report i.e. use values from multiple record sources (queries) in one report.