Message in SOE entry form
I have an order that when I try and edit in Sales Transaction Entry it's
giving me the message "This Document has been posted" and will not let me do
anything with the order.
Go to CustomerSource and run the Automated Solution to fix this error. Scroll
down to Sales Order Processing and run the link corresponding to SOP Already
Been Posted Error.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusin...Views using linked tables
On my own sqlDB, I need to link tables form other sqlDB in the same machine
and then, create views that combine fields of my own tables and linked
tables. Please give some suggestions.
LAM (luism0@(arroba)yahoo.es) writes:
> On my own sqlDB, I need to link tables form other sqlDB in the same
> machine and then, create views that combine fields of my own tables and
> linked tables. Please give some suggestions.
CREATE VIEW myview AS
JOIN otherdb.dbo.othertable ON
That is, you refer to the tables in...File Won't Open
Hi, I accidentally opened an xls file in Word, saved it with the Save
command and now can't open it in Excel. Help please!
Roadrunner's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27140
View this thread: http://www.excelforum.com/showthread.php?threadid=466566
It's gone, you might be able to open it in word and get some text info out
of it but essentially it's gone :(
(No private emails please)
"Roadrunner" <Roadr...Pivot table 11-20-09
Can I use the same value from data range in the pivot table part from using
the count and average etc?
If yes how?
Yes. Just drag the button of interest onto the data area again, as many times as needed, and set
that instance to the desired value (count, average, max, min)
MS Excel MVP
"Vinit" <Vinit@discussions.microsoft.com> wrote in message
> Can I use the same value from data range in the pivot table part from usin...A little help with access forms.
I am in the process of converting an Access 2002 db to use SQL Server 2000
as the backend. I have found a bug that is giving me fits. I know it is
because of my own ignorance as to how Access forms work.
I have a form that pulls from a local query that joins two tables. I have a
second form that opens when a button is pushed on the first form. The second
form updates one of the tables called from the first form. After the update
and I close the second form, the first form is unchanged. Even if I refresh
the record or scroll to another one, the record appears to be unchanged. If
I close the md...forms and contacts
Have designed a task page to suit my needs. I would like
to be able to add contact's details into that form so I
don't have to retype the phone numbers etc on each new
task. Have tried adding the contact field from the drop
down field chooser while designing the form but can't get
it to work.
...MSCRMDeletionService Error: Deletion Service failed to clean up table=CleanupInactiveWorkflowAssembliesProcedure
Every morning we have following 3 Error-Messages in the Eventlog
(Application-Log) of the CRM Server.
On this installation we tested the import of address-Data several times.
Accounts and Contacts with deletionstateCode = 2 are not physically removed
from the database.
Can anybody give me a hint, how to solve this problem?
Can the timeout be increased?
1st Error Message:
Event Type: Error
Event Source: MSCRMDeletionService
Event Category: None
Event ID: 16387
Error: Deletion Service failed to clean ...How do I open an Excel worksheet in a new window?
How do I open an Excel worksheet in a new window?
Start your opening process all over. Don't go through the excel you alread
have open. go back to your desktop and open a new excel and then open your
workbook through there.
> How do I open an Excel worksheet in a new window?
Do you have a need for something other than >File >New >Blank workbook ?
Perhaps Tools>Options>View "Windows in Taskbar" is what you/re looking for.
Gord Dibben Excel MVP
On Wed, 30 Mar 2005 15:05:05 -0800, "Ymotana"
<Ymotana@discussions.mic...Opening shared notebook on SharePoint opens temp directory in brow
If I go to a SharePoint site and click on the link for a shared OneNote
notebook we find that the temp directory gets displayed in OneNote (100s
files!). This seems to only happen on our Windows 7 PCs (all are x64) and if
we use Firefox or Chrome - IE works fine.
Does anyone have a similar environment without the problem or know of a
...Q: pivot table
Is there any way I can add one more column that calculate average of first
and second column in the pivot table? (Average column is not available in the
source sheet, and I can not change it)
...How to put a table in Slide Layout so it can be applied to a page?
I am working with Slide Masters and Layouts for the first time. I'm doing OK
with making them and applying them to pages. But when I make a table it
doesn't work. When I go to Insert>Layout Placeholder> Table, then I get a box
that has the word "Table" in it. Is that right? When I look for controls to
make it look like a table with headers, cells etc., right-click on it,
whatever, I don't see any table controls, just the usual text/box attributes
(size etc.). So in the ribbon I go to Table Styles and click on one of them
(Light #5) and then I have a no...Animated buttons
Is there a way to make a nimated button on excel activate a macro
Message posted from http://www.ExcelForum.com
...Archiving single sheets form workbook
Can I have only one sheet auto archive?
I have a workbook that has multiple pages. Periodically this workbook
main page updates. Subsequently, all the other sheets update. The use
will select certain sheets to print, archive and send to clients. I
there a way to auto archive these sheets only when they are accesse
via a hyperlink?
Below is a sample I have used for workbooks created that only have on
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$q$2" Then
ActiveW...Button to update a field
Can someone point me in the direction of a tutorial to do the following
I have a continuous form that allows me to choose the supplier for a product
product name | supplier 1 | supplier 2 | supplier 3 | supplier 4 | supplier
text box button button button button
There can only be one supplier, all updates will be done to the item
Currently I can do this with a combo box, but would prefer to do with with a
The standard way to select one item among many is a combo box not buttons...Outlook 2003 attachement not opened
I've just installed Outlook 2003 and I have this problem: a friend sent =
me an e-mail containing an attached e-mail message (signed, if it =
matters), and Outlook wouldn't open it saying "An error occured in the =
underlying security system".
How can I open that file? Note that that file has a ZIP file attached, =
so this could be the problem.
Thanks in advance,
...Help using Tables
I need some help. I have a table that has a percentage range. Like this.
Less than 90%
101...How To Add Rows and Cells in The Table Using IHTMLTable
I am currently working on the DHTML Dialog Based Application. I have been
stucked due to a problem, which is that my HTML Page contains a HTML Table
element and a button, i want my application to add rows and cells on the
click event of that button. I have captured the event of the button but i am
unable to add rows and cells in the table. Can anyone tell me how to acheive
that by using the IHTMLTable interface.
Thanks in advance.
"Ghazanfar Ali" <firstname.lastname@example.org> wrote in message
news:uMq8CiCjFHA.1416@TK2MSFTNGP09.phx.gb...league table #4
Sorry peeps email is email@example.com
...Help needed with form problem
Workbook contains several forms of varying style
and function. One form shows the results of 10
recent tests in a countdown fashion, showing just
the results of one test, followed by a one-second
delay, followed by just the results of the second
test, and so on until the result of each of the
10 tests has been shown. Then the program
proceeds on to the next step by calling up a
different form. The problem . . .
Sometimes when the program starts running one or
two of the forms are blanked out ("white" with just
the top header showing). The forms continue to
function within the ...Automatic opening
Please could someone advise how to stop the mail opening for a moment,before
This seems to imply especialy on spam that I have read the message.
The fact that Outlook shows the msg as being read has no connection with the
sender, unless you send a read receipt
"DEACON SCREWS" <firstname.lastname@example.org> wrote in message
> Please could someone advise how to stop the mail opening for a
> moment,before I delete.
> This seems to imply especialy on spam that ...Voting Buttons -- Missing drop-down box in Tracking tab
I have a user on Office 2003 who uses voting buttons in Outlook.
She claims that on the Tracking tab of her sent message, a drop-down box
should appear at the right side of each user's "response" column showing the
voting options -- for her to manually populate if the respondent verbally
replies to her.
Our outlook 2003 does not have this. I can find nothing on it. What is she
talking about, and how can I set up this feature for her?
I think she's wrong. That function exists in a Meeting's Tracking table,
not a vote related tracking table from an em...Hide toolbars when file opens
I have created a file for people to use to get quotes. When the file
opens, I do not want them to have access to any toolbars. How can I
hide these when the file is opened, but only for this file - not any
others that the user may subsequently open. All that they may need to
do, is print the page out after getting a quote.
You can use this in the Thisworkbook module Rob
Private Sub Workbook_Activate()
Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = False
Private Sub Workbook_Deactivate()
Dim bar As C...Permanently open Group Schedule
Is there any way I can configure things such that a Group Schedule is
permanently open, i.e. when I exit and restart Outlook?
Not that I know of in any version of Outlook that supports group =
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Chris Mitchell asked:
| Is there any way I can configure things such that a Group Schedule is
| permanently open, i.e. when I exit and restart Outlook?
...Substitute button is greyed out on line item in assembly transacti
I know how this is supposed to work and have used it before however when I am
on a line item even though on the inventory card shows this item has two
substitute, the substitute button is greyed out.
forgot to put the notify on
> I know how this is supposed to work and have used it before however when I am
> on a line item even though on the inventory card shows this item has two
> substitute, the substitute button is greyed out.
> Any ideas?
You are correct in that there must be at leas...excel opens up looking like it is in ms dos
how can I get my excell to stop opening up looking like it is in MS-DOS mode.
I get an error message that wants to send the info to microsoft, when it hit
yes send or no don't send it then shuts down.
what exact error message do you get and does this happen all the time for
> how can I get my excell to stop opening up looking like it is in
> MS-DOS mode. I get an error message that wants to send the info to
> microsoft, when it hit yes send or no don't send it then shuts down.
Sounds like you...