Search results for query: *

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

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!!!

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.

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.

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!

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

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

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

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

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

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

Isn't this the most helpful site!

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

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

Wow! so easy and it does work. Perfect

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

Thanks! that did it.

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!

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

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.