Recent content by nnabbale

Hi Paul thanks for getting back to me the concept behind the saving table is as follow Every project has savings (£s) over a 12 months period (P1 to P12), I want to be able to capture the savings broken down per period e.g if the savings is £120 a year then i would capture £10 for each...

Sorry to be a pain, I would really appreciate anyone looking at this for me thanks Much appreciated

Thanks, I have tried crosstabs but Im just gambling and not sure what to do. In the table [Saving], for the same ProjectID there are multiple [Site] and for each site multiple [Plan Type], each split from P1 to P12 They are entered into the table as different rows, when i report them i would...

Hi all I would really appreciate help in trying to crack this - Im new to Access but i will do my best to explain it as clearly as possible I have the following structure Project > Multiple Units>Multiple Sites>Multiple Savings Types I have created the tables to enter the records and they...

Cool thanks - will post it now

Thank you SOOO Much Paul, that almost brought me to tears, been at it for hours. I have another question about reports can you help - I hate to impose MUCH appreciate N

I have projectID in the main form (progress/Status) which is linked to the Subform (Saving). If you look at the form on my database called Progress/Status, the savings Subform automatically loads the ProjectID from the main form and keeps the entries for that ID, i would like to open the...

DoCmd.OpenForm "Saving", , , "ProjectID = " & Me.ProjectID

Hi Paul Really appreciate your time but it still hasnt worked, still opens a new record Really frustrating!!! urrggghhhh thanks anyway

Paul I have followed your instructions and entered the following Private Sub Command48_Click() DoCmd.OpenForm "Saving", , , ProjectID = " & Me.ControlName" End Sub But it still opens a new record - apologies for being a wooz

Thanks Paul, i have created a control and used the Action Arguments control and entered the following Form Name: Saving View: Form Filter Name: [Forms]![Saving]![ProjectID] Data Mode: Add Window Mode: Normal that macro runs and takes me to the form but opens a new record each time and does...

Hi all I would really appreciate you help. i created a subform by dragging a form over another, it all works OK as it gives me details about the item Im dealing with in one screen in 2 forms (the main - 'Progress/Status' and subform - 'Saving') However there is so much detail on the screen...