Search results

thats it, its working !! your a genius !! Thank you very much !

its still not doing it for me, i have attached the database, could you please have a look at it for me many thanks

thanks for the reply and the help, but it doesn't seem to work, the formheader colour stays at else backcolour all the time, no matter what date i enter in "actual fitted date" field

sorry could you not be any more specific than that, what will the code be... is this ok below, or is it totally wrong ??

Hi, Heres what i'm trying to do : if "actual fitted date" is 6months ago or older then change form back colour to red please help !!!

any help anyone ? would this below code i found be any use ?? Between DateAdd("m", -6, Date) And Date

Hi, I'm currently using MS Access 2002. I use forms to display client info and i would like to know if the following is possible, and if so, how ? When a clients installation date is older than 6months old (date is in a text box) i would like the form's background to change colour for that...

Hi, Is it possible to draw plans (house plans) in access - draw the plan for each record - displayed on a form ?? any help appreciated

thanks for ur help, but my current customer form is very big as it is, so i would like a seperate form for each customer's history. would i need to create a seperate table for all the customer comments, then create a form which displays that, if so how would i link the history form up with the...

Hi, I currently have a "customer" form (which displays client details from a table - name, address etc) I would like to add history comments for each customer. Does anyone know how i would go about doing this. I image i could press a button on the current "customer" form that will open a...

not really the info i was looking for, anyone else ?

Hi, At my office, we currently use MS Access 2000 for all our customer details (using the tables and forms) It would be ideal if we could transfer this db into html. I would like the html to display single records on the page (very similar to form view, but using IE) and also i would like a...

Hi, My current database holds information for jobs that we have done or doing. I'm lookin to convert this database onto a intranet web based database. Where each job has its own intranet page and you can log into the database as a user and maybe search for a job and add comments/journal...

Hi, my query is: i have a form with fields on, and when i click next button to display a new form, would it be possible to enter todays date in a field. so when entering a new record i would press next and it would have todays date in one of the fields and the rest blank. would this be...

Hi is there anyway to stop the msg box saying "The OpenForm Action Was cancelled" when you cancel the query

no, it isn't the temp file that is created when you open your database. Its the same database but its been renamed "Copy Of Database". Say the orginal database's data goin back from jan this year all the way till july. in the Copy of the database which has been created mysteriously, it has all...

hi i currently have a database. for some reason it decided to make a copy of itself, but if i try to delete it, it removes some of the information in my actual database. eg/ it removes all the stuff from april onwards when i delete the copy of database help

works like a charm, cheers :D

Hi, I want to make a query where it displays everything apart from if it has say "hello" in the field. what criteria do i use ? thanks in advance

if you make a form and create a command button then it has a find button in the wizard that you can use :D