Printing without certain text (i.e., answers, notes)
Does anyone know an easy way to print two versions of a document? For
example, I need to print a student version without answers and instructor's
One way would be to use a style (call it Answers for example), when you want
to print out the students copies change the color of the style Answers to
white. That should do it.
"TM" <firstname.lastname@example.org> wrote in message
> Does anyone know an easy way to print two versions of a document? For
> example, I need to print a student version without answers an...knowing who gains/looses the focus
What I like to have is some kind of generic way to let a window (not
necessarily a MDI child window, but more likely some sub-window) know that
one of its (in)direct child controls has received (or lost) the focus.
I know that there is the WM_PARENTNOTIFY message which notifies the parents
(ancestors) when the user clicked on a child control. I would like the same
thing for the gaining/loosing of the focus.
So basically this is the situation:
subwindow A1 (wants to be notified of focus gain/loose of all
control A...look up question #2
I have a list of people with their system rights in the
next column by group. Each person may have more than one
type of right in the list as follows
John Smith Edit
Joe Doe Submit
Cathy Dory Edit
John Smith Submit
As you can see above, John Smith has both edit and submit
rights on this list. What I am looking for is a formula
where I can look down the list of names and find all
instances of John Smith and then it can tell me if John
Smith ever has edit rights or ever has submit rights.
What I would like it to do is return a 1 if he has edit
rights a...question about spam
How is it that spam sent to one mailbox will end up in another not mentioned
in the "to" address. In other words how is it that spammers get mail
destined to Bob in Jim's mailbox?
Mostro <email@example.com> typed:
> How is it that spam sent to one mailbox will end up in another not
> mentioned in the "to" address. In other words how is it that
> spammers get mail destined to Bob in Jim's mailbox?
The BCC field. It can be used for evil as well as good.
...Another Access Question
Is it possible to place the front end (forms) of an Access Databse on a web
page, so that users can log on via the net and enter data into the forms. I
am guessing that the front end would have to stand alone but not sure !
Any advice would be great
will07 <firstname.lastname@example.org> wrote:
>Is it possible to place the front end (forms) of an Access Databse on a web
>page, so that users can log on via the net and enter data into the forms. I
>am guessing that the front end would have to stand alone but not sure !
Can't be done using...Yet another Lotus macro question
I have for the most part converted to Excel but have a simple macro that on
the surface cannot be converted.
The Lotus macro used a database, template and list of branch names. The
macro itself started with the name of the first branch, copied it to the
template, sucked in the data for that branch and then printed the report.
Then it went down to next name on the list and repeated the process until it
reached the bottom of the list.
In Excel it seems to indicate I have to repeat the steps for each and every
branch on the list and not loop back through a 8 line macro that refers to
the ...NMHDR question about hwndFrom
the documentation says that the hwndFrom attribute is the window handle to
the control sending a message. I have a toolbar sitting on a property page.
the toolbar is sending the message. Am I correct in assuming that the
hwndFrom is the property page? I am having a problem obtaining the window
handle of the property page. From the toolbar, I am calling
CWnd* pOwner = GetOwner();
fh.hwndFrom = pWnd->GetSafeHwnd();
When I run the debugger pOwner correctly has the value CMyNotesPP, which is
the parent window.
When I step through the next line hwndFrom has a value in it but when I
click th...CDC::GetTextExtent question
I have a function that is to resize a status bar text pane when setting text
GetTextExtent() seems to think the text is almost twice as wide as it
actually is so it leaves too much white space.
This is my func.:
BOOL CMainFrame::SetStatusText(UINT nID, LPCTSTR lpszText)
int index = m_wndStatusBar.CommandToIndex(nID);
if (index < 0)
UINT nIDRet, nStyle;
m_wndStatusBar.GetPaneInfo(index, nIDRet, nStyle, cxWidth);
ASSERT( nID == nIDRet );
CSize sz(cxWidth, 0);
CDC* pDC = m_wndStatusBar.GetDC();
sz = pDC->...Datasheet question
Is it possible to show a Form Header on a Datasheet form ?
Not that I know of, but you could emulate it by creating a new form with a
form header (unbound - no rowsource) and place a subform in that form
displayed as datasheetview.
"Phil Hunt" wrote:
> Is it possible to show a Form Header on a Datasheet form ?
No but you can fake it by putting the datasheet form in a subform =
control on an unbound main form - Put whatever you'd like on the main =
Microsoft Access MVP
"Phil Hunt" &l...newbie question on multi-dimensional array
I have a real lame question about multi-dimensional array operation.
Suppose I have defined a two-dimensional array "Array(10,10)". If I
want to use the Excel function "Average" to compute the average value
of Column, say 10, of that 2D array, is there any way to realize it? I
tried "Application.Average(Array(:,10))", but apparently the Excel
doesn't like that. (You can see I am a Matlab guy, so please don't
laugh at me:) )
Any comments are extremely welcome.
------------------------------------------------------------------------...Microsoft Outlook 2003 tasks view question
In Microsoft Outlook 2003, I am able to define a customized view of
each column, under the Tasks section. Is it possible to share the same
customized view of the Tasks with other users?
In other words, when other users open a shared view of a Task, I want
them to see the same column structure as I see. If it is possible to
propagate or share my defined view of columns, can someone describe
There is not an easy "copy this to everyone" command but its possible. When
you create the view, use the option to share it with everyone. When they
vie...A few small questions
I have an Excel document with many tab (actually it look
like a database, before any other thing no I can't move
it to Access (corporate reasons).
I also have a restriction to avoid using macro!!!!
First is there a way for footer or header information to
include info from cells in the speadsheet.
Second you can define info to repeate at the top, what
about at the bottom of the page.
Third the sheet that serve for report can have up to 8
pages, can the printing zone be define by a cell value,
so that page x of y (the y part be other than 8).
I have the database part in a sheet bu...formula question #7
Is there a formula that can change the color of cells if
revenues drop three months in a row and if so what should
the formula be?
Assuming that your data is in row 1, columns A,B,C, with C
being the latest data, Try using conditional formatting in
cell C1 with the "Formula Is"
>Is there a formula that can change the color of cells if
>revenues drop three months in a row and if so what should
>the formula be?
Formula only needs
you don't need t...Layout Question Please
When I am in the Monthly calendar view I have three small month calendars in
the left hand pane which is fine. If I click the folders button on the
left, the folders pane shows on the left with the full calendar view on the
right which is how I want it. The problem is that in the left pane on top
of the folder list it still shows on of those small calendars which takes up
room from my folder list and I cannot see all of the folders. How do I
configure it so the left pane is all the folder list and does not include
the small calendar?
Thanks in advance... Bob
I don't th...Question on "Value" function
In trying to use Excel to help solve a mathematical puzzle, I would like to
calculate the result of applying the mathematical operator in one cell to
the numbers in two other cells.
Example: A1 contains 2, B1 contains +, C1 contains 3. In D1, create a
formula that will give the result of 2 + 3, i.e. 5.
I have tried (among many other attempts)
=VALUE(CONCATENATE(A1, B1, C1)), but it gives me a #VALUE! error.
What am I missing?
this is not possible without using VBA. try the following UDF:
Public Function my_calculate(op1 As Range, operand As Range, op2 As Range)
my_calculate = Ap...I need to save templates in a different way. Anyone know a soluti
I am a lawyer building precedents for my law firm. Here is the problem.
I have about 100 separate macro-enabled templates created in my documents
folder. I have created a separate folder for shortcuts. There I put
shortcuts to each of the commonly used templates I have, and I have assigned
hotkeys to them (F1-F12, ctrl-alt A-Z).
Now here is the problem. Because I cannot save over a template (when I edit
it for changes in the law) and instead have to save it with a different name,
I lose the connection to the hotkey, which is linked to that particular
document. I do not wa...xml question?
what is the equivalent of this in C# ?
foreach (XmlNode xmlConfigNode in xmlConfigDoc["configuration"].ChildNodes)
Sorry I made a mistake here is what I want to convert to C#
For Each Node In XmlDocument.Item("configuration").Item("appSettings")
"Ray5531" <Ray5531@microsoft.com> wrote in message
> what is the equivalent of this in C# ?
> foreach (XmlNode xmlConfigNode in
Hi Ray,...Back Order Question
Have a back order question. Normal back orders are working right. In that
if you have 10 and the order is for 15. During the lineitem transtaction it
will put 5 in the backorder field automatically. What we need is if the
customer orders 15 and we have 20, but only ship 10. We want the BO field to
automatically fill with 5. Is this possible.
Thanks in advance.
It depends on how you fulfill and if you have cancel and bo enabled in the
document types. If you have these enabled and are using Use Separate
Fulfillment, you can select 10 to ship and set 5 to BO. T...Dynamics GP 10 Reporting Question
I heard reporting in GP 10 is upgraded. Does anyone know if it will be
anything like Rockton Software Dynamics Report Manager where you can send any
report to like Sql reporting services or crystal?
I haven't heard anything at all that reporting in 10.0 will be changed.
While I guess it's possible, I would assume for now that there won't be any
big changes in general. I would expect more MS Office & SQL integration in
the next version for sure, but I can't see everything rewrit...Array range error question
When i try to redim my array i get an out of range error. can someone tel me
Cells A1..A10 are filled with strings. thanks much
Dim names_array() As Variant 'dynmanic
Dim j As Long
ReDim names_array(5, 1)
j = 0
For i = 1 To 10
names_array(j, 0) = ActiveCell.Value
names_array(j, 1) = ActiveCell.Address
arraylimitFirst = UBound(names_array, 1) 'returns current dimension of 1st
array limit, init = 5
If j >= arraylimitFirst Then
ReDim Preserve names_array(10, 1) ' << RANGE ERROR ...Newbie Remote Assistant and Desktop Questions
Developing C++ on VS 2008 Pro, XP Pro, Win32.
I have a client that recently upgraded from Vista to Windows 7
Ultimate, 32 bit, on his laptop.
I recommended he get Ultimate so I could run Remote Desktop over
the Internet. This is before I actually tried using Remote Desktop.
After getting Remote Desktop up, I see that I really want, to help
my client, is Remote Assistant.
Both Remote Desktop and Remote Assistant are now running fine with
two XP PCs on my LAN, using my Internet address, to connect.
I've cobbled together port numbers requiring...i need to add more options to a formula but i don't know how
on one of my worksheets i use this formula
this tells excel to add up all our unpaid invoices and tell me how muc
we are owed.
I now want the formula to add up all the boxes with unpaid next t
them, plus all boxes with these phrases next to them:
received-not banked yet
banked-not cleared yet
so i have tried things like thi
=SUMIF(G126:G242,"UNPAID(or)received-not banked yet(or)banked-no
but it does not work. as you will have guessed i am not too great wit
incidentally, unpaid, re...Just a quick question
I want to be able to average a range of cells, some of these cells are 0,
and those are the ones I don't to include in on the calculation.
If your data is in "B5:D14"...
San Francisco, CA
"Brian Shafer" <email@example.com> wrote in message
> I want to be able to average a range of cells, some of these cells are 0,
> and those are the ones I don't to include in on the calculation.
If your range actually...=CELL("filename") function related question
Is there a function in Excel that only picks up the sheet name in a
workbook? I realised that =CELL("filename") function provides the full
path, workbook & the worksheet information.
Thanks in advance for any help & suggestions.
Take a look here:
In article <firstname.lastname@example.org>,
"wfcpyc" <email@example.com> wrote:
> Is there a function in Excel that only picks up the sheet name in a
> workbook? I realised that =CELL("filename") fun...Licensing Questions
I'm building an iSCSI host for a client of mine, and was wondering
what the license requirements would be. Here is he question, If I
install my iSCSI host software (in this case StarWind) on a windows
2003 Platform, what kind of license do I need, ie do I only need the
OS license or do I also need CLIs. Since no actual "User" will be
accessing this Server Directly (they might be using a VMDK stored on
the host LUN, but that would be via my VMware servers...
basiclly, I'm using the iSCSI host, to host disk space for 2 or 3
VMWare ESXi hosts, hosting 2 or 3 VMs which...