How to suppress #VALUE!
After setting up functions, the spreadsheet appears ugly when there are
empty input cells. Is there any method in suppressing the display of
#VALUE! etc, say assigning white colour to these error words? Thanks!
Fix the errors, dont just hide them, eg
Instead of your_formula that appears to give you the error when an input
cell is empty (assume it is A1), try
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------�-------------------...Main Form checkbox toggles many subform checkboxes
I have a main form / subform setup. The subform has a field that is
a yes/no data type, represented by a checkbox in the field.
How do I set up a control on the main form (possibly another checkbox) so
when I click the control, it will toggle ALL of the checkboxes in the
subform on and off. Similar to a "select/deselect all"?
Message posted via http://www.accessmonster.com
Use the AfterUpdate event procedure of the unbound check box on the main
form, to execute an Update query on the subform's table.
This kind of thing:
Private Sub chkSetAll_AfterUpdate()
Dim ...java based pdf and excel generation
I am working on a browser based reporting tool and would like to give
the client the option to save the reports in excel and pdf forms.
The reporting tool is a part of a WebLogic (Java) based application.
Ideally I would like to use a Java package that can generate both pdf
and excel documents. I have come across some tools such as iText (for
pdf) and Java Excel API (for excel).
Is there any library which could do both. i.e. a single library which
can generate both pdf and excel documents?
I believe reporting packages such as JReports can do this.
<email@example.com> w...Printing multiple records based on a field.
I have a database containing all students for our classes, and what class
they are taking. I need a way to print off each record, one per page, of all
students taking the same class. How would I go about this?
do you have all your info in one table or multiple tables?
build a query based on the table(s). this will allow you to set parameter
(filters) for one page based on one course. this query can also be copied
and change the filter for other reports if you need them later.
generate the report to group by class and sort by student. once the report
is generated by the wizard, you ca...blank page runs through after main page has printed
After my main page has printed a blank page runs through the printer. What
is my problem?
Do you have a second page that is blank in the pub file? Look at the bottom
of the screen and see if there is a single page icon or if there are two
page icons. If there is a second icon, Edit, delete page.
"lewieB" <lewieB@discussions.microsoft.com> wrote in message
> After my main page has printed a blank page runs through the printer.
> is my problem?
Open your printer folder, right-cl...How to suppress "Entourage cannot find server" message when offline?
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
Greetings. I'm a frequent traveler, and I can only access my email when connected to a VPN. When I am offline, I get the following error every time I send an email. <br><br>"Entourage cannot find the server. Verify the server information is entered correctly in the Account Settings, and that your DNS settings in the Network pane of System Preferences are correct. <br><br>Mail could not be sent. Error -3176" <br><br>What I wan...Display bitmap on main frame window
When my MDI application starts up, the main frame window is a big ugly grey
rectangle. I would like to display a nice bitmap as a background for the
Any suggestions how I might do this?
"TVR Fan" <firstname.lastname@example.org> wrote in message
> When my MDI application starts up, the main frame window is a big ugly
> rectangle. I would like to display a nice bitmap as a background for the
> Any suggestions how I might do this?
http://support.microsoft.com/default.aspx?scid=kb%3...Embedding Visio in .net based Windows Forms Application
I am using Visual studio.net to programmitically control Visio 2003.
I read some of the MSDN articles about this topic and trying to develop
some small sample programs.
I got some sample program devloped in VB 6.0 that just opens Visio
document with basic diagrams template with Basic shapes and then adds
Rectangle shape to the drawing and then sets the text to "HELLO WORLD".
so The VB code to achecive this task is as follows.
Sub HelloWorld ()
'Instance of Visio
Dim appVisio As Visio.Application
'Documents collection of instance
Dim docsOb...text box as label to appear when subreport does
I have a text box used as a label with the control source:
I'd like to add a subreport to this: srptFGProcessingPacketPouchAtts.
Can this be done?
What do you want to do?
Microsoft Access MVP
> I have a text box used as a label with the control source:
> ="Attributes" +IIf(IsNull([FillTemp_Label]),Null,"")
> I'd like to add a subreport to this: srptFGProcessingPacketPouchAtts.
> Can this be...Suppressing
I have a report that has a table with basically one grouping. I have sever
rows of the same group and another table inside each of the rows. So
basically I have 25 rows od the same group with a different table inside
eavh row. So table inside of a table. My problem is that whenever one of
the group tables has no data, it still shows whitespace and I cant get it to
suppress when its blank. Any ideas?
can you set the width=0 and then set the visible for that row=false.
"Ben Watts" wrote:
> I have a report that has a table with basica...Suppress X Axis Scaling
I have a table I’m charting. There are 15 textual descriptions in a column
and 6 date field headings. When I grab that table and switch the “Series In:
to rows, the chart builds correctly – to some degree. Though there are only
6 contiguous date field headings, the dates are not. Is there a way to
suppress the X Axis Scaling to show only the dates associated with this
table, not adding filler dates that do not exist for this data?
An apostrophe at the beginning of the date does the trick…
> I have a table I’m charting. Th...Generation of new subform record based on combobox AND main form
I have an unbound combobox (cboDOVSearchChart) whose row source is a query
that brings up all of the dates associated with a particular medical record
number. It consists of two columns, chart ID (hidden), and date. Each
combination of MR and date yields a unique (autonumber) chart ID. The first
column serves as the link field to associate with a subform that is based off
of chart ID and contains all of the chart information.
Is there any way to use the NotInList event for this combobox to create a new
record in the subform that will contain the next autonumber for Chart ID with
the MR number ...OnCreate of CFrameWnd based splitter pane gets called twice!!!
I have a splitter window, in which I want to have 3 panes (as vertical
My primary requirement is I want a menu inside one of the panes, i.e,
menu should belong to the pane and not the whole window.
To achieve this, I put a CFrameWnd derived class inside the pane. This
CFrameWnd derived class has the menu I want.
Now, my problem is that after I do this, the OnCreate of the FrameWnd
is getting called twice all the time. Can anyone help me know why this
Or even better, does anyone have an alternate solution to putting a
menu in each pane of a splitter window?
Hi, my problem is the suppression of a recording to àpartir of a list
indeed when I want to remove a customer for example an error message is
impossibe to remove contact the system administrator
Please stop workflows related to that list / record and also close activities
related to that.
It is basically because useable record.
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. email@example.com
> Hi, my problem is the suppression of a recording to ...Suppressing VBA Errors
I think I've seen a way to prevent (supress?) errors in VBA but hav
forgotten just how I should do it.
This is my code. As you can see, it's to update data in a Currenc
Conversion file that I made.
Sometimes I get a Run-time error '1004' message saying "This web quer
returned no data".
Any solutions? Would appreciate any help
Message posted from http://www.ExcelForum.com
have a look at
on error resume next
on error goto 0
Frank Kab...virtual CDialog base class
I need to add some functionality to a few dialogs AND property pages
in my program. Since property pages are derived from CDialog, I
thought that in order to avoid confusion I'd create a dialog class
with required behaviour with CDialog as virtual base class. Problem is
that the moment I change class definition from: "class CMyDialog :
public CDialog" to "class CMyDialog : virtual public CDialog" compiler
emits errors like below in WM_ON_PAINT() (and other ) message map
error C2440: 'static_cast' : cannot convert from 'void (__thiscall
CMyDial...Changing main menu colors
I'd like to change the background gray and selection color for the main
menu. What's the simplest way to do this?
I have an owner draw menu and am overriding DrawItem and MeasureItem but
it's a lot of work just to get this color change. I'm thinking there has to
be something simpler.
You are out of luck to do this if you are talking about menu bar. You
will need to onwer draw the pop up menus in order to change the color.
You could make main menu bar a toolbar and then its color (relatively
easy and code is available at different sites).
Aja...Hiding fields based on security privileges
Is it possible to hide a field/tab based on a user's security
privileges? I know how to do basic field/tab hiding, but how can check
for the user's privileges? Presumably, there is a GUID for each
security role, so I am just wondering what the code is for this.
There is no published code for this. C360 have a field security addon or you
will need to go researching to build the code.
Microsoft CRM MVP
"WiLLerZ" <firstname.lastname@example.org> wrote in message
news:1162163816.765962.160960...suppress detail in a report?
I have a trial version of MS Money 2004. I want to generate a report
based on Classification 1 and would like to see a summary only with no
detail.. just the amounts for each Classification.
I do not see an option in the custom report generator to suppress the
detail (in Rows & Columns). Have I overlooked this option? If so, how
do I accomplish this?
Have you tried Spending by Category with Customize|Rows &
Columns|Rows:Classification 1 and Columns:Totals Only???
"speedlever" <email@example.com> wrote in message
news:firstname.lastname@example.org...Tabbing between a main form and a subform
Normally when dropping a subform into a main for the tab order is
automatically set so that when you hit 'Tab' on the last record of the main
form it moves the cursor to the first record of the sub form. I have created
a main form linked to a subform but no matter what I try the tab simply
cycles in the main form. (The subform does not appear in the tab order of the
detail section of the main form.) Is there some setting so that I can get it
to move to the subform?
On Mon, 16 Nov 2009 23:06:02 -0800, Peter
<Peter@discussions.microsoft.com> wr...Workflow based on create Product entity -- possible?
Sorry if this is an elementary question -- I'm kind of fumbling my way
around on this, and I haven't found any documentation or resources on
any other sites that directly answer it.
The basic workflow I want to accomplish is for our accounting
department to be notified (via email) when a product specialist adds a
new Product to the system.
I'm trying to use Workflow Manager to create a new workflow based on
the create event for the Product entity type, but that type isn't in
that primary list in Manager. I see maybe 25 built-in types in there,
but not Product.
Th...Auto fill Column based on data in other columns
I have a report I'm downloading into Excel each day. Columns A, B, and C
have the same number of rows populated. Columns D and E don't. I want to
populate columns D and E with code the same number of rows Columns A, B and C
are. I want to auto fill Column D with the text "ABCD" and Column E would be
the current date in 06/05/06 format. I would like to put this code into an
existing Macro. Any help you can give me is appreciated.
Double click on the fill-handle
If you want to simulate with a macro
Filldown as...For the selected section and the following one: unlink headers from previous section
Below macro unlinks the current headers from the previous section. How
has this code to be expanded if I also wanted the following section's
headers to be unlinked from the previous section?
Help is much appreciated. Thank you very much in advance. Regards,
..Headers(wdHeaderFooterPrimary).LinkToPrevious = False
..Headers(wdHeaderFooterFirstPage).LinkToPrevious = False
..Headers(wdHeaderFooterEvenPages).LinkToPrevious = False
You can use
With ActiveDocument.Sections(Selection.Sections(1).Index + 1)
as the f...Recipient Policy based on OU?
Read through a few posts and searched a bit on how to set up a Recipient
Policy based on a users OU and not having a lot of luck.
This is what I do:
2) New recipient policy (email property pages only)
3) Name it
5) Change the find to "Organizational Unit" and choose Find Now
6) Select the OU(s) I want, hit OK
7) Brings me back to the General tab and the filter rules are always
8) Tried putting the exact name in the Find field and get
(&(ou>="")(name=MyOU*)) but never seems to do anything.
What am I missing? I ...Suppress UI of Dialog box.
i want to suppress the ui show after installing the cab in the PPC
i have tried
sei.cbSize = sizeof(sei);
sei.fMask = SEE_MASK_FLAG_NO_UI | SEE_MASK_NOCLOSEPROCESS ;
sei.hwnd = NULL;
sei.lpVerb = _T("open");
sei.lpFile = tszCabPathName;
sei.lpParameters = _T("safe /noui /nouninstall /delete 0");
sei.lpDirectory = _T("");
sei.nShow = SW_HIDE;
still it shows successful installation of cab, and i want to avoid that
Can u please help me?
"Bks" <email@example.com> wrot...