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.
...Product Key Query #2
I have a mac office 2004 product with 3 product keys. What has
happened is that i installed it, it read the product key and then
nothing happened... so I wasted a whole product key. Can i get help
so I can re-use it and also help with the installation. I have a
macbook - white - 2.00GHz
On 30/1/07 07:28, in article
"email@example.com" <firstname.lastname@example.org> wrote:
> I have a mac office 2004 product with 3 product keys. What has
> happened is that i installed it, it read the product key and ...Custom LDAP/OPATH query to create custom address list?
I'm going to ask this again because it seems to be a big problem going
to exchange 2007. How does one create a custom LDAP query to an
external server to build a custom address list? It would be nice to
be able to create custom address lists built on LDAP queries to Active
Directory or OpenLDAP, etc.
Can this be done?
Only recipients in Active Directory can appear in Address Lists.
You would have to import external recipients into AD as Contacts to be able
to do this.
MVP - Exchange
NEW blog location:
------------------------...query timing out. how do you stop this from happening?
What can be done to keep a querie from constantly timing out? Almost all my
queries and functions are doing this lately as my database grows. Any advice
on this is very much welcome.
Message posted via AccessMonster.com
...Off topic: VB6 question
sorry this is way off topic.
using _vb6_: i'm trying to add/replace nodes to an xml document via
xml = "<item>floogle</item>"
set newNode = oDom.createTextNode(xml)
call dDom.replaceChild( newNode, bloogleNode)
It works ok. But I can no longer find the new node in the document via an
xpath query. When I save the doc to disk I can see the new node but its been
escaped, presumably because it was a text node:
I guess my question is: H...Different Type of Picture in a Document
I have received a document that i have to work on that was compiled by
various folks and I have no idea who did what.
When I select pictures within the document, I have some pictures with
the usual single border; circles at the corners, and squares at the
I have other pictures, that when selected, have a double border, that
is turquoise. There are three dots in a row at the sides and three
dots in a triangle at the corner. With this type of picture I cannot
explicitly set the size or other options available with the type
Does anyone know why some pictures would be ...Rules
Can I create a rule that will act on all e-mails a different folder besides
the inbox (a folder that I created), and that will run at a specified time
every day (or at least when I open Outlook)?
Robin <email@example.com> wrote:
> Can I create a rule that will act on all e-mails a different folder
> besides the inbox (a folder that I created), and that will run at a
> specified time every day (or at least when I open Outlook)?
Automatic rules act upon the Inbox only.
...SO/HQ Store Numbers Different
I know this is bad, and I know how bad, but, I need some help here.
1. Location X has a local store Id of 3.
2. HQ Manager lists Location X with a store ID of 102. HQ Mgr already has a
store Id 3 associated with a different location.
3. I need to change Location X's store Id to 102.
4. I will be made crazy by the end of the weekend with this one. :-)
Thank you for any thoughts and ideas.
I don't completely understand your problem without looking at your data, but
reading both your post and the KB, you may only wan...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...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...adding new columns sheet with external data
I have a excel sheet that I import data from a external database and then i
added columns to the sheet that have entries made by me. When the data
refreshes if the data is no longer coming from the external it leaves the
data that i entered still there. I want it to delete the whole row and leave
no data at all external or internal for that line that now does not exist can
this be done?
...Upgrade AD when adding 2008 Server to Domain
We have added a new Windows 2008 Server (which will be a Terminal Server) to
our Windows 2003 AD Domain. Do we need to update the AD Schema? Our AD Policy
acts weird on the new server. Sometimes printers do not show up, then the run
command is enabled, then at times the task manager is enabled. We try and
lock down all of our TS Servers.
Thank you for your assistance.
> We have added a new Windows 2008 Server (which will be a Terminal Server) to
> our Windows 2003 AD Domain. Do we need to update the AD Schema? Our AD Policy
> acts weird on...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.
...AD connector and directory replication question
We're running Exchange 5.5 and have an external site running Exchange
2000 pushing and pulling GAL information to our site using their AD
connector. We want to be able to send Outlook meeting invitations to
each other and understand that in order to do this must allow the
messages to be sent in Rich Text. My question is that is there a way
to have the external site push their address list to us, and have the
"Allow Rich Text in messages" option checked by default? (seems that
when we receive their address list the users are imported as custom
recipients without this item checke...IF two different conditions are met #3
The array isn't working eithe
AnnaV's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=961
View this thread: http://www.excelforum.com/showthread.php?threadid=27065
Have you tried Jason's suggestion?
"AnnaV" <AnnaV.firstname.lastname@example.org> wrote in message
> The array isn't working either
> -----------------------------------------------------------------...Compiled ocx file reports different sizes
When I use MSVC 6.0 ide to compile my active x component , the size
reported is 412KB
But when I comple the same fromcommand line, the size reported is 408KB
Am I loosing something here
Does IDE add somethings...
Likely you are simply using different compile options. Variations in optimization, byte alignment,
debug info, etc. can all yield different sized modules.
"sandSpider" <email@example.com> wrote in message
> When I use MSVC 6.0 ide to compile my activ...Running Sum Query
> Q.1: I have table "HMADetail" That has fields as
> Date Lot# SubLot# HMAPlacedToDay HMAPlacedToDate .......
> (1) (2) (3) (4) (5)
> I Have not created Query table from this table but created report with
> fields (4) and (5) same. I set property for Field (5) with Running Sum
> Overall. This report works good. But it writes all records from begining date
> to end date. I need The end date records only. How do I get this without query table?
> Q2: If I have to creat ...Help with expression builder in a select Query
I am a beginer of Access. I have a database that consists of 4
columns/fields of dates. These dates/fields can be filled or can be blank.
I call them A, B, C, D.
Now I want to make a query or report to retrieve the date data in the
column/field of A. The criteria for this: all the dates in field A must be
later /larger than those in field B or C or D if B or C or D contains any
I queried the A,B,C,D from the table that contains these fields. The first
criteria I wrote is "A is not Null". But then I want to say if B or C or D
is not blank, A must be ...Adding plain text to a database?
I have some instructions (about 2-3 paragraphs) that need to accompany one of
Rather than sending them separately where they might get lost, how could I
include them within the database file?
Why not simply create a form and enter the text there. then you can add a
button so the user can access the info when they need it.
Hope this helps,
> I have some instructions (about 2-3 paragraphs) that need to accompany one of
> my databases.
> Rather than sending them separately where they might get lost, how co...Adding a number to a spreadsheet
I am trying to create raffle tickets in Excel, and I need to have a ticket number on the bottom of each ticket (starting with 001). Is there any way I can make the program automatically add the numbers, or will I have to do it manually? There will be five, two-inch high tickets on each page, and each ticket will have two halves. The number will have to appear on each half of the tickets.
You have given little info as to how you want to achieve this and my method
may want you to go out and buy them!!
1) Type a 1 in A1 and a 2 in A2. Highlight both cells
2) Grab the 'fill handl...adding lines to added data
I have added data to an existing worksheet but when
printed the row lines and column border lines do not
show. How do I add the lines to the added border to
match the existing lines?
...Using MDIChildFrame for different views of document
I have two separate questions:
How do I use my MDIChildFrame derived class in an MDI application to
show different views of the same document? This is what I want:
1. When the document is initially opened, it will be opened in a
MDIChildFrame-derived window with the "default" view.
2. In response to certain commands/menus, another child window should
open and show another view of the same document. There may be more
than one view.
How do I do this?
Due to the application having many views and the corresponding GUI
classes, the appli...Can I change the Excel Queries Developed From Reporting Tools
I have created the Excel iqy queries from the third party
reporting tools and during the process there is an option
either to pass the User Login id and Pass word as a
parameter or not. We have developed some queries using
generic id so that the users do not have to pass the Login
id and password and now we want to change that. Is there a
way to modify that excelquery.iqy file without redoing
can i see the sql script of that "iqy" file.
can i modify that?
Please let me know.
Thanks in advance!!!!