Event ID 57
We are using 2 servers, the first one is a 5.5sp4 running on NT4 SP6a, the
other one is a 2003 running on W2k3
I'm getting event ID 57 on the 2k3 machine, I've tried to apply the solution
But still getting the error message, I've increased the threshold from 50 to
1000 and it's still doing the same thing.
Anybody ever experienced that issue?
I'm getting the same error, same setup as you i tried following
http://support.microsoft.com/default.aspx?scid=kb;en-us;300048 with 0 success
"John Doe" w...Unique Constraint
How can I implement a unique constraint in access?
Does anyone know what activity causes the Modified User ID (PM30200 table,
MDFUSRID column) to be updated?
This column is rather updated with the user ID, from activities that occur on
the record when in an open status. Once the record makes it to history, there
is nothing that would change the value of this column.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
"Don Leugers" wrote:
> Does anyone know what activity causes t...Unique Values, not Unique Records
My data looks like the following:
ID Type Amt
1234 A $10.00
1234 B $10.00
1234 C $10.00
I would like to find a way to get only one of the items on to a new
spreadsheet, because they are duplicate records in my eyes. The Advanced
filter does not work because each record is unique. Can anyone help?
in the dialog for the advanced filter, make sure only the ID column is
> My data looks like the following:
> ID Type Amt
> 1234 ...Unique Records
I was looking for someone who could help me with the following:
I have a rather large Datase (5000 records and growing). One of the data
collumns excists of 120 different categories (and still growing). How can I
make a list, in another sheet, which only contains the categories? Thanks in
Data>filter>advanced filter and unique records only and copy to another
location, select only the column with
"Jasper" <Jasper@discussions.microsoft.com> wrote in message
>...Kernel Process (EB) ID to PID
my apologies for the cross-posting but i needed an answer sooner rather than
i need to know how i can convert / translate the process ID from a security
audit event (apparently the linear address of the Kernel Process Environment
Block) to a PID (the process ID one might see when you run tlist from a
command prompt). we are seeing numerous event id 578 in our PDC / BDC event
logs apparently logged by the built-in (now renamed) domain 'administrator'
account - approximately 10 to 40 per minute - with the
seTakeOwnershipPrivilege listed. no one (?) is using this acc...XL 2002 Pivot tables: 1 pagefields section -> many tables
I would like to coordinate several pivot tables I have designed with only 1
All the Pivot Tables are linked to the same data but display various
statistics in different format (% growth, unit growth, market share....).
They currently all have their own Pagefields section.
Could they be linked to a single one?
You can use the following code, adapted from a posting by Robert
Rosenberg. It changes all Pivot Tables if the page is changed on the
first PT. You could revise it to suit your layout. As noted in the code,
place the code on the module for the worksheet which con...Unique record
I am quering a table that has two entries in it with the word area in the
record. From some odd reason the query eliminates one of the two records
even though they are both unique. Is there a way to show both of these
records without displaying all the other duplicates?itles
SELECT DISTINCTROW Teams.TeamDesc, CoursesMaster.CourseTitle,
FROM ((Teams INNER JOIN TeamTrain ON Teams.TeamID = TeamTrain.TeamID) INNER
JOIN CoursesMaster ON TeamTrain.CourseID = CoursesMaster.CourseID) INNER
JOIN Sessions ON CoursesMaster.CourseID = Sessions.CourseID;
I have two ...Creating a form that can be dragged from any click within the 'Detail' section
I'm trying to create a dashboard and I want the form to be moveable,
however I have removed the control box and I don't want the form to
have a border (hence no title row that can be used to drag the form).
How do I allow a click from either a control or the detail section to
enable the form to be dragged? Any help would be appreciated.
Phil I agree with your suggestions to stick with the standard Window UI. But
if the OP really must have this interface it is possible using the Form's
MouseMove etc. events. I and others have posted code how to do this ov...Wrap text around certain section/paragraph
I have a paragraph and a table on a page. I want to wrap all text around
that certain page. That is no matter what happens, that one paragraph and the
table underneath it should stay on page 16!!!
I have searched for 2 hours already... cant find solution
You can't wrap text around an entire page. Anything that is text-wrapped
must be anchored to a text paragraph.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"VBforlifeYO" <VBforlifeYO@discussions.microsoft.com> wrote in message
news:C9B...renewing 'product id'
Does anyone know how to re-register the Office X product ID without
destroying the installation, preferences etc? We have 4 legal copies
between the 4 of us but seem to have installed one copy twice - this
is now a nuisance whenever my daughter is home as it complains about
another on the network. There seems no 'change registration' function
- is there a file I can delete, if so which one? Thanks.
See this tutorial from McGimpsey & Associates.
On 7/5/04 1:33 PM, in article
email@example.com...pop and smtp errors unique to machine
I'm using windows xp home and i'm running into pop and smtp errors using
outlook. i've verified on another machine that the account works and the
settings i'm using are correct. when i try "test account settings" for the
account using outlook the "log on to pop" fails and the "send test e-mail"
fails. i've also tried using outlook express and i get the following pop
The connection to the server has failed. Account: 'pop.cogeco.ca', Server:
'pop.cogeco.ca', Protocol: POP3, Port: 110, Secure(SSL): No, Socket Error:
10061, ...Create New Page at TOP of section?
This seems like it should be a FAQ, but I've been unable to find an answer -
is there any way to make new pages/tabs appear at the top of a section
instead of the bottom? I'd really prefer the most recent items to be at the
top of the tab list.
R Watkins wrote:
> This seems like it should be a FAQ, but I've been unable to find an
> answer - is there any way to make new pages/tabs appear at the top of
> a section instead of the bottom? I'd really prefer the most recent
> items to be at the top of the tab list.
Sorry, but there is no way to achieve wh...How do I make a unique entry
I have data which consists of a row with an identifier and several columns
which are options for the identifier that contain an X when it's selected. It
looks like this
number option1 option2 option3
1234 X X
2345 X X
What I'm trying to get is a single column of
I've tried to use transpose and concatenate but it's a large spreadsheet so
it's still very manual. Any ideas or macros that would help me automate this
process would be VERY appre...Get count of unique field values
I have a table with a column called Employee ID. Many rows can have
the same Employee ID. I need to get the total number of unique
Empolyee IDs and use this number in a formula.
What's the best way to do this? I'm wondering if I should make a
Pivot table that provides this number, but I'm not sure how to do
that. Or perhaps there is some other approach.
Any info would be greatly appreciated!
have a look at
for some formulas depending on your data structure
Frankfurt, ...Event ID 111 after migrating to Exchange 2003
I just migrated my Exchange 2000 Server to Exchange 2003 server. The way I
did this basically is setup a temporary Exchange 2003 server, moved all the
user mailboxes from the Exchange 2000 server and public folders from
Exchange 2000 server to the temporary Exchange 2003 server.
Then after that, I formatted the old Exchange 2000 server, installed Windows
2003, joined it to the domain as member server, installed Exchange 2003 in
it, and migrated all the user mailboxes and public folders back from the
temporary Exchange 2003 server.
The problem since this is back and forth (actually should be ...GP10 Security Task Id Question
When building a task id you must select the Product, Type & Series.
Then in the bottom part of the scrollable area you select "operations"
to be included into the task. However, what is meaning of the
operations that are NOT checked? Are these operations not available
to any user in the system?
Users that have only this task in their role will have access only the the
checked operations, unchecked operations will be unavailable for those users.
But if the user was a member of other roles or tasks that have shared
operations checked, then the system will gain user...How to have records with ID transferred to sheet ID
I have a sheet with raw records from a telkom company that lists the
SIM card phone numbers, name of the user, SMS usage etc.
Record# SIM# User SMSusage etc.
1 12345 Andrew 500 etc.
2 65432 Deborah 430 etc.
3 12355 Andrew 450 etc.
How to have these records transferred to the new sheets, per name?
So, on sheet Andrew:
Record# SIM# (User) SMSusage etc.
1 12345 (Andrew) 500 etc.
2 12355 (Andrew) 450 etc.
The amount of record# varies, also the amount of SIM# per user.
...Unique Values only please
Just plain brain dead ayt this point! Access XP on Win XP
Query to find the unique value sets in a table. HAve approximately 5200
records in a table. One field is date, another is classname. How do I set the
query to only display UNIQUE date/classname combinations. I am sure I have
done thsi before, but can't remember where I found the Unique values control.
Who can point me in the right direction again?
On Nov 27, 5:19 pm, JR Hester <JRHes...@discussions.microsoft.com>
> Just plain brain dead ayt this point! Access XP on Win XP
> Query to find the ...Combo box
Im an excel 2007 user and am having problems populating a combo box.
The code below runs a loop for every single row on the worksheets and adds
values from column G (Diagnosis) into the combo box where it is a text
However there are duplicates, i wish the combo box to contain UNIQUE values
Now I dont want to go off on a tangent, but I did think about using custom
views and an advanced filter to select unique values and then ALSO use goto
Special and apply the condition to look for text values ONLY (i.e. removing
the rows with BLANK values).
However the custom view...System Log Event ID 2043, 2044 from MSExchangeSA
I recently had to rebuild my Exchange Server so I have been monitoring the
Event Logs pretty closely. Today I noticed these entries in the Application
2043 Event Type: Information
Event Source: MSExchangeSA
Event Category: General
Event ID: 2043
Time: 1:51:45 PM
Computer: <my exchange server>
Starting the bulk e-mail address process.
Event Type: Information
Event Source: MSExchangeSA
Event Category: General
Event ID: 2044
Time: 1:51:46 PM
Computer: <my exchange server>
Completed the bulk e-mai...Unique Words
I am copying and pasting numbers and text from 2 seperate programs. The 1st
program has numbers in front of the text. I remove the numbers by doing a
text column and then deleting the number column. With the text that remains
in the next column I then move it over to column A.
Then I grab my next set of text from the 2nd program and copy and paste it
afterthe last word in column A. I then do an A-Z sort to list them
I then name the top row "NAME" and try to do a filter to take out the
duplicate names by doing a unique filter on that column. However, all...Problem in "Auto Generate Customer Id"
I have a form named Frmcustomers. in this i have a field called "PartyId"
which was auto number generating field. I used the following code for this.
Me!PartyId = Nz(DMax("[PartyId]", "[TblParties]")) + 1
Now I want that the code should check the field "PartyId" and make increment
in the id which starts from 65....
and so on.....
while this field also has some id's starting from 61, 62 and 67
61001, 61002, 61003.....
...Creating a Unique Chart - New User
I want to create a chart using data from two or more worksheets but so far the paperclip is giving me the run-around...any suggestions?
Create the chart on one worksheet using the data from that sheet.
Then, switch to the 2nd worksheet and copy the data of interest.
Switch back to the 1st worksheet. Select the chart, then Edit | Paste
Special... In the resulting dialog box, indicate desired attributes
(data in columns, new series, etc.)
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <2...Excel to protected application? Unique Computer ID
I have a excel spreadsheet that ideally I would like to run as a standalone
Is it possible to do this?
I want to distribute by disk - but restrict the use of the to a specific pc.
Is it possible to locate a Unique Computer ID variable in Excel (such as MAC
address) to implement a key system?
Any help appreciated.
See Chris Rae's page at
and additional information at http://www.mvps.org/dmcritchie/excel/property.htm---HTH, David McRitchie, Microsoft MVP - Excel
[site changed Nov. 2001]My Excel Pages: htt...