Find and replace 03-04-10
I'm trying to scan a field in one of my tables and find a specific character
and remove it. However, the character is a " so I'm having difficulty. The
field I speak of of contains the sizes of our material so the values look
1/3" and so on.
How can I find all of the " in my feild and remove them? I don't want to
replace them I just want to remove them.
Create a query, and in the Criteria row under the problem field, enter:
Allen Browne - ...How can I find career change resumes templates?
I like to review some nice "Professional Career Change Resume Templates" for
the job market. If someone could tell me where to go on the inter-net, it
will be well appreciated. Thanks!
You could start at www.google.com
"Mike" <Mike@discussions.microsoft.com> wrote in message
:I like to review some nice "Professional Career Change Resume Templates"
: the job market. If someone could tell me where to go on the inter-net, it
: will be well appreciated. Thanks!
Templates are...non latin characters in nvarchar
is there a way to select nvarchar fields, that have non latin characters ?
Do I have to use UNICODE() and search for high numbers ?
Volker Jordan (email@example.com) writes:
> is there a way to select nvarchar fields, that have non latin characters ?
> Do I have to use UNICODE() and search for high numbers ?
That or an expression with patindex:
WHERE patindex('%[' + nchar(nnn) + '-' + nchar(65535) + ']%',
col COLLATE Latin1_General_BIN2)
This assumes that there i...Lookup/Find help
Windows XP Professional
Hypothetical, but hopefully you'll get the gist of it:
I have two worksheets. On worksheet #1, I have two columns. First
column is a list of entire workgroup by name and 2nd column is the hours
worked. On the second worksheet I simply have an list of names that
is a subgroup of those on the first page. These indicate a target group.
Now, on the first worksheet, I want to add a third column for summing
only the target workgroup. Basically, I need a function...check instance running
My application will call another application and would like check is
it running or not.
Are there any function to check the instance already running?
Your information is great apprecaited,
Check http://www.mvps.org/access/api/api0007.htm at "The Access Web"
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"iccsi" <firstname.lastname@example.org> wrote in message
> My application will call another application and would like check is
> i...how to organize several class and their instance in windows programming
Hi, everyone, I'm designing a project which could do some image
processing, motion control and networking using MFC.
nowadays I'm puzzled how to organize so many class and their instances.
Though I think the "design pattern" could solve my problem, but what I
only want is to get a simple method or a belief understand.
suppose these class are like this:
CImageProc (class deal with image processing)
CMotionControl (class deal with motion control)
CNetwork (class deal with networking)
CXXXClass (class doing other work)
This is the way I use, in the CMainFrame( I'm...Create an instance of new Customized entity by Workflow
I created an entity named E1 under Account entity(Many-to-1 relationship with
Account) then I want to create a workflow Rule that after creating an Account
an instance of E1 entity is created automatically.
It seems Activity creation is possible in workflow automatically!
Is any soloution for this issiue?
you can create activities but not custom entities. You would need to either
do this by using a callout or by creating a workflow .net assembly that can
create the custom entity for you.
Microsoft CRM MVP
http://codegallery.g...Multiple Outlook 2003 instances launched
I'm running Outlook 2003 on my home machine to access my Verizon email
It does not matter how I launch Outlook, from the Start Menu, from a Desktop
shortcut, or from the Launch Bar, I always get multiple instances of Outlook
Does anyone know what is going on here and how I can prevent the multiple
Outlook will only display one instance under normal circumstances. Did you
perhaps in a previous session elect to open other folders in a new window?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Al...can't find normal.dot
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I need to delete my normal.dot file and I can't find it anywhere. I've had to do this before and I was able to find it in the templates folder, but I guess an update or two has changed that. Can anyone tell me where to find it? Spotlight says that it doesn't exist. But I have to be able to delete it. Is it called something different now?
If you're using Spotlight & searching for "Normal.dot" it's no wonder it
isn't being found - that isn't the correct name :-) it's ...Finding maximum value
I want to find the maximum value in a column, but I want to ignore the
negative and positive part of the value. Basically, the maximum difference
Example: the maximum value I am looking for will be -0.467.
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
In article <OGKhnF1KEHA.2100@TK2MSFTNGP10.phx.gbl>,
"Ruan" <email@example.com> wrote:
> I want to find the maximum value in a column, but I want to ignore the
> negati...How do I find the inside page in the 3-panel brochure.
I am trying to make a 3-panel brochure and all that seems to be available is
the side shown in the brochure options. When I print, it prints both sides
yet I can see no way to access the inside part. Thanks.
View, status bar... this will allow you to change page views, you will see the page
tabs at the bottom of the screen.
I am not sure I know what you are asking. Are you saying you are printing the
brochure sight unseen?
Mary Sauer MSFT MVP
"springmtn" <firstname.lastname@example.org...Find a multiple photos on a page template for Publisher?
Possible to find a template for Publisher to print a page full of multiple
photos without recreating the page each time I print.
Why not save your page you have created as a template?
File, "save as", files of type, scroll down to Publisher template.
"srfaith" <email@example.com> wrote in message
> Possible to find a template for Publisher to print a page full of multiple
> photos without recreating the page each time I print.
...Searching in a column of strings
I try to find how many cells have a sequence of
charcters. From Cell A1:A50.
Exemple for "NY" :
cellA1 = NY123
cellA2 = NY3235
cellA3 = NY5434
cellA4 = LA4234
function(NY) = 3
Like Seach but instead to be in a single cell, it's in
a sequence of cell?
"Jack" <firstname.lastname@example.org> wrote in message
> I try to find how many cells have a sequence of
> charcters. From Cell A1:A50.
> Exe...formatting selected characters or numbers in each cell within a range of cells
I am sending this to several Excel newsgroups, because I am not sure
which one if the most appropriate. I apologize in advance for the
multiple postings. I have MS Excel 2000 (version 9.0.3821 SR-1). How
can I format only a selected character or number within each cell in a
specific range of cells? For instance if I have a cell containing
�1234234�, how can I format it so that only the 2�s are bold or are
colored? Obviously, I have a range of cells, and I want to format all
the 2�s occurring in any of the cells as either bold or colored.
Conditional formatting does not seem to all...Finding Desktop region in MFC
I am working on a commercial application, and recently discovered a bug
I have been asked to fix (they threw it back in my lap).
Run the application on a 2-monitor system, such as a laptop in a dock
with an external monitor. Drag the main window to the second
(non-taskbar) window and quit. Now move the laptop to a different dock
with the second menu on the other side (or without a second monitor at
all) and launch the app.
Oops. The app continues to want to go on the side it was last put, even
though there is now no monitor there. (Yes, my dock in the office and at
home have the second ...Performance counter for Outlook Finds?
What server performance counters (if any) are there for monitoring the
number of "Find" requests that Outlook clients make?
...finding calendar and data info
I had to move my primary hard drive into another computer. It is now running
as a slavein the new computer. I'm unable however, to find my calendar and
contacts from Outlook 2003 when I open the program on the new computer. If I
attempt to open the program from the F drive (the drive assigned in the new
computer to the hard drive that was moved from another computer) it tells me
the program is not installed. If I open Outlook 2003 from the C drive of the
new computer, of course, it doesn't find the old calendar and contacts. I
would appreciate any and all assistance in findin...Conditional Formatting VBA with formula to find string
Please can I get some help....
I need to create a conditional format VBA in Excel 2007 (because I have many
conditions to include) and I don't know how to do it...
The Action Required:
If Product A appears in any text string in range($C$95:$C$300) then colour
that cell RED,
if Product B appears anywhere in a text string within range($C$95:$C$300)
then colour that cell BLUE,
if Product B appears anywhere in a text string within range($C$95:$C$300)
then colour that cell GREEN,
and so on through 41 products...
- I have a list of about 41 Product names in range Z...Using sdk to find out if an Account already exists
Want to use sdk to see if an Account already exists , all i have is
I've looked at Retrieve method but it requires the Guid.
Any equivalent call to Retrieve that just takes name? Or a way to get
the Guid from the name?
Sample code would be great if available.
Thanks for all help.
The method you are looking for is RetrieveMultiple as only the guid
search gives the certainty to retrieve only one record.
All explanations are in the sdk but as the sdk sample is nearly the
exact code you want, here it is :
// Set up the CRM Service.
CrmService service =3D new ...Find number of weekdays and wekend days given a total number of da
I have a question for the gurus here.
I am working on a spreadsheet where in column A I have Total # of Vacation
# Vac Days --- # Weekdays --- # Weekend days
75 55 20
44 32 12
25 19 6
I figured this out by simply creating a list like this
And so on...
And then doing a countif to figure out how many of either on...Doesn't find files w/spaces in name
There are a lot of folders and Excel spreadsheets on our shared drive that I
need to open. Most of the folders and file names are named like:
get reports\reports sep 2004.xls
When I try to open one, Excel doesn't find it and I think it's because there
are spaces in the folder names and/or file names. Is there a setting in Excel
that will help me get around this? This was working until I had a glitch in
Excel and the technician fixed the glitch and this problem appeared.
Any help would be appreciated.
I found an answer and so far it works. "C:/program files/microsoft
off...SQL statement to find a particular column within all tables
I am looking for a query that will allow me to find all instances of a
particular column within all tables so I know where they are all located.
Does anyone have such a query they would be willing to share?
I posted this query a few months aback on my blog
(http://dynamicsgpblogster.blogspot.com/2008/03/in-past-days-i-have-found-lot-of-people.html), but here is the excerpt:
select distinct rtrim(objs.name)
from syscolumns cols
inner join sysobjects objs on (cols.id = objs.id)
inner join sysindexes indx on (cols.id = indx.id)
where (cols.name = 'ACTINDX') and (ob...Multiple Instances of Manager Program
I have a situation where it might become necessary to have multiple people
running the SO Manager program at the same time. Doing edits and changes
primarily. Has anyone run up against any performance/stability issues
under such circumstances. Does this cause any instability problems with
the POS frontend also operating at the same time? The reason I mention
this is that we did some experimentation with having an MS Access forms
app try and edit some data in the Customer table and it would cause the
frontend to crash if we were operating on the same record. We we...Problem displaying string data in Edit box
I am trying to display a CString in an Editbox. In the dialog, I have
set the edit box to multiline, read-only, auto vertical scroll and
want return. I set the Edit box with the CString variable when a
serial handler occurs.
The serial handler code is obtained from http://www.codeproject.com/KB/system/serial.aspx
and have integrated into my main dialog.
I have created a edit box variable in my dialog and create a member
variable within the main dialog window. When the serial handler is
called, I store the serial message into the CString variable and use
SetwindowText() to display the st...formula to add a number to a long string **
I'm not quite sure how to best describe this:
I need a formula that will take the example below and return the "final
Col. A = 220.127.116.115 and Col B= 23 making Final Result = 18.104.22.1688
Is there a way to do this?
This seems to work:
If this information was helpful, please indicate this by clicking ''Yes''.
> I'm not quite sure how to best describe this:
> I need a formula that will take the e...