Remote users cannot send e-mail through Outlook
I have a few users who do not work in our office. They
have Outlook installed on their home computers and then
dial up to the internet and do a send/receive.
I have Exchange 2k3 on a Windows 2k server and the users
are configured to allow for SMTP/POP3. All was working
fine until earlier this week when they informed me that
they could no longer "send" mail. They get the
message "The TCP/IP connection was unexpectedly terminated
by your mail server. If this problem persists, contact
your LAN Administrator or Internet Provider".
The users can still receive mail ...How OMPM Scanner (offscan) Filter by Access/Modified Date ?
I have problem to inventory excel files on very big file server, but I
believe there are so many documents we no longer need to maintain.
I want to skip files if the access date or modified date longer than 6
month, but don't see the OMPM providing feature about it.
I currently running OMPM since 2 weeks ago and running out of time for
reporting to my manager.
Please help me, this is my critical assignment.
...comdlg32.ocx and Access 2007
I have several Access databases that were originally written using an Access
version prior to Access 2007. I am in the process of converting the
databases and installing them on new machines running Win7 and Access 2007.
Over the years, one of the References I commonly used was comdlg32.ocx. It
does not appear that either Win7 or Access 2007 installs that particular
Active X file. I can copy it from an older machine, but that seems like a
Is comdlg32.ocx a "legacy" Active X file and has it been replaced with a
newer (and differently named) Activ...Moving from Home & Student to Full version of Office
Operating System: Mac OS X 10.5 (Leopard)
I need Exchange support and therefore I am planning to buy the Full version of MS Office 2008 for Mac. I already purchased and installed (and have been using) MS Office 2008 Home & Student edition.
My questions are:
1. Should I uninstall the Home & Student edition before installing the Full version? (I assume so).
2. How do I make sure that the data I have already created in Office 2008 Home & Student edition will be available to me after installing the Full version? In particular, how do I make sure that ...Error 2455 Closing Access 2007 database with form open
I have a form with a subform that is requeried when you select a new key for
the main form from a combo box.
Everything works fine - usually. But sometimes if you have the form open
when you close the database down you get the following error message (twice)
in a pop up. You say OK (twice) and the database closes OK
"2455 you entered an expression that has an invalid reference to the
If I close the form before the database I never get the error.
If I do not touch the form before you close the database I don't get the
If I update a field by t...Inserting Excel into Access Reports
Have a great Access application that produces a nice template (headers &
footers) report into which I'd like a spreadsheet inserted before going to
the printer. In the past, I'd just print the Access reports, then reload
them into the inkjet printer and run the Excel spreadsheets as needed. The
heat of the new color laserjet turns the paper grey if it runs through too
often, so it's time to get the reports printing on one pass.
Any suggestions would be welcome. I've of course also got Word XP, MS
Publisher XP, as well as Adobe Acrobat, if anyone thinks it m...Simple Access counting queries
Hi, hoping someone can help a relative newbie with a pretty simple
query. My database (Access 2007) has three tables:
Purchases (many-to-one links to both of the other tables, this is
basically a linking table)
I have two simple queries I'd like to get out of this database, but
I'm a bit stuck on how to construct the SQL. Any direction you can
give me would be helpful.
1. List of all customers who have purchased 2 or more products (or 3
or more products, or 4+, etc.)
2. List of all customers who have purchased both Product A and Product
B (or A, B, and C, or B an...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <email@example.com> wrote in message
> How to get only the year in the date form...Expression Too Complex in Access 2000
Consider the following query:
SELECT crTbl.acct_1, crTbl.amount, crTbl.date
WHERE (((crTbl.acct_1)="Supplies") AND ((crTbl.date) Between
The query works fine on my own computer in Access 2002.
When converted to Access 2000 and used on an other computer,
I get the following error:
"This expression is typed incorrectly or is too complex to be evaluated.
Try simplifying the expression by assigning parts of the expression to
The problem is with the "Between...groups detail section totals access 2003
I know this can be done, but haven't figured out how yet. I have what
basically is a summary report that my sql comes up with for the detail
rows. I want to total these rows in the report and display
immediately below the detail section. I don't really want to group
anything, but want to treat the whole detail section as a group.
That being said, how can I get a "group footer" on the designer so I
can add my total columns. If I use "sorting and grouping", it starts
grouping things and that is not what I want.
I don't want to use the "page foo...Remote Wipe Out Work with Treo 650?
Debating whether to get the Treo 650's with the ActiveSync built in vs. the
PPC-6700 (both from Sprint) for our marketing reps here.
Treo's are appealing due to how cheap they are now, and with the ActiveSync
looks like you can sync up with xng2k3 sp2 (which we are implementing now).
ActiveSync aside, can the Treo's be remotely wiped out with the Mobility
Tool in xng2k3? Or is this feature only compatible with Windows Mobile OS?
No it can't.
Remote wipe will only work with Windows mobile 5.0 devices with AKU 2.0
Treo 650 is Palm OS.
Be...M2004 Won't Save Customized Toolbars / Home Page
Unable to find anything in archives or the UFAQ on this...
My Money 2004 file recently stopped saving customized toolbars / home
page. Any changes I make don't "stick".
I've used super salvage, which supposedly found and corrected some
errors, but the problem persists.
Try this (and it is in the UFAQ under a less specific topic at
http://umpmfaq.info/faqdb.php?q=153). Stop Money Express. Change your
toolbar stuff. Exit Money. Restart Money. Restart Money Express.
"Sock" <firstname.lastname@example.org> wrote in message
news:8205f05b.04101407...Email accounts are not created for new user
I had a severe system crash several days ago because of bad memory in my
domain controller (Server 2003 R2)/Exchange server 2003 (small site - no
extra systems). I had to reinstall Exchange 2003 and reload the exchange
store from backup. For existing users everything works great. Everybody can
send and receive email, the calender works correctly, etc. OWA works.
However, when I create a new user account in Active Directory Computers and
Users, the account is created and the new user can log onto a system.
However, Outlook 2003 cannot be configured to use the exchange server. In
t...Cannot create mailbox for new user accounts
I am running Exchange 2003 on Server 2003. I was able to move all existing
mailboxes from my old Exchange 2000 server to my new 2003 server. Whenever I
try to create a new user it creates the user normally and asks if I want to
create a mailbox for the user. I check yes, and it says account created
successfully. However, the mailbox never appears in Exchange, no email
address is assigned to the new user, and I cannot send mail to the user
account either. If I try to access any Exchange properties from ADUC it
shows everyhting as if a mailbox exists, but there is no mailbox. I am
...Help with Synchronizing a user folder with a Public Folder
Hoping that someone can offer a suggestion on this one.
I'd like to be able to synchronize an email folder in a particular users'
Outlook account with a public folder. The idea is to have email
conversation threads in a particular folder (just one folder) visible to
others in the group via the public folders. Ideally, it would be great if
changes to the public folder are instantly mirrored in the users folder -
but that requirement is not critical, the core requirement is to have the
public folder mirror the user's folder (in real time).
I know that I could accomplis...Retrieving Current User Information from JScript (OnChange)
I am adding functionality to one of my client's OnChange scripts to append
the Current User Name into a memo field with date and action information. I
scoured the web but can not find a way to properly retrieve the Current User
information. Any information would be incredibly appreciated.
...Prevent users from saving music and pictures to their hard drives without folder redirection?
Hi there. I'm wondering if there is a way via GPO or anything else to
prevent users from saving music and pictures to their local hard
drives without using any type of profile or folder redirection.
...Remote access to another company's Outlook calendar?
I have one client on Exchange 2003 that wants to access the calendar of an
employee (consultant?) at another company running Exchange (version not
known yet). How can the remote company share this person's calendar with my
client? He would need to access it and add appointments to it.
Thank you for the help!
On Mon, 30 Aug 2004 22:15:24 -0700, "Gregg Hill" <email@example.com>
>I have one client on Exchange 2003 that wants to access the calendar of an
>employee (consultant?) at another company running Exchange (version no...Fueling your car with natural gas from home
as you know the price of the Oil is more and more increasing, while
the oil supply is decreasing. Moreover Oil is
causing wars, terror, oil spills, a lot of greenhouse gases. Do you
know that there is plenty of natural gas ? The
supply will last for many decades, probably for hundred years. A lot
of methane (natural gas) is found as shale gas,
a lot more will come from methane hidrates. Natural gas is causing
much less greenhouse gases and since it is found
locally, it will not cause any wars or terror. It will create jobs in
your own country and not in the middle east...Can't connect to Exchange server after VPN access
I can connect to my office Exchange server when in the office (LAN) but I
cannot connect outside with Outlook.
I can only use the webmail after entering a web VPN access:
- First portal for VPN : https://xxx.yyy.com --> I enter my
- On the next web page, I have the choice for the webmail and it's a link as
https://xxx.yyy.com/go/webmail.yyy.com~ssl where I can enter my
So I can't enter the url in RPC as every slash is forbidden
In my Outlook, the Exchange server (EXC.yyy.com) is not reachable by ping
(or tracert) and I can't ...Access 2007 12-17-09
I am building a contact data base for my church. How do I get the phone field
to automatically format like this (xxx) xxx-xxxx when the numbers are typed
in the cell?
In the form design view select the phone control and open the properties
dialog. Goto the Data tab and use the Input Mask to define the format you
wish to use. If you click on the ... to the right hand side on the property
you will get another dialog where there are predefined input mask or you can
define your own.
For instance, I use
to format my telepho...Users cannot login to OWA after Exchange 2K3 was moved into different OU
I created a new OU named member servers, and moved the
exchange 2k3 server into it. After I moved it, only the
administrator was able to login to OWA successfully. No
users could login to OWA. I created a test account with a
mailbox, and was able to login to OWA with the newly
created test account. I then moved the exchange 2k3
server from the member servers OU into the computers OU,
and the newly created account was unable to login to OWA.
Any help with this would be appreciated.
...Backup a users mailbox in Exchange 2003
We have recently terminated a couple employees, and I would like to make a
copy of their mailboxes. How do I go about doing this?
On Mon, 30 Oct 2006 06:36:02 -0800, chb12
>We have recently terminated a couple employees, and I would like to make a
>copy of their mailboxes. How do I go about doing this?
Exmerge is always a good option.
What I normally do is open their mailbox on my outlook, then create a
PST (name it the users name). Once the PST is created I copy the
contents of their mailbox into the PST. From there you ...user forms #5
I have created a user form (click on New Employee). How do I get the
information entered in to this form to appear in the correct columns in
the Payroll data sheet? And how do I get the combo boxes to display the
drop down information from the sheet called input.
Runner77's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30388
View this thread: http://www.excelforum.com/showthread.php?threadid=500502
...Make sales target (quota) invisible for other users
I am setting up a MS CRM system for a pilot which focus primarily on our
I have given each user who's a salesperson given a quota in the CRM system.
These numbers are confidential and so not everybody may be given the
possibility to view this data.
But when I checked with another role, I could see the quota of erverybody
who's got quota assigned.
Is there a possibility to make these quota's only visible to the persons I
want (for example the director can see the quota's of everybody, the
salespersons can only see the quota for themselves and the rest o...