Recent content by eislander

That's it! thanks PAV

Hopefully one of you can help me with this problem. I need a query to take a table like: Field1 Field2 ------ ------ A B A C A D E F E G and output: Field1 Field2 ------ ------ A A A B A C A D E...

Thank you both. I'm sure both suggestions are in the right direction, but I went ahead and joined through queries using an intermediate table. It's not quite as elegant, but I don't have the time to experiment. Thanks again.

Hi all, How would I go about implementing a conditional sum/count in one field in Access 2000? For example, let's say customer C001 has two different types of transactions in April and May (A,B). What I need to do is get into one record the following: C001:count_of_A_Apr,count_of_B_APR...

Thank you both. I could use an older backup, but in this case at least I can import through the already existing link. Weird. It's really the lost queries that bother me. Thanks again.

FYI, I have tried to import and open with Shift+click, to no avail.

I just used the Repair and Compact utility on a db and now when I try to open it I get nothing. No error message. Nada. I can however, look into the database through a link in another db, and it looks like I last left it i.e. not corrupted or anything. Suggestions anyone?

It did. That was quite a brain fart. Thanks Leslie.

Thank you PHV! Your posts helped to solve the first hurdle of my problem. In a similar vein, could someone answer me this ... Say I have a table called [T_Transactions] with a field called [F_Customer_Number]. Many records in this table have the same customer number. I have another table...

Richard, Your register/flush dns suggestion worked. Thanks to you and everyone else who posted.

By the way I have another problem at thread605-629004 that I'm sure is related.

Thanks for looking at my post. Here is the situation. My office has three computers that use an offsite mail/web server. Last friday, all three Outlook installations started getting the following error whenever Outlook tried to send a message from an address associated with this offsite pop3...

Serbtastic, thank you very much for responding. Here is what I get on the errant machine: c:\>nslookup our.pop3.com *** Can't find server name for address 66.252.224.241: No response from server Server: ns1.floridabroadband.net Address: 66.252.228.241 DNS request timed out. timeout was...

Hi all, There is one computer in our office (WinXPP) where, when I try to ping, for example, our.pop3.com, I get: "Could not find host. Please check the name and try again." If I ping the numeric value of this host, I get a response. I don't have this host listed in the hosts file...

Hi everyone, I have a user with the following problem: Netscape will hang any time you try to save or load a file. For example, when using the "Save as" feature, or when downloading a file, or when trying to import bookmarks. I've already uninstalled 7.0 and installed 7.1, but to no...