Sorting Alphanumeric values in a text field
I'm using Access 2003 for a database for my company. I have a field in a
table that has both text and numbers. They are part numbers, for example
21BC124. I kept the field as text because of the text with in the numbers
and didn't figure that a numeric field would alow the text. In my part
numbers table it sorts correctly (first by number then by letter then by
number again), but in my reports and queries there are a few number that sort
in the wrong place. Like this...
I can't quite f...How to create a CustomerID field for custom entities
The customerid field is used in opportunity and case and it allows you
to select an account or contact, Great.
I want to create this field in a form for a new entity i have made,
but i cant work out how.
Customer is special composite type which is not available for custom
entities in CRM 3. You will need to add two separete lookup fields for
account and contact.
uMar Khan :: MS CRM MVP
CRM Freelance Consultant
Email :: imumar at gmail dot com
Blog :: http://umarkhan.wordpress.com
MVP :: https://mvp.support.microsoft.com/default.aspx/profile/umar.khan
Hello, does anyone know how they call the suggestion field that appears at the explorer bar when you type an address. Or appears when you double-click on a username field. I would like to create something like that; maybe someone knows how to do that. It's probably simple but because I don't know the exact English word for it, it's hard to find.
You might want to take a look at IAutoComplete. Here is an interesting
article that talks about it a bit.
"Woestenburg" <Woestenburg@discussions.micr...Question On Fields
What is the (Microsoft desciption)difference between the
SIC field and the Industry Code field? To me they seem
like a duplication.
According to the Deployment Manager descriptions of attributes:
SIC - Standard Industrial Classification code for the Account
industrycode - the type of industry with which the account is associated...
Hope this helps!
"Shauna Koppang" <firstname.lastname@example.org> wrote in message
> What is the (Microsoft desciption)difference between the
> SIC field and the...Subform in Datasheet View
Is there a way to have the datasheet view of a subform *not*
show the "button-like" row that shows the field names?
No there isn't. If you create a continuous style form, you can eliminate
the headings. You can modify a continuous form so that it looks like a
Microsoft Access MVP
"tbl" <hateThatSpam@invalid.net> wrote in message
> Is there a way to have the datasheet view of a subform *not*
> show the "button-like" row that shows the field n...Get at messages in queue
Is it possible to get at the undeliverable messages that are held in a queue
(eg to check the message body or redirect undeliverable messages). I would
like to be able to selectively forward them to an alternate email address or
to archive them to a PST etc rather than just deleting them?
...How to get XML data out of an XML file
I am trying to retrieve the Parameters first or second (0, 1 ,2) node from
the following XML file:
<?xml version="1.0" encoding="utf-8" ?>
There will be more data than just a name for each Parameters node. Here is
Dim node As XmlNode = xmlDocument.SelectSingleNode("/P...How to get paper size from dmPaperSize returned from GetDevMode?
For example, dmPaperSize returns 1 which is DMPAPER_LETTER, how do I
calculate the paper size like in this case 8.5"x11"?
There are so many paper sizes, is there any function call to calculate
based on the return value of dmPaperSize or mapping between the value
of dmPapersize and actual size?
The reason I asked the question was because dmPaperLength and
dmPaperWidth are 0 for some printers.
Also, my HP laserjet returns as a color printer (dmColor = 2) from
GetDevMode call. Anyone knows why?
...does vista installed on virtual machine 2007 get wsus updates ?
It is searching for updates but it is not finding anything and saying
that Windows is up to date. I have set the updates to install from the
wsus server and assigned the updates to the same Vista virtual machine
aconti's Profile: http://forums.techarena.in/members/73272.htm
View this thread: http://forums.techarena.in/active-directory/1290161.htm
If the machine is getting the correct GPO for the WSUS settings, check with
rsop...Baseball Stats question: How can I get the RBI's?
I have a data table that looks like this:
STR-S SNK-S STR-K STR-F SNK-S STR-3 STR-2 STR-F SNK-S SNK-4 SNK-S STR-3 SNK-F STR-4 STR-O
"STR", etc at the beginning are pitch types, SNK is Sinker for example
The end character is the result of the pitch, a 4 would be a home run,
3 a triple, and so forth. O is out, F is foul, S is strike --- you ge
How can I figure the amount of RBI's? I know that it's 5, but I can'
think of any automated way to calculate this, anyone got any ideas?
THANK YOU!! :confused
AVER...SQL in Excel data
Is there a possibility/way to run an SQL query in an excel data sheet?
I have quite some data like the sample below, now i would like to have the
sum of spending for each person. Like it is possible in Access.
Advice would be appriciated.
You could use a formula like this ...Repair SQL Corrupt database
I have a corrupt MS SQL Server 2005 database which I
am trying to repair using:
DBCC CHECKDB ('MYDB', REPAIR_ALLOW_DATA_LOSS)
Unfortunately this does not seem to fix anything.
After running the repair multiple times, I ran
DBCC CHECKDB ('MYDB') WITH NO_INFOMSGS
to see if it fixed the corruption, I noticed that is was returning a
random amount of errors on each run.
Does any know if It is the case that this database is beyond repair?
If so will the best approach be to revert back to a non corrupt
database backup and then roll forward using Transaction Lo...How do I get text to copy from one cell to another ?
Type = in the target cell. MouseClick the cell containing text. Pres
BrianB's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5
View this thread: http://www.excelforum.com/showthread.php?threadid=27034
...Is SQL 2000 tran working with VS2008?
I code a store procedure mySP in SQL 2000 in which using transaction.
I used two ways to test after saving sp.
1) rename one table
2) rename column name
If I use "exec mySP" in SQL 2000 query window, error will catch but ASP.NET
try-catch will catch nothing, it always return no error.
Is SQL 2000 tran working with VS2008?
Message posted via DotNetMonster.com
On Feb 5, 10:15=A0pm, "aspfun via DotNetMonster.com" <u53138@uwe> wrote:
> I code a store procedure mySP in SQL 2000...if statement with text
I am trying to create an if statement where the string of text contains
total, if yes then perform calculation base on that row and column. if no
total in text leave blank
FIND returns #VALUE if "Total" is not in A1
Therefore, ISERROR returns False if "Total" is in A1 (i.e., it was found, no
Remove 'Junk' from return address.
"jerry" <email@example.com> wrote in message
news:E249057A-F6E4-45BF-929A-B2BB61C3A700@micro...NESTED IF STATEMENTS #2
Having a little problem in an excel class, hoping someone might be
able to help. I'm trying to fill in the discount column on a
spreadsheet with the following info. The problem states use a nested
form of the IF function to calculate 15% if Amount is greater that
$300., 10% if Amount is greater than $100., and 0% if Amount is less
than $100. The Amount column is cell D5. Anyone know how to write the
formula and explain how to go about it? Any help would be much
Let's see. This is homework so you should come up with the answer yourself.
Did you start by looking in the he...Changing the Selection Fields in a Combo Box
I've created a Combo Box using the Controls Wizard. In creating the
control, I specified that my unique value to be stored in the table is an ID.
When the user views the selection options in the Combo Box, I'd like to have
the ID field hidden and only see the text values, while still storing the ID
in the appropriate column.
This is probably a second question.
Also, when the user views a form that has been populated, I'd like them to
see the actual textual values on the form, as just the stored ID value. Is
that possible to do with the one Combo Box or is that...Formula for date field
1.I have simple dates in one column (say column A) .
2.In the next column(Column B) I would like the date five months after
Column A to be displayed.Eg if Column A has an entry of 9th June
2007,Column B should display 8th November,2007.
3.A simple formula does not do the job as this does not take into
account the different number of days in different months!
Your post is a bit ambiguous since you don't really say how the
different number of days in months should be handled.
In articl...OAB field size limitations
Hi, we've noticed several user display names getting cut off within the
offline address book. There appears to be a limit of 64 characters.
If I look at the corresponding user entry in the "live" address book it
displays correctly. If I search for the user in my copy of the offline
address book it is cut off at the 64 character mark.
Does anyone know if this is indeed a limitation of the OAB? I can't
seem to find much about this anywhere.
OAB property filtering for Exchange 2003 Service Pack 2 OAB Version 4 -
http://blogs.msdn.com/dgoldman/archive/2006/04/29/586827.asp...Contact looses Post Office Box field when synchronized to Outlook
When I sync contacts from CRM 4.0 to Outlook, the Post Office Box field from
the contact gets empty.
Anyone has the same issue?
...How can I parse or Loop a list based on single field to Googlemaps
This is some code that will parse each sequential field [Point_#) into a list
"http://maps.google.co.uk/maps?f=q&hl=en&q=" & "from: " & Me.Point_1 & (" to:
" + Me.Point_2) & (" to: " + Me.Point_3)
The table/form is laid outlike this:
[Route_No] [Point_1] [Point_2] [Point_2]
5 North St, N1 East St, N3 High Road, W6
And the code will give this style of parsed list:
from: North St, N1 to: East St, N3 to: High Road, W6
That works just ...Getting Cell Value from the Concatenate formula
I built a concatenate formula that returns the following result: =Jul!
I am looking for the cell contents of Sheet: July Column D Row 27.
I tried to use offset, but I am stumped. Can I add something to the
front of the concatenate to not only build the reference to the cell,
but also return the value instead of the =Jul!$D27 ?
Don't include the equal sign in your formula. And match the name correctly (Jul
Depending on the name of the worksheet, you may need to have a string that looks
=indirec...Need help with update sql plus filter
I have the following update sql (copied from the query design view)
UPDATE ListQry SET ListQry.ApprovalStatusID =
And (ListQry.ApprovalStatusID)>-1) AND ((ListQry.OtherStatusID)>300)) OR
(ListQry.ApprovalStatusID)>-1) AND ((ListQry.OtherStatusID) Is Null));
ApprovalStatusID is an integer
OtherStatusID is an integer
ListQry is the recordsource for my form. I would like to add the f...Can't get rules to run.
I can't get Outlook 2003 rules to run. I am getting my mail from a pop3 account and would like to have new mail sorted to specific folders when it arrives. I set up the rules as I did in previous versions of outlook, but they do not run automatically. I can run the rules manually and they will move the mail.
I have this rule (for example
Apply this rule after the message arrive
and on this machine only
move it to the somefolder folde
I have tried deselecting on this machine only
Do you have an Exchange service in this profile? Are you using Cache...Compare 2 different workbooks with the result in a 3rd
I have two workbooks (2005 Sales, 2004 Sales), which track daily results in
half hour intervals. I want to be able to show the increase in 2005 in a 3rd
workbooks. The first two workbooks are identically formatted. How can I do
this? Many thanks to all in the forum who have helped in the past.
If the data is in exactly the same position in the two worksheets you could
copy/paste one's data to a new worksheet and then copy the second's, doing
an Edit, Paste Special, Subtract on top of the first's data. This is
admittedly crude but it is easy to do.