How do i sort contacts using more than one catagory ?
I am trying to create lists which have contacts sorted by more than one
catagory. So including contacts that are linked to two or more specific
catagories. Can this be done, if so how?
"samong" <firstname.lastname@example.org> wrote in message
>I am trying to create lists which have contacts sorted by more than one
> catagory. So including contacts that are linked to two or more specific
> catagories. Can this be done, if so how?
The Category field is non-sortable because it is a multi...test 05-11-10
...Using OLE DB in MFC Project
I have developed an MFC application. I now want to add database
functionality to it. I have had a look at the various database technologies
and have decided to try using direct OLE DB rather than ADO as it is faster.
However I have noticed that in tutorials it is recommended to use the
wizards in an ATL project.
As i have said before my application has been written in MFC. I was
wondering how easy it is to add direct OLE DB to my MFC application.
I would appreciate suggesstions on how i can manage this,
Thanks In Advance
...population pyramids using bar charts with a secondary axis
I have a problem that I had given up as unsolvable, but after recently
learning about secondary axes, I've made encouraging progress. However,
I'm stuck on the last step(s), and I'm hoping that someone will have
My organization has been producing reports that contain population
pyramids. In the past, all of their reports have been printed, so it
didn't matter that in order to get the desired look, they had to use
two charts slightly overlapping each other. However, we are getting to
the point where we would like our charts to be available online for
download....Conver Numbers to Log 10
How do I convert column of numbers (n=3000) to log 10 column of numbers?
Assuming that your column is column A, one way:
In an unused column, enter
and copy down 3000 cells.
Copy the column, choose column A and choose Edit/Paste Special,
selecting the Values radio button.
In article <0CDE6301-FC9C-488C-9D9F-3AD26B46EFCE@microsoft.com>,
"Fishfan" <Fishfan@discussions.microsoft.com> wrote:
> How do I convert column of numbers (n=3000) to log 10 column of numbers?
...Custom Reports Using MS Access?
Ran across a thread where Glen Adams suggested using MS
Access to create custom reports instead of Crystal
Reports. But Glenn never said where to point Access to
obtain the needed information to create the reports.
Glenn, if you are watching can you give us some more info
on how to use Access to create a report?
I'm not Glen...
I think you would use ODBC... to connect to the RMS database. Then use
Access to connect via ODBC...
"Dan" <email@example.com> wrote in message
Operating System: Mac OS X 10.5 (Leopard)
I have created several files in Word 2008 using templates (.dot) files previously used with Word 2003/2007. Unfortunately, my customer keeps receiving an error when opening the new file I create. The new file (created in .doc format) has some hidden data that is pointing to the template folder on my Mac. The error looks like:
Could not open: 'user:Libarary:Application Support:Microsoft:Offce:User Templates:template.dot
My customer can fix this error by using the remove hidden data tool inside Office 2003, but that&...How can I change the program used when following a hyperlink
I have a database which uses hyperlinks to take me to a set of image files,
gif & jpeg. I have recently moved to Firefox. If I click on a link to a gif
file it opens in Firefox, but if I do the same for a jpg it persists in using
IE. The file association for jpg files on the computer are to Photoshop. But
I prefer opening the links in the browser as I am only viewing, not editing,
Anyone got any ideas
Use a button that when clicked calls this code (pass in the value on the
Public Sub OpenWebPage(url As String)
Dim browser As Vari...counting using multiple criteria
I have a problem for which I can't seem to find a working solution. On the
one hand I have a vertical table with employee names, the number of years
they have been with the company, and all this sorted by the employee's age
(in years). This table will be updated from time to time, and as such it
doesn't have a fixed length.
On the other hand I have a table which shows the number of employees in a
particular age category (-20, 21-25, 26-30, etc) horizontally, and the number
of years they have been with the company (again in groups: 0-5 yrs, 5-10 yrs,
...scripting adding obj-users and mdb-use-defaults to exchange 5.5 users
I have successfully created a script for creating exchange 5.5 users. I
can't however, figure out how to add the assoc-nt-account to the obj-users
[pseudo attribute] or set MDB-Use-Defaults to True :-(
Can anyone offer advice on how to do this [other than generate a CSV file
and use the exchange admin tool to import it]?
...Custom Report 03-19-10
There is no way for me to run a report on Buydown Pricing, is there anyone
who has a report for this option?
If not, can someone write a custom report for it, and how much might
something like this run me?
I would like it to do something like buydown quantity greater/less/equal and
same for buydown price...
please contact me at nagarra @ yahoo . com or respond here with your contact
...WLM Stopped working 02-20-10
I'm running Vista Home Premium, SP2, 2 GB of RAM, Firefox, WLM, all WU's
I was in WLM mail newsgroups earlier today and things just stopped. WLM
stopped responding. Now I cannot log into WLM. It used to log into window
Live by itself (password and all) from my desktop icon, but now the only
thing that happens when I try to open my WLM app window is I'm taken to IE
(7). Then when when I try to sign in Windows live it won't do it.
I've already ran SAS, MBAM, CCleaner and Avira in Safe mode but found
nothing. Then I did a system restore back to a fe...Database using Access 2.0
Our church purchased Church Windows software. When we asked if we could
import our members from our existing database Greentree CDMS they said we
couldn't because CW is an Access 2.0 database and we don't have that
software. What would be the benefit of still using Access 2.0 for software
I doubt there are many new programs being written in Access 2. It was a
great piece of software, and many databases were writing using it. I don't
know Church Windows, but I am guessing that it was written back in the
Access 2 days (around 1994), ...Looking for GP specialist
We are looking for a GP specialist, expert in Greatplains, Business Portal,
SharePoint, MS SQL server database development.
This opportunity will be located in Ottawa, Ontario.
Please email your resume to:
bnemaniAThotmail.com (replace AT with @)
...Email server 02-13-10
The smtp outgoing email with VISTA cannot be authenicated.
Vista is not an e-mail client. 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
"Charles" <Charles@discussions.microsoft.com> wrote in message
> The smtp outgoing email with VISTA cannot be authenicated.
I had wanted to set up a separate identify to get my work e-mail as Windows
Mail, rather than the webmail from my ISP; didn't know until after completing
the process that Windows Mail combined both personal and work e-mail into one
account. If I "undo" it, popup says I'll lose all of my work e-mail. How can
I save it and undo the dual identities?
Windows Mail doesn't have identities.
You can add multiple accounts, via Tools - Accounts - Add, but Windows Mail
doesn't have identities or a password option.......Use Datedif but for future dates
I have a formula for identifying years, months, days from a past date to
now. DATEDIF(C6,NOW(),"y")&" Y, "& DATEDIF(C6,NOW(),"ym")& " M, " &
DATEDIF(C6,NOW(),"md") & " D"
I'd like a formula that can produce the same format (years, months, days)
between now and a future date.
Thanks in advance,
Try this with the date in A2
=IF(TODAY()<=A2,DATEDIF(TODAY(),A2,"Y") & " y " & DATEDIF(TODAY(),A2,"ym") & " m","-"&...Creating opportunity using CRM api
Looking for an example of how to load the crm api to create an
opportunity using C#. I'm way new to this and have downloaded the CRM
3.0 sdk but not sure how I access the information it contains. What
I'm hoping to find is an example of creating an opportunity with just
the necessary information so I can build on it from there.
I appreciate any help!
When you install the SDk you will notice there is a help file in the
installed directory of the SDK, I think it is crmsdk3_0.chm
Open the helpfile and search for create, there are lots of examples
let me know if you get s...Printout Method
In building a form to allow users to print a "blank form"
I've constructed as an Access Report, I'd like the user to
be able to select the number of copies to print.
It looks like the PrintOut Method would be a good choice for
this, but I'm not smart enough to know quite how to get the
"Copies" argument to get its input from the textbox on my
form, where the user will enter the number of copies they'd
like to print.
Does the report have a record source?
Microsoft Access MVP
If I have helped you, please help...Using Regular expressions in Excell 2007
I have code written in excell 2003 where I use Regular Expressions
'heavily'. In Excell 2003 you had to import the RegExp library to be able to
use it. Is Regular Expressions part of VBA in Excell 2007? or do you still
need to import the RegExp library?
Same as in Excel 2003, the library is part of IE not Excel or VBA.
"ncunha" <firstname.lastname@example.org> wrote in message
>I have code written in excell 2003 where I use Regular Expressions
> 'heavily'...User login failed on the customized VBA project after GP 10 upgrad
After GP 10 upgrade, I am getting the login failed error for all useers who
tried on working on my customized Dynamics VBA project.
Error # -2147217843: Login failed for user 'sa'.
Procedure: frmDateEntry - cmdProcess_Click
Source: Microsoft OLE DB Provider for SQL Server
Thanks for help.
You might need to re look at your connection in VBA
"Kevin Zhou" wrote:
> After GP 10 upgrade, I am getting the login failed error for all useers who
> tried on working on my customized Dynamic...Customization 10-13-04
I want to add a field "Company" to my contact information.
I have entered a new field called "Company" in the
attributes of the schema "Contacts" and it is listed
there as "CFSCompany" as a string.
I then went to customization in crm settings and edited
the "Contact" fields by removing "Middle Name" and
adding "Company". I then save this new layout.
However when I go to "New Contact" the "Company" field is
not there and "Middle Name" is still there.
What step am I missing to publish this...how to use "barcode" in excel 2000??
i would like to set up an inventory system for recording
the stuff. previously, i have a long table of data in
excel. i need to do some tasks:
1)print the barcode out for each item
2)scan the barcode for checking the inventory.
i have no idea how to start, install barcode fonts? what i
have to buy and do i need to write "MARCOS"?
Please help me!
It depends on how you intend printing the labels. If you're wanting
simple all in one solution, 'Bizfonts' (http://www.bizfonts.com/) ca
help. Another way is to use a 'bar code module
(ht...How to have margin-left: 10%; margin-right: 10%; only sometimes??
My website is created so that the width is not fixed. I adapt to the width
of the browser. If I have a page of text I do something like:
<div style=" margin-left: 10%; margin-right: 10%;">
so the text is set off by margins.
That's nice on my monitor's 1600 pixel wide screen.
But on a laptop (or as a user option) I'd like to change that to no margins.
Can you suggest a way of doing that without having two .css files?
On May 16, 10:25=A0pm, " Cal Who" <CalWhoNOS...@roadrunner.com> wrote:
> My website is c...Multi Year GP Budget?
GP 10 & FRx 6.7. We are migrating to GP from MAS 500. In MAS, our budget
data existed under one header (Current Budget). Each year's budget data was
entered under this one Budget name (ID). In GP it appears that one Budget ID
based on Fiscal Year can only contain data for one year. Is this correct?
The whole point is for FRx column specifications to reference a single
Budget ID regardless of the Base fiscal year you are reporting on. Can
someone provide GP Budgeting answers? Thanks.
You can only have one budget associated with a particular Budget ID.
If you want ...