Auto populate multiple fields from related table
Hi there ,
I have Incident entity which has 1:N relationship with a Custom table (Part
Master). Lookup field is created on Part # on the Incident form, When I
open a new Incident , on entering the Part # I would like to display whole
bunch fields on the Incident form from the related Part Master. Also would
like to assign some of these fields to the Incident record.
Any ideas how can this be done ? Any help is appreicated.
Thank you in advance.
call the CrmWebservice retrieve the selected entity ...SQL Server 2000 Standard Edition vs SQL 2000 Personnel Edition
I am using SQL server 2000 standard Edition sp3 with Gp 9 Sp3, I am planning
to move GP with database to new server different hardware.
can I use sql 2000 personnel edition sp3 or should I use same old version.
I hope u understand my question.
Generally speaking, personal editions are not robust enough to support a
product like GP. I would stay away.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
"MK KSA&quo...Drawing Control in VB.NET
This is a multi-part message in MIME format.
I don't know if this post should be here or in the .net languages forum =
but I'll start here. The problem is I am trying to use the ActiveX =
control in a vb.net program and I have a form that includes this control =
.. The problem is that when the form initializes it starts Visio duing =
the initialize component module when it hits=20
Public vsoApp As New Microsoft.Office.Interop.Visio.Applicat...Using a field from one sub form and into another subform
I have a form with tabbed subforms on it.
subform1 - datefield1
subform2 - datefield1
When I fill out subform1 I then tab to subform2 and I would like the data in
datefield 1 to carry over to the datefield1 in subform2. Is this possible?
It is a bit unusual in a well-normalized relational database to have to
store the same fact more than one time.
If you'll describe a bit more specifically what having the same fact (date
info?) in two places will allow you to do, folks here may be able to offer
more specific suggestions.
Microsoft Access MV...disabling restore control
i have a problem that in my mdi form when i open a child form in
maximized state it has restore control button and i want to disable
that button whan the form has opened up so that client can not restore
the mdi child form can any body help me
Ajay posted this for you earlier, but in case that one scrolled off:
Try something like:
CMenu *pMenu = pYourChildFrame->GetSystemMenu(FALSE);
"Muhammad Ahsin Saleem" <email@example.com> wrote in message
> ...Editing Text when using Publisher as a web page...
I'm using Publisher to document the status of current taskings in the office.
I'm trying to ger Publisher to allow people that pull up the web-page to add
and edit text on the web page so we can keep everything up to date. Right
now, someone has to come to me and tell me the changes, then I change the
info in the Pub doc, then I have to repost the web-page. Is there a way for
people to edit the text on the web-page when they pull it up. I have text
boxes in there now that people can edit, but the text doesn't update when you
close the page and re-open it. Please Help if you ...editting auto recovery
is it possible to change the auto recovery directory just for one document
and is also possible to ensure that the auto recovery file is not deleted
after the file is closed?
AFAIK this is not possible. But you may consider using the following
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
> is it possible to change the auto recovery directory just for one
> document and is also possible to ensure that the auto recovery file
> ...BOM & Edit List
I created an Assembly transaction and printed it from the Assembly
transaction entry window before posting it.
In the posting journal that prints it does not print the Assemble cost,
extended assemble cost, Unit cost of the components and the extended cost.
But if i post the transaction then the same posting journal is printed with
Why does it not print?
Please let me know
It only pulls posted costs, like other Great Plains edit lists including
items. You will need to modify the report to include costs.
> I created...template edit question, add more? edit template?
Operating System: Mac OS X 10.6 (Snow Leopard)
i'm using a resume template and it's beautiful, but only allows four job positions before it moves one the education, etc. <br><br><i>guess theres a way to do it on the pc version, but with mac, how do i insert an addition formatted block? it will only let me work within the template currently.</i> <br><br><i>hope that makes sense, thanks for the help!</i>
Mac or PC makes no difference � it's a matter of how the template is
constructed. With...Fast grid control
I am developing a trading type application and would like suggestions on any
efficient performance-wise grid controls out there.
I dont need any bells and whistles such as links to database but would like
the ability to have multiple lines per cell and coloration.
It's fairly efficient and has a lot of features, it's easy to use and
Just be careful of performing large number of resizing row height
operations. Page Fault City.
...Adding a new Required field
Can i add a new field to my table such that i enforce a Required condition on it? I cant do this in the table design cos the field will be blank till date. Only the records henceforth should have a mandatory entry in this field. Is there a way i can set this up in the Form?ThanksRamesh Thanks .. that helped. I need to use it only on fields which should not go without data.Ramesh"Wayne-I-M" <WayneIM@discussions.microsoft.com> wrote in message news:3680E488-4ED6-4EC7-966D-9504717B4BEE@microsoft.com...> Hi Ramesh>> You could use a messages box to tell users that they...How to edit entitys attributes directly?
I messed up with entity mappings and ended up with errror: attribute not found.
How can I manually remove attribute from entity?
Tried export -edit -import but it seems not to be the right way.
You will first need to remove the "bad" mapping that you created. Since it
is referncing the field, you need to do that prior to trying to remove the
field. You also need to remove it from any forms & views that may be
The customization Import will not remove fields (as you have discovered).
That is done as a safety feature to rpevent accidental loss of data (ima...Adding a control line to excel chart without showing up in the leg
How can I add a control line, (such as average, ucl, lcl), to an excel bar or
line chart and not have the control line series show up in the chart legend,
or data table?
Any sugestions would be greatly appreciated.
On Sat, 15 Sep 2007, in microsoft.public.excel.charting,
TWeaver <TWeaver@discussions.microsoft.com> said:
>How can I add a control line, (such as average, ucl, lcl), to an excel bar or
>line chart and not have the control line series show up in the chart legend,
>or data table?
Single-click twice on the legend entry for the control line, and ...Calculated field & hiding #Error results
I have a calculated field in a report I am running in Access 2003.
The report shows attendance percentages for 3 shifts over 3 zones.
However, only one shift has
employees in the third zone, the other two do not. When I run the
report I get
#Error because the calculated field is:
and Zone 1, for example, does not have an Authorized roll number so
is zero divided by zero.
I thought that the following might work:
But I still get #Error in this field on the report. Any suggestions?
=IIf([Zone1AuthRoll]=...Prevent duplication in a field
(Access 2003) Is there any way to check that the data typed into a field
(e.g. 201-150-500) is not duplicated as I leave the field, not after
exitinng after all of the form is filled in as happens now
Use the control's before update event to check your values. If you want to
stop the update then:
MsgBox the user
> (Access 2003) Is there any way to check that the data typed into a field
> (e.g. 201-150-500) is not duplicated as I leave the field, no...Editing
Could you please tell me how to remove a linked
transaction within the budget planner. For example, I
have a double entry under the debt category.
...Calculating additional fields on a Quote Form
I have this percentage custom field I convert into a money field using
order to get a total amount. The problem is when i use the below script, when
I save twice the correct total amount appears, but when I save and close a
totally different total amount appears
(crmForm.all.totallineitemamount.DataValue / 100) *
crmForm.all.totaltax.DataVal...Macro to edit details
Hi, i am currently trying to create a macro regarding editing staf
details on a worksheet.......
therefore i recorded a macro and named it editstafflist, i highlighte
my headings...and then went to 'data > form' and then had to close th
form and then stop my macro. It wouldnt allow me to stop my macr
whilst the dialogue box was open. Anyways after stopping the macro
drew out a button and assigned this 'editstafflist' macro to it.
saved my sheet and then clicked on the button, but a error '1004' kep
occuring, can anyone please help me on this as i am rather stuck
...editing a drop down #2
that's not one of my choices.
kateweb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16301
View this thread: http://www.excelforum.com/showthread.php?threadid=276931
what do you mean by this .. is it greyed out on the toolbar or shows "any
if you'ld like to tell me where you downloaded it from i can go have a look
"kateweb" <firstname.lastname@example.org> wrote in message
news:kateweb.1fictb@excelfor...Data collection Form Edit
We have a form which will be used almost daily, for data collection, based on
a query. During the test we found a typo in one of the field labels where a
brief description is included. Is there some way to edit the form?
(recreating it with all the custom lables is just too long a task).
Another issue on this topic, every time the form is sent, the messge reverts
to the default "Please fill out the form and retunr it to me". Can this
default message be changed?
Nothing in the help functions. Any advice, or deirection to a learning
resource will be appreciated.
Thanks is adva...Money 2007 and Vista user account control
I have noticed a nasty behavior when running Money 2007 on Vista ultimate.
If uer acount control is turned on Money opens the file in program files
then writes all its changes to the vitural store. When I close Money and
open it again the file that is opened is the old file from program files not
the file that contains the changes made last time. Is there another way to
fix this behavior other than turning UAC off?
Thanks in advance
John A. Dwyer, MCSE
In microsoft.public.money, John A. Dwyer, MCSE wrote:
>I have noticed a nasty behavior when running Money 2007 on Vista ultimat...Setting caret in edit control & activating it.
Does anyone have any example code for setting and enabling the caret in an
edit control ?
Take a look at the CEdit::SetSel() member function.
Check Abdoul [VC++ MVP]
"Nicholas Kingsley" <email@example.com> wrote in message
> Does anyone have any example code for setting and enabling the caret in an
> edit control ?
If you are asking how to create & use your own caret in an edit control then
check..."Windows PowerShell Cookbook" by Lee Holmes second edition draft available for viewing and comments
O'Reilly Books has made the working text of the PS V2 second edition
of Lee Holmes' "Windows PowerShell Cookbook" available for viewing and
In message <exi7SKRyKHA.2552@TK2MSFTNGP04.phx.gbl>, Larry__Weiss
>O'Reilly Books has made the working text of the PS V2 second edition
>of Lee Holmes' "Windows PowerShell Cookbook" available for viewing and
> - Larry
I have two problems with Acc2003, it worked fine with acc97.
1) I have a report with Sorting/grouping section and I want that every group
should start a new page. I set the Force New Page to Before Section. Now
with acc2003 the first page is blank.
(the After Section doesn't work either)
2) I always use the short cut Ctrl+Brk to copy from the previous line. When
I change the keyboard mode to Hebrew by pressing Alt+Shif, the form opens in
Design mode. Acc97 was no problem.
...Having Insert button functionality while editing
I want to have the functionality of Insert button (on keyboard) in my while
application while editing in a cell or a edit box. For eg if i am editing my
text say "alpha" and my cursor is between "l" and "p" and I insert an
alphabet say "z", i want the "p" should be replaced by "Z" and the text
should become "alzha".
Thanks in advance.
CEdit does not support that by default.
Here is a good example of how implement this (Although I think UpdateCaret
should just be a method of CXEdi...