Search results

Hi Thank you for your fast response. I've checked all the child/parent links for all the subforms and they are working as expected. I don't get a vba error so there is nothing for the debugger to show, it's an Access dialogue error and it happens as soon as I select any field in the subform...

Hi, I'm trying to work out how to fix an error, but can't quite get my head around loading recordsets. Any assistance would be appreciated. I have a button on the switchboard to "Add New Invoice". When pressed this opens "frm_MainInput" and hides navigation buttons : Private Sub...

This worked perfectly. Thank you

Ahh I see ! Thank you :)

OK, So I was playing with the GROUP BY options and got this to work with the Expected field value. I set all calculated fields in the Row heading to Expression. Only the Column Heading had to be a group by so I couldn't use the Expected value there. TRANSFORM Sum(tbl_MainData.InvoiceValue) AS...

Ahh I think it may be a grouping issue and this affects Crosstab queries I recreated the query as a select and it let me choose the fileds in the Expression Builder and ran no problem with created fields in other calculations : SELECT Format([Expected],"yyyy-mm") AS SORT...

Hi, I have a form with a combo box to control the parameter running a report. It's a year select and I would like to add this year to an unbound text box in the Report Header. If Me.[cmb_CashFlow] = "Run" Then If Me.cmb_FinancialYear = "All" Then FYtitle = "All"...

Hi, I wonder if this is possible... I have a combo box to select a list of years generated by a query. Can I add the value ALL into the list ? Example : ALL 2016 2015 2014 2013 etc... I have "ALL" set to the default value and it appears selectable as long as the dropdown isn't selected as it...

Just to clarify this is all same query, but different fields in that query. There are 4 fields in this query : Expected : The scheduled date + the term days + days to pay FY : Find the financial year that the Expected date is in Sort : A yyyy-mm formatted version of Expected for the column...

Hi, Just curious. Is there a way to add a created field to another field in a crosstab query ? I've created a field called Expected: DateAdd("d",Nz([DaysToPay],30)+Left([terms],2),[ScheduledDate]) This gives me a date on which I can expect my invoice to be paid. When I want to use this...

Hi, I have a an invoicing database that has a main/sub form setup. Each subform row has a unique RowID and an InvoiceID - the InvoiceID is the field that connects the sub to the main. I want to add a "Next" button that advances the main form InvoiceID without going through all the rows in the...

Hi, I'm using a form to return searched values in a subform and then have the ability to generate a report. Adapted from this awesome code : http://www.access-programmers.co.uk/forums/showthread.php?t=99353 I have this working perfectly, however I would like to give my users the ability to...

Wonderful. That did it ! I couldn't work out where I had to change the format !

Hi, Thanks for your reply. I'm using calendar controls on unbound text boxes for the input of txtGreaterThan and txtLessThan to avoid user input error. I also tried creating txtUSGreaterThan with the control source as =Format([txtGreaterThan],"mm/dd/yyyy") and running the query on that but...

Hi, I'm adapting the search form example posted here : http://www.access-programmers.co.uk/forums/showthread.php?t=99353 Instead of a Min/Max age, I'm attempting to use dates and have run into a bit of an issue. This code uses the form inputs to build a recordsource query and I'm wondering if...

Ahhh I think this is because it's not a new record in theview, but an existing one that seems to have snuck in without the check. How can I amend the above to either undo or delete the viewed record if the ProjectCode field is empty ?

Hi, I have a main/sub input form and have a close button that should check if a specific field has been entered on the sub form - if it is empty then the record is not saved. I have the following existing code : Control for the Close button Private Sub btn_CloseForm_Click()...

Thank you for this, it has really helped ! I've been able to reverse engineer the formula and apply it to other situations :) Thanks for taking the time to help

Hi, Thanks for your assistance with this. I'm still not able to get it to work and I can't work out why. I have made a very very basic database but still can't get this to work !! Hopefully it will be fairly obvious what I'm trying to do. In brief, I just want a field on a form to return the...

I have updated this and there is nothing ... no errors no values. When I change the drop down nothing happens. When I look in design view the field has a green triangle error that states : "Invalid Control Source : Control Property" Circular Reference Surely this can't be this difficult ? I...