Changing opertation mode from Mixed to Native...
We are building one more mail server and we would like to take all to-
be-discovered advantages of Exchange 2007 since we have purchased
We figured out it is a requirement that the Exchange organization
needs to be under native mode, in order to deploy Exchange 2007. We
have no more 5.5 server and I verified having Exchange 2000 and 2003
co-exist is not a problem in changing the mode.
My concern is about our AD, it is still under mxied mode. So my
question being, is it nessasary to change the mode of AD to native,
before I could change the mode of Exchange to native?
...change Colomn name automatically
i have two different table Table1 and Table2 :
Table1 is like:
field1 field2 field3 .........fieldn
A B C N
A1 B1 C1 N1
Table2 is like this
ID_name Name .... address tel
the goal is to change the colomn name of the first table1 with the fields of
table2 (field Name).
The results should be like
pippo pluto ......... paperino
A B ...change spaces to _
Is there a way for access to return what was being input into a text box
I am having trouble with trailing spaces (access text box removes it)
therefore I am thinking to format it to "_", therefore I am still able to
preserve the length
Message posted via AccessMonster.com
>Is there a way for access to return what was being input into a text box
>I am having trouble with trailing spaces (access text box removes it)
>therefore I am thinking to format it to "_"...Change window title in dialog app...
I'm using AfxMessageBox to inform my users as to some action. How do I
change the title (it's usually the project name) of the window that's
In a normal SDI or MDI I can go to the string resource and change the
AFX_IDS_APP_TITLE, but there is no string resource for a dialog based app.
you can use ::MessageBox instead
"sftwrdvlpr" <firstname.lastname@example.org> wrote in message
> I'm using AfxMessageBox to inform my users as to some action. How do I
> change the title (it'...Excel 2002
I have a user using Excel 2002 on windows. Just this month whenever she
enters a date formatted for any day in 2004 it automatically changes
the month to the day.
We've checked the cell format and even tried to change it to a
different format and it still occurs. (ie 01/04/2004 to 1/4/2004). The
vesion of excel is Excel 2002 (10.3506.3501) SP-1. I searched the
Microsoft site for an upgrade but there wasn't another SP version
listed for Excel 2002.
Any one else come across this problem?
Message posted from http://www.ExcelFor...Re: How to change the AutoNumbers inID field in my finished database?
"hans" <email@example.com> skrev i meddelelsen news:...
> "hans" <firstname.lastname@example.org> skrev i meddelelsen news:...
>> "Tom van Stiphout" <email@example.com> skrev i meddelelsen
>>> On Mon, 4 Feb 2008 19:48:01 -0800, Jako
>>> <Jako@discussions.microsoft.com> wrote:
>>> Define "different".
>>>>This may be a simple question but...
>>>>...display text with button
I have multiple buttons and one text field (unbound). What I want to do is
when user click on the button. It will display a message in the unbound text
ie. My first button is Product and when the user click on the product button
to open the product tab control the unbound text field will show Product.
When the user click another button label Milk, the unboud text will show only
...subform data changes after each line input
In my subform I enter the data through text box entries as well as
combo box selections. After I finish a line and go to the next one
when I select in a combo box my selection is cascaded up to all the
The data from the previous lines is entered into the tables correctly
it just gets changed in the view of the subform.
Sorry I am new to Access programming. Any help
It sounds like the combo box is unbound. In design view (of the form) look
at the combo box. Open properties. Click on the DATA tab. The "Control
Source" property is the field the data is...changing from 2 dongles (2 databases) to 1 dongle (2lanes)
We recently bought MS RMS 1.3a, even bought support on it.
But, our needs have changed we went from thinking we would have 2 seperate
databases to just 1 database and needing 2 lanes.
Now, our reseller who thought Microsoft would accept a return and exchange
us or allow us to buy the 2 lane dongle informs us Microsoft has denied our
return request. Has anyone else had similiar problems? I want to know
before i call MS myself to discuss their reason for denying us. I had not
know MBS to be unreasonable to customers but this is flat out rude to not
allow us to do what we need and wast...How to input "Keep the Change" transactions with Bank of America
I just signed up for the BofA "Keep the Change" program and need to figure
out the easiest way to set this up in MS Money 2006 Deluxe.
This program rounds up my debit card transactions to the nearest dollar and
puts the difference in my savings account. They match 100% for the first 3
months, and then 5% thereafter
So...how do I do this?
My first thoughts are...
1. Create the Savings Account in MS Money--Doh! :)
2. When entering the transaction, I enter it as a SPLIT..for example..
A purchase of 99.01 at WalMart for FOOD would be split as:
Transfer : BofA Saving...Excel automatically changes the formatting of the cell to "Time"
I have a long column of numbers [dates in the YY:DD format]. I wanted to
":61" to ":59". Even though the cells are initially formatted as Text, as
soon as I make the change, Excel changes the formatting to Time, and the cell
with the change now has text ":59:00" in it.
Is it possible to force Excel to keep the cells formatted as Text?
If the cells are truly formatted as text (Format - Cells - Number - Text),
the formatting should never change, and you should always see exactly what
you've typed. Give us an example...How do I change the Customized Entity icon?
The customized entities have a default icon, any idea how to change
Settings-->Customization-->Customize Entities. Select your custom entity in
the list. On the toolbar, click More Actions-->Update Icons. Then you can
browse for a suitable image.
"Niel100" <firstname.lastname@example.org> wrote in message
> Hi All,
> The customized entities have a default icon, any idea how to change
...Publish w/o having to manually change links to get them to work
To get my web links (to my pages) to work, I have to manually type the whole
url and file name to get them to work on the uploaded page. When I do this,
the selected state feature no longer works.
Answered in the Publisher web group...
"ummibra" <email@example.com> wrote in message
> To get my web links (to my pages) to work, I have to manually type the
> url and file name to get them to work on the uploaded page. When I do
> the selected state feature no...how can i change the traditional chinese font to simplified chine.
how can i change the traditional chinese font to simplified chinese font in
...Pass changing values to parameter to Crystal Report scroll thru re
In a C# and ASP.NET app I embed a Crystal Report. In the Crystal Report I
create a parameter field named id. Then I read one id from a table and I
pass the id from the table to Crystal Report where Crystal Report creates
the report successfully.
The problem is that now I am reading atleast 5 id’s each containing a
different value from the table and I want Crystal Report to create a report
for each one of the id’s such that the user can use the carat and scroll
thru all of the reports from the first one to the last.
Crystal Reports creates reports like...Can we change line spacing in Excel? (Not row height.)
If the text is too widely spaced apart between sentences in a cell, is there
a way we can scrunch them closer together similar to what we can do in a
word-processing program when we change line height? Tx. :oD
> If the text is too widely spaced apart between sentences in a cell, is there
> a way we can scrunch them closer together similar to what we can do in a
> word-processing program when we change line height? Tx. :oD
I think you mean character (horizontal) spacing, not line (vertical)
spacing. I don't think you can do that with Excel. But yo...reuse unusable urls in a column ith 1 command
Here is another freak question from one of my students:
"I receive a column with URL's where some are clickable and others
aren't. (blue or black)
When I get into a cell with an unclickable url and press F2 and next
Enter the URL becomes clickable again. Taking me to the clicked website.
When I have a column of 5 problematic URL's this is OK but when I have
thousands of rows I get tired.
Is there a way to in one command activate all unclickable URL's?"
My idea is that we ould need a macro to go to all rows and edit and confirm.
I could write the macro ...Registry change after upgrade to 2007?
I had changed my Publsiher registry to allow printing of the entire mail
merge file when I had Publisher 2003. We have upgraded to 2007. Must the
registry be changed again? If so, does the same fix apply?
Hello, I was hoping someone could answer my question. I've used this
group before with great success:
In older versions of Excel, if a spreadsheet had named cells in it,
those named cells could be inserted into a formula simply by selecting
the name from a drop down list. The down arrow for the list is beside
the formula line immediately above the spreadsheet grid.
In the newer versions of Excel, if a spreadsheet has named cells in
it, those named cells do appear in the drop down list. HOWEVER, once
you begin to enter a formula into a cell (i.e. entering the =93=3D=94 sign)=
the dr...Changing users Email Address, problems...
I have a user that has an email address firstname.lastname@example.org. He wants his
email to be email@example.com so I went into the AD Users & Computers and
added firstname.lastname@example.org to his email addresses. I then set it as the
primary, and it looked like it took it. Then twenty seconds later it
changed it back to bcastillo. Any idea why this would happen?
Your default recipient policy is probably setting it back to the format
specified. You can change the recipent policy or uncheck the box that
automatically updates email addresses according to the recipient policy.
Is there a formula in excel which allows you to convert numbers to th
respective number names?
e.g. 21 will be retunred as "twenty one
Message posted from http://www.ExcelForum.com
Not as far as I know. You will probably have to write a
macro do it.
I'll try to write one and post it to my website at:
Keep an eye out for it in the next couple of days. I can
send it to you if you write to me and tell me your number
>Is there a formula in excel which ...Custom number format button
I'd like to create a toolbar button linked to a custom number format so that
clicking on the button would re-format the active cell or range to my custom
Alt-F11 to enter the VBE
Insert | Module
Paste the following code:
Public Sub aTester()
Selection.NumberFormat = "#,##0_);[Red](#,##0)"
Alt=F11 to return to Excel
View | Toolbars | Customize | Select 'Commands' tab
Select 'Macros' in the left-hand Categories window
Drag the smiley icon ftom the commands window to your toolbar
I have an excel file that is password protected and will
be shared by 5 people. I know that shared workbook and
tracking changes doesn't work on a password protected
file. Is there any other way of tracking changes made by
5 different people?
You can't change the sheet protection in a shared workbook, but AFAIK
you can share an Excel file that is password protected.
Did you try it, and encounter some problems?
> I have an excel file that is password protected and will
> be shared by 5 people. I know that shared workbook and
> tracking chang...Sorting songs by real names?
Is there a way, without using a leading space, to be able to sort songs with
their real names. By that I mean not ignoring the words "A" or "The" for
exmaples. Sometimes these words are an integral part of a title.
Any ideas out there?
A work around can be
- WMP has a lot of tags you probably don't use
- find one accepting text and not doing 'intelligent' sorting
- use a tool like MP3tag to copy the titles to this tag
- do the sorting on this tag
> I...Domain names up for grabs, earn on the net .