SBS firewall from Server Management
Recently I had someone trying to get into my SBS 2003 server so over the
weekend I went into Server Management and under Internet and email chose
enable firewall and all was fine. But for some reason it was not letting the
company phones get their email forwarded over. I turned off the firewall, and
since then I have not been able to get into my server via domain/remote or
domain/exchange. Any help would be greatly appreciated.
You actually haven't given us much information. Here would be my questions,
and this is by no means complete:
1) Is your SBS a single-NIC or dual...Report Filter
I want to filter out null entries from a field in my report and am
getting errors on my expressions
My Report is Sourced from a Table called "Table1", the field is
"Field1" that I want to filter out null entries.
* To filer out null entries from this field in the report shouldn't
it be simply enterring:
[Table1].[Field1] is not null (in the Properties/Data/Filter Tab"
Yes (in the Properties/Data/Filter Tab")
Can someone please assist.
>I want to filter out null entries from a field in my report and am
>getting errors on my express...Password Protect Two Sub-contact Lists
I have a regular contact list, and within this list I have two
subcontact lists. One is personal, and the other is personal business.
How can I password protect the personal and personal business lists?
Thanks for any help!
Sorry, I just realized that there's a newsgroup dedicated to contacts.
I'll post this there.
> Hi everyone!
> I have a regular contact list, and within this list I have two
> subcontact lists. One is personal, and the other is personal business.
> How can I password protect the personal and...Passwords #5
I would like to password protect a workbook so that when
the workbook is selected to open a dialog box pops up
asking for the password and after the password is entered
correctly the workbook will then open. Thanks for the the
Todd, do a save as and look under options, depending on what version you are
using and set a password to open
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address t...Problem receiving mails using VPN
I have a problem updating my folders in Outlook 2003 when I'm using th
VPN at home to connect to the Exchange server. I can however send email
with no problem.
Outlook states that I'm connected. When it tries to update the folde
showing the status "Waiting to update this folder" the Outlook icon i
the system tray tells me that "Outlook is requesting data from th
server" but nothing happens.
I can ping the IP address (and server name) of the Exchange server.
When I create a new message and try to look up the recepient from th
addressbook outlook freezes. So...Passwords
Hi, I have a password field in a database. How do I set it so that a
user can only type in 7 characters for a password. and if they type
more an error message will appear?
> Hi, I have a password field in a database. How do I set it so that a
> user can only type in 7 characters for a password. and if they type
> more an error message will appear?
You may use the ValidationRule and ValidationText of the field in the
table design view. Setting ValidationRule to Len([YourField])>7) will
raise an error in your case.
--> stefan <--
...add older HP 500"all in one" HP printer, fax, copier problem
I am not able to install a "all in one" HP printer, copier, fax, and scanner
to my PC. I have Microsoft XP professional. As I attempt to follow the
install/add on hardware directions i, in the last step, get a message of,
"sorry, we have encountered a problem and are unable to complete the install"
message. There is nothing wrong with the printer and I know it works as I
had it working before on the computer but after having installed XP pro I
left it disconnected for a long while and now am not able to get it
installed. Help me somebody by giving me instr...System Stability Report Won't Render
Running Vista HB SP2. Performance Monitor and Reliability Monitor are
running and generating data. When I click on an event in Reliability
Monitor I get a pop-up message with a red X.
Internet Explorer cannot download . (there is a space before the period)
The system cannot find the file specified.
Any idea what file it's looking for?
We have pinpointed the problem. You are using the most buggy OS ever made in
GIVE THE DARN THING UP AND UPRGRADE TO WIN7 or MACOSX
"Gary" <firstname.lastname@example.org> wrote in message
ne...Add day of week to data from external report (html)
I have a spreadsheet which lists a date and time as 1/02/2007 8:31:36
AM. I would like to be able to add the day of the week for the date in
column A. It would be preferred to have the day appear directly in the
column but would be acceptable to add a column for it.
As long as you have that date and time in a cell
as an Excel datetime then it is simply a matter
of formatting in Excel, Format (menu), cells, custom
ddd mm/dd/yyyy hh:mm
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: ...How to disable context menu options in disk management
can anybody tell me how to disable the format and change drive letter
options from the context menu which pop up when the user click on one
particular partition in the disk management option of Computer management.
...Integration Manager V10 SP4 SOP
I have created an integration for SOP entries and get a error advising that
there is no Qty Override password. However I can not see where to enter the
password in v10. It was there previously in V8. Can anyone advise where this
In GP 10, the password field for Override Quantity Shortages can be
maintained in Sales Order Processing Setup Options window (Microsoft
Dynamics GP>>Tools>>Setup>>Sales>>Sales Order Processing, Options TAB).
In Integration Manager, all passwords can be maintained in the Options TAB
in the Integr...problem with saving #2
I hope somebody can help with the following problem. This is th
I have a java application which basically writes data (integers an
strings) to an excel spreadsheet. The spreadsheet is doing th
necessary calculations and reads back the results to the jav
application. At least he is supposed to do so.
But (as you probably guessed) it doesn't. Although in windows explore
I can see he has changed the excel-file and when I open the file I ca
see the correct data he reads back older data. More precisely the dat
that has been saved when I manually open and close the...Recipients problem in received mails
We're using Exchange 2003+SP2 in mixed mode with Exchange 5.5 SP4.
Most of the user mailboxes already moved to new Exchange server.
Since the move some of the people started getting mails that do not have in
To: field the real recipient name but another user name from the
organization. We started thinking how come the user gets another user's mail
because there was only one recipient name in the "To:" field. When I checked
the Exchange server, I saw in Message Tracking Center the message that came
to that user was actually intended for couple of users but the Outlo...Sending reports to via email
Is it possible to create a workflow that sends an email with a report to
management with all opportunities where the closing date is in the past...?
MS CRM using Reporting Services (SSRS) and SSRS have this functionality
How to configure SSRS:
...Passing values between reports
Here is the deal,
I have a billing system that uses multiple reports. All reports get open
when I run the system. Everything works fine when there is data in all the
reports, and data summaries gets passed from all reports to the summary
report. Sometimes in one or more reports in a certain month, there is no
data, and instead of passing 0 (zero) from the these reports that do not have
data to the summary reports. I get #Error or #Name. (The summary values to be
passed are usually in the footer section of the reports)
I use this on the summary report to get the values from the re...Keep user passwords
We've just finished installing a new Exchange server and connecting it to a
separate DC. We used to have everything on the same server but we'd like to
be able to scale our solution better in the future - therefore the new
setup. Users are primarily connecting to Exchange by means of RPC over HTTP
from clients that are not part of our AD.
The old setup allowed users to save passwords if they configured their
clients to use NTLM authentication and followed the directions in this
This worked both for RPC...integrity problems while copying
I work with a data base with visual basic. when i copy the file on my lokal
disk and then do any changes, after another opening the excel is not able to
open the file and after reperation all pivot table are not active any more. i
will be gratefull to get some suggestions.
...Crystal report not picking up information
I have a commission report that gathers sales amounts from field
"RM20101.RMDTYPAL". We've recently changed service management software and
now, after integrating the transactions - the commission report picks up
I have no idea what I need to change - thoughts?
RMDTYPAL stores the type of transaction, like Invoice or Credit Memo, not
the sales amounts....is the commissions report basing what it's picking up
on that field? Has the change to what is being integrated from the service
management software caused a change in what's going into this fiel...How to retrive password protected worksheet but forgot password?
I password protected an Excel spreadsheet and now can't remember the
password. Is there any way that I can gain access to my worksheet?
There are tons of FREE good Excel password 'cracking' tools. Your favorite
search engine should get about a gazillion hits on a phrase like "crack excel
password" or "excel password cracker".
A good one that many report great success with can be found at:
> I password protected an Excel spreadsheet and now can't remember the
> p...centralized management of mail forwarding, out of office replys, i
-is ist possible to allow/disallow mailforwarding and out of office reply to
the internet by USER? ex2k: i can only find that point by DOMAIN not by USER
-is there any way for centralized management of all "mail-forwardings" and
"OoO-Replys", for documentation purposes, maybe 3rdparty?
...Spreadsheet password protection
How do you password protect a spreadsheet. I can't find anything in the help
You can prevent un authorised access by giving a password to open the
workbook itself, so that no one else can open it (Go to Tools, Options and
then Security Tab). You can do it there if you have already saved the file,
or you can go to "save as" then "Tools" and "General Options" where you can
On the other hand you can protect work sheets and ranges for different
people by using "Tools" and then "Protection" Tab
M Imran Buha...Chinese Characters in Report
How can Simplified Chinese characters be displayed in a label or textbox on
I will need to have some labels and textboxes displaying Simplified Chinese
and others displaying English.
Is just a font needed or something else?
Any advice would be appreciated.
"AG" <NOSPAMaemail@example.com> wrote in message
> How can Simplified Chinese characters be displayed in a label or textbox
> a report?
> I will need to have some labels and textboxes displaying S...Chart Linking Problem
I have a chart linked into my active worksheet. The
linked chart is a bar graph whose data is based upon the
offset formula which was chosen to automatically update
the chart based upon the new month's data.
However, my active worksheet will not update the chart.
When I try to update it manually I get the message that
says: "The name you specified is defined as something
other than a rectangular cell reference". Anyone ever see
this? Any thoughts on how to work around this?
I am working with publisher 2007. I finished my site last Dec. and went to
It is not letting me make changes because it does not like my password. I
can not figure out how to go in a reset everything from my provider.
I was also trying to see if I could find web publishing wizard, which
doesn't seem to exsist with 2007.
If you are saying you forgot your password then contact the ISP Tech Support
and they will reset the password to something like 1 2 3 4 or something
other that is very simple. They will also instruct you to change it to
somethin...Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy
and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
user. my client want to know how to enable it. hope for your prompt action.
Only works for SQL 2005. If you client wants to use a beta database server...
> I'm curious why are the Change Password Next Login, Enforce Password Policy
> and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
> user. my client want to know how to enab...