Can't get Dmax +1 to work

[RainLover]

I need it in 2003 please.

 

[avalon60]

I need it in 2003 please.

ooops, sorry.
Here it is in 2003 format:

 

[RainLover]

I need Glasses.

The L is missing in tblBalance.

 

[avalon60]

I need Glasses.

The L is missing in tblBalance.

It is there when I look at it...very strange.

I even downloaded the one I uploaded and checked that.

I don't know what is going on then.

 

[RainLover]

There should be TWO Ls

 

[avalon60]

There should be TWO Ls

So do you mean:

tbllBalance
OR
tblBallance

Confused.com

 

[RainLover]

Here it is in a Query.

Just open the query to see the result, then copy paste into your code.

End of day for me. Will check back in the morning.

 

[avalon60]

Opening the query, gave the result of 8 for each and every record.

I copied and pasted the query code into my qryBalance and ran it, where it gave a result of 1 for each and every record.

I then cut and pasted the said code into the BeforeUpdate event, but as ever, it did not give any results.

Interestingly, when I used the code in the qryBalance, no results were written to the tblBalance.

Thanks

 

[RainLover]

Interestingly, when I used the code in the qryBalance, no results were written to the tblBalance.

The query is only a Select Query with a Calculated Field. It is not meant to update the Table.

DMax("[CountID]","tbBalance")

I will create a Form with the code working.

It will be sometime later today.

 

[avalon60]

Aah yes, I see what you mean about the L missing, I never really noticed , but I did make sure it was right in the coding window.

Well it's the end of my day now so I'll have a look tomorrow.

 

[RainLover]

Have a look at this working example.

 

[avalon60]

I had seen that example during my search for help on this subject, and now I'll have a good look at it to see if I can adapt for my needs.

I have had a cursory look and copied to code, changing as required, but no luck yet.

I will investigate further.

Thanks