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 Rhinorhino 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. Tiggertoo

    Flash player 10 (and 9) causes IE to close

    I'm not a programmer. My husband just wants to work the jigsaw puzzle. With both flash 9 and the newer version 10, we get a message that an error has been encountered and IE must close and it is always flash*.ocx causing the problem. Sometimes it is so bad that it closes IE before you can open...
  2. Tiggertoo

    Encrypting an Excel file

    Thanks for all the info. I know that lots of companies block .zip files due to the possibility of viruses. Some of the tools available only work thru Outlook which we don't use. I'll check out all your suggestions. Appreciate all the help. Thanks!!!
  3. Tiggertoo

    Encrypting an Excel file

    Is there something besides the password option to protect an excel file with sensitive data. This needs to be emailed but I'm very concerned about security risk. I haven't logged onto Tek-Tips for a while (major job change) but I've always gotten great response from you guys.
  4. Tiggertoo

    Need to track content changes on an excel spreadsheet

    Does anyone know how to look at a spreadsheet and determine what has been changed over a period of time... Need to know what data has changed.
  5. Tiggertoo

    Excel Countif Function

    Wonderful. It Works! Not only that your reply was SO QUICK. Now I can send out the spreadsheet to the world this afternoon and without having to sit and count. Thanks!
  6. Tiggertoo

    Excel Countif Function

    On my spreadsheet I'm trying to create a formula to look at one column and if a cell in that column has "retest" then it will look at another column/cell and if that cell is "C" it will count it.. 1 Column A Column B Column C Column D 2 XXX 1 xxx open 3 xxx...
  7. Tiggertoo

    Unmatched query wizard

    thanks. I'll give it a try. Sometimes I suffer brain fade and just need someone to put things in very simple terms...
  8. Tiggertoo

    Unmatched query wizard

    I'm sorry. You have totally lost me. Step by step what am I doing??
  9. Tiggertoo

    Unmatched query wizard

    I can use the unmatched query wizard to find items between 2 tables that do not match or by changing the parameter to "is not null" can find those that do match. But how can I get a query to match 2 fields. I have 2 spreadsheets of data both using first and last names with lots of other...
  10. Tiggertoo

    Unlink tables and change text field to date

    Okay, I can convert the dates but I still cannot copy the table (export or import) without the link being retained to the live database. Any suggestions? This db has an unbelievable number of tables and I really don't want to have to recreate each one with all it's definitions, etc. If I...
  11. Tiggertoo

    Unlink tables and change text field to date

    I have a database that is linked to a backup of a live db. All my tables are linked which means I cannot change anything only query data. What I'd like to do is be able to copy a table (structure and data) to another database without linking the two (an import left them linked). Then I have...
  12. Tiggertoo

    Query using =iif(isnull plus a comma and

    Isn't this the most helpful site!
  13. Tiggertoo

    Using VB how do I get rid of the ending ","

    That worked perfectly. Thank you! I couldn't create the Access dbs that I do without Tek-tips!
  14. Tiggertoo

    Using VB how do I get rid of the ending ","

    No I really don't speak VB of whatever this is... I stole it and customized to my needs... Private Function PlatformSelected() Dim Platform As Variant Dim strItems As String For Each Platform In Me![lstPlatform].ItemsSelected() If Len(strItems) <> 0 Then strItems = strItems strItems = strItems...
  15. Tiggertoo

    Query using =iif(isnull plus a comma and

    Wow! so easy and it does work. Perfect
  16. Tiggertoo

    Query using =iif(isnull plus a comma and

    This is what I have IT: ([ITOwn1] & ", " & [itown2] & ", " & [itown3]) Unfortunately if a field is null you end up with a comma or two ,,Joe Smith I'm hoping to write something like IT:=iif(isnull(([itown1]),"",([itown1]&", ")(isnull(([itown2]),"",([itown2]&", ") etc In other words if...
  17. Tiggertoo

    Multi-select list box

    Thanks! that did it.
  18. Tiggertoo

    Multi-select list box

    Looking for the Your first option (FirstItemSelected, SecondItemSelected, ThirdItemSelected... etc). I copied some one else's code so I wasn't aware that there was a carriage return & line feed... can I just remove that and what is it? Thanks!
  19. Tiggertoo

    Multi-select list box

    After much searching in GOOGLE I've come up with... Surely there is someone in Tek Tips who can help?? Option Explicit Private Function DivisionsSelected() Dim Divisions As Variant Dim strItems As String For Each Divisions In Me![lstDivisions].ItemsSelected() If Len(strItems) <> 0 Then strItems...
  20. Tiggertoo

    Multi Select List Box

    Oh, well. Looks like no help here. Guess I need someone to hold my hand and walk me thru this. I get pointed in directions but when you don't know what you are looking at it is difficult to figure out what needs to be done and how to do it.

Part and Inventory Search

Back
Top