Coding help!!!!

[mike60smart]

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

[deepaksharma]

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.

Mike is right, you check, there are two offers noted on 30th December while the sub form shows 5 offers.

[Minty]

Ah that wasn't clear.
A sub query or second query fixes that.

[mike60smart]

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.

[deepaksharma]

Ah that wasn't clear.
A sub query or second query fixes that.

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.

[deepaksharma]

Ah that wasn't clear.
A sub query or second query fixes that.

I have removed sum in total meter field from dashboardcount query now it is working properly now please just tell me why offer meter query is not showing in dashboard query thanks

[Minty]

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...

[deepaksharma]

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.

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.

[mike60smart]

Hi

The following is a Forms Reference:

[Forms]![Offer_Entery]![frmGREYOFFERDates].Requery

So the code is making aReference to the Parent Form - [Offer_Entery]

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

[deepaksharma]

now i got success

Private Sub Form_AfterUpdate()
[Forms]![Offer_Entery]![frmGREYOFFERDates].Requery
end sub

[deepaksharma]

thank you very much to all..........

[Minty]

Too slow - already fixed!

[deepaksharma]

Too slow - already fixed!

Please i dont't understand what you mean...

[Minty]

I asked what you had attempted, but by the time I posted it, you had already answered your question.