Checkbox control and forms
I have a database with a few different tables but each table is pretty much
the same. The tables have a set of tasks in the cells in Column A (a daily
routine to be completed). All other columns in cell 1 have a number 1-31 for
each day of the month. I'm trying to create a windows application (I'm using
Visual Studio) that as soon as it comes up asks for the users initials, then
goes to the main form with a list of tasks that comes from one of the tables
(I guess I'll connect using datagrid view for the rows?), beside each task
there will be a check box and when the user ...Hiding "0" values in pivot table
In a worksheet I have a listing of stock records with ItemNumber, Date,
StockLocation and NumberOnStock. When I make simple Pivot Table with
ItemNumber and StockLocation as rows and select a Sum of "NumberOnStock"
I would like to hide rows where the sum is "0". But this does not seem
to be possible.
Tried to follow the guidelines in the Microsoft article:
But no luck :-(
You could use conditional formatting on these cells - highlight the
cells,...Query by Form-TJ
I need to do a Query by Form based on multiple selections from combo boxes on
a form using Access 2000 I need to bring back the appropriate records in a
On Mon, 31 May 2010 07:08:01 -0700, ambushsinger
Query by Form can't do that. It can only select records in the current
form view. After that, you can potentially open a new form with that
subset of records in a subform.
Microsoft Access MVP
>I need to do a Query by Form based on multiple selections from combo boxes on
>a form using Access 200...Hiding formuals in cells question
Hi. I was wondering if there was a way to hide the formulas in cells without
protecting the sheet. I am making something for other teachers at my school
and I want to hide the formulas so they won't mess anything up on the
spreadsheet. Any help would be greatly appreciated. Thanks!
not without protecting the sheet but why is this a problem for you?
"JP" <JP@discussions.microsoft.com> schrieb im Newsbeitrag
> Hi. I was wondering if there was a way to hide the fo...Forms issues
This form has five sections (all on a tab control) 1. materials 2. up 3.
down and 4. take up and 5. properties. Each of these sections have parameters
associated within the tab.. Section 1 is special because each of the
following sections depend and the results yeilded depend on the formulation
of materials in section 1. By the way each Formula is composed of maybe 3
different ingrediants at different amounts.
So for example A under section 1 could be materials x, y, z at 3g 4g 5g.
Section 2 will than keep A and do many trials tweeking one or two processes,
if okay Section three will build...hide my name
When replying to an email or creating one from scratch how do i hide my name
in the "from" field...thx
fred <email@example.com> wrote:
> When replying to an email or creating one from scratch how do i hide
> my name in the "from" field...thx
Are you saying you want the reply to be anonymous?
Brian Tillman [MVP-Outlook]
no, I don't mind if my email is revealed.. just my name. I have tried by
removing it from the "User Name:" field in the email account but it
continues to show up. I have also removed from the header informati...White Text On Black
I've looked through my printer's settings (Epson) and haven't found
anything helpful there. Is there a setting in Word 2004 that'll
reverse the colors? No sense in running through all that black ink.
I'm not sure exactly what you're asking, but my guess is that it's best
answered by simply saying that there is no such thing as "white" ink - at
least not at anything less than special spot color at the commercial
printing level. White on the typical home/office printer simply means the
absence of ink in those locations where it's called ...Dynamic Range and Combo Box
I've succeeded in creating a dynamic named range by following the
I've half succeeded in using it to populate a combo box.
The combo box happily takes the values in the range when I first created
the combo box but it doesn't use any additional entries I make to the
named range. I know Excel's seeing the new entries because I'm testing
it with =SUM(MyRange). This alters as soon as I add anything to it.
Where am I going wrong?
You could use the combobox from the Forms toolbar, which updates...Title & Text Layout Format Issues
I believe this has been answered before but cannot locate. (probably Echo)
On a Title & Text Layout slide I manually reduced the font size so all text
would fit. I saved the file but when re-opening it reverted back to the
large size. The auto correct options are all turned off.
I think you've run into a bug, Fritz. The info at this link offers some
Text size or other formatting is lost when you save, close, and reopen a
Echo [MS PPT MVP] http://www.echosvoice.com
Wha...Button Text not showing :Too many items in Oppurtunity Menubar
It is indeed necessary for me to display the Text for all the buttons. But, there exist a lot many and CRM is hiding the text.
How can i tackle this?
How can MenuITem be useful (if at all.)?
Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Report Engine, Part 2
This code will hide "Create Invoice" button on "Order" entity form.
var mb = document.getEle...enter key behavior on a form
what property setting activates the next text box when hitting the enter
key? right now hitting the enter key submits the form. i only want the
enter key to submit the form when the command button is highlited
Message posted from http://www.ExcelForum.com/
It's the TabIndex property of the control. Set them in ascending order.
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Zygoid >" <<Zygoid.firstname.lastname@example.org> wrote in message
news:Zygoid.113pks@ex...Hiding and Un-Hiding Data fields
I am using a form for people to select data via dropdown menus and then
having it run through a query to filter results. Is there a way that I can
have certain feilds hidden until a toggle button or something of the like is
Basically I want have three choices of buttons: Year, Quarter, and Month.
What I ideally want to happen is when someone selects the button for year, a
hidden drop down menu appears where they can then choose from the available
years to filter through the query.
I would say I am above average with using access, but I have no idea how to
hide fields and then...How do I hide gaps in an Excel 2007 chart?
I have a bar chart that is showing gaps and i don't want them. The select
data > hidden and empty cell button does not give an option to hide gaps. I
think by default they are hidden but if you even click on this to see what it
does the gaps are shown and no way to turn off.
If you hide the actual rows then with the Plot visible cells only
setting on the gaps will be removed.
In xl2007 the setting is on the Select Data dialog, Hidden/empty cells
> I have a bar chart that is showing gaps and i don't want them. The s...how to draw static text in a dialog
I creat a dilog and want to display some lines in the static text of
the dialog .
this is code:
CWnd *pWnd = (CWnd*)GetDlgItem(IDC_mystatictext);
CDC* pDC= CWnd::GetDC();
but it just display in the dialog and cannot display in the static
I just a newer one to study vc,thanks for yous help.
You dont have to draw anything. Simply call SetWindowText on it:
CWnd *pWnd = GetDlgItem(IDC_mystatictext);
> I creat a dilog and want t...Inserted images and pasted text is the wrong color in publisher.
When I insert a picture (jpg) from file or scan it in, it places it as a
green picture even though I scanned as a full color. Also copied black text,
when pasted into publisheris pasted in green? Am I missing a default setting.
Everything I try to insert or past is green.
Have you looked to see if there is an updated video driver lately?
MVP Microsoft [Publisher]
How to ask a question
"CaryK" <CaryK@discussions.microsoft.com> wrote in message
>...text wrap problem
I'm importing address info into Excel from our in-house database. Th
addresses comes as a block with line breaks which show up as a squar
in Excel (when text wrap is off). I need to change these marks int
commas. Is there any way to do this automatically?
I dont have VBA knowledge but suspect this is where the answer lies.
Apologies if this is an innane question to some but Im stumped.
Message posted from http://www.ExcelForum.com
From a previous post:
Chip Pearson has a very nice addin that can help identify those funny
http://www.cpearson.c...Text is Truncated With String Variable
If I do this:
Dim theTxt as String
theTxt = Activesheet.Cells(1,1).Text
for some reason the text (which is actually 1849 characters long) is
truncated to 1024 characters.
If I do this:
Dim theTxt as Variant
theTxt = Activesheet.Cells(1,1)
I get the complete text string from the cell.
Can someone tell me why these two approaches are giving me different results?
One uses the .text property, the other uses the default property (.value).
> If I do this:
> Dim theTxt as String
> theTxt = Activeshee...Hiding a worksheet #3
I want to hide a worksheet. So, I went to the format menu and the "worksheet" option is grayed out. Why? And, how do I "ungray" it.
is your worksheet protected ?
> I want to hide a worksheet. So, I went to the format menu and the
> "worksheet" option is grayed out. Why? And, how do I "ungray" it.
I think Frank meant to ask about the Workbook--not the worksheet.
(Check under Tools|protection|Protect workbook or Unprotect workbook)
My question is: Is there another sheet in the w...No Text Shadow option
Using Excel 2002, Win XP.
I have all the buttons on the Formatting toolbar showing, yet there is
no Text Shadow option.
Any suggestions will be appreciated.
Thanks in advance.
AFAIK there is not such feature for text only.
You can use the Drawing Toolbar to place shadows behind Graphics, WordArt,
Autoshapes and Text boxes.
Gord Dibben Excel MVP
On Tue, 23 Dec 2003 03:46:51 +0200, "Stan" <me@there> wrote:
>Using Excel 2002, Win XP.
>I have all the buttons on the Formatting toolbar showing, yet there is
>no Text Shadow option.
>Any suggestions will...chart on the form
Is it possible to have chart controls on the form?
I would like to have Excel chart like bare, pie, line chart on the form base
on the data in the table.
Is it possible to do this?
If yes, any controls or activeX controls available for Access?
Your information is great appreciated,
Use Pivot Chart view and select pivot chart on form properties.
"Souris" <Souris@discussions.microsoft.com> wrote in message
> Is it possible to have chart controls on the form?
> I would like to have Excel chart like...Hide images when Hiding Rows
I have inserted images into cells, but when I hide the column the images
are not hidden with that column, they just get squished between the two
cells next to the hidden cell. Is there a setting or way to tie the
image to that cell so that it hides/unhides appropriately with the row?
kurt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35686
View this thread: http://www.excelforum.com/showthread.php?threadid=554712
You cannot insert an image into a cell.
You can overlay ...Non-modal forms and multiple documents
I have a non-modal form over my documents for convenience tools while I am
working with it. Essentially a constantly-running macro until the form is
closed. It is set to automatically run upon opening the file.
The macro/form is based off a template file so that if I send the document
to someone else, they won't get the macros, since they don't need it.
The problem I am coming across is that if I have documentA loaded, with the
macro running, and open up documentB for reference.
Instead of running a separate process of the macro, it takes over the macro
running with ...cannot see my dialog/forms.
By accident i excluded a file or something from my project, now i dont see
my gui anymore,.
i try to include the res files, but in the resource viewer i dont see the
dialofg box nomore.
the appl. still compiles and runs,
what do i have to do to get the gui back?
thanx N. Karademir
Smart Software wrote:
> By accident i excluded a file or something from my project, now i dont see
> my gui anymore,.
> i try to include the res files, but in the resource viewer i dont see the
> dialofg box nomore.
> the appl. still compiles and runs,
> what do i have to do to get the ...only returning cells with Text in it
I have a column that returns some text, if something else is true. Now
what I want to do is take only the cells in that column and list them
on another sheet.
The trick is, that ill need to do this with a frmula, since it will be
a hosted template and the user wont be able to use excel functions like
so, if I have 10 cells and 3 of them have test in them, I want to show
only the text in those 3 cells in another sheet.
I hope that makes sense....
Thanks for your help....
Assuming that Sheet1!A1:A10 contains your data, enter the following
formula in Sheet2!A1 and copy do...how to hide an ActiveX control?
i have an ActiveX control, written in C++, which has the
OLEMISC_INVISIBLEATRUNTIME flag set, yet when i display the web page
it is attached to, i get the familiar "red cross" graphic in the
middle of the screen - how can i hide the control so nothing is
displayed at all?
can u set the size of ur control as 1x1 pixels
"bhu Boue vidya" <email@example.com> wrote in message
> hi there
> i have an ActiveX control, written in C++, which has the