Search results for query: *

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

I recently set up a WinXPP VPN server at my office. I can connect from my home machine (also XPP) but I can't access network files. The home machine can connect and verify, and ipconfig shows that I am connected with the right IP address from the server. But the subnet mask is not the same as...

Thanks very much for your response, Matt. What do you mean "create accounts for your home computers on the server at work"? I have user accounts on the server of course, but they are distinct from the account names at home. Of course, I use the server accounts to log in there. To...

Hoping that some guru can give a pointer or two... I have two networks, Home & Office. I want Home users to be able to vpn into Office. Here's my setup: 1. Each network has a Belkin wireless router. 2. Home uses a DSL modem. 3. Only static IP addresses are used. 3. I've opened tcp/1723...

Thanks guys.

Thanks for your reply. I only have 3 machines connected to the shared box at any given time. The shared box is XPP so that should be plenty.