Search results

Hi, I have searched high and low and can't find any inspiration... I need to be able to within my database when creating a new project put in a proposed monthly profile based on what % complete I expect by month ends. i.e. so may be July 09 = 25% August 09 = 50% September 09 = 100% I will...

Hi - I've worked it out (just didn't know what to search for!) =IIf(([Total]=parent![Total Value2]),"Y","N") Thanks for making contact!

At present it is on the frmRevenueTypes but it could be moved if it makes things simplier... Thanks for your help!

Hi, As my title suggests I have a main form (frmProject) and a subform (frmRevenueTypes) On my frmProject I have a field called Total Value2 and on my subform a number of fields and then a field that totals them all called Total... I then have a textbox where i want to get the form to check...

Thanks for your help... I've only just discovered Union Queries and realised that I could use one for this!

Hi Leigh, Don't worry I've been busy too - I do appreciate your help! I've still got the errors i.e. if I just select Type and try and exit I get errors that should be trapped by the handler but are not and I get the confusing Access messages. If I try and close the form by clicking the X in...

Thanks for coming back to me... When I paste the sql code into my query I get an error: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' or 'UPDATE' Any ideas what could be causing that? :confused:

Hiya, This may be really easy... but I can't do it... I have a form with a subform embedded - the subform is based on a query that reads the combo box cboOwner and only displays the records that match the entry... My problem is there are three status of owner - "Operations", "Technology" and...

I've added a me.refresh on the exit button - this now commits the record and generates error messages... Problem is despite them being 3316 and 3317 messages they are not being captured by the error handler... (I've fixed the code as you suggested) and removed the validation text (but kept the...

I never knew you could do that at a table level! :o When adding a new record I can populate one or two of the fields in question and then exit - no validation problem... how?? If I try to get onto the subform without filling them all in then I get my on error bit triggered - not the table...

Whole database attached... Just try and add a new project and work down the combo boxes and you'll see what is happening... Thanks for your help!!

Still can't get this working - anyone willing to look at my database?? In summary... It is the enable/disable edit function I'm struggling with... If you open the database, select "Xyz" client and then "View Existing Project(s)/Invoice(s)" The form and subform is opened so you are unable to...

I've changed them from being required and used the code and a simple message in the validation rule and text - on choosing the first option in my cascading combos I now get this error and have to click end to clear it then it allows me to continue... So ti is still trying to validate at a field...

Ok I've worked out why my subform was dirtying itself... I had an entry that was populating On Current - I've now taken this out... The subform is now behaving fine - but I am able to shut a form that is dirty with some of my required fields empty... How???? :confused: Plus I'm still getting...

Thanks Leigh - I've placed that code in my form and subform On Error sections and changed the wording and it works... sort of... As soon as I create a new record in my main form - it creates a new record in my subform as well (was only doing this when i actually purposely dirtied the subform...

Hi Leigh, Yes this is a multi-record sub form - txtInvoiceAmount is the textbox name... Is there a way of changing the standard Access non-user friendly message that comes up if the field is null when it is marked required? (can't believe I hadn't thought of that...)

No progress over the weekend... Can anyone help?? :(

No progress over the weekend... can anyone help?? :(

Thanks Brian that did work... :D Thanks for your help!!

I have two task names within my database that I want to check if they exist together for the same project to merge them together into a new task totalling their estimated and actual hours booked against them... "WP0 - Project Management" "WP0.1 - SPM Supervision" New Task: "Project Management"...