Create sequence number for table
I have a table with a Title field, comment field and a Sequence field. I
would like code to sort the table by Title and then fill in the Sequence
field based on the order of the records. The first record would have a
sequence number of 1, the second record a 2, etc.
Can someone help me with code to do this?
Thanks in advance.
"Phillip" <Phillip@discussions.microsoft.com> wrote in message
> I have a table with a Title field, comment field and a Sequence field. I
> would like ...Exporting email with atachment to text file
I would lke to have a backup of all my email in a pure text form. Many
years ago I used Netscape email, and the entire mail file was pur text;
attachments followed the message and were encoded in base64. I could
always retrieve my email (with a little effort) by cuting and pasting,
and using uuencode to retrieve the binary form of the attachment. Is
there any way to do this in Outlook?
I have recently encountered difficulties with different versions of
Outook at home and work, so would like to avoid problems like this in
the future by having a purely text email file.
<dtshedd@yah...Rich Text / Plain Text. Error message
Every time I send an email, I get a window telling me that the email I am
sending is in Rich Text format ((HTML) and asking me whether I wish to
proceed by sendng in HTML, sending Plain Text or canceling.
This is regardless of whether I am sending a simple attachment (Excel file a
picture) even without any text.
I have also just deleted my old account and re-set it up again.
Please can you tell me how to avoid this message in the future?
Looking forward to your answer in anticipation.
Isn't there a "Don't show me this again" ...Listbox contains check box, small image icon and text
I would like to implement a list control in which every row contains check
box, small image icon and text. how can I do it? Are there any sample codes?
Nothing impossible, Nothing sure
This will be a good start:
"NianHawk" <NianHawk@hotmail.com.invalid> wrote in message
> I would like to implement a list control in which every row contains check
> box, small image icon and text. how can I do it? Are there any sample
Dont k...If-Then logics
I have a work sheet with numbers in 'Column A'. In 'Column B' I wish to get
the following output:
If column A is < 3000 then give me '1'; If column B is >5000 then give me
'3'; if column A is >3000 but <5000 then give me '2'.
> I have a work sheet with numbers in 'Column A'.
> In 'Column B' I wish to get the following output:
> If column A is < 3000 then give me '1';
> If column B is >5000 then give me '3';
> if...Context Menu w/Popup missing initial menu text
Hello. I've been trying to find the answer to this on my own, but it's
just not getting me anywhere.
I've put in a context menu with a popup. Problem is, I can't get the
first menu to display, but I can get the contents of the popup to show
Here's the code I'm working with.
BOOL CGUISnoopView::OnNotify(WPARAM wParam, LPARAM lParam, LRESULT*
CGUISnoopDoc* pDoc = GetDocument();
CPoint pt;...How to make ListBox refresh an item's text when the item object is changed?
public override string ToSting
.... return different values according to its state.
in the form's code
SomeClass s = new SomeClass();
If I add it like that, the Listbox will use ToString() method to
display the SomeClass. But the problem is when the SomeClass's inner
state has changed and therefore ToString() value is changed, the
Listbox doesn't reflect the change automatically. What could be the
best clean solution? The only way I can think of is not to add the
SomeClass directly, but add its ToStrin...Text box reference a cell
I have a text box that I want to be equal to a cell. I posted a similar
problem yetsreday about colors in two objects, but now I need the syntax for
textboxes. Here is what I have so far:
but it is having a problem with the syntax before the = sign. The text box
is protected, so I was trying to avoid selecting the object.
Drawing toolbar textbox ? No code needed. Just select the textbox, and enter
in Excel's formula field
HTH. Best wishes Harald...Testing #3
I have never done this before cool huh
...IF THEN LOGIC
Can you have a cell return a value based on another cell's input. Ex: If I
enter the year 2004 in a specific cell then I want another cell to display
the date 12/01/03 or some other date or value that I would pre-determine.
"flotowntiger" <firstname.lastname@example.org> schrieb im
> Can you have a cell return a value based on another cell's input. Ex:
> enter the year 2004 in a specific cel...TEST SUBJ
TEST SUBJTEST SUBJTEST SUBJ
"mr. test" <email@example.com> �������/�������� � �������� ���������:
> TEST SUBJTEST SUBJTEST SUBJ
"Mr. Tester" <firstname.lastname@example.org> �������/�������� � �������� ���������:
> OK PASSED
> "mr. test" <email@example.com> �������/�������� � �������� ���������:
> > TEST SUBJTEST SUBJTEST SUBJ
> > ---JJ
...Concatenated text and Leban's Rich Text Control
I was wondering if anyone has run across the problem I'm having with
concatenating rtf control contents and line returns.
I am using Steven Leban's rich text tool in Access 2007 (as
Microsoft's integrated rich text control is pretty much useless if you
need to manipulate its contents) (Steven's tool is excellent). I am
trying to insert new text into the middle of a rich text field, after
formating it as needed, however, I've noticed that the rich text box
inserts a line return at the end of my inserted text.
I have searched around and have read that rich t...Publisher 2003
Im trying to find out how to update certain textboxes (if that's what
they really are) automatically.
If you notice when you open a template and insert a new title, Certain
boxes on the following pages automatically contain the SAME TEXT that
you inserted for the title.
Is there a way to do this in OTHER AREAS, for instance, I have a
newsletter that will be published monthly there are 6 areas for
articles, I have a small table of contents on the first page (its not
formated as a TOC just a table with Titles and Page numbers)
What I want to do is have those Titles automatically update wh...IF THEN logic
A B C D E
CID IID Concerns Interests Contact first timers Identifier
1 1 Building Fellowshi NO U65286929 a
2 4 Tips for Meeting sp b
1 3 Building Opportuniti NO L35069718 a
What i want to do is:
if column G has an "a" then count column A if it has a 1 in it
if column G has an "b" then count column A if it has a 2 in it
Seprate the data as first choice and second choice.
=SUMPRODUCT(((G2:G200="a&quo...Insert Bookmarked text
I use Word as the default composer in Outlook.
I have a button in Word that, using VBA code, will insert into the active
document the contents of a
certain bookmark found in another Word document.
Here is the essence of the VBA code:
Selection.InsertFile FileName:="MyDocName.doc", Range:="Address"
In 'regular' Word, the process works just fine, and the text found in
bookmark 'Address' is properly inserted.
But in Outlook, the command results in the entire document "MyDocName.doc"
being inserted as an attachment to the message. Is there any wa...Entering Text and Date
I need a macro that will enter some text "Uploaded" and the date and time in
this format "The text" date time such as Uploaded 04/19/07 12:42 PM. I don't
want this time to change after it is entered"
Can any one help?
ActiveCell.Value = "Uploaded " & Format(Now, "mm/dd/yy h:mm AM/PM")
MS Excel MVP
"Herschel Lawhorn" <Herschel Lawhorn@discussions.microsoft.com> wrote in message
>I need a macro that will enter...Sorting numbers into ranges i.e 0-1000,1001-2000 and getting count
I need to sort the following
so that it sorts by type and then does count between ranges 0-1000
type 0-1000 1001-2000 2001-3000
banana "with a count here "
Message posted from http://www.ExcelForum.com
1. Add a helper column to show your type. e.g. enter the following in
column C / cell C1:
=MAX(INT((B1-1)/1000),0)*1000 & " - " &
and ...Visio 2003
Visio 4, 5, 2000 and 2002 could automagically create great drawings
(flow-charts) from text-files. Visio 2003 professional does not recognize
the text-files my VC6 application creates :-(
I there an available another not so hard technique my application can use to
let Visio create my simple drawings?
Template, "Audit Diagram.vst"
Shape,"2","I/O","Some kind of input",,,,,,,
Shape,"3","Decision","Test the input",,,,,,,
...Removing text #3
Is there anyway i can remove unwanted text and numbers from samples below
Blythe Knight(IRE) 34 Course and Dist winner
Ecomium(IRE) 174 Distance winnerBeaten Favourite
Echo of Light 25
Khyber Kim 36
and just leave the names ie: Almuraad(IRE), Khyber Kim etc.
Any help will be welcomed.
Here's one way assuming all entries have some numerical digits in them:
Entered as an array using the key combo of CTRL,SHIFT,ENTER:
=LEFT(A1,MATCH(1,(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))>47)*(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))<58),0)-...Showing Significance Testing in Bubble Charts
We are preparing a bubble chart in which the x-axis shows scores from a
survey, the y-axis shows relative importance, and the z-dimension shows the
percentage point change in the score from the previous period. We have set
the default color of the bubbles to grey (which means no significant change),
and would like to make the significant changes colored in red (negative) or
green (positive). We have already done the stat testing, and can mark the
significance testing with a -1 (negatively significant), 0 (insignificant),
and +1 (positively significant). We would like to be able to autom...Label cell size changes when text direction changed in Word?
When making labels, the cell size changes when text direction is changed. I
would like to have text read vertically - to label spline of binders.
Selecting text direction changes the cell size so that it does not match the
size of the sticky back labels. It results in text running off edges of
label. I am using label sheet 6466. So, I would like to:
but it progresseively moves off sticky back label centers as more labels made.
It sounds as if you need to change the ori...A question of concept/logic
I would really appreciate your help on the programming logic of the
Let's say you have an invitees table with Invitees_ID and Invitees_Names
Assuming that you have another table this time with Events_ID and _Name.
Now I would like to be able to select invitees, some of them, and invite
them to q selected event.
Which logic should I use:
- Make a third table with gathered Invitees_ID and Events_ID?
- Make a table for each events' year so that it can last in the future?
Any correction/info will be greatly appreciated :)
Have a nice day
P.S. sorry a...lookup function 01-26-10
how can I set up a lookup that will insert jpegs into a cell range. The
jpegs are currently listed in Windows photo gallery
> how can I set up a lookup that will insert jpegs into a cell range. The
> jpegs are currently listed in Windows photo gallery
...text not wrapping in column
I have an Excel spread sheet with columns of wrapped
text. At a certain point, the text stops wrapping. If I
try to shrink to fit, the text disappears. Any ideas?