Hi, I'm trying to create a single report (please see attached mock-up), which takes data about our students, issued penalties and issued detentions, and displays them, grouped by Form, then Student and showing a list of penalties and then a list of detentions. I've zipped up a mock-up, the SQL...
We use ISA 2006 and have an FTP rule to allow our accounts software to connect to updates, which works fine when the ISA proxy server settings are configured in the application and Internet Explorer. However the Microsoft Firewall Client is install the FTP connection fails. If I check the ISA...
I'm very new to visual basic 2008 and could do with a helping hand. I've created a small windows form app with a Combobox (dropdownlist) where users can select a pre-entered productgroup. There is a TextBox where they can enter a quantity, a Label for results and finally a generate Button.
At...
I'm very new to visual basic 2008 and could do with a helping hand. I've created a small windows form app with a Combobox (dropdownlist) where users can select a pre-entered productgroup. There is a TextBox where they can enter a quantity, a Label for results and finally a generate Button.
At...
I have the following query which brings back special prices set for customers, however there are sometimes multiple special prices on the same product for the same customer. What I'd like to do is change the query so that it only returns the row with the latest expiry date (spr.validto), but I...
We have a folder called TEST which has the correct permissions set for it and does not inherit it's permissions from it's parent. Let say we have Administrator and security_group_A with Full Control set for "this folder, subfolder and files". There is a subfolder called SUB1 set to inherit...
I have the following statement, which returns what I need:
SELECT B1.Name AS Branch,
(DATENAME(dw, OH.DateTimeCreated)) as [Day Created],
(DATEPART(hour, OH.DateTimeCreated)) as [Hour Created],
OPT.Name AS HowPlaced,
NVL1.Name AS SaleType,
(OH.TotalSellPrice - OH.TotalCostPrice) AS...
This is a new one for me. A late worker last night noticed the the body of old emails was missing. Upon getting in this morning it seems that for all twelve of the our exchange mailboxes, the actual body of all existing emails in all folders (including sent and deleted) disappeared. Any...
We have a really weird problem, which has me stumped. We have a small Windows 2003 domain with 10 Windows XP SP2 workstations. We have a Watchguard firewall and everything was fine until yesterday. Now, the server can browse the internet with no problems, however none of the workstations can...
We have an XP Pro machine in an office, being used as a print server. We're fully aware of the 10 concurrent connections issues, however the timeout for net sessions has been reduced to 1 minute, which should be enough for the usage. However, when we run net sessions from the command prompt, we...
I cannot uninstall any software on our Windows 2003 standard server. Everything fails with the following message:
Internal Error 2203. C:\WINDOWS\Installer\35835c2.ipi, -2147024629
I then check the application log, which shows an error Event ID: 10005 for MsiInstaller.
I've checked and the...
We have a single SBS 2003 domain controller on our network with 15 CALs in total. Every now and then users are unable to log in and upon checking the licensing I find that the additional licenses have disappeared and it defaulted back to the five minimum. I then have to restore the licenses from...
When trying to go into Active Directory Users and Computers, I am met with the following error message:
"naming information cannot be located because: class not registered"
This is on our only server, which also has Exchange 2003 installed. This is a new one by me, can anyone help?
Thnx.
A user had Office 2000 installed which worked fine with our Exchange Server 2003. He upgraded to Outlook 2003 but then could not access Exchange 2003. He gets the following message: "Your Microsoft Exchange Server is Unavailable" It then gives you the option to: Retry, Work Offline or Cancel. I...
A user had Office 2000 installed which worked fine with our Exchange Server 2003. He upgraded to Outlook 2003 but then could not access Exchange 2003. He gets the following message: "Your Microsoft Exchange Server is Unavailable" It then gives you the option to: Retry, Work Offline or Cancel. I...
Hi,
the genius in our U.S. Head Office decided to replace the Watchguard firewalls in our U.K. office with a Cisco PIX 501, before getting me trained. Therefore I need help!!! At the moment all users can get online as the firewall is setup mainly with the default PAT configuration. However, I...
Hi,
I know that officially SBS 2003 doesn't have application mode in its Terminal Service, but I was just wondering whether there was any way of installing Citrix Metafram XP on SBS 2003 standard?
Thanks.
All NDR messages our server receives are forwarded to a designated email account. My MD then accesses this mailbox through Outlook 2003 Standard (as supplied with SBS 2003). All NDR messages appear with an attachment paperclip however there is no option to view them. If he logs in via OWA he can...
We have a new install of Windows 2003 SBS server, with Exchange 2003. OWA works fine when connecting inside our LAN, however, when anyone log in externally, they get the login in prompt and that works fine, but in OWA all of the icons on the left side and top of the screen are blank placecards...
We have a new install of Windows 2003 SBS server, with Exchange 2003. OWA works fine when connecting inside our LAN, however, when anyone log in externally, they get the login in prompt and that works fine, but in OWA all of the icons on the left side and top of the screen are blank placecards...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.