Search results

I searched my computer for dbx and bak files but found nothing related to my missing files. I used a porgram, Recuva.com, and it located many previously deleted files, including a number of my missing email folders. I 'recovered' them and put them back into the email file structure. I do not...

Is this just for Outlook files or will it also work with OE files (dbx)? The way I understand it, because the compacting was interrupted, the computer will delete/purge files. That said, I do not find anything in my recycle bin so I am left wondering what I can do here. I see that there are...

This morning I checked email and then closed OE6. It prompted me to compact and so I did, as I have done many times before. When I got home at the end of the day, I found that my computer had experienced a 'crash'. Apparently, it was around the time of the compacting as now I am missing most...

Okay, now I feel like an idiot. I again tried the original method you suggested and it should work as when I was copying the information, I realized I should have been using paste special to paste the information as data. Hence, I can add the prefix to the data needing it, then I can move it...

Sorry for the delayed response. I have not had time to work on this until now. I have to admit I am lost at what you are suggesting that I do. As I only tinker with these applications as needed, my knowledge of them is about average. What is a sub? How do I make that macro? Sorry for the...

Does this mean I am at a dead end?

I currently have it setup so that the computer tower, the dvr, and one camera, are on the UPS backup power while the computer monitor and the other cameras are on the UPS regular power. Hence when there is a power outage, the only devices running are the computer tower, the dvr, and one camera...

First off, thank you for your quick response. Secondly, I made an error in my description. I said that when the error appears that the usb is unplugged, that I unplug the usb and plug it back in. I realized a few moments ago that I should have written that when the error appears saying the...

Hope this is the correct area for this question. I have a DVR on a stand-alone computer. The DVR is external and plugs into the USB port, with a number of cameras subsequently plugged into the DVR itself. I also have a UPS on this system such that the tower, the DVR, and one camera will have...

Thank you for your quick response. I have done as you outlined and it appears to work great except that when trying to compare the modified data, it is not a value but rather a formula. I wanted to cut/copy the modified data and paste it into another sheet for comparison. Here is the actual...

Hello everyone. This should be an easy one for many of you, although I thought it would be easy for me as well. I have a number of excel spread sheets whereby the data in one of the columns should be following a certain format, yet doesn't due to the way a third party entered the information...

Thank you Thank you Thank you Thank you very much. I knew it was simple and I knew I had done it a few times before. You are a life saver! Thanks again, Jay

I haven't used Access in over a year and I need to pull some information from a database. I currently have 2 tables consisting of 2 columns each. What I am trying to compare are accession numbers on each list and need to know which accession numbers do not appear on the second list. Table 1...

Won't this give me +/- 6 mths? I changed the value to just <6 and then added criteria in another column to only include records where the collection date for my Cytology were before the collection dates for my Surgicals.....but not the same date as. Looks like it did the trick. Thanks very...

Referring back to Peter Reid's response He gave me the expression: WHERE (((Abs(DateDiff("d",[GyneCytology1]![collection_date],[GyneSurgical1]![collection_date])))<=7)); This allowed me to pull the records from table GyneCytology1, which shared a unique identifier with table GyneSurgical1, as...

the reason for the duplicates... is because of the way this database is setup. You would think some kid put it together and not a Lab Information System Vendor. There has been lots of complaints about it from other users as well but the vendor cannot change it on the fly and we were foolish...

I have tried this.... And it seems to work as I re-ran the report. Now I have to work on getting rid of all the duplicates, which I thought I prevented in the query and table already. In Design View, I am confused how it has presented as there is now a new column...

I will give you specific info..... Pathology laboratory information system database......I pull a list of Cytology cases for 2006.....then I pull a list of Surgical cases for 2006......then I compare the two lists to see what patients have both case types. I am only interested in correlating...

I am trying to filter out information for an ODBC query I have written, to obviously make it more concise. Because our data is not set up very logically, a lot of my queries are based on text...but that is another story. My current situation starts with a simple make-table query finding...