Recent content by Gerhardc

Resolved Sorry all Never mind i got the selution to this

#value error Hi I had a re-look at that formula. If your collum A is a string and not a value then you will get that error. Now i can only assume what you wana do is that if A have something typed in you want the value of B to be taken to C. If this is so then change your formula to read as...

Hiyas Go to your spreadsheet and look at your dates for 21-25 August............your year is set to 2005 therefor the macro can not focus on a date.. Good luck

re: error with if statement i have tested your formula and it works fine with me. What i can sugest ( not that it should make a diffrence) is to make sure that all 3 collums have the same cell format, ie: number or genaral , etc. good luck

Hi there I have a database where on a form 2 fields are compared to be the same ( done with relationship). I now want a macro ( or something else) that will open a form when the data in the 2 fields are not equal. sample table= stock recieve field 1 = stock code ( recieved) field2 = stock...