Recent content by Drummermoose

I've come into a slight problem. The code works great, but when I save and close it, the code stops working. I look at it and it looks as if Access has changed part of the code. SELECT DISTINCT C.Surname, L.desciption1, L.description2, L.Description3, L.Qty, L.[Despach Date], E.Name...

Excellent Thank you for your help!

Looks good! I just discovered that a few orders have two occurances of 'REG' lines therefore the orderlines are showing twice. Is there anyway to rectify this? Thanks for your help it's much CLOSER now

here's the code for the query: SELECT dbo_Customers.Surname, dbo_OrderLines.desciption1, dbo_OrderLines.description2, dbo_OrderLines.Description3, dbo_OrderLines.Qty, dbo_OrderLines.[Despach Date], dbo_Employees.Name, dbo_tblStores.StoreName, dbo_Orders.ID FROM dbo_OrderLines INNER JOIN...

Hi I'm trying to do a query in access from data on SQL server. I want to be able to display all the lines which have the same order number if one of those lines has a certain critera. At the moment I can get it to bring back only the certain line that has the critera(Suppliercode="REG"), not...

sorry - not quite right. I'll try the simple terms you used. correct - the main address is a catchall -catchall@mydomain.com the other address is the same domain, an address that is excluded from the catchall - ben@mydomain.com This address does not come through the catchall account. I hope...

Our e-mails are hosted by easyspace.com. The main e-mail address is a catch-all. The e-mail address that is setup is a standalone seperate address in the same domain setup through easyspace which works as a seperate acount. i.e - if an e-mail is sent to this address from a hotmail account it...

We have a domain to send internal e-mails. Sending e-mails internally works fine. An e-mail has been setup on the same domain but with its own address with the ISP. This address is external to building. When e-mails are sent to this address from inside the company, an e-mail comes back from...

Ok - i'm going for remote access using terminal services. We're using Windows 2003SBS - this only gives 2 cocurrent connections. We still have our Windows 2000sbs, I have demoted it so its not a domain server and linked it to the 2003sbs network. Can I use terminal services through this...

Hi! I have setup a VPN connection between two stores. The main store uses a retail program based in SQL 2000. I need to be able to connect the new store to the SQL database. The program suppliers say that we need to use remote desktop login to access the program. The only problem is that the...

I've recently been setting up roaming profiles for all users. I've redirected documents, desktop, mapped drives etc to keep profile size to minimum. This works fine. Problem: When a user logs onto a computer they've never used before and runs a program which uses MS Word 2000, the Word...

I've found the answer!! ....and it had to be a simple one that alluded me. I set the gateway settings on the server and for any static IP addresses and it worked! Next thing to look in to now is VPN... :-P Ben

Hi! Bit of background first: I have a network with approx 30 computers connected - most Win2000 pro, a few Winxp pro and a Windows 2000 Server To connect to the internet I use a 3COM officeconnect adsl wireless 11g firewall router. When I first configured the router I had to set it to assign...

Thanks for the replies. I was thinking too complicated. They've got Zone Alarm firewalls and they weren't configured to let the IP addresses through which were set by the server. Once done, it all works fine. It's always the easy answers that get past you. Thanks ;o)

We have a network with a domain and sharing an internet connection. Offices next door are waiting to have internet installed, so we are sharing ours with them. They have no server, all Win XP home, and their router is connected to our hub. I've managed to share internet connection by setting...