Problems with GP10 Field Service module
I keep having new problems come up after upgrading from GP9 to GP10. At first
it was we could not post sop invoices that created a new contract and now we
find that Contract Revenue Recognition isn't working.
I figured out that applying SP3 resolved the invoice posting problem.
When I open Transactions>ContractAdministration>RevenueRecognition I get the
following error - "[Microsoft][ODBC SQL Server Driver][SQL Server]Violation
of PRIMARY KEY constraint 'PKSVC00625'. Cannot insert duplicate key in object
'dbo.SVC00625'." before the window opens.
If ...adding field to form
I have made continiuse form with 10 field that works (text box in detail and
lables in form header) but when i want to add one more field that text box
is in detail part of form and lable in form header part ,I can not save my
form.and access goes to repair mode after saving and there is no change when
I reopen my form.
...Attaching activities to leads
I would like to asign one task activity to 600 leads.
I have created the task activity already and it is in
I have loaded my 600 leads already and they are in open
Does anyone know how to do it?
Thanks so much.
If you have a professional license, the best way to accomplish this would be via
a workflow rule. Had you set it up ahead of time, the activity could have been
created automatically by the workflow. Now, you will either need to delete &
re-import, or manually apply the rule to the leads.
If you don't have a pro license, there ...item list should display more fields
when looking through item list, it would be nice if more fields were
available to see. If I am trying to find a specific item I don't always know
what the lookup code is for a size or color. I would like the option to
choose which fields are available for me to look at (like on a report) so I
can more quickly find items in the list.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
lin...attachments won't attach
Since I downloaded SP2, attachments show up as an icon in
the body of the email, not below the subject line. When
the mail is received there is no attachment.
...Document ID Field Locked
I'm trying to use VBA to unlock the DocumentID field (TypeID on the Sales
Transaction Entry window). Initially when entering a new order it is unlocked
but when you navigate off this field it locks and cannot be changed. The
people who installed GP are no longer here so I'm not sure if this is a
customization or if all GP installations work this way. In any case, I'd
like to unlock this field completely so that users can change the Type ID at
any time in case they put in the wrong one. No matter what VB code I use and
what event, the field stays locked after tabbing off...How send email inline (not as attachment) from Word 2007?
In Word 2003, when I have a document open I can click File | Send To |
and then choose Mail Recipient to have Word open Outlook and email the
document as text inside the message, not as an attachment.
However, in Word 2007 when I click on the MS Office button and choose
Send, that option sends it as an attachment. There doesn't seem to be
an option to send it inline.
Any thoughts? Thanks.
Add the "Send to Mail Recipient" item to the Quick Access Toolbar. You will
find it in the All Commands group.
Hope this helps.
Please reply to the newsgroup unless y...required fields--the sequel
I already got the answer to my question, thanks to the kindness of Habib
I just have a follow-up question to the topic I created earlier on "requried
If you cannot make a required field "unrequired" even through the use of the
Dexterity code, is that because of a setting (flag) in SQL? I'm just
wondering what mechanism is being used in the system to prevent "unrequiring"
No that is in the application, in Dex code.
From a SQL point of view, Dexterity creates all table fields as not null so
eve...Need to change date in field to whatever I want
I have a database for my research. I need to change the date, so that I do
not have any restraints on my admissions. I have checked the data field for
date of admission and it looks exactly the same in the data field, but for
some reason, the date will not allow me to move forward with 2010. I am not
sure what to do. Can you please help. This seems to be the only field that
does not change to what I need it to change to. I currently am able to use
the date for 2010. in other date fields except for one field. Please any
suggestions. I am very new in setting or using access.
Can Outlook 2002 search for keywords in email attachments?
On 10/21/2003 4:58 PM, Partha Mandayam wrote:
> Can Outlook 2002 search for keywords in email attachments?
-( Alex Yu | Systms Admintr | Multmd Devlpr | AEM | RPI | MSFT MVP )-
...Workbook minimizes when sending as attachment using Outlook Expres
When I send a workbook as an attachment, using Outlook express, the Excel
document minimizes instead of staying open. How do I stop this so the
document will stay maximized?
...Stopping emails with .exe attachments?
Running Ex2003 on 2003 Server in a 2000 Domain.
Is there anyway to stop emails with certain kinds of
attachments (example .exe )?
Nothing native will do this; there's attachment blocking in Outlook, but you
shouldn't wait til mail gets to the client to handle this. The best way to
deal with it would be to get Exchange antivirus software, which you should
be running anyway...it can do this and more. Trend ScanMail or Sybari
Antigen would be good to look at as they're probably the best out there. You
can get a free 30 day eval of Scanmail from the Trend site.
For a list of attach...deleting a fields content
I have a situation in which a user will need to delete only the content of
one field for a record. For each record in the table there is a column
(field) called IsChildOf. On the webpage there will be a button that will
delete only the content (a number) of the field IsChildOf for the record.
So, if record ID 449945 has 25 in the IsChildOf and the person uses the
delete button, the 25 is deleted.
How is the DELETE statement constructed for something like that (I'm a noob
> On the webpage there will be a button that will
> delete onl...Hotmail OL attachment uploads
Since upgrading from OL XP to OL 2003, everytime I send an email from OL
with an attachment of any size or type, it seems to fail with an error
below. However, when i check the sent items folder, there are multiple
copies of the sent email therefore spamming the recipient's mailbox
unknowingly I think.
At the same time, trying to stop the file from sending from the outbox, I
can't delete the file when it is not sending until I access offline mode. I
now have to use the web based version to send attachments.
Need to stop this problem.
Task 'Hotmail - Sending' reported ...Outlook Express removing access to attached email files
I requested a file from DayTimer, a reputable online
site. They sent me an email with the file attached. I am
sure this file is fine (no viruses etc.). When I clicked
on the paper clip to download the attachment, I got this
message: "OE removed access to the following unsafe
attachments in your mail: top10faq.htm" This actually
happened with three separate emails from DayTimer, with
three separate attachments. How can I gain access to
these attachments? I am sure these attachments are virus-
This newsgroup is for support of Outlook 97, ...Allow searching of date fields to allow wildcard characters
For fields such as birthdays and expiry dates, customers often want to search
the database for a list of contacts with birthdays. It would be great if you
would allow wildcards in date field searches so that we could search for all
birthdays that occur in a specific month. The year is not always relevant
when performing date searches. Birthdays is a common search performed by
customers in the financial sector as well as other industries. Currently, we
have to add an additional text field to facilitate this type of search. It
adds confusion to the users, in some cases double data entry...cut and paste limitations for TO Field
I use Outlook 2002 and an Exchange 2000 server. The
clients in question have workstations ranging from Windows
SE to XP. We have a program that puts email addresses
into the clipboard. when I paste to Outlook 2002, I only
get about 1400 of the 4800 email addresses. However, if I
paste the email addresses to OWA all 4800 addresses are
listed. If I paste to Excel I get about 1400 email
addresses. If I export from the application and import
into a folder in Outlook I get all addresses.
Is there a limitation in Outlook from pasting so many
email addresses in the TO or BCC fields? ...MS Access 2007: Calculated field based on subform:
As part of a review assignment, I have been tasked with adding a calculated
field to a form that will count the number of items listed in the associated
subform. The subform is based on the table "tblProduct", and is a subform
named "frmProductSubform". The Parent table is named "tblCompany".
The tables are related by ProductID, and CustomerID fields. The fields
included in the subform are: ProductID, ProductType, Price, and Unit.
I am trying to create a calculated field based on the subform that will
count the number of line items in th...Check if field is empty (what code to use)
In a form's BeforeUpdate I check if certain fields are empty, and if that's
the case I cancel the BeforeUpdate. I always use this kind of code for that:
If IsNull([Surname] or Surname = "" then
However, I noticed that others use other ways for checking this:
If Len(Nz([Surname],"")) = 0 Then
If Len(Trim([Surname] & "")) = 0 then
If RTrim([Surname].Text) = Nothing Then
If Nz([SurName],"") = "" Then
I'm wondering what I can use best in this case.
Also I'm wondering, why do you have to check for a ""...Reading emails from distribution group and extract attachment
We are using Exchange 2003 as part of sbs 2003 premium.
We have a distribution group abc which receives emails firstname.lastname@example.org. How
can I retrieve emails from this distribution group and extract any PDF
attachments that may be present using vb.net or another .net language?
On Thu, 29 Apr 2010 17:14:25 +0100, "John" <email@example.com>
>We are using Exchange 2003 as part of sbs 2003 premium.
>We have a distribution group abc which receives emails firstname.lastname@example.org. How
>can I retrieve ...help with summing fields in repot
I have a field called ponts assigned in a report. It uses an if statement to
assign points based on which class my students are attending.
I want to sum the total points accrued for each student. In the detail section
I made sure I named the if statement field pointsassigned and then I entered
a text box with =sum([pointsassigned])
when I run the report, It doesn't recognize pointsassigned. I checked
I even tried =abs(sum([pointsassigned]))
it doesn't recognize the name I assigned. Any thoughts on what I am doing
I appreciate any help
Thank...clearing field "Bank Balance"
Is there any way to clear the field "Bank Balance" since I no longer use on
line updates, this field has no meaning and is a pain! HELP!!! Thanks
In Account List? No. But you can make the column width near zero.
"Joe F" <JoeF@discussions.microsoft.com> wrote in message
> Is there any way to clear the field "Bank Balance" since I no longer use
> line updates, this field has no meaning and is a pain! HELP!!! Thanks
In microsoft.public.money, Joe F wrote:
>Is there ...OneNote 2007 Attachments from Outlook
Is there any way to have the attachements of an email sent from Outlook to
actually be attached to the notebook you file the note in once received?
I have THOUSANDS of attachments to emails filed, and all the actual files
are in the "Temp" subdirectory, and don't move when the page is moved from
the "Unfiled Notes" section.
Certainly makes synchronizing notebooks a problem.
...Field names from SOP10100 table
While troubleshoot a problem for a customer, we found these field names from
SOP10100 table 'TXENGCLD', 'BCKTXAMT', and 'OBTXAMT'. Is there a way to find
out what are these fields for?
For future reference, is there a way to find out what each abbr. field from
GP table mean?
Any helps would be greatly appreciated. Thanks a lot in advance!
Here is what they stand for...
Tax Engine Called
Backout Tax Amount
Originating Backout Tax Amount
This information is available in the resources descriptions. double click
on the table when you find it and...Formatting Mandatory Field in whole CRM
In MS CRM 3.0 all mandatory fields have a descripion bolded and in red in MS
CRM 4.0 we have a small red plus. Do you know how change it globally (i dont
want to do this via onLoad script) in whole CRM. Client want to have the same
formatting for mandatory field like in version 3.
The red bolding in CRM3.0 was accomplished through Cascading Style
Sheets in the CRMWeb folder where the class "req" was defined to bold
and color the text. You can see an example of this in Form.css for
the TD.req tag.