I have a customer who is trying to remove an Analysis Group ID from a GL
account by setting the Analysis type to 'NONE'.
They get a message that says the Group is used on an unposted transaction,
You cannot change its type to None.
When I check through an inquiry Enquiry >> Financials >> Analysis and
uncheck the 'Open' & 'History' boxes and hit redisplay - there are a couple
of old documents (from 2004) that appear. When I try to drill back on
document number, message re 'Cannot zoom to transaction - hasn't been saved'.
Is there any way ...Passing values in Sheet to VBA
I'm trying to pass the .MinimumScale value from a range on my spreadsheet to
a chart which is created when the Macro is run from the spreadsheet.
The macro is halted by an error message 'Run-time error '1004': Unable to
set the MinimumScale property of the Axis class'.
When I 'Debug' and F8/Step-into the code however, it sets the value as I'd
intended and completes the rest of the code without any problems - In fact
running the code using the 'Step Into' function all the way completes the
program without any hitches.
Please could somebody tell m...Batch ID
How do I modify a financial trial balance report to show the batch id?
You could use report writer to have this included.
1. Print your trial baalnce to the screen.
2. Click modify button at the top.
3. seelct Year to date transaction under the toolbox.
4. drag the "Originating trx source" to the body (B).
5. Click File (at top left) then slect Dynamics GP. Save the changes.
6. grant permission to use the modified trial balance.
7. Print the report and have it tested.
Best Rega...Limiting Picklist Values
Hopefully a quick question: I've been asked if it's possible to limit
the picklist values that a user can see. Specifically, so that AP can
only see (select) one checkbook. I don't need to work with GP much and
have been unable to find a solution. Any ideas?
Does anyone know if it is possible to have a column without an identifying
letter; in other words, A,B, blank C,D....?
It is purely for cosmetics (on screen) that I would like to have a white
seperating column between two sets of data with coloured infills without
showing the alphabetical ID.
You can separate your columns by setting a larger column width.
"Ed O'Brien" <email@example.com> a �crit dans le message
> Does anyone know if it is possible to have a column ...Setting Combobox Values
I have come across a strange error.
I have a userform set up with 5 comboboxes. Each box has its item
populated when you load the form based on the contents of a range on
worksheet. I use the following code to update the combobox (ctl is th
combobox to be populated):
Dim i As Integer 'loop counter
With Worksheets("Reviewer Data")
For i = 1 To ArrayMethods.Size(fileList) - 1
ctl.AddItem .Cells(fileList(i), 2).Value & " - "
Once the form is loaded, a second function sets the ...Update values on large amount of records
I need to change a value on 16000 leads.
How can I do it without run a workflow rule form a View ?
(A view can show at maximum 100 records, so I would need to run the rule 160
I would try running an update directly from Query Analyzer on the LeadBase
table. This is assuming the that new values is something easy to set. If
you need to do something more advanced (like changing the owner or another
GUID field), then this still might work, but I would recommend testing
"Sebastiano Castrini" <[remove this]firstname.lastname@example.org>...No CRM user exists with specified domain name and user id (CRM 4.0
I am getting the above message when i attempt to connect to my CRM server
from a users PC.
The Outlook client was installed, he got into CRM fine one day then the next
day he went to expand the folder in Outlook for CRM and was prompted for a
user name and password to access the server. He entered the administrator
account and was denied access. Ever since i cannot get into CRM from his PC
as him. I can logon fine as him via the web version from another PC but
cannot get into either the web version or outlook client version from his PC.
I have removed CRM for Outlook, got rid of r...ID and password for MS Outlook 2002
My mailbox is on an exchange server, but our IT
service is contracted offsite and is hard to get in touch
with. Do you know how to setup an Outlook ID/password for
a user on an exchange server?
...list missing values in a sequence
I've got a list of data with some values missing. Is there a way that I can
leave the data unaltered, while listing which values are missing from each
So if my data looks like this:
<header> <data 1> <data 2<
1 .5 .6
4 .6 .2
my list will have
data 1 data 2
Any help would be greatly appreciated.
Copy the data e...Check column header value
I would like to verify the value of certain column header. How does the
code looks like?
check, if column J = "Product_Name", do A, else stop.
if column AC = "Price", do A, else stop.
Just want add that they are all on row 1.
This checks each field and will "run" the "do A" twice if both are found.
if lcase(.range("j1").value) = lcase("Product_Name") then
msgbox "do A"
if lcase(.range("ac1").val...Hide Cells with Zero Value in Excel 2007 while using line chart ty
I am using Excel 2007 and have a situation with the charting functionality.
For example - I am trying to set up automatic update chart update for Jan 08
– Dec 08 data i.e. user just enters data each month and the graph trend shows
up each month. I have done this a lot of times but seem to have a unique
situation with excel 07 this time when I am using the line chart type to show
The date cells that have some kind of formulas used i.e. if function or
Iserror function etc. I tried to test the chart by entering data for January
it works fine with bar graph only displ...Cell Value Override
I would like to know if there is a way to change the value of a cell by
clicking on it. say for example, I have three boxes: one box has "Y",
another has "N" and yet another has "NA". the goal is to click on one of the
boxes and have the value replaced with an "X". Thanks.
...Naming Site ID's
How would someone go about assigning a name to Site ID's that show up on PO's
for "Ship To".
The issue is, when you go to Cards>>Inventory>>Site you can input the site
id, and address information, but not the friendly name of the site itself.
This is important because as we select a site ID for shipping to, for a
specific line item on a PO, it will only show the address and not the name...
Furthermore, if you go to the item detail screen, you will notice that the
Site ID is locked in, in the lower right side, and if you expand the detail
of the site, it is...format merged value in word
In older versions of word & excel, a value formated in Excel would hold its
format into word through a merge. I need to merge a percent 1 decimal place,
but the resulting merge prints to 10 decimals. Help says to format the value
in Wrod, but I can only format words, not values. Any help?
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Word
Dr. Pete wrote:
> In older versions of word & excel, a value formated in Excel would hold its
&g...why is this class abstract?!
i have looked all over this class and cant figure out why its abstract.
below are the header files for it. the first one is a regular class called
CCeFileFilterSite, which is derived from an interface called
ICeFileFilterSite (it's header file is below the CCeFileFilterSite header
file) which is derrived from IUnknown. i've been looking at this code for
days and cant figure out why CCeFileFilterSite is abstract.
thanks for any help you can give me,
CCeFileFilterSite header file:
class CCeFileFilterSite : public ICeFileF...Change default value of From: field
Is there a registry hack or something similar that can make my default
'from' address something other than my primary address? I can easily type
the alternate address in for every email but that's a huge pain.
Any help is much appreciated.
What type of email account? If IMAP or POP3, no hack needed - change it on
the Account settings dialog.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
mailto:email@example.com...2003 Minimum rights to create an id and restrict access to Mailbox Rights
I have been trying to determine the absolute minimum rights required to
allow specified users to create new accounts and mailboxes but not have
the permissions to be able to then grant themselves access to that
My testing was done using a test account within a single OU. The test
account was only given the "right" to create and delete users within
that particular OU object (and any child objects) using the Advanced
permissions page of that OU. It was also given the following special
permissions to "User Objects" (again within that OU's advanced
O...Money 05 markel Total portfolio market value
I seems a simple request - but is there any way to maintain a history of
total portfolio market value and plot it on a graph report?
I'd certainly like to see that (and I'd imagine most investors would like it
as well) - but it does not appear in the list Standard Investment reports.
Or do I have to jot it down each day and enter into an Excel spreadsheet?
Many TIA - JohnS
From John Saxon
In fine Springtime Canberra
You can do it on a monthly basis using the Net Worth over Time report. If
you want it down to ind...Not existing value
I want ask you that ...
I have a list box in a form and my question is that, how to cancel the new
value of the list box when the user gives a value which does’t exists in the
Thankig you in advance for your collaboration
>I have a list box in a form and my question is that, how to cancel the new
>value of the list box when the user gives a value which does�t exists in the
In a list box, users can not enter a value.
Sounds like you mean a combo box, in whiich case you can
just set the combo box's LimitToList property to Ye...ID Card
We just got Publisher 2003. I am the membership chair of a professional
organizaton, and one of the things we want to create is a membership ID card.
Are there any templates or suggestions ?
I use business cards but allow for cutting off �" of one end in order that
they fit in wallet pockets if they are laminated.
"cliffordjf" <firstname.lastname@example.org> wrote in message
> We just got Publisher 2003. I am the membership chair of a professional
> organiz...DCOM event ID 10009 errors
I'm getting lots of
DCOM was unable to communicate with the computer
computer.DOMAIN.local using any of the configured protocols
on a swinged SBS 2008 box. Checking the GUID of the DCOM points to
oleres.dll. This happens on other SBS 2008 servers as well accompanied
by some Kerberos errors saying
The Kerberos client received a KRB_AP_ERR_MODIFIED error from the
server vista$. The target name used was RPCSS/computer.DOMAIN.local.
This indicates that the target server failed to decrypt the ticket
provided by the client. This can occur when the target server
principal name (SP...Pass value to combo box
I have an unbound text box (txtSaveVal), an unbound combo box
(cboName), and a string variable strSaveVal.
me.txtSaveVal=strSaveVal .............. Works fine
me.cboName=strSaveVal ............... Does Not Work
I simply want to put the value of strSaveVal into the combo box, as
though I had typed it in, BEFORE pressing the enter key.
Why isn't this working?
Why are you doing this?
A combo box is not intended to accept a value from another control,
but provide a means to select a value from a list of values either from a
a query, or a manually ...Creating new P&ID master symbols
I would like to create a new master P&ID valve symbol and add it to the
Valves and Fittings stencil. I want to duplicate the tags and properties of
exisisting valves so that it functions like the other valves in the stencil
(auto-numbers, same data fields, etc.). Is there a way to copy all the
information (not just the shape properties) from one valve and apply it to
the new one?
Use the Shape Conversion command from the Process Engineering menu to do
this. Here are the steps:
1) Drag an existing valve onto the page so that there is at least one valve
in the document.
2) If your ...How to abstract a number from a string?
I'm trying abstract second number from a cell.
If cell a1=1234, how do I abstract 2 using a function?
I will need to use 2 for some math calculation.
I tried this but it don't work.
Function test(num As String)
test = num.char(1)
Thank for assisting.
Function test(num As String) as long
test = mid(num,2,1)
(with no validity checks at all!)
Danny Hoon wrote:
> Hi all,
> I'm trying abstract second number from a cell.
> If cell a1=1234, how do I abstract 2 using a function?
> I will need to use 2 for...