Search results

Hi, I've got a problem with my form that is confusing me... In my form there is a section that check if a customer has signed a sheet or not. In the table its in the form of Yes/No (-1/0) so its displayed as a tick box. In my form it says "#Name" and a little yellow diamond with an...

Hi all, quick question. Is it possible to create a query based on if a tickbox is ticked or not ? how would the query work if it was based on 2/3 tickboxes ?

Any progress or any further help ?

Try this one https://rapidshare.com/files/776005554/Enquiry_Database_Test.accdb

Click on the link to download it. https://rapidshare.com/files/1756604047/Enquiry_Database.accdb The query is called "Customer Search Query"

Hi, Thanks for that however it Didn't work. It also asked for the search thing twice so like enter customer name and then it'd ask again. Do you want me to send the database ?

I'm confused. Can you explain more ? Sorry

Would this allow me to search for a specific customer name ? Say for example if I go to create a new query in design view, enter the relevant fields and put this in the customer name/number/email criteria section ? All I really want to search for is customer's first name I tried that out and it...

Hi all, I'm back again. Thank you for the help with my last question however I have another question now. I have created another database that stores customer enquiries for example the date it came in, the member of staff that handled it, the vehicle details, customers name/number, nature of...

thanks Simon! however it didnt seem to work at all :confused: I think I'll just stick with the original code that you put up!

Ive put that code in and it seems to work but it doesn't update as and when the tick boxes are clicked. It works when you i click on the refresh all button (at the top in the toolbar) or go backwards and forwards through the records. Is there a way to make it so when the tickbox is clicked it...

I certainly can, here it is: w w w.mediafire.com/?32kxjlod1sgdkis (remove the spaces because I'm not allowed to post links because I have a post count less than 10) I've deleted the previous button that i coded but the code is still there in VB just in case

It only applied it to the numeric fields. do you want me to send the database to you so you can see ? what expression would i need to use ? Ive used "Tickbox_Actioned=True"

Re: Specific font colours on forms in access I used that description but it only seemed to change number fields and not text fields. I followed the tutorial exactly and it didnt seem to work! the tick boxes did work and change it based on the relevant colours however it only changed the number...

Hi Thanks for that link!. I tried it out however it only seems to change sections of the forms that have number inputs. I want it to change both text and numbers, how would I go about that ? I want it to change the text to the relevant colours when the relevant check box is ticked

A further question I have is how do I keep the font color the way it is when I load the form ? I dont really want to have to click on process for every record. Is there a way to keep it the way it was before (i.e. if two boxes were ticked then it should go yellow and that record should stay...

Specific font colours on forms in access Howdy everyone, I had a read on this thread w w w.access-programmers.co.uk/forums/showthread.php?t=34499 (please remove the spaces) which helped me alot! however I'm come across a problem on my side. I've made a database where you input relevant...

Sorry to bump this but I have a question: Howdy everyone, I had a read on this thread w w w.access-programmers.co.uk/forums/showthread.php?t=34499 (please remove the spaces) which helped me alot! however I'm come across a problem on my side. I've made a database where you input relevant...