Search results

Thanks for your interest... I'm still in testing mode at the moment, but basically I have a SubForm for inputting 'LineItems' with [Qty] & [ListPrice]. With an [AfterUpdate] event on the [Qty] control I populate the [Total] control with [Qty] * [ListPrice] (OK so far) In the Footer of the...

Hi Everyone Does anyone know how to get Access to perform all the default calcualtions before running a bit of code? I'm finding that the code which passes calculated information to another control completes before Access has had time to complete it's own default calculations. Therefore it...

Hi Ken Basically it is pretty simple (but if it can be simpler...): I have a [JobsMain] Form with a [LineItem] SubForm. On the JobsMain Form is a calculated field [TotalJobList] which collects the data from a calculated field in the Footer (notVisible) of the LineItem SubForm...

Hi again Ken Looks like the Dirty property could do it if I understand it. While the Field is updated, but not saved, it is in its 'Dirty' state? If this is correct then if Dirty is 'True' should I be able to copy the unsaved (but updated) Calculated Field data to the Table Field? Could you...

Thanks KenHigg for your speedy reply The On_Exit event works, but I have to select the field and then move off it (Exit) for the event to trigger (which is what it is designed to do). The Calculated field updates instantly when I enter data in the subform and I wanted to update the Table Field...

Hi Everyone Bit of a 'newbie' to Access 2007, but getting there. Can anyone point me in the right direction: I have a calculated field on the Main Form which I need to pass to a Table Field on the SAME form when the Calculated Field is updated. I can get it to pass the data with the [On_Click]...

Hi again everyone I have figured the code out to get the data from the Calculated Field on the form to the Table Field on the same form, but I'm still having issues trying to automate it. It will work on the [Click_Event] but not on the [AfterUpdate_Event] or [Change_Event]. I suspect the...

Just to let you know: The JobsMain Table is the main table used in the parent form CD

Hi everyone Newbie to Access 07, and I know know this should be simple but can't seem to sort it: I have a calculated field ([TotalSubList]) in the Footer of a subform; the value of which I need to pass to a field in the JobsMain Table so that I can use this value in a different form I have no...

Thanks for your assistance Linq, much appreciated... Neil: I remember reading years ago about Andycap being created, and when I think deeper, I believe it was when Reg Smyth was actually driving around Manchester when he came up with the idea of the character... not that I was ever any good at...

Hey Neileg I thought Andycap came from Manchester ;) CD

Point taken Missinglinq ;) Don't get me wrong, I am impressed with what I have seen in Access so far, I simply thought there would be a quick way of pulling the desired fields into the record; especially as you can show the additional fields when when you activate the Combo :confused: Any...

Thanksfor your speedy reply Neil Yes, I thought I would use a Combo to pick the product. In Paradox I used both the [CTRL+Space] to pull the Look-up or a Query under a button to narrow the criteria. Seriously, Is there no standard procedure to pull the required fields in? I thought this would be...

Hi Everyone We are a smallish Telecoms company in UK. We originally wrote our current database in objectPAL some 10 years ago which has run the company 1st class :) However, we have decided to redesign the whole thing in Access. Things are going OK but I can't seem to find an answer to the...