Removing Manager from user
I assigned a user to a manager. I now need to remove this manager from the user (they are accountable to no one now). When I go to change manager, it will not let me make the field blank. Has anybody ever done this same thing? (Sorry if this has been posted before. The search isn't working right now). Thanks.
i want to create a form to convert several hundreds of A97 dbs to A2K.
does anybody know what which routines are behind the Convert to
in the A2K-Tools Database Utilities option.
How could this be integrated in my form for the convert-loop over the
many thanks f=FCr helping
The vast, vast majority of Access 97 databases can be opened in Access 2000
(or any later version) and saved in Access 2000 format. No, I don't have a
suggestion as to how you would automate that task.
There are, however, some very accomplished Access developers...Does SumIf work with a range?
I thought you could Sumif on a whole range, ie if A1 to A10 was your
criteria range, and B1 to D10 was the range from which to sumif.
However it only seems to sum what is in B1 to B10. Is that right?
I know I could use an array formula, but that might be a bit complex
for the recipient of the file.
(change the xxxx to gmail if mailing direct)
<email@example.com> wrote in message
>I thought you could Sumif on a whole range, ie if A1 to A10 was your...SHFileOperation not working
This is what I have for deleting the contents of a folder
const wchar_t g_wsz_DriverBackupFolder = L"C:\\My Folder\\*
memset(&info, 0, sizeof(info));
info.wFunc = FO_DELETE;
info.fFlags = FOF_NOCONFIRMATION | FOF_SILENT;
info.pFrom = g_wsz_DriverBackupFolder;
if (0 != SHFileOperation(&info))
DWORD dwError = GetLastError();
It fails and GetLastError is 6: "Invalid Handle". What the fuck is
Offhand, I don't see anything serious here. You have three more \0s than you actually
ne...Printing Labels (Receipts) For Each Item On Work Order
I need to print labels containing Ship to Address, Item Look up Number and
description. Each Item Needs an Individual Label With All of This Information
and the Number of Labels Printed Should Reflect The Quantity From a Work
Order. I am attempting to do this as a receipt. I am looking at code from
existing receipts and trying to cut and paste what I need from diffrent
receipts into one that may suite my needs. I am no XML pro to say the least.
If anyone knows a better way or has more experience with XML and may wanna
help I would appreciate it!
...Removing wire frame in 3D surface chart.
I'm am experiencing difficulty to view 3D surface chart as
the number of data points are increased due to the wire
frames in the chart.
Is there any way to remove wire frame in a 3D chart?
To get rid of the frame you need to set the border for each of the
legend entries to none.
The quickest way to do this is to click the legend, then click the
legend marker for the first entry. Double click and set the border to none.
After the dialog is closed use the left arrow key to move to the next
entry. Press F4 to apply changes to the series. repeat for all entries.
C...FRx export to Excel with formulas to work for XCR columns
The calculation column shows the wrong signs for revenue (normal balance =
"C") rows when you export to excel using formulas.
The issue is coming from the following setup in FRx:
1. The normal balance was set to “C” in the row format.
2. Print control that was set to use “XCR” in the column layout.
3. Including formulas when exporting to excel.
RESPONSE FROM MBS
We have found few bugs that were written regarding this issue. One of them
states that this is working as designed. The reason they gave is because you
should not include formulas when exporting to excel as it...How can I merge and purge two excel work sheets?
...default user name and password for RMSsample database
I just installed RMS Store operations 2.0 on a Vista computer. It installed
SQL 2005. now I am trying to open the sample database to start a new one. I
don't know what is the password for the "sa" user.
In version 1.3 with MSDE 2000 the "sa" password was blank.
I setup a user and password when I was installing RMS, but that is not
thanks for your help
Send me an email and I will send you a utility to set SA password.
Afshin Alikhani - [ firstname.lastname@example.org ]
CEO - Retail Realm
= = = = = = = = = = =
"Bob Dahdaleh&qu...TRY THIS. IT REALLY WORKS!
...Removing Orphaned System Folders
We are running Exchange5.5 with SP4, I have a situation where I need to
remove orphaned system folder i.e. OAB and FreeBusy + Schedule folders for a
non-existent site from our exchange Org.
Basically we had anumber of sites, for example we had a Site Boston which
was replicating its public folders to Site London and directory replication
was set in place between the two site. Unfortunately they (Boston) removed
the X400 connector and dir repl connectors and afterwards this site got
removed from our Org - as expected and the Boston server decommissioned.
Since Public Folder replicas w...change a work order to a sales invoice
I am a new user in RMS and I am working with my auto department. We are
working on oan older version of RMS (Pre 1.3). He primarily uses work orders
when he has a new order. Once the work is complete on the auto he needs to
bill it and take the items out of inventory. He is currently doing a
1) Processes the payment as a negative sale (an accounting nightmare)
2) Then he takes the WO number and does a sale refereing the number
3) Then he manually adjusts his inventory.
4) Because of the way he has processed them, the work orders remain open
until he has time ...Outlook 2003 rules, check messages after sending, not working
Since upgrading to Outlook 2003 (from 2000) we are experiencing problem
when using rules and sending messages from other applications (a
We have some rules defined that check messages after sending, dependin
on certain words in the subject, the message is moved to another folder
This works with no problems when sending messages via outlook but whe
sending (as attachment) with word, for example, the message does no
This worked with no problems in Outlook 2000. Also still occurs afte
SP2 installation. :(
Any advice would be appreciated
-------------------...? Re Balancing Account Stalled, Then Fixed, H2 Prevent
I'm using Money 2004 Deluxe. Started in mid-August and all has basically
worked fine until this week. (Did have a temporary loss of .NET Passport
but found the fix for this in prior posts here and fixed it).
This week, I started to balance a credit card account. After entering
starting & ending balances, date, etc. nothing would happen when I clicked
the Next button.
I "Googled" for this symptom and found a year old thread for this issue.
The thread concluded with the advice that I should contact Microsoft. I did
and they were very prompt in responding, instructing me t...Office:mac 2004 and Tiger (OS X 10.4)
microsoft.public.mac.office and microsoft.public.mac.office.word.
Some years ago - although after the release of Tiger, OS X v10.4 in
April 2005 - I read in one of the microsoft.public.mac newsgroups a
posting from an MVP who was still using Office:mac 2004 with Panther,
in this case OS X v10.3.9, and that this was because Office:mac 2004
was developed on Jaguar, OS X v10.2 and only works 100 pct with OS X
up to v10.3.9.
I have been running Office:mac 2004 on a Powerbook FW800 with
Panther, OS X v10.3.9 and now want to...How to Prevent Users From Seeing Activities Based on Regarding
In the interest of leveraging CRM to handle more of our internal operations,
I've added some custom entities to the system to track marketing events.
Because these marketing events have financial information associated with
them related to the cost of the event, I don't want anyone in the support
department to see this information.
I can easily prevent them from seeing the entities themselves, but they can
apparently see all of the activities related to the entity. Because some of
the e-mails related to the entity contain financial information, this is
Does anyo...Issues regarding drawing tools
Operating System: Mac OS X 10.6 (Snow Leopard)
Hi <br><br>The Drawing tools are of poor standards when compared with Windows version of Ms office. Why is MS doing this kind of sub-standardizing the quality for mac users who have purchased the licensed product. This is day light robbery. <br><br>I find drawing tools too tedious to work with, for instances if you try to draw a simple arrow, the line is not at all aligned with the arrow head. <br><br>regards - JMohan
Contrary to what you apparently believe, Mac Office 2008...workflow suddenly doesn't work.
I've a big pb : 2 days ago, our wrokflow stopped to work. I don"t know why.
All workflows (automatic or on demand). I don't know at all what to do : what
do I have to check, to do. For info : we are with CRM4.
Any help would be so great.
Thanks to all
please check " Microsoft CRM Asynchronous Processing service" on CRM
server .if it is stopped or started?
Blog : http://mscrmsupport.wordpress.com/
...External Data Query
I have a worksheet that was originally set up with the Get
External Data-->New Database Query menu option, I used
ODBC data sources and entered my user id and password at
Since then, I use the Refresh Data menu option monthly to
get new data. The password is embedded in the worksheet
so I don't need to enter it a second time.
However, I just changed my password on the database server
and now Refresh Data gives me an ODBC error (Attempt to
connect to the server failed.)
I can't find a way to update the worksheet with the new
password. Help please!
>-----Origi...Removing title bar Win98
The purpose of the question is to get the content (everything except the
title bar and the system menu) of an existing window and to display it in
another window of my application.
Once I have a CWnd from a handle, is it possible to get the window content
without the title bar ?
"Joseph M. Newcomer" <email@example.com> a �crit dans le message de
> It is a common misconception that changing styles after a window is
created will do
> something. This happens for only a limited number of styles on a limited
&...Working with a spread sheet to show names, address, etc.
While working with a spread sheet to develop a roster
when I have a zip code to enter that begins with a 0 such
as 08842 the program refuses to show the zero and
continually drops it. Is there a way to rectify this
Format your cell as text before you enter the codes
(Select the cells and use Ctrl-1 and on the number tab choose text)
Or type a ' before the code.
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"Betty Cea" <firstname.lastname@example.org> wrote in message news:email@example.com...
> While work...it worked!
Thanks that worked! Even the best with excel in my office couldn't figure that one out!!
It would be nice to stay in the ORIGINAL thread so we would all know what
"Colleen" <Colleen@discussions.microsoft.com> wrote in message
> Thanks that worked! Even the best with excel in my office couldn't figure
that one out!!
Well, clearly the best in your office are not as good as Debra<g>.
Seriously though, the constituency here is much...How to remove exchange 2nd exchange server from site?
We recently added an exchange 5.5 server in our site. We
dont need it anymore and there are no mailboxes in the
server. How do I safely delete the server from the site?
Do I uninstall Exchange from the server or just delete the
server from Exchange administrator? JC
Assuming its not the first server in the site, or a bridgehead etc.
etc. and you have removed all the pf replicas, run setup.exe and
choose remove all. Then from another Exch server, highlight that
server and delete it.
On Sat, 25 Sep 2004 11:50:18 -0700, "Joseph" <firstname.lastname@example.org>
>We re...Conditional formatting not working as expected (A2007)
I've got 4 unbound textboxes which represent start date, start time, end
date, end time. These textboxes are visible and initially get filled in with
data from two bound fields (Start_Time, and End_Time) which are hidden on the
form. I did this so the dates are separate from the times allowing use of
the date picker for the dates and a spinner button for the times. As each of
the unbound fields is updated, the appropriate bound field gets updated as
I've setup a conditional format on each of the unbound fields which is set
to evaluate the expression ([Start_Ti...How to remove comma and decimals from a value
How can I remove comma's and decimal's from a value using a formula in a query?
Assuming Excel recognizes the data as numeric, just reformat it. Edit >
Cells, select the Number tab, choose 0 decimals and uncheck the separator box.
If there not recognized as numbers, you'd first want to convert them: type
a 0 in some random cell, copy it, select your data set and Edit > Paste
Special, select Values and Add, then click OK.
"Send Object Command - Two attachments" wrote:
> How can I remove comma's and decimal's from a valu...