In Outlook2002 I can go to File, Open..., Other users folders...
How can I reset that list so that it is empty?
I have tried to delete the nk2-file but that didn�t seem to have any
Open a lot of folders from someone else untill they are starting to fall of
the list ;-)
By recreating your e-mail profile the list will be gone.
All info regarding this is kept in the registry;
Note that this key has never been created for manually editing so back-up
the ke...Export file to CSV delimited with fixed field length
I have an Excel file with a series of fields, each in one column.
What I need to do is determine a fixed length for each of these fields, so
that when I export this file to a CSV file, I get a file in which each column
has exactly the same fixed length.
For example, if my Excel file contains:
A B C
1234 ABC21 1234
and I want fields to have these fixed lengths:
A - 5
B - 6
C - 4
my CSV file should contain:
1234 ;ABC21 ;1234
Any easy way of accomplishing this? I tried custom cells but when exporting,
I lose the information.
Thanks in advance.
http://www.mcgimp...Calculated field to group numbers
I have a dataset that includes a field called Pymnt Days...data in the field
represents the number of days that transpire between date of service and
I would like to create a new field -- Pymnt Group -- that groups values in
the Pymnt Days field. For instance, if the value in Pymnt Days is between 0
and 45, then the value in Pymnt Group would be 1; if the value in Pymnt Days
is between 46 and 90, the value in Pymnt Group would be 2; etc., etc.
Is there a formula I might create in an update query that would calculate
the value for Pymnt Group?
Thanks for any...Populating the contactid field of the OpportunityBase table
I need to the ability to add the contact to the opportunity. I noticed
that the OpportunityBase table has a contactID field. However I am not
able to add this field to the Opportunity Form. How can I populate
this field without using any kind of Query Tool? I have CRM 1.2.
Actually I worded the above question incorrectly. I know that when you
go to add the Customer you can add either an accoutid or a contactid.
However, I would like to be able to add both since the cotactid will
represent a Channel Partner and the AccoutID will represtent the actual
Thank Y...Ranking based on Multiple Data Fields
I am trying to Rank a field based on multiple sort criteria. My query sorts
correctly, but the Ranking assignments are not correct. Could someone please
review my SQL query and let me know how to correct this problem?
I need to sort Descending by [Type2] AS WELL AS Descending by [Ext B/O]
I used the following to assign my [Type2] field data:
Type2: IIf([All BO]>=100 And [Host DN]>=20000,3,(IIf([Host
I am currently using the following to create my Ranking:
Rank: (SELECT Count([VT].[Ext BO]) FROM [tmp_tbl_Chart5a_1]...Outlook 2003 Message column headers keep resetting
I keep seeing the column headers in the messsages pane reset to their
Inbox defaults. This is really frustrating when I want to find an
email I've sent as the To & Sent fields keep disappearing, to be
replaced by the From & Received fields!
Changing these back via the field chooser is both annoying & tedious -
is there anyway to fix this issue?
Create a new custom view with the layout you desire and switch between the
default and the new one to change the view.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Wi...Copy 2 fields from subform into new form
Really do not understand VBA. I want to copy the ID fields in a subform and
paste them into a new form via a command button.
Many thanks in advance
On Sat, 27 Feb 2010 16:22:01 -0800, Charlie
>Really do not understand VBA. I want to copy the ID fields in a subform and
>paste them into a new form via a command button.
>Many thanks in advance
You'll have to give us a bit more context, I'm afraid!
Are you working on the *design* of a form? or copyin...Merge an alpha field and a numeric field
I would like to merge an alpha field with a numberic field. Not sure it this
How do you want to merge them - put the 2 results into another cell? Then you
can use =A1&B1 (assuming the alpha & numeric fields are in A1 & B1!)
Do you mean Merge Cells? If 2 cells both contain data, then merging them
will only keep the data in the upper left cell.
> I would like to merge an alpha field with a numberic field. Not sure it this
> is possible.
the mail incoming to irene
...Updating data in fields
I have several thousand records in MS CRM (leads and accounts), which
contain fields like annual turnover, number of employees etc. In 12
months time the information in such fields will be out of date and I
need to be able to up date these fields from an external source so
that we can continually target our marketing activity based on fields
like turnover, number of employees etc.
Can anyone tell me how I update individual fields for a record using
data from an external source?
Scribe Insight will do this. It has a DBLOOKUP function so that you can
search fo...reset a combobox
i'm kinda new on excel.
i want to create a button command linked to combobox; so that when i
click on the button, it reset the combobox to nil.
thxns in advance
Set the Listindex property to -1
(replace somewhere in email address with gmail if mailing direct)
"girlie" <email@example.com> wrote in message
> i'm kinda new on excel.
> i want to create a button command linked to combobox; so that when i
> click on the button, it reset the co...Invoking required fields, hiding/displaying
I have 3 custom fields on the opportunity form
new_add; data type = bit
new_adjustedamount; data type = money
new_previousamount; ; data type = money
This is the logic and behavior I am hoping to achieve using the OnChange
event of the new_add field
if new_add = true
new_adjustedamount + new_adjustedamount = required fields
estimatedvalue = new_adjustedamount + previousamount;
I would also like to see about hiding and displaying the fields
new_adjustedamount + new_previousamount based on whether or not the new_add
is ticked or not.
Not sure how to accomplish this. ...Workbook reference is reset to  in chart data source spec
Operating System: Mac OS X 10.5 (Leopard)
I try to create some dynamic charts to a worksheet using named variables and it works great as long as I keep the workbook open, but when I close it and re-open it the workbook reference has been reset to  and the chart is not dynamic anymore. What do I do wrong? <br><br>In detail, this is what I do: <br>
I define the names: <li> chtRange to =Variables!$B$4, where Variables!$B$4 contains =COUNTA(Pace!C3:CU3)<br><br><li> chtLen to =Variables!$B$3, where Var...link xml document data to textbox fields in .net
I wish to write a program that will display xml data into texboxes.
That is I write a xml document that has data and each node(s) would match up or assign to different textboxes.(etc.txtbox1,txtbox2...)
Is there a way, if so I would like to know the code.
...Migration: Migrated custom fields can't sync with plan
We migrated a set of enterprise global fields from 2003 to 2007. However,
some of the post migration changes to these fields can't be reflected into
project professional for all plans.
Example, we have a project outline code in 2003 called Portfolio, which is a
hierarchical set of values. In 2003, we allowed selection of non-leave node
and didn't allow multi-selection. After migration, we changed the settings of
the field to allow only leave node and multi-selection. However, these
changes are neither picked up by migrated project plans nor newly created
When ever I type an eMail it always comes out in red. How do I reset the
color so that when ever I start to type it is in black. Thanks for your
in outlook -- go to tools menu and select options
click the mail format tab
click the fonts command in the stationery and fonts section
adjust to suit yer needs.
"Steve Reinstein" <SteveR7138@msn.com> wrote in message
> When ever I type an eMail it always comes out in red. How do I reset the
> color so that when ever I sta...Field required
Is there a way to require something in a blank field on a protected document?
I have a protected excell doc. and I want some way to require some type on
entrey into each unlocked field. Some fields on the form are being left blank
and I want some type on reminder to prompt users that there are still blank
fields on the form
I use an adjacent cell (or column of cells) with formulas like:
=if(a1<>"","","Please enter something in A1!")
And give that cell a nice bold red font.
> Is there a way to require something in a b...how to reset up mail
i can not get or send e-mail .comes up pop3 and http sends error
My crystal ball is broke. Please post the error message in its entirety.
You can left click on it to highlight and then right click to copy and
then paste it into this thread.
Imperial Beach, CA
"confused" <firstname.lastname@example.org> wrote in message
>i can not get or send e-mail .comes up pop3 and http sends error
Please provide the name of your email provider (a...AutoNumber, messed up sequence, duplicate values.
I have a database that is used by about 20+ users entering about 1000
records per day. I am noticing that they are having trouble adding records to
the DB sometimes. When they have trouble, I go into the database table and
try to add a record manually at the source and sometimes it tells me that the
Autonumber is creating a duplicate record. As I scrolled through the data in
the table I noticed the following....
Autonumber type field called "RecordID"
1-1085 looks good
then it jumps to 3741 through 3749
then it jumps to 16864 through 17074
I know ...Create new field
Access 2007 - I have to label each claim with a claimtype based on a
combination of fields and I'm not sure how to do this. In AS400 query, I
used conditional calculations, but would really prefer to find a solution
that is easier to update and manage. Hopefully, the table below gives an
idea of the combination of fields that I am working with. Each claim has all
of these fields. However, all claims with Aslob 052 should be labeled
"Casualty". All claims with Aslob 230 and FieldB=EPG are labeled "Surety,
but those with Aslob 230 and FieldA=EIC01 should be ...Format of date field in CRM
I have just created an email template in CRM. I have put a date field that
is specified as "date only" in the schema but when it is mail merged the date
and time appears in the email. Is there a way to format these fields on
merge ie only the date? I am aware that I could push the fields contents
into a redundant text field "on save" and then hide the field "on load" but
thought there may be a way to format these fields.
I just installed Microsoft Office. One of my children entered something in
the username, password, domain name fields unknown to me. How can I reset
this to enter new usernam, password and domain name? I cannot use the
program at this point. I have tried deleting the program and reinstalling,
but it keeps giving me an incorrect login message.
1. Delete the profile under Control Panel->Mail Icon->Profiles.
2. Create a new one.
3. Teach children to not play on YOUR computer.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
I have a dialog app with a welcome window, then the main window. I
want to be able to have a button on this main (second) window that
resets everything in that window to its initial state. How can I do
that? Somehow call the InitDialog?
> I have a dialog app with a welcome window, then the main window. I
> want to be able to have a button on this main (second) window that
> resets everything in that window to its initial state. How can I do
> that? Somehow call the InitDialog?
Make your own Reset function and ca...reset autonumber
I am using a table to import data from text files. the text filess are
daily files with about 60K rows per day. So after one month, I clean out the
data and I want to reset the auto number
I am using the follwoing code to reset the auto number:
Public Sub ResetAutoNumSeed(sTableName As String, sFieldName As String, num
On Error GoTo ErrHandler
Dim cat As New ADOX.Catalog
Dim tbl As ADOX.Table
Dim col As ADOX.Column
Set cat.ActiveConnection = CurrentProject.Connection
Set tbl = cat.Tables(sTableName)
Set col = tbl.Columns...How do you reset things?
When I press the apostrophe button an a with an accent mark appears instead
of an ' (on word) how do I fix it?
You find the button on your laptop that switches between the English
keyboard and the "international" one, and press it again;
or you return Windows to using whichever variety of English keyboard
it was set to -- perhaps by pressing Shift-LeftAlt (which will toggle
or cycle through all the installed keyboards), or perhaps by going
through Start > Control Panel > Regional and Language Options to, if
you know you're never going to need them, remove al...