Search results

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.

I have managed to get this code to work, however it now allows you to enter a username and then you can enter any password you want and it will let you in?? why is this happening ? Please help (-:

That doesn't work either. What I have done is set the column bound to 1and it works fine, however I have text in the combobox that says 'Enter Username' when the form opens. that disappears when the user enters there name. Now that I have set the column bound to 1 the text 'Enter Username'...

The EmpID is numeric. If I go to the property feild of cboEmployee and click on data tab and change the bound column from 2 to 1 it works fine. If I change it back to 2 again you can login with any user and it will only except the password from the first user in the table.?

Thanks for the reply, however it's giving me a syntax error missing operator message.

Hi guys Since I have split my database I'm having trouble with this piece of code on my login form. If Me.txtPassword.Value = DLookup("EmpPassword", "TblEmployee", "[EmpID] =" & Me.cboEmployee.Value <> "'") Then MyEmpID = Me.cboEmployee.Value When you update the users password it...