Remote Access to Web Client???
Are there any options for Remote Access to the Web Client? other than
...Using the Text Formula
I have a range of cells that I want to apply the =LOWER function to but each
time that I go to make the text lowercase the text disappears from the cell.
I was wondering if someone could tell me what I was possibly doing wrong?
capnhud, with the text you want to change in column A, in B1 put =LOWER(A1)
and copy down
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 2002 & 2003
"capnhud" <email@example.com> wrote i...Writing to windows registry using XML....
I have query regarding the registry.
Is it possible to write it to windows registry using the XML?
if yes then what is the API or tag used to write it.
I am just a beginner in XML.
thanks in advance.
> I have query regarding the registry.
> Is it possible to write it to windows registry using the XML?
> if yes then what is the API or tag used to write it.
Why do you want to use XML when dealing with the Windows registry? It is
not based on XML so I don't see that XML helps.
The .NET framework 2.0 has this class
<...link Access workbook to Excel workbook
Can I link information from an Excel worksheet to an Access worksheet?
In Access, clic on File menu, External data, link tables and follow each step.
You'll have to define first row as heading label and that's it.
> Can I link information from an Excel worksheet to an Access worksheet?
...Use that security update
Content-Type: multipart/related; boundary="sxwxczsxhcxkocu";
Content-Type: multipart/alternative; boundary="nmfgoiam"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three new vulnerabilities.
Install now to maintain the securit...Can't Use Outlook after changing Servers
Moved users from one server to another. Users map USER folder to U:\ drive,
no chnage there. After move when trying to open Outlook it stops with an
error that there is a security problem with the .pst file. There is none I
can find. Tried deleting Outlook profile for user and installing a new one,
came up with same pst file. tried adding a second pst file and get the same
security violation, No other files have problems, WORD or Excel.
...How to access a category name and code from vbscript
I am modifying the lineitem.html for the status bar in Store operation. I
want to ask how can i access the category name and code for each item, i only
can find a categoryid function, which is in the
TransactionEntry.Item.CategoryID, but can not access the name and code for
You will need to retrieve the name and code via SQL using the ID:
resultSet=QSRules.OpenRecordset("SELECT Name, Code FROM Category WHERE
ID=" & TransactionEntry.Item.CategoryID, true)
New West Technologies
> I am modifying the lineitem.html for t...OWA Access Is Denied for Win2k Users on internet
Dear kind MVPs,
Sorry for cross posting and the length.. but i am desperate for the
Heres the setup.
one Win2k Server (DC) ,
One Win2k3 Server (DC+Exchange2k3),
One server with Reverse-Proxy configured to direct all HTTP requests to the
Exchange Server (working OK ).
Assume my exchange server name is MyServer and Proxy Server is MyProxyServer
and domain is MyDomain - names assumed for clarity otherwise valid IPs are
I am able to login using
http://MyServer/exchange interanlly ( XP + Win2k )
http://MyProxyServer/exchange from XP clients from internet
but not from http://My...Restoring shares WITH share permissions using DPM
I'm backing up about 58 shares (using DPM 2007 SP1) and need to restore said
shares to another (duplicate) server. Upon restore, the share permissions
are missing, while the security permissions remain intact. I'm backing up
what appears to be volumes and shares so I can recover either way as
well....but the results are the same, no share permissions restored. Is
there a step\process I'm missing???? Any help appreciated!
Restoring share permissions is not supported by DPM. Though DPM allows
protecting at share level, it backups/restores data underneath it incl...Any add on products I can use with SOP
We are trying to keep track of our orders that are not ready to be processed
for reasons such as waiting for approval from customer, waiting for confirm
ship date, needing customization and therefore take longer in production...
We want to be able to add a comment that has a date and an action date. Date
is the date someone enter in a comment, action date will be a date when
someone needs to follow up. We need multiple dates and multiple comments for
a single order and do not want everything type together in one comment field.
We already have collection main module and we can use so...Need access advise regarind linked versus imported tables
I have designed an application that uses a linked csv file as the main table.
The reason for this is because another user creates this file and jsut puts
it into a designated folder on their computer.
Here is the issue.
The csv file contains approximately 20K records. I cannot create any type of
index on a linked file. Am I better off importing the file into access (or
reading the linked table and inserting them into another table with an
index)? Is there an easy way to perform something like this? Will this
I am pretty new to access and am looking for any and all...Can a workbook be used as a function
I have an excel workbook (A) that givern three parameters, temp1, temp
and flow calculates the energy transfer for a process we conduct,
have another workbook (B) which contains the hourly logged data for th
process from which we generate monthly reports.
Is it possible to use workbook (A) like a function and pass to it th
three parameters from workbook (B) and return to workbook (B) th
answer ie. energy transfered.
Workbook (B) contain approx 750 logs so i need to repeat th
calculation 750 times
I could link the two which works for the first piece of logged data bu
how to automatically...What can stop a PC from displaying Access 2000/2003 text & background colours?
Can anyone suggest a reason why a specific Dell Inspiron 9300 laptop should
be unable to display any of the text or background colours on an utterly
basic test form with only a couple of text boxes and no VBA code on an
otherwise empty test database?
The problem also happens with an application of mine using Access 2003
runtime - but only on this PC. It runs fine on several other PCs.
I have applied every available Windows XP Home update and every available
Office 2000 update to no effect. The laptop (set to 32-bit colour) can
display digital colour photographs without any problem and ...Need Help Using A Custom Session Manager
I have some questions about session management.
I have decided to use a custom session manager class to have more
control over session state in my web site. I have started out by using
Stephan Prodan's Session Class here:
You'll need to take a look (which I appreciate immensely) to get a
sense of what I am talking about.
1) My first question pertains to how I persist and access my session
information after a user authenticates (or doesn't). In his exam...When to use contact and account
We are working on MS CRM for a retail bank. It has both individual customers
and corporate customers. Considering the requirement we thought of storing
both of them in the Account entity.
Is this a good approach or will it have any impact on the OOTB
functionality. Should we be using contact for Individual customers?
On Jan 12, 7:47=A0pm, mvj123 <mvj...@discussions.microsoft.com> wrote:
> We are working on MS CRM for a retail bank. It has both individual custom=
> and corporate customers. Considering the requirement we thought of storin=
> both of them i...Most Recently Used list (MRU)
My Most Recently Used list (MRU) does not always list the
Most Recently Used file. Sometimes the file i just used
shows up and sometimes it doesnt. I cant find a pattern
to identfy why it lists. Basically, i would like it to
show any time i open the file. Or, at least if i save the
file. How can i understand and control this. I now have
it set to 9 Most Recently Used files.
The MRU will only show those files that you open using Files | Open....
If you use a macro to open a file, or double click on a file to open it, then those won't show up.
You can use a macro t...Can I use 'or' in conditional formatting?
I'd like to have 4 conditions, Red, Yellow, and Green. But I have two
conditions for green, without using two conditions for green is there
a way to use OR somehow to beat the limit?
PS Win2000 + XL2002
Sure ... just click on "Formula Is", and you can use "OR" for more then two
Will trigger the set format if "any" of the above equate to "True".
Please keep all corr...Using Code instead of Criteria
In my query builder, I'm getting the message:
"The string returned by the builder is too long. The result will be
I think I understand why, as I am using a form to specify a large
number of options for the report.
Can I use VB to specify these criteria instead of the query builder?
Examples in query builder:
If [Forms]![boxSeatsMailings]![PW] Criteria =1 and (PFDirect>0 or
PFBulk>0 or PIDirect>0) then select record.
If [Forms]![boxSeatsMailings]![PW] Criteria =2 and (PFDirect>0 or
PFBulk>0 or PIDirect>0) then select record.
As ind...How to clean 0x0E value from file when using XSL?
I have some code that cleans up an xml file before running xsl
transformation on it due to what I call bad characters in the data. I
have as an example:
str = Replace(str, "", ".")
str = Replace(str, "", ".")
In there as filters to strip out characters XSL doesn't like and
replace it with periods. I am now getting an exception of a hex value
of 0x0E however can't figure out what the string replace value should
be for this one. From what I can tell, it's some kind of "shift out"
character whatever that is. A...Money using wrong date to calculate ROI YTD
I have opened a new file in Money to track investments for
a stock club. I entered all transactions, which go back
to Jan. 2002. When I look at performance for the account,
the ROI YTD is not accurate, as Money is using values for
the stocks going back only 6 months form the date I enterd
the transactions rather than the values as of 1/1/03.
What to do?
In microsoft.public.money, Brooks wrote:
>I have opened a new file in Money to track investments for
>a stock club. I entered all transactions, which go back
>to Jan. 2002. When I look at performance for the account,
&g...Using XSD stored in assembly resource with includes
I am trying to validate an XML file against an XSD that is stored in the
assembly as an embedded resource. I can get it to work as long as the XSD
does not include other XSDs. After a fair amount of searching, I have found
3 possible solutions but none have worked for me. They are:
1. Use the Includes property of XmlSchema to add included XSDs, then call
XmlSchema mainSchema = XmlSchema.Read( stream1, null );
XmlSchema includeSchema1 = XmlSchema.Read( stream2, null );
XmlSchema includeSchema2 = XmlSchema.Read( stream3, null );
mainSchema.Includes.Add( includeSchema1 ...Limited User can't use Money
I've installed Money 2004 in hopes to clear this same
problem I had with 2001, to no avail.
I installed Money 04 with my System Administrator acct.
It works fine for me. But when my wife tries with her
Limited Account, she cannot get access. How do I get her
access to this program and data? I've tried installing
it in the All Users dir, but no help. I really don't
want to give her Sys Admin priveleges just to use Money.
Thanks to anyone that can help. MS Support has no info
on this, nor does a Google search turn anything up.
If she creates a new Money file, can you b...How to check if mouse wheel has been used, system-wide?
I have the following task - I need to check time to time if mouse
wheel has been used by the user, in ANY application. I have some
kind of user activity detector, to do certain actions in application
when user is idle for some time. It would be nice to have the
ability to check if mouse wheel has been used. I already know how
to check for keyboard (GetKeyboardState and compare with previous
call's result) and mouse (GetCursorPos and compare with previous
I know how to set up a hook, and can achieve what I need via hook.
But, customer says sometimes system runs slo...how to use a saved master page
I have created a new master page and saved it as a .pub file. The question
is when opening a new document, how do I apply the saved master file?
Open the master file, copy, paste to your new publication.
Mary Sauer MSFT MVP
"Colin" <Colin @discussions.microsoft.com> wrote in message
>I have created a new master page and saved it as a .pub file. The question
> is when opening a new document, how do I apply the saved mas...How to Populate .msg File Used in Command Line
I have a .msg file I saved as a boilerplate for Calendar requests that will
be programmatically started in an application I am developing. I want to be
able to modify the Calendar request's date, time, duration, and message
contents based on the user's inputs prior to opening the .msg file. After
the user verifies the contents, he/she will click the <Send> button.
Currently, from the command line, I can run
"c:\program files\microsoft office\office12\outlook.exe" /f
The Calendar request opens with the boilerplate. Ho...