Search results

Hi hillsee Here's some VBA that doesn't have the usual 3 Cond Format limitations; This code works on column 'A' & you add the Cells value (in place of where I have put 'yes', 'value' & 'ENCYCLOPEDIA' ) you want to change the colour to. You could change it to format column 'B' if the...

Hi I have a db with frm_team with an ID autonumber & 3 unbound fields - Player, Team & Position. There is a Subform that also has the Player, Team & Position fields & a Checkbox to designate the Captain of the team. I need the frm_team fields to update to the records from the subform where...

Hi Again I noticed that the requery runs the query but I need it to only show the records for frm_mains ID field. I'm finding that as I move through frm_mains records, the query result is the same whereas I need it to change for each records specific choices. Is there a need now to use...

Thanks vbaInet I should have thought of that... Thanks also smig for the code.

Thanks vbaInet Yes, the combo is bound, I've got to the stage of creating a file & the query works up to entering the results into the combo box, could you suggest what code or examples of where I can find some similar examples to complete this part? So to repeat what I want to do, the user...

Hi I have a form (frm_main) with an autonumber field called 'ID' & a Combo Box called 'cbo_chosen'. It (frm_main) has a subform (sfm_others) containing a Checkbox & a text field (txt_others) - 'txt_others' contains various names. The user will go to the subform & check various checkboxes...

Perfect!! Thanks for your patience & the response, I couldn't think past vba for this type of issue, so appreciate your aspect on this, Have a great day!!;)

Thanks pbaldy This is great, but what steps did you take to get it to work? Going to design view & focusing on the Member checkbox, the whole form , the label, you name it, won't allow me to select Conditional Formatting?? How did you get it to be available to use here? Cheers

Hi pbaldy I've attached an example database I am using to test this code. The 'slgfrm_example' is a Single form that shades the 'Prod' field green if it is populated - using vba code. The 'Datasheet' form is the one to apply Conditional Formatting to, if you can show me what you mean I'd...

Hi pbaldy An example would be best to show me what you mean as I still don't fully understand. Thanks Dairy Farmer, for the syntax of the empty field. Appreciate both responses. Thanks

Hi Again pbaldy Is it possible for you create a database with one table, one form created from the table & apply shading using Conditional Formatting? I'm clearly doing something different to you & would like to use it if you can show me how. Thanks:)

Hi pbaldy I do believe you but when I tried to use Conditional Formatting, the option was greyed out unless I used a text field but I need to use a Checkbox. I tried getting cond formatting to be available from the form, the field, the row - all were greyed out as an option so I wasn't able...

Thanks I got it to work to shade just a text field with the below code but not from the Checkbox & also not on a Datasheet form. So I could add the conditions that if 'PROD' is populated, colour all the fields a certain colour. It will work on the field background for a Single or...

Thanks Now I'm getting an 'Invalid Qualifier' error for 'CurrentRow'. Changed it to [Member] as well but got the same error. The code recognises that Member is now true but I need to know what will cause the row to change its background colour when this is true. Can anyone help with the...

Thanks I did get the formatting to work but not using a Checkbox field. I need it to work on the basis of if the Checkbox is ticked, the row is shaded in a background colour.

Hi Pbaldy Yes, but that option is greyed out in normal & design view, that's why I thought vba would be the answer. Can you assist with my code at all?

Hi I've looked at many examples of how to do this but can't find one to do exactly what I want. I have an Access 2003 form (frm1) in datasheet format with several fields, one being 'Member' which is a checkbox. I want the entire row to be shaded a colour when the Member checkbox is ticked...

That's right, The code will operate by itself, I found the reference to a post about DetectIdleTime, Thanks

Hi DCrake I've tested the number figure in this code & using '5' = 5 seconds for example & it does work but this detail is not so important to get this proc to repeat (which is my question) I've already tried changing the settings & that's why I am trying vba. No I can't be sure if...

Hi Do you want to use VBA or Excel formulas? Maybe, several Excel formulas or nested Excel formulas would work but otherwise VBA would be able to do this for you. Can you give some dummy sample data to get an idea of what you're trying to do?