Search results

Nope... Month is a calculated in the previous query using the following query: SELECT Year([Entry Date]) AS [Year], Format([Entry Date],"mmm") AS [Month], Sum(qryData.[Billable Hrs]) AS [Total Billable Hours] FROM qryData GROUP BY Year([Entry Date]), Format([Entry Date],"mmm"); I am simply...

On a new record accessed by clicking next record on the navigation buttons at the end of the existing set, it remembers what the last visible and invisible fields were and doesn't refresh back to the standard if the invoice sent checkbox isn't ticked... If you check and uncheck that invoice...

Here you go... Click on Joe Bloggs as the client and then view existing... If you then go to the invoices tab click the edit form button to enable you to change things then click the new record button on the embedded form it will keep the same fields visible as before... If you click and...

That gets rid of the syntax error message but I still have #Error in every line of my query... SELECT qrySeniorTeamBillable.Year, qrySeniorTeamBillable.Month, qrySeniorTeamBillable.[Total Billable Hours], MyCountWorkDays(DateSerial([Year],[Month],1)) AS [Working Days] FROM...

Thanks namliam, I get an invalid syntax error and it doesn't like the AS statement... ???

I did have one big If statement with lots of else clauses... I then changed it to lots of if and end if statements... I had the same problem both ways - I'm not sure which one is technically correct but neither seem to work still... :( Any more ideas - sorry for being a pain!

All, I need to calculate the number of working days excluding weekends and bank holidays by month my current query is this: SELECT qrySeniorTeamBillable.Year, qrySeniorTeamBillable.Month, qrySeniorTeamBillable.[Total Billable Hours], MyCountWorkDays([Month]) AS [Working Days] FROM...

My code is still as above which was posted to show that this still isn't working despite me following pbaldy's suggestion... Any further ideas???

Subform On Current Private Sub Form_Current() If Not Me.NewRecord And Me.chkSent = False And Me.chkPaid = False Then Me.cmdPlanned.Visible = True Me.cmdClearPlanned.Visible = True Me.Planned_Invoice_Date.Visible = True Me.cmdActual.Visible = False Me.cmdClearActual.Visible = False Me.[Actual...

Hi, Similar code is in the on current in the subform, but that didn't work when the form was embedded so i changed the references and added it also to the on current on the main form - so it's kind of in there twice and still doesn't work...

Thanks namliam, Think this may be beyond me as although that kind of makes sense I wouldn't know where to start... So forgetting the formatting thing I am still keen to understand how I can avoid having 20 fields and obviously this will only grow and grow... Is there a smarter way of handling...

Re: UPDATED On Current for embedded forms Ok slightly new but related problem - wonder if I'm missing something obvious again... When I add a new record within my embedded form it retains the previous record's visibility settings... What i want it to do on clicking the next record button on...

I did it... I opened the properties of the embedded form and notice the name was different to the form name - so that is clearly what I was missing... Then I just couldn't understand why i would take the me. out from in front of the field when it is in there for practically anything else...

Thank you for your help - i just don't understand what a subform control is... I've pasted inserted a form inside another form so have two forms frmProject and frmInvoice... I really am sorry if I'm missing something blatently obvious... I'm just understanding the terminology...

I think I've followed that right but i still get a message that it can't find frmInvoice This is my first line: If Me.frminvoice.Form!Me.chkSent And Me.frminvoice.Form!Me.chkPaid = False Then What's going wrong??

This may be blindingly obvious... but after some hours wrestling with this I may be blind to the obvious... I have an embedded form (frmInvoice) within frmProject I have various visible and non visble settings on current for frmInvoice which work a treat when opened isolation... When opened...

I'm sorry but that makes little sense to me... :( The labels are dates but the fields are percentages - I'm not sure if this is constant or not?? I'm also not sure about strings... Yes the field txtTodaysDate just has Date() as it's default value. I wasn't sure if I needed to specify what...

We have the fields to capture % complete as at every month end we use this historically to capture actuals and for the future to capture planned profile: So it may look like a current project 30/04/2009 - 25% 31/05/2009 - 50% 30/06/2009 - 75% 31/07/2009 - 100% But we have fields that go back...

Thanks for that i think I've got it working but a but clumsy... lngGrey = RGB(169, 169, 169) lngWhite = RGB(255, 255, 255) Me.End_Jun_08_Label.Caption = "28/06/2008" If Me.End_Jun_08_Label.Caption > Me.txtTodaysDate Then Me.End_Jun_08.Enabled = False Me.End_Jun_08.Locked = True...

Hi, I have a form with a todays date text box (txtTodaysDate) and a series of fields with percentages in them... The label is a date e.g. 30/06/2008 and I want to check on the form opening or something similar what the todays date is and then lock the related text boxes If...