Search results

I have a relatively large database with lots of sum queries within queries which are used as a data source for reports - I suspect I didn't set it up as efficiently as I could have! For all the queries that are required to sum the cumulated data for the financial year - which in my company runs...

I have a form which I want to be printed, and as forms are not designed for printing I have designed an identical report (with subreports) displaying the data in all the fields on the form, for all records. I have put a command button on the form with the caption "Print this page", but am not...

I have a situation where I have a report with a subreport, and on that subreport are another 2 subreports. Therefore there are nested 2 levels of subreport. When I print the main report it prints the first subreport but leaves blank spaces where the other 2 should be. Clearly this is not good...

Probably a stupid question but I can live with that: Is it possible to use the same underlying query for different (but similar reports or forms)? Or do you have to copy and rename it. eg can you use qry1 as the data source for both rpt1 and rpt2?

I have a database in which i have to record data relating to companies, with a page for each new company. One of the pieces of data is key individuals who work for the company, and since this is a repeating field, i have set up a separate table called tbl KeyStaffand linked it to the company...

I have a situation where I need dates in two separate formats. Currently I have 3 fields - FollowUpDay (eg 19), FollowUpMonth (eg may) and FollowUpYear (eg 03). What I want to do is retain these, but have another field - FollowUpDate - in date/time format. So I can work with the two formats...

I'm struggling with this problem and I'm sure it's simple. I've search the forum without success for a solution, and have found it necessary to ask! I want to have a command button which when pressed makes one subform visible and another not visible. To do this I've been attempting to declare...

I'm having a problem with a query, as follows: I need to be able to enter the name of an account handler when prompted. So in the criteria section of the AccountHandler field I've got [name]. This works OK when none of the other fields have criteria. However I also need to have data for...

I have a report comprised of several subreports. One of the subreports has calculated fields based on a query using using aggregate functions (SUM). If all the amounts come to zero/null, however, the subreport doesnt show when the main report is produced. This results in a large blank space...

I've put this post in the forms forum and didn't get a reply, so I'm thinking it may be more of a VBA question: I have a tabular subform linked to a main form. The main form (not tabular) has fields including TrainingNeed, RequiredScore and ActualScore. If there is a deficit between...

I think this is pretty simple but I can't get it right! I need to design a query using COUNT in which there are two different criteria, ie Source = "recommendation" CreatedMonth = "nov" or "dec" or "jan" or "feb" (I want it to tell me how many records there are with source = "recommendation"...

I need to write VBA code to transfer information from a main form to one of its subforms if a condition equates to true. I would do this bit with the OnUpdate event of one of the controls in the main form and using If Then Else. The problem is that the subform is tabular, and I find that...