Search results for query: *

Excellent… worked a treat. Thank you very much for your help.

Hello, I am using Shell to execute files on the click of an Access button on a form. In the code below Me.filename is the value from a control on the form which is the file name and extension. It is generated and saved in the same folder as the mdb file so CurrentProject.Path completes the full...

I have been working with Skips last posted formula: =AND($A1&$B1<>"",SUMPRODUCT(--($A$1:$A$9999&$B$1:$B$9999=$A1&$B1))>1) and success. Here’s the final setup: I used row 1 as a header row typing over the value Cat with the heading MyName and the value A-34B with heading MyID. I selected...

Just can’t get quite what I need given all your help and the countless time I put in exploring the suggestions. So one last try at conditional formatting formula. This is data A B 1 Cat A-34B 2 Dog B568 3 Tree GGG5 4 Dog B569 5 Box 98-7POY 6 Car 989867 7 Plane...

Does any one know the dynamic formula I need to use for conditional formatting to highlight the whole row A through to B where duplicates are present. I have tried =COUNTIF($B$2:$B$11,$B2)>1 which does highlight duplicates across row A through to B however it only works for the specified...

One other problem which I have found is the Data Validation only seems to work if you type the entry. It does not prevent you from copying and pasting a duplicate. Is it possible to highlight a row A through B in a color where a duplicate is present as a visual safeguard against copy and paste?

Hello SkipVought Looks like I applied the validation rule incorrectly. If I highlight the entire columns A and B then apply your formula exactly as you typed it the whole thing works fine. My apologies and thanks

Hello SkipVought When I place the formula in column C (just as a test) and drag it down it does show true or false however when I place it in the Data Validation box and set an Error message (check box to display message is ticked) the error message never displays for me and I can type...

Hello I have a spreadsheet with 2 columns A and B this is an example of my data: A B 1 Cat A-34B 2 Dog B568 3 Tree GGG5 4 Dog B569 5 Box 98-7POY 6 Car 989867 7 Plane TTT-9-0 8 Boat A9-A9-X789 9 Horse B7709G 10 Tree GGG3 11 Dog B568...

Hello traingamer This is a different CSS and a different scenario I tried to apply the modification from the other post to this but of course it won't work because this is a different CSS.

Hello I have the following code which creates a rounded corner box using only CSS and no images and works in IE. I need to modify the CSS to include hover and active states so that the box Background colour changes to white when the mouse hovers over it and yellow when it is clicked. Can...

Hello Vragabond Thank you for your reply. I clicked on your link 'active example' and it still won’t work for me. I’m running IE8. Interestingly when I change active with focus like you mention it does work so this must be the solution I guess. Thank you for your help and time I have learnt...

Hello Vragabond Thank you for your reply. I tired your modification however it does not seem to work. If I delete the Strong from the CSS then it works but only if you click in a certain place which is no good. Anyway deleting the Strong from the CSS changes the way the script works which also...

Hello I have the following code which creates menu or rollover buttons with rounded corners using only CSS and no images and works in IE. I need to modify the CSS to include the OnClick or Active state which I think it is called in CSS so that the button Background or Border or Text changes to...

Hello I have the following C# code which I compile to a windows exe. However there are 2 problems I need to resolve: 1) It contains 3 list boxes which require modifying to allow you to copy and paste the contents. 2) The first box where you enter the URL needs modifying to trap errors from...

The only reason was the modifications to overcome the way the current code works. I thought these changes might make one new routine better than two modified ones either way works for me it’s the changes that are important. As I explained: At present when the code runs it selects the dap in...

Hello all, Excellent. Both work fine. Will stick with the StrComp in this instance. Thanks to everyone for contributing to this thread.

Hello, I have the following two sub routines (please see below). I need them to be combined in one function. The subUpdatePageLinks must run before the subUpdateConnStr. Also at present when the code runs it selects the dap in the database window making the database window visible even if it...

Hello TheAceMan1, Thanks for your response. I tried the code but it generated the same error I was getting with my code. This is the error: Error 2465: Microsoft Access can't find the field '|' referred to in your expression.

sorry there is a typo: I have tried: Set ValidPassword = CurrentDb.OpenRecordset("SELECT * FROM tblLogonPassword WHERE " & _ "UserName='" & Forms![frmLogonPassword]!txtUserName.Value & "' AND " & _ "StrComp([Password], Forms![frmLogonPassword]!txtPassword.Value,0)=0;")