Recent content by Neilster

Changed, thanks for the warning.

Thanks guys, however I have used this right at the start of the code and works fine for now I think. No errors so far.

What's happening is when you update a field on the main form and click on the button to open the account history form to add notes I get the error if I haven't refreshed the mail form. If I refresh the main form then click account history then add notes it works fine....

I've put the Me. in as I should have, however it doesn't like this part of the code..

Hi guys Anyone shed any light on this as it's only just started randomly doing this, would the code need to be simplified? :banghead::banghead::banghead: Cheers for any help..

Oh yeh (-: thanks Minty should have have thought of that silly me.

Well I have a txtbox with Apartment Cost and below a txtbox for 35% deposit of that. ultimately you could manually enter the value, however I was wondering if there was VBA that could perform such a task and automatically fill that in. Maybe on an After Update event.

Hi guys, I want to calculate a field using VBA, I know I can add this in the Control Source =([txtApartmentCost])*0.35 to work out 35% of the Apartment Cost. However I don't want to use the Control Source that way as it's being used on another form to run totals using DSUM. Is there away...

NICE ONE Minty!! Thanks all for your help. I can't beleive I missed the signature bit out.

Hi Guy's Anyone shed some light on this, I'm trying to pick up the signatuer from Outlook and I'm getting nothing.

Thanks for all your help.!!!!!!

Works good!

(-: so far so good! Let me test it a little more and I will keep you updated, Thanks so far though.

Yeh tried that loads of times. I just can't understand why it would make any difference if it was split or not.

What I mean is, since spliting the database to frontend and backend the code below no longer works corretly on the login form.? If the database isn't slplit then the code works fine on the login form.