Allow a user to log on as a service as well as a user
I'm doing a blackberry enterprise install and need to allow the admin user
for the berry install to log on a service as well. How do i configure the
user this way? He is already configured as a admin user.
You configure this (usually) under the Local Security Policy in User Rights.
Blog - http://mostlyexchange.blogspot.com
Directory Update - http://www.directory-update.com
"nigel" <firstname.lastname@example.org> wrote in message
> I'm doing a blackberry enterprise install...Access Code Pushing Values
I have a customer database with [BillAddress] and [ShipAddress]. I am using
a "yes/no" box titled[SameShipAddress?]. To automatically fill [ShipAddress]
after checking the "yes/no" box I used this code in the after update event
for the check box.
If Me![SameShipAddress?] Then
If IsNull(Me![BillAddress]) Then
[ShipAddress] = [BillAddress]
This works for the selected customer, but then pushes the entry
[BillAddress] of the previous customer to [ShipAddress] of all of the
Sounds as...enter value based on drop down list of another field?
I have an excel 2003 spreadsheet with 3 worksheets. In sheet 1, I created a
drop down list in column A based on values in sheet 3, column A (item
number). Thisd data comes from sheet 3, where I have column A (Item #'s),
column B (Item desc)an Column C (price)
In column B of sheet 1, I have Item Descriptions and in column C I have
price. I want this to automatically fill in based on what I enter in the
column A sheet 1 and it should get the corresponding values from sheet 3
column B and C. I can make the drop down list in sheet 1 column B and C, but
some of the descriptions need ...Services terminating
For the past few days I've come to the office with my
Exchange services stopped. The Event Log tells me the IIS
Service Mgr shutdown first then the IMAP4, FTP Publishing,
POP3, Exc Routing and SMTP. This series of events
happened 12 times between 4am and the time I rebooted the
server, which fixes the problem until the next morning.
Another Event log entry tells me the the SMTP server could
not connect to any DNS server, this occured 4 times
between midnite and 4am.
I have what I believe is a solid AV program (CA eTrust
w/Exc option) that is kept updated and scans the drive
d...ADAM Error with Web Service Installation
i need to install the Business Portal for GP 10.0
the web services is required.
during the installation of the web services, i encountered an error
" ADAM Error 128"
what could cause this and how do i solve this?
Any one help!!!!!
Are the web services already installed?
If they are it sounds like the issue may be that a different user account
installed the web services (other then the one that is installing the BP)
> i need to install the Business Portal for GP 10.0
> the web services is required.
> during the insta...Returning Data from a third cell in same row that meets two other
I'm looking for a formula that will return a result from a cell on a same row
as two other cells that meet certain criteria. I'm sure there is a way to do
this but i am a novice at this kind of stuff and can't seem to figure it out.
For example i want a cell to = what is in column E when column A="36751" and
when column B="Total Returns" The spreadsheet has 55000 rows. there will
only be one instance where both these criteria are met. i want to use this
to create a seperate spreadsheet with just info i need and can update on a
thanks in ...How do I filter rows based upon a column value
I have a spreadsheet that contains multiple agency id's in a column. When
generating reports, I would like to filter per agency and display only the
rows associated with that agency.
Is there a tutorial or sample on how to do this?
It sounds like you are looking for Data / Filter / AutoFilter. Have a look
here for some basics:
"Jack" <email@example.com> wrote in message
> I have a spreadsheet that contains multiple agency id's in a column. When
> generati...CRM 3.0 SDK Web Services
I am writing a small data migration tool to migrate account and contact
data. I have approximate 1500 accounts and 6000 contacts to import to
CRM 3.0. I finished the application and ran the data migration, I will
able to migrate all of the account records without any problem at all.
when I run the contact migration, it can migrate 2800 contact records
when it get over 2800, my application throw me the following error
message: The underlying connection was closed: Unable to connect to the
remote server. I am running CRM 3.0, SQL server and my data migration
on the same server. I am wonder w...Comparing cell values then labeling them based on comparision
Hi. I'm trying to find a function or way to compare two cells and then label
them according to if one cell is lesser, greater, or the same as the other.
I have a large data sheet where I want to compare many pairs of cells and
then have them labeled in this way. For example for each pair where the
second cell value is larger than the first it would put greater, where the
first is larger it would be lesser, etc.
Can anybody help me with this? also feel free to email me at
Thanks so much for your help.
> Hi. I'm trying to find a function or way to compar...Adding Fonts to New Font Collection
Operating System: Mac OS X 10.5 (Leopard)
I need help in adding a few of the fonts I commonly use to the Fonts Collection, which appears at the top of the Drop down menu under FONTS. I would like to store the names of a half dozen fonts in the Font Collection menu so that I can avoid scrolling through the entire Font list in order to highlight them. If one uses Verdana a lot, this is a real pain. Right now, when I go to Font Collections (under the Font menu), I see the subheading New Favorites, not no list appears when I click on it. I want to put my favo...Sum of values in a form
I have read numerous threads on this topic, and understand that in order for
my Sum() to work I need t ensure all references are made back to the Record
I have endeavoured to do this, but am still getting #Error.
I am trying to Sum the revenue each tenant provides in a given date range, to
give a total revenue figure. If the date range is a whole month, then the
expression just takes the value of Rent PCM, and not Rent PCM * No. of Days,
which would give some unusual results.
My Expression looks like this:
=Sum(Nz(IIf([Short Let]=-1,[Rent pcm],IIf(Day([Forms]...Programmatically adding function to copy all incoming mail to public folder (based on sender domain)
I would like to be able to (from any client) execute a script (vbs,
exe, whatever) that creates a public folder. That's should be pretty
The tricky part is that I want the same script to create a rule (?) on
the Exchange server that copies all incoming mail from a specific
sender domain to that new public folder.
Hmm... Let us assume that I have the sufficient credentials for this
action hardcoded in the script.. does anyone have a good idea how to do
I am creating an interface in our ERP software that should be able to
see mail correspondance horizontically accross ...Add cell value with mouse click
I want to create a counter, so that every time I click in a certain cell it
takes the existing number and adds "1" to it. Is there any way to do this?
I'm compiling statistical information, and need to get cumulative counts in
various categories as I sort through the data.
Maybe you can use a spinner button for this.
Right click any toolbar then select Forms. Click on the spinner button ( it
looks like an up arrow on top of a down arrow).
Place it near the cell you want increment. Once you have it placed and sized
right click on it and select Format Control. Fill in ...Combo box default value multiautocomplete
i have a subform with 10 item. The first one is a combo box that can choose
the value from a list that is linked to a table with many record.
This subform is related to the master form with
link master field codice,cognome,nome
link child field codice,cognome,nome
that are the other items that are not visualize in the subform. These link
give me the right connection to the master form.
Normally when i choose the value from list (table) i place also all the other
item in the subform using this code in after update precedure
Me.ISEE.Value = Me.ISEE.Column(0)
Me.F_Costo_con_M...Adding Contact Person to SOP Other Invoice Form
We would like to add a field to the "Bill to" and "Ship to" addresses that is
the "Contact Person" field from the Address ID palette. How do I do this?
This is done easily, check out Knowledgebase Article 874176. You will need
to add some additional calculated fields and then modify the existing
calculated fields. Using the rw_SelectAddrLine user function you can add the
following fields (for example) to an address and have it grow and shrink
dynamically with no empty lines.
...IIF Query for Numeric Values in Text Field
I’m attempting to flag interest rate spread errors and omissions in a file
from a sales database using IIF statements I adapted from another database
(I’m a novice at this). The field I’m querying is text format and contains
both alpha and numeric values. When I test for a null value the IIF works
fine, but when I test for a numeric value I get an #ERROR.
Spread Error1: IIf(([Tbl 1 Eligible Closed Deposit Opps Appended]!Spread Is
Spread Error2: IIf(([CCC Fall 2007 Eligible Products]![IB/NIB]="NIB" And
[Tbl 1 Eligible Closed Deposit Opps Appended]!Spread<4),1,0...How to get task manager CPU and default memory column values
I need to return CPU and memory columns for each process in server from web
service like task manager shows by default.
I tried code below but s.TotalProcessorTime throws Win32exception with stack
How to get CPU and real memory size from server using web service ?
static void Processes(StringBuilder sb)
List<Process> processes = new List<Process>();
foreach (Process process in Process.GetProcesses())
processes.Sort((a, b) =>
...Getting the handle of a combo box in a dialog
have a dialog box that contains a tool bar that contains a combo box.
From the dialog box I want to obtain the combo box control to perform a
SelectString(). I know that I need to get a handle for it first. The
reason I am doing it this way is because when I created the tool bar I
placed an empty button there and named it IDC_FONTNAME and then in my tool
bar class, I did a SetButtonInfo and changed the style to a TBBS_SEPARATOR.
I then created the combo box using the IDC_FONTNAME
From the dialog class.
CComboBox* pCB = (CComboBox*)GetDlgItem(IDC_FONTNAME); //// returns
0x00000000...Cincinnati Janitorial Service
...M04, Go to Online Services, default selection
Whenever I synch with my bank, MS Money defaults to
1) Download quotes, News, and Exchange Rates
2) Get the latest money updates
I'd prefer to do neither by default. Can I turn these selections to
...Adding a space to a string
Hi i am trying to add a space i.e Column A1 " hello " Column B1 "mom"
with column C1 reading "hello mom" at the moment it reads "hellomom" i
know it maybe a simple question but new to this
HTH. best wishes Harald
"lennymos123" <firstname.lastname@example.org> skrev i melding
> Hi i am trying to add a space i.e Column A1 " hello " Column B1 "mom"
> with column C1 reading "hello mom" at the moment it rea...Adding images to a checkedListBox
If I understood well, I can add not only text but also objects to a
So i'd like to add an image as item to my checkedListBox.
I tried this: checkedListBox1.Items.Add(imageList1.Images), but it adds
"System.Drawing.Bitmap" instead of an image.
I'm still pretty inexperienced with c#, so who can help me with this
...Linking Values in Worksheets
Is there a simple method of linking a column of values in
one worksheet to another worksheet?
I can do it manually, one at a time but is there a way of
copying the link down the column?
(The columns are identical in length)
and copy down
> Is there a simple method of linki...most often occurent value(s)
I would like to count and determine the most often (10) occurent
values (strings) in a column.
How can I do that?
Thank you very much your help.
Use a helper column of formulas. For example, in cell B2:
Copy down to match your column, then use Data / Filter.. Autofilter and pick "Top 10" from the
dropdown at the top of column B.
MS Excel MVP
"Tamas Konczer" <email@example.com> wrote in message
>I would like ...Merging Accounts Twice to Use Bank OFX Services PLUS MSN Money Bil
I have not upgraded from Money 2004 primarily because of the problem I am
describing here related to merging accounts. I have tested this with Money
2005 and 2006 and each time I reverted back to 2004 because of this. I have
not checked 2007 yet but suspect that this problem persists. Could anyone
confirm this for me one way or another?
The problem involves the limitation that merging works only with one online
and one "offline" account. So for a checking account, when I connect to my
bank's online services, a separate online acocunt is created that I can merge
with the o...