Finding characters within a text
How to check, using single formula, that a text within a certain cell
contains one of certain characters? For instance, how to check if there is a
'R', 'L' or 'Ps' character within cell A1 that reads 'W-RII'.
Thanks in advance
Hmm..not very elegant, but maybe
Returns TRUE if the text in A1 contains 'R', 'L' or 'Ps' .
FIND is case-sensitive, use SEARCH if you also want to find lower-case
Joerg Mochiku...Sql to find record in a hierarchical chain
Hi, lets say I have a table with 2 fields:
Field 1 - ref
Field 2 - parentRef
Now in the structure there could be numerous chains until you get to
the top of the hieratchy (where the ref field = parentRef field).
so in this 444 is top of the chain (there will be many other records
as well that are nothing to with 444 and are part of their own
hierarchy). So how do I easily relate 111 to 444. Ie how do i find
the ultimate top parent for a given 'ref' field.
Hope anyone can give me some pointers ...Need Formula To Find Blank and NonBlank Cells
I have a worksheet with 6 columns (by Month)
Sep Aug Jul Jun May Apr
I have to review starting for example with May, I need to find any cell in
May range that is null <> where Jun and Apr both are not null <>
So if May is null and Jun and Apr are not null than I would count that as 1.
If May is null and either Jun or Apr are null then I would not count them.
"hilltop55" <email@example.com> wrote in message
news:08D989CB-D1B4-49F...Need to import EDI file
Hello. I have an EDI TS-130 file (academic transcript) that I would like to
import into Access 2003. Is this possible to do for free? If so, how?
...Downloaded songs no longer appearing in Media Player
Hello! I have been downloanding and ripping songs for a few months now and
they all appear in Media Player once I play them once. Nothing has changed
to my computer or software systems (I'm on Vista and using Limewire). Now,
for some reason, the songs I'm downloading will play if placed in the "Now
Playing" area but do not save to the Media Player library.
Is there a possibile limit to the number of items in the player? Any other
suggestions? I appreciate any ideas anyone would pass along as I'm working
on a project and cannot afford to lose what I...Downloading multiple messages
All of a sudden outlook has started downloading multiple
messages from my pop account (ie 22 of the same)
It is also sending out 22 of the same message.
How can I resolve this issue?
What version of Outlook do you have? Does it download duplicates of *all*
messages, or just of one or two messages?
This posting is provided "AS IS" with no warranties, and confers no rights
"GW" <firstname.lastname@example.org> wrote in message
> All of a sudden outlook has started do...Finding all queries which use a table
Does anyone know of a tool that can scan all queries in a database and find
if a certain table is used? I have a table called tblCustomerRollup which is
old and outdated. I want to see which of the 500 queries in my database use
this table without opeing every single one of them?
Sounds like a variation on Search/Replace. Try searching online for
"Database Documenter" as a starting point.
A couple of the commercial tools I've used include FMS, Inc.'s Total Access
Analyzer and Black Moshannon's Speed Ferret. There are a lot of fr...Where do I find SSADM 4+ templates in Visio ?
Hi, I understand SSADM 4+ templates were available in Visio 2002. I have just
moved from Smartdraw to Visio Professional 2003 and am having difficulty
finding SSADM 4+ templates.
Does anyone know where I can find these templates? Are they still available
in the 2002 version?
...need custom cut and paste functions
I once wrote here about a problem I had cutting and pasting where columns
would turn to "REF!" after a cut and paste. I would work around it by
copying, pasting and then manually deleting instead. I thought turning
everything in the sheet to absolute references would solve the problem but
it didn't so now I am thinking of a different solution.
Could someone tell me what I need to do to write my own cut and paste
functions which would basically copy the selection and then on a paste it
would paste and then delete the original selection from where it was copied
from...You wont believe this! SERVER DOWN
I was helping the operations/it director to get RPC over HTTP going on their
exchange server for a company I use to be the sys admin for. The ops/it
director was doing the add/remove programs portion to add rpc over http
there, somehow in the process of doing this he managed to uninstall IIS -or-
just NNTP and SMTP (I can't figure out which and he claims he did neither).
Long story short, I've reinstalled NNTP and SMTP, reconfigured SMTP to the
best recollection I have of the previous config and the server still refuses
to send/receive email, even internally. All services are s...wire transfer download problems
I made an international wire transfer of $5000 from my US bank. The receiving
bank in Panama took $15 as a service fee and credited my account with $4885.
Somehow my US bank now wants to show the amount as $4885 during downloads
to my checking account. But some genie reminds Money 2004 that the original
amount was $5000 which triggers a discrepancy. As a result, this transaction
wants to download each and every time, whether I change, accept, or whatever.
Thanks for help.
In microsoft.public.money, lanecito wrote:
>I made an international wire transfer of $5000 from my US bank. Th...2003 Outlook email only downloads headers, not the full message
When I attempt to open an email I receive " This is a message header. The
full item has not been downloaded."
At INBOX, ALT CTRL-S >SEND/RECEIVE GROUP>All Accounts>EDIT >displays an
option to display headers only or the entire message including the
attachment. In the grayed out area, I can see that a dot in the display
headers only section. Due to the gray out I cannot chooose the alternate
How can I access the alternate choice?
Which mail account type are you using?
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft O...XL 2007: How to find out what keyboard shortcuts I've assigned to macros?
Over the years, I've recorded and written a lot of macros. (Probably
time to take a week or two and go over them and delete at least
half!) I assigned a keyboard shortcut to a lot of them.
I seem to remember that before XL 2007, there was a keyboard organizer
that I could go through and review what shortcuts I had already
assigned to my macros. I can't find that in 2007, though.
Is there an easy way to generate a list of all my keyboard assignments
and what macros they go to?
I don't recall ever seeing any such keyboard organizer in 2007.
Canned from a prev...Mailbox needs reducing
We have this mailbox that has been left for months and with no limits, it's
Ho can I trim in down, I don't really want to go into the mailbox and do it,
can Exchange do it?
Gonzo <email@example.com> typed:
> We have this mailbox that has been left for months and with no
> limits, it's now 11GB!!
> Ho can I trim in down, I don't really want to go into the mailbox and
> do it, can Exchange do it?
Presuming you're not on 5x or earlier, you can use mailbox management
policies to get rid of items ol...I need help restoring Public Folders
I've been having issues getting Public Folder replication going between 2
Exchange 2003 servers.
Prior to doing any work I performed a Backup using Veritas Backup Exec and
this completed and verified correctly.
I screwed things up and managed to delete some of the public folders on my
original server. I'm not 100% sure what I did but it is a mess and the only
backup I have is the Exchange backup I created before doing any work.
The public folders contain a number of Contact Lists and a very important
I have restored the public folders but when the restore c...Need help on a formula 05-20-10
I need a formula to calculate the following information please: I will have
someone enter a time (ex 6:31) in cell C3. If the time matches one of the
times in cells B17-B22 I need it to display 4.6, if it matched one of the
times in cells B23-28 I need it to display 4.7, if it matches one of the
times in cells B29-34 I need it to display 4.8 and so on. Does anyone have a
simple formula I can do for this please?
Can't do the "and so on" part, bu...[ANN] "Bend Word to your Will" -- April 2005 edition free download
THIS ANNOUNCEMENT IS ABOUT A *NON-COMMERCIAL* RESOURCE BASED IN PART ON
ACCUMULATED ADVICE FROM THIS NEWSGROUP
The latest version of my notes on Word -- titled "Bend Word to Your Will" --
is now available for downloading from the Word MVPs' site,
WHAT IS "BEND WORD TO YOUR WILL"?
"Bend Word to Your Will" is not a commercial product for sale -- it's free.
It's a dictionary-style (mainly) set of notes on Word that I've been
continually adding to and polishing for the past four year...Need Syntax for "AND" to Evaluate 2 Cells
I need to evaluate 2 cells while inside an "Private Sub
Worksheet_SelectionChange(ByVal Target As Range)". I thought AND would work
but I cannot get it to work; I receive a syntax error on the AND(Range...
Can someone please provide me the proper syntax to evaluate the 2 cells?
Here's my code...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveSheet.Name = "Sheet1" Then
And(Range("I3") <> "", Range("K4") = "") Then
Range("K4") = Range("K3")
End...Find and replace with bold in cells
I have a VB6 program that is executing Excel 2007, opening a worksheet, and
extracting some of the cells to write data to a text file. Some of the cells
contain bold text on some (not necessarily all) of the text in the cell. I
would like to do a find and replace on the bold tagging to replace it with
something like "<b>" at the start of it and "</b>" at the end of it. How do I
set this up in VB6? Thanks!
The following function will return a string including <b> and </b>
tags from the text of cell R.
Function BoldMarkup(R As Range) As...Formula to find last monday (tue, wedn, thu or friday) for a given month
I need a formula to calculate the date of the last monday, tuesday,
wednesday, thursday or friday of a given month.
Can't seem to find the answer anywhere.
day: wednesday (or corresponding nr)
Who can help?
Thank you for reading and eventually answering my question.Back
Microsoft MVP - Excel
"Michele" <firstname.lastname@example.org> wrote in message
> I need a...Need to retrieve a deleted Excel File
On Saturday I hide an excel sheet and then protected the
workbook. When I got into work today to open the file it
was non-existent. What do I have to do to retrieve the
file? Does it make a difference if the file extension
ended with .csv?
Thanks in advance!
Search in Windows to make sure it's still on your compute
go to the folder the file is in and look to make sure it's still ther
If you didn't do this, you might need to to text, which includes *.cs
Excel is not set to open this type of file by defaul
Did you (try to) open the file with Excel.
If so : did ...ebay - ereseller stook my money
a terrible thing happenned to me on ebay.
i am a disabled woman in and eresellers took my money and never sent my washer.
his email address is email@example.com.
anything that you can do to help would be nice. ebay is doing nothing.
i can give a reward
This group is for discussing the Microsoft Money computer program.
Does it really sound like an eBay buyer complaint forum?
Do a google search on ebay and you will find a couple of groups, one
of which may reply to your problem.
That ebay seller has been selling on ebay for over 5 years.
On 1 Jun 2004 13:50:08 -0700, (An...Switching Accounts on Download
To Whom Can Help:
MS Money 2007 has started downloading account information into the wrong
account--it is swapping it with another account.
This happened in a previous version of Money and I don't know how to correct
In the previous version it was with a Banking account--two savings accounts
from the same institution.
In this incarnation, it is with two investment accounts--mutual fund versus
brokerage account--but from the same institution.
Anyone have this happen to them...anyone know of a solution?
Thanks for your help.
In microsoft.public.money, golfbum71 wrote:
...how can I asign printscreen to a function key or key combination?
My key board has no printscreen key. What can I do?
That seems unlikely, but it is hardly a Word issue. The PrtScn button is
usually a dual function button somewhere on the top row of your keyboard. If
it is not then you need to ask the keyboard manufacturer.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< ...How to return the primary key from a combo box
I have a table containing two columns
Column 1: Primary key
Column 2: Name.
I want to create an unbound combo box that shows the name but returns the PK.
I have these properties set:
Control source: <is empty>
Row source type: table/query
Bound column: 1
Row source: <I have a select that returns the desired records>
In cboClient_AfterUpdate() I look at debug.print cboClient.Value and I see
the name. I need the PK so I can construct the query for the next combo box.
How do I get the PK
Thanks for the help
Message posted via http://www.accessmons...