Combo boxes #12
I have a combo box in a form that lists all of the countries. I am
trying to set it up so that if the user presses the first letter, it
goes to the name of the first country with that letter and then if they
press the same letter again, it goes to the next country that begins
with that letter. I have the first part working, but the second part
is not working. I press a letter once and it goes to the first country
beginning with that letter, but when I press it again, it doesn't go to
the next one. Is there a property to set in the form for that combo
box to make it do this?
...mail.comcast.net box to enter username and password pops up every 15 seconds
I have a remote user/co-worker that has Comcast email. Every 15 seconds
(we literally timed it) a box asking for a username and password pops
up. I had him call Comcast for help, and they said it's a VPN issue,
and they can't help.
Any ideas on how to get this annoyance to go away? I'm terrible at
remote help, and he's very computer illiterate :). Any suggestions
would be greatly appreciated.
Jilly <Jilly4@gmail.com> wrote:
> I have a remote user/co-worker that has Comcast email. Every 15
> seconds (we literally timed it) a box asking for a username and
&g...stretch text box very very little
In publisher on a calendar I use text box in the date square. Some I can
stretch a very very little others stretch too much. How do I make them all
so I can stretch them very very little. That way I can get them very close
to the date box line and not go pass it.
> In publisher on a calendar I use text box in the date square. Some I can
> stretch a very very little others stretch too much. How do I make them all
> so I can stretch them very very little. That way I can get them very close
> to the date box line and not go pass it.
I'm entirely ...alter the content of the from box in a message
in outlook my "from" box automatically defaults to the email from me and that
is the email address issued to me by my ISP that I entered at inception.
I want my default email to read a different email which corresponds not to
my ISP but to my web site and email service by my web hosters?
for example my outlook says that my emails are from firstname.lastname@example.org
in my signature block i type my small company details and include my company
website and my email which is email@example.com etc how do i get this
email to appear as a default in the "from" box?
Enter i...Dynamic Value in Workflows
I am creating some workflows and I want to set a value in an Account Entity
based on a value in the Opportunity Entity. I believe I should be able to
use the Dynamic value wizard within Workflow manager - i.e. select Account
and the filed and select = and then go to Dynamic Value and select
Opportunity and the field that I want the value to inherit on change of
However when I do this I can only select Account within the Dynamic Value
Dynamic Values are only available to children of Parent entities. Since
Accounts are at the top of the CRM food c...restoring exchange 2000 SBS stores to a differnt exchange box...
We are looking at dumping our SBS 2000 box and would like to set up a
different win2K box with just the std version of exchange 2000 until such
time as we can afford to upgrade to the newest version of exchange.
I need to get this up and running asap.Can I setup my new win2k server,
running the regular version of exchange 2000 and then once setup restore my
sbs exchange 2000 information stores to this new box running the regular
version of exchange 2000?? Are the information stores in the sbs 2000
version of exchange the same as the std version of exchange 2000 or will I
run ...Vlookup from Combo Box
I am trying to use the Vlookup function from a Combo Box.
The combo box will contain currencies (USD, JPY, EUR). Once a user selects
a currency, the lookup will use that currency to find the exchange rate from
Something like this
Any help would be much appreciated.
If it's a Combo Box from the Control Toolbox toolbar, you
can set the "LinkedCell" property (right-click on the
combo box and go into "Properties") to a worksheet cell.
When the user makes a select...which table Picklist integer value stored?
Which database table pick list interger values stored?
this query will list all the pick list integervalues and attribute
// for account
attributename will tell u about the name of the picklist
attribute value is the intigers
and values are what u can see on the form
i think this will help u
...AutoFill Changing Wrong Value
I'm trying to create an analysis sheet that gathers data from 100 worksheets
within the same workbook.
I want the same cell reference in each sheet, but to change the sheet number
in each cell.
The worksheets are named 1 - 100
Here is the formula: ='1'!B3:E3
It changes the cell references only, not the worksheets.
I've changed the formula to keep the cell references: ='1'!$B$3:$E$3
I now need the formula to increment the sheet number each time, PLEASE!!!
Presumably you want to sum data from that range? Try this:
=3DSUM(INDIR...How set totals of various cells with per colour fill value?
I have a sheet containing values as follows.
April May June
company 1 43
company 2 5
company 3 17
The cell values are also coured to indice a status.
Somewhere beside the table I want to mention the totals of the cells,
per status (so per colour).
How to perform the latter?
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
(remove xxx from email address if mailing direct)
"AA Arens" <firstname.lastname@example.org> wrote in mes...how can we transfer data from child dialog box to parent Dialog Box. #2
hi guys, i have created modalless child dialog box by parent dialogbox
using UI Thread . now i want to do 2 things first i want to transfer
CPoint variable from child to parent and second i want to call
OnLButtonDown() function of parent DialogBox. i have hint but not
proper please help me to complete this one.
SendMessage(m_pParent, WM_LBUTTONDOWN, x,y); // from child side
void CHRS_MoleDlg::OnLButtonDown(UINT nFlags, CPoint point) //on
parent dialog box
first of all tell me is it possible if yes then what will be "x" and
"y" so that they can convert into CPoint v...Getting the "name=" (bit, picklist) value that is returned from SOAP
OnChange event to poulate other field on a case.
One of those fields is a bit, and one is a picklist. Those nodes in the
response come back with <attribute="new_active" name="true">1</attribute>
for the bit field and <attribute="status" name="On Hold">3</attribute>
How can I read the name value? I've tried selectSingleNode("//status").name
with no luck.
I am doing a similar process, using a SOAP response message. I ge...Using Drop Down box that can be edited
I have created a form in Word 2007, but would like to have the drop down box
I created to also be overwritten by the user if the items in the drop box
doesn't include their choice. Thanks
One possibility would be to replace one of the items in the list with a user
input item. You could do this with a macro run on exit from the dropdown
Assuming the dropdown field Dropdown1, put an item at the end of the
dropdown list "Enter your own value" then run the following macro on exit
from that field
Dim sChoice As String
Dim fDD As FormFie...Drawing a selection box using CRectTracker
I have an MFC SDI CView application and I want to draw an selection box
when the user left clicks and move the mouse. I have found the CRectTracker
class but I can't get it to work
I have this code:
void CSCMLaserView2::OnLButtonDown(UINT nFlags, CPoint point)
m_startPt = point;
void CSCMLaserView2::OnLButtonUp(UINT nFlags, CPoint point)
//Release the capture on the mouse
CSCMLaserDoc* pDoc = GetDocument();
ASSERT(pDoc != NULL);
// Co...Hiding Returned Value of hlookup
Okay, this is a tough one... (At least for me)
I'm using the hlookup formula to import the starting times and ending times
of employees on a daily assignment sheet. I'm compiling all the times onto
a weekly schedule where each individual's hours for the week are added up.
Now, I've done all this, but I get #NA when a particular employee is not on
a certain day. I'm currently using IF and ISERROR to convert the #NA to
"0", which allows the sheet to properly add up the hours being used by each
employee. Now, I need to be able to hide the zeros so I can pri...Counting Different Values
Well here we go,
i have coloum B which has the name of the person and column F has the
now i want to have a summary page which has :
Name & Number from the other page counted up.
Robert Smith 10
Robert Smith XX
Jim Smith 10
Jim Cox 10
Jim Cox XX
Jim Cox 10
and on the summary page it has:
Robert Smith - 10 Total: 1
Robert Smith - XX Total: 1
J...Help with counting values that have different endings
Hi guys, i just joined SQLMONSTER and was wondering if you guys can help me
with this problem...
I have 10 columns and 8,000,000 rows which have stock ticker names and
exchange tickers-like the following:
How do I find the number of unique ticker names in my database and disregard
the .L, .LS, .S, .L, .KZ endings (because I am looking for the unique tickers,
not the exchange). I.E., I want
the values counted to be only AQR, GDY, NBAE, 0023CA, FOR or 5 values (I
don't want AQR to be counted twice becau...Updating Subform check box from Mainform check box
Hello, I've always found this site extremely helpful for figuring out my
Access problems but this one has me stumped. Forgive me, since I do not know
how to write code.
I have a Mainform called Open PO Main Form that is linked to a subform
called Open PO Sub Form by a field called CustomerPONumber. I would like my
user to be able to check off the box called DELIVERED on the Main Form and
have it automatically check off the box called SUBDELIVERED on the Subform.
Any help that you could offer would be greatly appreciated!
You may want to try setting the control...Modal and Modeless dialog boxes
I have a modeless dialog box and also modal dialog box in some application.
When both appear I would expect the modal box to eliminate any access apart
from it but I can access the modeless as well and it could get focus just as
the other box. Is that normal or am doing something wrong?
Can I force the focus to be only on the modal box?
> I have a modeless dialog box and also modal dialog box in some application.
> When both appear I would expect the modal box to eliminate any access apart
> from it but I can access the modeless as well and it could ge...how we can retrieve the value of edit control of combobox.
hi guys, how r u, can you please tell me how we can retrieve the value
of edit control of combo box. actually i want to allow the user to
input data in the combobox and then save this data in the database. i
don't want to select already exist data in list box of combobox.
please help me.
> hi guys, how r u, can you please tell me how we can retrieve the value
> of edit control of combo box. actually i want to allow the user to
> input data in the combobox and then save this data in the database. i
> don't want to select already exist da...Multiple If True Values?
Does anyone know of a way to check for a value in two different cells, and if
a certain combination of values exists, change the format of another cell?
Any help would be much appreciated.
Start by experimenting with Format|Conditional Formatting
Then come back if more help is needed
Bernard V Liengme
remove caps from email
"Lee" <Lee@discussions.microsoft.com> wrote in message
> Does anyone know of a way to check for a value in two different cells, and
First thank you in advance for any help. I want to put a search box on the
first sheet of my program to enter data, either a name or an assigned number,
and have it search for and go to that line of information on another sheet.
Can I do this or do you have another suggestion?
This should do it. Change sheet name and column numbers to suit
mv = InputBox("Enter name or number")
If IsNumeric(mv) Then
mc = 4
mc = 1
Set mf = .Columns(mc).fi...sent mail appears in my in-box
How can I change settings to prevent e-mail that I send
also going to my in-box?
Thank you in advance
Under Tools->Options->Preferences->Email Options->Advanced Email Options, do
you have the box checked to save mail in the same folder? Do you have any
rules that affect mail after it is sent?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
TopCat <email@example.com> asked:
| How can I change settings to prevent e-mail that I send
| also going to my in-box?
| Tha...Stored Procedure with array of values
I have the query below in a stored procedure in MS SQL 2005 server. My
problem is that I would like to be able to pass in multiple questionID values.
So I would like to replace
A.QuestionID = @QuestionNumber
with a method where I can pass in a list of question numbers. For example
instead of passing in 286 I would like to pass in 286, 289, 412, and 513. The
number of values passed in would vary from 1 to 15 or 20.
I imagine the line
A.QuestionID = @QuestionNumber
would be edited to something along the lines of
A.QuestionID IN ( @QuestionNumber )
SELECT Coun...dialogue box
Can anyone offer help:
When I click on the "new" tab in outlook a dialogue box comes up that says "
A dialogue box is open. close it and try again". I don't have anything else
open. Any ideas??
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"Elliott" <Elliott@discussions.microsoft.com> wrote in message