I have a form with fields; ID, DATE and QUANTITY. The Date andQuantity Field I've changed into a List Box showing the two columnsrespectively and the ID field is left as a normal text box. When Iclick on any item in the list box the ID change change according towhich ever entry I have selected. Unfortunetly ID field staysconstant!!Any suggestionsThanks Hi, Asif,did you include the ID field in the ListBox?The easiest solution:1) Add the ID field to the RowSource.2) Point the BoundColumn to the ID field.3) Set the ID field column width to 0.HTHVlado"Asif" <email@example.com...In-Box
My in-box label in left rail shows 4 messages, however they do not download,
while at the same time other new messages download. Has Outlook forgotten
how to count?
You probably have a filter applied to your view so that some messages are
Verify that your view is set to the Messages view via the View-> Current
If that doesn't work either, use Customize Current View from the same menu
and use the Reset Current View button.
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, H...Combo Box Result
I have two unbound combo boxes (c1 and c2) that based on the value of c1,
will determine what shows for c2. By selecting c1, it will correctly limit to
what c2 shows, but when I select the option for c2, it is not choosing the
correct value. The result set for c2 is based off a table, that has the
ISID ISD ITID
1 red 1
2 blue 1
3 green 1
4 red 2
5 blue 2
6 green 2
c1 will select the ITID, which then limits what I see in c2 to the correct
set (I even brought in the ISID column to make sure the numbers ...Message box with Combo box function
Is it possible to create a combo box within a message box i.e. whenthe user clicks on preview report a message box appears and says"which report do you want to open?" and a combo box displays thedifferent reports available with the user clicks, upon clicking therelevant report opensThanks * Asif wrote:> Is it possible to create a combo box within a message box i.e. when> the user clicks on preview report a message box appears and says> "which report do you want to open?" and a combo box displays the> different reports available with the user clicks, upon clickin...combo box query
I have a combo box that includes a drop down box when selected. Can this be
in any way altered so you can scroll down the box ? at the moment, i have to
select the box with my mouse, then browse through the contents using either
my up / down buttons or the little down arrows. It would be so much easier to
scroll up & down.
When i select the combobox, presently it scrolls excel and not the box.
And help appreciated.
...Edit Box Display Control
I have a dialog-based app, and I want to have a read-only edit box to
display changing output(when the user hits a button, the displayed
numbers change in the edit box). Can I change the background color of
the edit box, or should i just draw a rectangle and write text to it
to control the background?
Just change the readonly style of the editbox. Take a look at the
Check Abdoul [VC++ MVP]
"matt" <firstname.lastname@example.org> wrote in message
news:email@example.com...Automatic update the number in a text box
I have text boxes in my charts. In that text box, I need to copy a number from another sheet each time I update charts. I am wondering if there is a way that I can update the number automatically.
Thanks in advance!
Is the number in the same cell every time? Here's how to create a new
text box that's linked to a cell (whenever I try linking an existing
text box, Excel just draws a new one on top of the old one).
Select the chart. Press the equals key. Navigate to the other sheet and
select the cell with the mouse. The formula bar reads like:
- ...To chage the string of the Message Box
I was told the following query, and it works good. How can I change the
Notes By to be a Msg String : "Dicatat Oleh". I want it as a variable,
because i have already the table of String message, so that it can be in many
INSERT INTO Catatan ( NO_URTANGT, TGLCATATAN, WKTCATAT, Subject, Notes )
SELECT a.NO_URTANGT, a.TGLCATATAN, a.WKTCATAT, a.Subject, a.Notes & [Note by]
FROM [C:\Churchdata\Churchdataconso\BkEnd\Hahomion_be.mdb].Catatan AS a;
Thanks in advance for many helps.
Are you talking about a stored query that you...Turn on Edit option in Combo Box
How do you turn on the Edit option in a Combo Box in Excel 2000? I have no problem entering the drop-down part, but cannot get it to allow editing. Please help.
What kind of combobox? Forms toolbar, Control Toolbox, or Data Validation.
What do you mean by editing? Do you want to edit an entry on the list, add a
new entry to the list, or just be able to type in a value that's not on the
MVP - Excel
Excel Blog - Daily Dose of Excel
"Pam at Greer" <Pam at Greer@discussions.microsoft.com> wrote in message
ne...Filtering Combo box items based on related table field- Please Help!
Hi im stuck on filtering a combo box. I have users who can be assigned
a category. Jobs can be assigned a category and also have a list of
people working on that job (in the JobDetails table). I have the
CategoryID (FK on Categories.CategoryID)
CategoryID (FK on Categories.CategoryID)
JobID (FK on Jobs.JobID)
UserID (FK on Users.UserID)
Then in the job details when listing users for a job (many users can
be for one job) i would like to only show the us...How do I add input data in the input ranges in drop down boxes.
I have a spreadsheet that was sent to me that has drop down boxes with data
that you can select and it is link to other drop down boxes. I would like to
add additional data in the drop down box range but cannot find where you add
additional data to select in the drop down boxes.
If the dropdown lists are created by Data Validation, you can select the
cell, and choose Data>Validation. In the Source box, you'll see the
range where the list is stored.
If that's not it, right-click on the dropdown list, and choose Format
On the Control tab, you'l...Comment Box or description box
Is there a way to assign the comment box to appear when a certain item is
sold, so therefore a description can be inputed.
you can use the Item Message (item definition - Special tab) to remind the
cashier to set the comment on those items when sold.
> Is there a way to assign the comment box to appear when a certain item is
> sold, so therefore a description can be inputed.
...The From box
Every time I create a new email the "from" box appears.
How do I turn this off.
Create a new message; View-> uncheck From Field
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Navigation Pane Tips & Tricks
-Create an Office XP CD slipstreamed with Service Pack 3
"Mike" <firstname.lastname@example.org> wrote in message
> Every time I create a new email the "from" box appears.
> How do I turn this off.
...font sizes for To, From, and Subject text boxes
How do you change the font sizes for these 3 textboxes
when composing an email? When you set the fonts under
Options->Mail Format, only the font in textarea for the
message body gets changed.
Correct. That's what that setting is for -- to change the message font. If
you want to change the font sizes of other elements, you'd have to design a
custom form. In some cases, changing the overall Windows font size might
also have an effect.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Dev...Question Box ?
I am using so far:-
MsgBox "Whatever", vbYesNo + vbQuestion, "MsgBox Title"
I want to ask a question, and then have response1 and response2 a
buttons to press on the msgbox.
Message posted from http://www.ExcelForum.com
though Bob Phillips posted some Windows API functions this is not
really possible (at least you won't get a robust solution). So I'd
recommend you create your own userform for this
"ianripping >" <<email@example.com> schrieb im
Newsbeitrag new...text box issue
I have a group of text boxes where I input data into, which go into
the criteria of a query. This works out fine when I run the report
with these criterion. My question is: one of my text boxes is an item
#, is there away to make it where I can put numerous item #'s in there
to look for more than one?
I was thinking about creating a subform where the items inputted would
go into a table. Then somehow linking that table field data to the
textbox giving multiple item #'s in the text box. The text box is
already linked to the query. Is this possible or what would be a good
way to go abo...Switch text box to combo box
I have a form and subform created from the following tables:-
RepairCategoryID (Primary Key - Autonumber)
RepairCategory (Text) - on form main (frmCategory)
RepairCategoryID (Number - Long)
RepairType (Text) - on form (subfrmRepairType)
BuyPrice (Currency) - on form (subfrmRepairType)
SellPrice (Currency) - on form (subfrmRepairType)
form objects are:-
Main Form - frmCategory
Subform - subfrmRepairType
"txtBuyPric...Enable Combo box based on value in check box and list box....
I am working in Excel 2003
As a part of my worksheet titled "Worksheet" I am trying to enable
Combo boxes based on the value of a check box and the value in a list
There will be a total of 6 combo boxes on the Worksheet. The first
combo box that deals with the body of a book will by default enabled.
The second combo box will be set to appear disabled unless a forms
control check box is checked to indicate there will be a cover on the
The 3rd through 6th combo box will each be disabled by default and
will be enabled when the list box which indicates the additional
sect...Command Button wont take click after editing text box
I have a form which has a text box as the last part where the user
needs to enter data. This text box has a date input mask configured.
Under this last text box is a command button which the user must click
to confirm and add the data that they just entered.
The problem is then when a user has finished adding a date in the last
text box then try to click the command button the command button will
not take the click for some reason. It is as though the text box with
the date will not release the focus or something similar. The user has
to click around the form in a haphazrd manner unt...check boxes 03-26-10
I have a form in Word 07 with multiple check boxes.
I would like to check one box, and automatically have another check box get
a check, instead of manually checking the 2nd one, which leaves room for
human error. There are 2 instances of this on my form. Hope this make
For that you would need a macro run on exit from the first check box field
(here Check1) to set the value of the second (here Check2) as follows
If ActiveDocument.FormFields("Check1").CheckBox.Value = True Then
ActiveDocument.FormFields("Check2").CheckBox...How do I make round corners on a text box?
How do I make Text Boxes have round round corners instead of 90 degrees?
If the goal is to have round corners on a text box with a border....
You could use the round corner border drawing tool from the left side of the
Also select Tools, Snap to object.
Don - Publisher 2000�
"TomCurley" <TomCurley@discussions.microsoft.com> wrote in message
> How do I make Text Boxes have round round corners instead of 90 degrees?
...List box, Combo box #4
Thanks for the info. Now I know one difference between the forms an
control toolbox combo box. One other question, can I link to anothe
excel or word document on my hard drive also
P-C-Surgeon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1477
View this thread: http://www.excelforum.com/showthread.php?threadid=26396
...How to draw the Minimize box, Maximize box and Close box mannually?
I'm writing a DOC/VIEW program. In my program, I need redraw the all
window objects with my style. But I met a question that I can not find where
to process the drawing of minimize box, maximize box and close box on the
CMDIChildWnd, CMDIFrameWnd or CFrameWnd window.
Who can tell me about it?
DrawFrameControl is likely what you are looking for.
Ajay Kalra [MVP - VC++]
"Bill Gates" <firstname.lastname@example.org> wrote in message
| Hello, all!
| I'm writing a DOC/...List box arrow key handling
What event gets triggered when you have nothing selected in the list
box and you press an arrow key?
I am in a situation where I have a list box where nothing is selected
(although there is a dotted border around last selected item). But if
you press an arrow key, an item gets highlighted. I have a code to
handle the "selection of the item" event, but that handler doesnot get
called for this case.
"pj" <email@example.com> wrote in message
> What even...i type in a text box but it changes other text boxes
Help! I am using one of the default publication designs in Publisher. When
I type in a text box on the cover page, it changes the text boxes on the
following pages. How do i stop this from happening???
Stop using one of the text boxes that's synchronized on the other pages.
Title blocks, issue/volume numbers, dates - all those tend to be carried
over to the other pages.
MVP Microsoft [Publisher]
"Tomth147" <Tomth147@discussions.microsoft.com> wrote in message
> Help! I am using one...