Search results

Hi, I've got a new database that i am trying to get to work... It's mainly centred around budgets and actuals... I've got two tables tblBudget and tblActual With twelve fields in each... Budget Month 1, Budget Month 2 etc and Actual Month 1, Actual Month 2 etc I've managed to link these...

Hi - just figured it out needed to add more joins in and not just change the type of join! :) SELECT qryBudget.[Budget Owner], qryBudget.Site, qryBudget.[Cost Center Number], qryBudget.[Cost Center Name], qryActual.[Cost Heading], qryBudget.[Budget Month 1], qryActual.[Actual Month 1], [Budget...

Hi, I am trying to form a join of two queries, one showing budget and one showing actual... the two queries themselves work fine when i join them no matter how i change the join settings I cannot get them to show correctly i.e. for a single cost centre and cost heading have one line showing...

I may be having a real mental block but I think this is why I have built previous databases 'wrong'... I cannot figure out how I get a query to churn out a nice report with budget owner - site - cost centre - cost heading - actual month 1 - budget month 1 - etc I have previously created...

Thanks - I've got no idea how to convert back to a .mdb I'll have a look! :)

Thanks - no not month names just month numbers month 1 budget, month 1 actual etc But your advice probably holds true still... I will have actuals for each type of cost I.e. Salaries, travelling etc under each cost center... I also have the problem that I may have actuals against some cost...

Ok... It's been several years since I last touched Access and it was Access 2000 I was using - I've now been asked to build a database in Access 2010!! I'm struggling to get my head around the basics of how best to build my tables... basic structure of my data is 1 x Owner Many x Budget...

Ok... We're getting close... txtInvoiceValue =Sum([Invoice Amount (NET]) txtAmountInvoiced =Sum(IIf([Invoice Sent?]=True,[Invoice Amount (NET)]) Worked!! And I amended field on the main form to look up these textboxes which are in the subform footer... BUT my main form still hangs with the...

Ok... I thought I was being clever... I created queries for these two fields and added them to the query that's the control soruce for the form... this stopped the entire form opening just white space (no error) I then took this out of the control source query and inserted dlookups into the...

Ahhh... The fields involved are: Name: txtInvoiceAmount Control Source: Invoice Amount (NET) Name: chkSent Control Source:Invoice Sent? I'm back to thinking about the best way to do this... I've got all kinds of text boxes all over the place trying to just display the value for the single...

Still no joy... I've created two textboxes in the subform footer: 1: =IIf([chksent]=True,Sum([txtinvoiceamount]),0) 2: =Sum(IIf([chksent]=True,[txtinvoiceamount],0)) Both return #Error I'm assuming if I can't get one of these working then trying to get a textbox on the parent form to...

I'm getting a #Name? message in the textbox... I'm not sure what other info you refer to may be useful... The subform form name is frmInvoice but the name for the control is just Invoice... I was using the 0 and the result if the iif statement was false as what i wanted to display not to be...

Hi Dave, Thanks for coming back to me - I've made the changes but it hasn't improved much... Private Sub Form_BeforeUpdate(Cancel As Integer) ' perform data validation If IsNull(Me.Client) Then MsgBox "You must select a Client Name.", vbCritical, "Data entry error..."...

I've had a think about this and i think that it more data than i want to input... these projects have up to 50 tasks and we have other software that tracks those... I'm all out of ideas... I can think of somethings that may work for the display but not have the detail on a month by month basis...

Ok, I've managed to use all of these independently before but when I put them together I seem to be missing something... I have a subform (Invoice) with two fields on that are relevant... txtInvoiceAmount and chkSent I want to be able to on my parent form have an unbound field that totals...

I'm still stuck on my before update code as above - if anyone can help I really want to fix this issue and hand the database over to user testing... Last bug... For now at least!! :)

Thanks David for coming back to me - my problem is that none of our projects have that kind of flat profile we could be 50% of the way through in terms of time but only 10% of work to be done, then we leap from 10% to 60% in one month... I do need some mechanism to input and track the profile...

Thanks everyone for your suggestions... not all of them make sense as i don't know what normalise means! :) At present on my main table and as a result my main form I have Project name, number, value etc then fields called Jan 08, Feb 08 etc etc all the way to Dec 09 at present... I don't knwo...

Thanks Guys... I'm trying to go with the method suggested by HiTechCoach and have this as my before update code: Private Sub Form_BeforeUpdate(Cancel As Integer) ' perform data validation If IsNull(Me.Client) Then MsgBox "You must select a Client Name.", vbCritical, "Data entry error..."...

Hi, I have some required fields, and trying to close the form once it has been dirtied and these fields are not complete should generate my nice error message from within my error handler... Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr = 3314 Or DataErr = 3316 Or...