Using Excel XP.
Is it possible to have certain letters in a text string be moved to a colum
of their own? For example I have several rows of text:
What I want to do is to move the individual letters in each row into its own
colum, an F would always go into its own column,
X would go into its own column, H would got into his own column and T would
go into its own column. The sequence of letters into their own column will
alaways be in this order: F-X-H-T. Every row may have some o...Resource dll question...
I'm separating my project out into the main code and a resource dll. I've
now got it so that when I build the debug solution it will build the
MainExe - Debug
ResourceDll - Debug French
I intend to bundle all the languages into a single resourcedll, and build
separate dlls from there depending on the build configuration ( E.g.
When I add another project config (E.g. Debug German) building the Debug
solution will only build the existing Debug French.
What I would like is that when I select to build the debug solution, it will
Ma...CListCtrl Header height change??
CListCtrl Header height change??
Is it possible to change the height of a CListCtrl Header.?
...relates to previous question regarding memberships cards and intia
Hi,before i start my next question i would just liek to say thanks to
everyone who replied to my earlier quetions it is much appreciated,the next
question i have is related to the question regarding the membership cards i
wanted to create.I made the query as told and it works great!
Left([FirstName],1) but how do i get the query to run when opening the
report to display the bales ?? thanks
On Wed, 16 Jan 2008 11:49:03 -0800, newuser
>Hi,before i start my next question i would just liek to say thanks to
>everyone who replied ...Problems with CListCtrl
I'm having trouble with a CListCtrl object. I'm trying to automatically
set the selected items of the list from my code. I try the following
m_List.SetItem (pos, 0, LVIF_STATE, NULL, 0, LVIS_SELECTED, LVIS_SELECTED,
The SetItem function returns non-zero, which supposedly means it was
successful. However, I don't see any selection showing up. I even called
RedrawItem on this list item, but it didn't help either.
Anyone know about this?
>I'm having trouble with a CListCtrl object. I'm trying to automatically
>set the selected ite...CTreeCtrl and CListCtrl problem
I use create a single document struct using MFC(explore
style).The left of the window is CLeftView class(which
inherit CTreeView).The right is CBrowserView which inherit
CListView.I want to display the content of a directory in
the right(CListview) when user click the item of the
In the LeftViw I add method "void CLeftView::OnClickItem
(NMHDR* pNMHDR, LRESULT* pResult)" because I want to know
which item be clicked by user.
data=mtree.GetItemDat...Office 2010 Buying Question Assistance Needed
I've been looking through the MS Office 2010 web site to try to determine
what my new small company would require, but I can't find the information I
We for sure would need Office Pro Plus, but other than that I'm not sure. We
want to run it on our own server. We will initially have 3-5 people using it
and perhaps more later on. Would we need to purchase site licensing?
Unfortunately, our programmers are MS haters (I'm not) and I can't get any
assistance from them on this, but I have power of the pen. I would appreciate
any assistance I can get.
Th...Mail merge question
This is a multi-part message in MIME format.
I've been reading about mail merge, setting up postcards, etc.
I remember doing this when I did the tutorials in Publisher 2000, but =
still not sure about it (I've never had to actually use it, but have a =
few ideas about using it for postcards for people I have made flyers =
What is the best program to make the mailing list in? I now have 2007 =
and have Word (I know enough about to...RS 2008 Charts Question
I am using RS2005 moving to RS2008 shortly. My question is: in RS2008 if
you build a bar graph chart, can you click on one of the bars and display the
data that makes up that bar? I know you can do this in Report Builder but is
this funcionality available outside of Report Builder?
...newfish's question:HOW TO make a sniffer using winsocket in vc++6.0 ?
I need a sample about sniffer .any one could help me? please...~~
What do you mean by "a sniffer"? I have an idea what this kind of program
does so perhaps it's more appropriate to ask what you are trying to sniff?
"feizx" <email@example.com> wrote in message
> Hey all,
> I need a sample about sniffer .any one could help me? please...~~
WireShark (formerly known as Ethereal) is an open source packet sniffer. Start there.
On Sat, 5 May 2007 22:01:41 +0800, "feizx" <...Follow up to Calculated Field question .....
The syntax worked fine for that. Now I'm wondering two more things ...
In one of the tables I have multiple identical room numbers that I need to
combine in this calculated field to determine a price for each room.
Plus, I also need to determine a number for income generated based upon the
number of days the romm is rented.
Can you point me in the right direction?
...CListCtrl and sub item editting
Is it possible to implement CListCtrl sub item editting without creating a
I am using VS2003.
>Is it possible to implement CListCtrl sub item editting without creating a
There's no built-in support for this, so no, you have to provide some
implementation for this. Have a look on sites such as CodeGuru and
CodeProject, they'll have examples.
I've seen examples, I just wasnt sure if I needed my own ctrl.
"David Lowndes" <DavidL@example.invalid> wrote in message
news:k...Permissions and Roles question
This may be a Reporting services question, sorry if wrong NG.
I created a number of roles in Active Directory to limit
access to reports in the Management Portal for Job X. Initially, I created
a role for each report and then added groups to those roles. After getting
all set, I determined that it would probably be a better idea to set up more
general report roles that could encompass groups of reports rather than
individual reports. I deleted most of the original roles I created and
new roles to serve this new structure. Now, when I hit AD for a list of
to se...How to add clistctrl into clistctrl?
How to clistctrl into a clistctrl? For example like adding checkbox ,
combobox, i want to add clistctrl into a clistctrl
...PST on Network Question
We have Exchange 2003. We have a lot of users (school district staff and
students), so we have strict limits on the mailbox size. For many years we
have been telling users to save their messages to their PST files (which is
on their network drive). Now we've come across some documentation that
suggests that is a BAD idea.
What do others use for managing mail and keeping the size of the mailbox
low? Where do you store messages/attachments? How easy is it for the
Thanks for any and all suggestions.
Bellingham Public Schools
how do i change from microsft exchange to pop3 in outlook 2007. The program
wont stay open to use the tool menu. it tells me its not connected and closes
out the window.
"krzatchok" <firstname.lastname@example.org> wrote in message
> how do i change from microsft exchange to pop3 in outlook 2007. The program
> wont stay open to use the tool menu. it tells me its not connected and
> out the window.
Use the Mail applet in Control Panel.
Brian Tillman [MVP-Outlook]
...Question about budget accounts...
Hello again all,
I have 4 credit card accounts. 1 checking account that everything gets paid
from and 1 savings account. These are all listed under what accounts I would
like to select as budget accounts. should I select all of these accounts as
budget accounts? Currently, I only have the checking and savings accounts
checked off but that doesn't seem right to me. Any help would be
BTW, it's Money 2005 Deluxe.
On 2005-01-20, Steve Thompson <email@example.com> wrote:
> I have 4 credit card accounts. 1 checking account that everything ge...Question about ::MoveEx()
Hello. The LineTo function calls ::MoveEx(), but I have not been able to
locate this function. What I'm trying to locate is the function that
actually does all of the grunt work in drawing the line. This might be in
assembly language or I don't know what but I'd like to see it. One of the
main reasons I went to MFC was because of the lack of graphics in the
standard C++ library. I'm doing C++ again, and once more I'm stuck on
graphics, and am unable to do any drawing at all with other than asci
characters. I know there's third party libraries out there, in addition to
M...Gathering open-ended question text into one sheet
I have an Excel file with data from 60 or so respondents to a questionaire.
I have all my raw data on one worksheet. On another worksheet I have totals
for the various questions broken out in various ways. I would like to create
another worksheet that lists the answers to an open-ended question at the end
of the questionaire. Less than half of the people responding wrote comments
so I don't want to include blanks. I'd like to have a consolidated list of
the comments in a tidy, separate sheet.
As yet, I've been unable to figure out how to do this. Any help would be
app...A newbie question: LNK2001: unresolved external symbol
I am just learning MFC. I have VC6++.
I have a program that is a Document/View and in a RichEdit control. It is an
The one error I have is
replace.obj : error LNK2001: unresolved external symbol "class
This is the situation.
replace.cpp is a Find/Replace dialogue. I am using
extern CHtmlRichEditCtrlSSL m_richEditSSL;
In HtmlRichEditViewSSL.h I have
void CHtmlRich...autonumbering question
hi all, I have office 2007. Im using access.
I have two colums of numbers, the first, column 1 is for a context number,
and i enter it by setting a value manually in design view i.e. 140. i want
to enter a list of items numbered 1 to 50 in the second column, column 2.
when i use auto number it lists the sequence but when i change the value in
column 1 for the next context i.e. 142... the numbers contuinue in colum 2
i.e. 51 52 53 but i want them to start again at 1 2 3 etc... how do i do
this? any help is greatly appreciated
well - as you have found, you can't use Autonu...reports question #2
How do I generate a report that will tell me how many store credits (or Gift
Certificates) have been issued/redeemed in a givin time frame?
I have a report "Detailed Sales with Tax & Tender" but the only problem is
it does not show more than one tender type per transaction. So if a customer
combines two tender types only one is shown.
throw me a bone?...anyone
> How do I generate a report that will tell me how many store credits (or Gift
> Certificates) have been issued/redeemed in a givin time frame?
I just started using CTEs and I thought that it was really just a
restatement of a derived table:
select x from MyCTE
Could be rewritten as a derived table:
select x = 'hello'
But then looking at this one:
select top 10 x = id from sysobjects
select x, maxx = (select max(x) from MyCTE), pct =
100.0 * x / (select sum(x) from MyCTE)
I can't restate like so:
select x, maxx = (select max(x) from MyCTE), pct =
100.0 * x / (select...IIF statement question
How do I write an IIF statement if I want to exclude rows where there are
dates. There are 3 date fields. If one of the date fields is Not Blank then
do not print report. If all fields are Null then print report. Would a
simple "IsNull" in each field in my query suffice?
Seems to me it would take less time to test "Would a simple "IsNull" in each
field in my query suffice?" than to post a question.
If you can't test this on your own, reply back.
Microsoft Access MVP
> How do I write an IIF st...Chart Question #3
is it possible to create a chart, skipping columns or rows
I need to creat a chart using data from every other column and another
using data from about every 5th row
Any help appreciated
I'm open to correction on this, but I believe the best way to do this
(assuming you don't want to delete the in between data, and resort the
columns somehow) would be to create a macro that copies the data you want
into the right format (probably on another sheet) and make the chart from
Something along the lines of:
dim NewSheet as worksheet
dim OldSheet as w...