Search results

Afternoon ll, How do you refresh,reload,requery the underlying queries that a report and subreports are based on? My report opens from a buttonclick on a form based on criteria in a combobox on that form. I selected one option from the combobox and then clicked to open the report. This works...

Wow.... I'd well tried to overcomplicate things! Thanks, Mandy

Sorry - I think it might be called a "tab control"? Not a "page" Thanks, Mandy

Hi all, I have a text box within a "page" on a form. this text box is used to filter one of my queries, previously I had it on the form and the syntax was: [Forms]![frm_Select_Tier_II_Owner]![cbo_Select_Tier_II_Owner] What syntax do I now require to reference the Page within the form as...

Hi, Sorry, went to the pub to grab food as figured I'll be at my desk for a while yet! ....and when I got back.... this is now working perfectly (?!?!) I must go to the pub more often! Thanks so much for your help! Mandy

Sorry... syntax is actually..... SELECT quni_MAIN_STAFF_Details_AUDIT_TRAIL.ID, Max(quni_MAIN_STAFF_Details_AUDIT_TRAIL.Record_Date) AS MaxOfRecord_Date FROM quni_MAIN_STAFF_Details_AUDIT_TRAIL WHERE ((([Record_Date])<[Forms]![frmAsAt]![FilterDate]+1)) GROUP BY...

Its really weird.... its not working: My actual sql (for the exact field names) is: SELECT ID, Max(Record_Date) FROM quni_MAIN_STAFF_Details_AUDIT_TRAIL WHERE DateChanged < [Forms]![frmAsAt]![FilterDate] + 1 GROUP BY ID It is changing it to: SELECT quni_MAIN_STAFF_Details_AUDIT_TRAIL.ID...

Mmmmm, almost.... I realised that my DateChanged format looks like this: 19/06/2008 16:50:05 will I need to change the syntax for this? Thanks, Mandy

Ah... I only have 2x employees in this Table, Mandy Smith changes her name to Mandy Jones.... Hence I need to use the Emp ID as a "group by" when doing the MAX caluc. So ForEach (EmpID) take the Max of (Date Changed) where (Date Changed) is <= (Filter Date) Thanks for your help, Mandy

Good afternoon all, I have the following challenge (!) I have 200 employee's data which is historised for changes. When a change is made to an employee (using a form) the change is date stamped and held in an audit table. I have been challenged to do the following: Run as-at reports...

Brilliant. Thanks, the visual was very useful! Mandy

Hi All, I have 2x subreports on a main report. My subreport1 is 1.5 pages long and the subreport2 is starting immediately after this. Is there any way to force subreport2 onto a new page? So if my subReport1 grows to 2.5 pages, subreport2 starts on page 3 etc? Many thanks, Mandy

Can anyone help with this please? I cant find an answer on ze tin-ter-net thanks, M

Hi All, I have 2x subreports on a main report. My subreport1 is 1.5 pages long and the subreport2 is starting immediately after this. Is there any way to force subreport2 onto a new page? So if my subReport1 grows to 2.5 pages, subreport2 starts on page 3 etc? Many thanks, Mandy

It was actually far wasier than that..... =DCount("ID","Tbl_MAIN_Staff_Details","New_Tier_II_Owner ='" & [New_Tier_II_Owner] & "' AND Synergy ='" & [Synergy] & "' AND Employee_Indicator ='" & [Employee_Indicator] & "' AND Employee_Status ='" & [Employee_Status] & "'")

My original formula (which works fine) to reference a table from the main report (a main report with no sub reports) is: =DCount("ID","Tbl_MAIN_Staff_Details","New_Tier_II_Owner ='" & [Reports]![rpt_Current_Report_Synergy_Tier_II_Owner_Count]![New_Tier_II_Owner] & "' AND Synergy ='" &...

Sorry, I meant Reports and Subreports.... (not subform) Does that make a diff? also, when calculating a count of IDs in a table using dcount, would that be "To refer to a form property, like RecordSource" Regards, Mandy

Hi All, I have a Dcount formula in a normal report that is working fine. When I try and put this into a sub form it falls over and returns #name. Do I need different syntax when doing a subform dcount? Ive been working on this for several hours and have gotten nowhere.... Thanks, Mandy

Oh, I need to basically sum up accross the row.... So if a manager has employees in Europe and North America - I want to sum the total.... Dsum was working fine in my non-subreport report.... (also attached in the samp,e db)

Ah... its actually a DCOUNT and it is in the detail section (and the subtotals) and it is the furthest column to the right under the "Total" header... On preview of the report on the "sub" report, it is the column that comes up with #Name.