Reply:

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
Hello, 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. thanks. ...

Attaching activities to leads
Hello everyone! I would like to asign one task activity to 600 leads. I have created the task activity already and it is in open status. I have loaded my 600 leads already and they are in open status. Does anyone know how to do it? Thanks so much. Gus, 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
Hi, 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
Hello: I already got the answer to my question, thanks to the kindness of Habib Salim! I just have a follow-up question to the topic I created earlier on "requried fields". 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" a field. Thanks! childofthe1980s 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. ...

search attachments
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? No. Alex -- -( 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 to sql)? Thanks. John John > 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- free. Tools->options->security. 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:
Hello: 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
Hi We are using Exchange 2003 as part of sbs 2003 premium. We have a distribution group abc which receives emails abc@mydomian.com. 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? Many Thanks Regards On Thu, 29 Apr 2010 17:14:25 +0100, "John" <info@nospam.infovis.co.uk> wrote: >Hi > >We are using Exchange 2003 as part of sbs 2003 premium. > >We have a distribution group abc which receives emails abc@mydomian.com. 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 spelling etc. I even tried =abs(sum([pointsassigned])) it doesn't recognize the name I assigned. Any thoughts on what I am doing wrong ? 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 news:C5C90FEC-3822-4E1E-90D5-93A48C0C7044@microsoft.com... > 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 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
Hello, 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! Hi Nikki, 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. ...