cascade combobox in a subform
Please help, with a cascade combobox in a sub form.
I would like make a selection from the combobox named cboSiteID in my main
form named f4Project and have the combobox named cboUnitID in my sub form
named t032ProjUnit be limited to only the records relating to the SiteID.
How can this be done?
Thanks in advance!!
> Please help, with a cascade combobox in a sub form.
> I would like make a selection from the combobox named cboSiteID in my main
> form named f4Project and have the combobox named cboUnitID in my sub form
> named t032ProjUnit be limit...Change the working directory for a MFC application
I am trying to change the working directory of a MFC application after
the application execution begins.
Chdir or setcurrentdirectory doesnot work for a MFC application.
Can anyone suggest how i can do this?
> I am trying to change the working directory of a MFC application after
> the application execution begins.
> Chdir or setcurrentdirectory doesnot work for a MFC application.
> Can anyone suggest how i can do this?
> - Akila.
SetCurrentDirectory does work for a MFC application. If it doesn't seem ...Standard Cost Changes Screen
I'm trying to enter a proposed standard cost on a finished good item but the
Proposed Standard Cost Field is greyed out.
Cards >> Manufacturing >> Inventory >> Standard Cost Changes.
Any ideas as to why it's Greyed Out, and how can I fix this?
Is the Bill of Materil a "Phantom" item?
> I'm trying to enter a proposed standard cost on a finished good item but the
> Proposed Standard Cost Field is greyed out.
> Cards >> Manufacturing >> Inventory >> Standard Cost Changes.
&...MS Excel file extension changed through e-mail
MS Excel .xlsx files sent as attachments are received without the x,
as a .xls instead. The same is true for MS Word .docx changed to .doc
Answered in the Word group. Please don't post the same question in multiple
groups. It not only causes responders to waste their time replying to
questions that have already been answered but it also makes it more
difficult for you to follow up on the replies. If it truly is an issue that
involves more than one app either post to the Office group rather than the
individual groups or use a newsreader rather than the web interface & learn
to ...Problems with re-setting the last active cell in an Excel workshee
I am trying to re-set the last active cell on an Excel 2002 worksheet (in
this particular sheet it should be cell DA197). I have used both the methods
described in the Knowledge Base article (deleting rows and columns and
re-saving; and the Excess Format Cleaner add-in).
Deleting the rows and columns does not work; using the Excess Format Cleaner
does not work either and it then also hides the rows from 198 to 65536 - but
does not do the same for the columns.
I have checked that there is no protection on the worksheet.
Has anyone else come across this problem and if so can you please ...Cannot change account type.
I have an HSA with a credit union that is updated online, I want to have it
listed under the Investment Accounts instead of Bank Accounts. The option to
change the account type is greyed out with the message "...online-enable
account cannot be changed"
Was there a question here?
I think the message you got tells you about three fourths of the problem.
The final fourth that the first three fourths prevents you from getting to is
that an Investment Account and a Bank Account are fundamentally different
types--one holds Investments, the other holds cash--so a change from one ...How do I un-"Group" my workbook; cannot see entire pane or move/re
...Add Word and change format
1) Let say colomn A is a product codes, such as "PK0021", "UQ05P8", etc...Now
I want add a "Z" in front the codes. To be "ZPK0021, ZUQ05P8". What's the
faster way in case I got thousand of codes?
2) In my colomn B is such code as "18-521-65, 18-81-84, 18-1112-65" and etc.
Now I would like to make it to be standard to 4 digit for the middle number
to be "18-0521-65, 18-0081-84, 18-1112-65" ... As the same senario as above,
I got more than thousand of such codes... What's the faster way?
The first could be done wi...zoom on RTF text
I am currently developing a windowless textbox object using ITextServices.
Everything went very well until performed zoom on text. In my code the RTF
text is rendered using TxDraw, which calculates zoom factor as this: zoom
factor = (pixel height of client rect)*2540/[Himetric vertical
extent]*[pixel per vertical inch]. But the result wasn't really that good,
the scaled text often went out of box, and word wrap wasn't consistent
specially when it scaled below 60%(above 100% much better). Does anybody
know what problems caused it? Any input would be appreciated. Thanks.
H...Text to dates
I have a column of dates F6:F148, the dates have been entered in the
following formats all entered as text "21.01.2009","21.1.2009","21 Jan 09" &
"21 Jan 2009".
I'd like to be able to change them all into a common date format 21 Jan 09
(I'll also change the sheet so that data is validated to this date format)
Does anyone know a way I can do this?
You can use the 'Convert Text to Columns Wizard to convert the dates
--Select the range of dates which needs to be corrected.
--From menu Data>'Text to Col...Serious performance issues when changing roles
Just a heads-up: don't change roles during times of heavy
user activity or you may have severe performance issues.
When you change a role, the MSCRMSEcurityService
evidently kicks off a massive job that updates the
securitydescriptor field in every record of every major
object. Last time I did this, it attempted to obtain a
table lock, and as a result, brought my system to its
The process was trying to update 46000+ rows from the
annotationbase table (you can see this by looking at the
last SQL command for the process that is blocking other
processes). Evidently bec...Change Withdrawal/Deposit to Transfer
Hi folks. How do you change a transaction that's already been recorded
from a Withdrawal or Deposit to a Transfer?
I'm assuming you are using Transaction Forms. Most people who have used
Money for a long time would advise just turning them off. You can also
change the category to Transfer: or one of the Expense categories. There is
also For a WD -> Transfer switch the Transfer seems Options|Change
<email@example.com> wrote in message
> Hi folks. How do you change a transaction...Cannot select a range of text
Operating System: Mac OS X 10.6 (Snow Leopard)
I am unable to select a range of text with either the track pad or my mouse. I am able to double- or triple-click to select, and can use keyboard commands to select all, etc. <br><br>This is a new problem that has not existed before. <br><br>Thanks! <br><br>Art
Not enough information to answer. Please carry out some diagnostic testing
1) Is this one document, several documents, or all documents?
2) Is this both .doc and .docx? If not, which ...How do I change the text size in a drop down box
I am using excel 2003. It seems to default to 10pts. Changing the size in
the source list or the default in the general tab did not change the size.
...choice to colour text
Hi, hope someone can help.
I have a shared spreadsheet with quite a lot of users.
I need to categorise who is using the spreadsheet so that
text that they add comes up in a different colour. Is
there anyway to do this?
I realise they could just change the text colour
themselves, but it would be simpler in the long run if
when they tried to input text they were faced with a
question, and the answer changed the text colour
Any help is much appreciated!
Maybe a user has to log in to the worksheet. eg when the
sheet opens, an input box asks for username. The a...Problem with Text box and Background
I am using the background as a temple for a form
I add test boxes where I want to have text typed in
The problem is when I print the page the text I have typed in isn't where it
is supposed to be
It is below the line of the background form
How do I solve this problem?
Best asked in the publisher.webdesign group
Mary Sauer MSFT MVP
"News" <firstname.lastname@example.org> wrote in message
>I am using the background as a t...VBA to add and remove text within cells
Hi, I have a field named "Postal" at the top of column F that always include
a number with 5 digits then a city name then a region name, such as "11090
CARCASSONNE Linguadoca-Rossiglione". I need to create a program to have this
field changed as following : "F-11090", then copying "CARCASSONNE" into the
City field which is empty (column G). The city name is always starting just
one space character after the postcode, same thing for the region name, it
always starts one space character after the city name. The region has to be
...Dialog text only updated on mouse moves
My PreTranslateMessage() function has code in it to update some of the
text in one of my dialog boxes. It works, but instead of updating it
every second, it only udpates the text when my mouse is moving or
Any ideas on what might be causing this?
Well, that's becuase PreTranslateMessage gets called only when there is
message in the queue for that window.
Instead use a timer. See OnTimer (WM_TIMER)
<PloutzMR@Npt.NUWC.Navy.Mil> wrote in message
> My PreTranslateMessage() function has c...text boxes that label axes in line/scatter graphs
I tried to use "SAT-M" as y-axis label, but "M" was cut off (actually went to
second line that could not be seen). I tried every trick I know to lengthen
the text box, to fit label on one line.
The only way to length chart textboxes is with more text. But at some
point more text will cause the content to wrap. The charts textboxes do
not have the ability to be sized manually even though the bounding box
and grab handles would suggest otherwise.
Try adding a few spaces or even non-breaking spaces ALT+0160 (Numpad)
> I tried to use &qu...Re:Re: Excel Problem
This is a multi-part message in MIME format.
I have some sheets 1;2;3;4; ETC.................
I would like the new page list release with one botton:
A1-Nome de sheet(1;2;3;4; ETC)
"Bob Phillips" <email@example.com> ha scritto nel =
> I am not absolutely clear as to what you...Word documents are re-formatted to an undesired font on opening
I have saved documents with an Arial based style but on re-opening the styles
have Times New Roman and different font sizes.
How did you change the styles?
Microsoft Word MVP
"KeithCC" <KeithCC@discussions.microsoft.com> wrote in message
>I have saved documents with an Arial based style but on re-opening the
> have Times New Roman and different font sizes.
...cannot change part of a merged cell
I merged cells and come time to paste from the clipboard into a merged cell,
I get the error it can't be done. I can hit F2 and paste. It's an annoying
step and users who are not quick on the draw with Excel would be stuck.
Is there a way to stop the error and succeed with a paste?
don't use office clipboard use Ctrl + C & Ctrl +V
On Apr 7, 5:46=A0am, "shank" <sh...@tampabay.rr.com> wrote:
> Annoying problem...
> I merged cells and come time to paste from the clipboard into a merged cel=
> I get the error it can...Strange problem while running MFC 7.0 apps on Windows 2000
I'm writing an MFC 7.1 program and it runs smoothly on XP and 98. However,
on Windows 2000 I encountered a strange message saying that
The application failed to initailize properly (0xc0000005). Click on OK
to terminate the application.
Thus I try to install VS.Net 2003 on a Win2k machine and run my EXE from
VS.Net IDE. The debugging outputs are attached below. Any clues /
suggestions / solutions are appreciated.
My program uses VS.Net 2003 (MFC 7.1, link as static library) and CImage
class in that. The GDIPlus.dll is copied from .Net framework 1.1.3705.
...How I can change the direction of Paste All in MS-Excel (MOST URGE
I am using Office 2003. I have copied some data from a word file in Office
Clipboard. Now I want to paste this all data in MS-Excel. When I
choose the "Paste All" option it pastes all data down side, while I want to
paste the data right side / left side. How can I change it's pasting
direction? I do not want to use "Transpose" option beacuse it is tadious &
time consuming. I want to do this with a fasttest manner. How can I do this.
Is it can be done by a macro? If yes then please tell me the macro code.
It is Most Urgent so Please help me as soon as possible...change an icon
I'm using XP Home. When saving an email in 'Message format' within one of my
the envelope icon is too similar to the standard folder icon. Can I change
the Outlook envelope icon for something else - what choices do I have and how
can I do it so that
the new icon becomes the default icon?
> I'm using XP Home. When saving an email in 'Message format' within
> one of my files, the envelope icon is too similar to the standard folder
> icon. Can I change the Outlook envelope icon for something else -
> what choices do I have and how can I do it so...