Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pdeman

    How do I make the Shell function work in MS Access 2002/3

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

    How do I make the Shell function work in MS Access 2002/3

    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...
  3. pdeman

    Excel 2003 prevent duplicates in two columns

    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...
  4. pdeman

    Excel 2003 prevent duplicates in two columns

    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...
  5. pdeman

    Excel 2003 prevent duplicates in two columns

    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...
  6. pdeman

    Excel 2003 prevent duplicates in two columns

    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?
  7. pdeman

    Excel 2003 prevent duplicates in two columns

    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
  8. pdeman

    Excel 2003 prevent duplicates in two columns

    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...
  9. pdeman

    Excel 2003 prevent duplicates in two columns

    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...
  10. pdeman

    CSS modify existing code to include hover and active states

    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.
  11. pdeman

    CSS modify existing code to include hover and active states

    ...the code and include detailed comments for all of it I would really appreciate it and actually learn more and better. Thank you and best regards ****************************CODE START*************************** <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head>...
  12. pdeman

    CSS OnClick Active state modifications to existing code

    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...
  13. pdeman

    CSS OnClick Active state modifications to existing code

    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...
  14. pdeman

    CSS OnClick Active state modifications to existing code

    ...Background or Border or Text changes to a different colour when clicked. Can anyone help me by modifying the code? Thank you and best regards ****************************CODE START*************************** <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"...
  15. pdeman

    C# copy paste and error trapping modifications to existing code

    ...entering a bad URL rather than the built in debugging window appearing. Can anyone help me by modifying the code? Thank you and best regards ****************************CODE START*************************** using System; using System.Drawing; using System.IO; using System.Net; using...
  16. pdeman

    Modify two sub routines in to one function

    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...
  17. pdeman

    Use StrComp Function to match case

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

    Modify two sub routines in to one function

    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...
  19. pdeman

    Use StrComp Function to match case

    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.
  20. pdeman

    Use StrComp Function to match case

    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;")

Part and Inventory Search

Back
Top