Hi Minty
The OP is saying that the CountofOffers is wrong. What he actually needs is a Count of specific Dates within the Previous Week.
So for the 8thDec he needs 3 and not 7
Hi Minty
The OP is saying that the CountofOffers is wrong. What he actually needs is a Count of specific Dates within the Previous Week.
So for the 8thDec he needs 3 and not 7
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Mike is right, you check, there are two offers noted on 30th December while the sub form shows 5 offers.I'm a glutton for punishment - here are the two totals.
Your coding needs to be more structured and logical. You method for validating data entry is very clunky, but we can have already covered that, so I'm not going to revisit it.
I have removed a load of redundant code (not all of it by any way!), and indented it properly.
Ah that wasn't clear.
A sub query or second query fixes that.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Hi Minty
Well I just knew there would be an ideal way to resolve this and your latest solution fixes everything.
I learn something everyday.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Thanks minty now it is working properly but now it is giving wrong total meter you can try changing the meter in the previous record.
I would also like to know why the offermeter query that you have used in the dashboardcount query is not showing up in the dashboardcount query.
Thank you.
Well - as a guide to helping you develop have a look at the qryOfferMeters.
Make a copy of it an play around with it, until you get the numbers you expect, or can explain why it's wrong.
Sorry, but I'm rather busy with trying to fathom out why a building contract quotation is £0.06p out between two reports.
Out of a total of >£1,250,00.00 which is obviously a rounding error somewhere, but proving a little difficult to pin down...
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Thanks now I understand everything.
Now if you just help me a little more, it will be very kind of you. With the help of Mike, I tried applying this code in various ways in the meter text box of greyshade sub form to auto update this offerdate sub form, still the meters in the offerdate sub form are not getting auto updated properly. Actual results are not available until the main form is closed and reopened.
Private Sub METER_AfterUpdate()
[Forms]![Offer_Entery]![frmGREYOFFERDates].Requery
End Sub
I have tried applying this code in every way like after update, on enter, on got focus, please help in suggesting a way.
Thank you.
Hi
The following is a Forms Reference:
So the code is making aReference to the Parent Form - [Offer_Entery]Code:[Forms]![Offer_Entery]![frmGREYOFFERDates].Requery
Then the subform named [frmGreyOfferdate]
You just need to remove [frmGreyOfferDate] as this was the Subform that I added and
replace with Minty's final working example.
Rename the Form reference Code as well
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
now i got success
Private Sub Form_AfterUpdate()
[Forms]![Offer_Entery]![frmGREYOFFERDates].Requery
end sub
thank you very much to all..........
Too slow - already fixed!
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
I asked what you had attempted, but by the time I posted it, you had already answered your question.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓