how do i display only formula in an excel spreadsheet?
do you want to display the formula text?
"johan" <email@example.com> schrieb im Newsbeitrag
> how do i display only formula in an excel spreadsheet?
Ctrl + ` (grave accent) will toggle between formula and non formula view
you can also go to tools>options>view andf check formulas
> how do i display only formula in an excel spreadsheet?
...Sales Transactions Entry Error
When logon to Great Plains, click on Transactions, click on Sales,
click on Sales Transactions Entry, click on Lookup next to Document No,
double click on one of the Sales Document Numbers. We got an error
Unhandled script exception:
Value of range.
We are using GP 9.0 with SP1 and Nolan 9.00.3e. Thanks.
...search button - msgbox on error
I have a search button that prompts for info, then opens a form based on
criteria entered. If there are no records to be found based on that
criteria, I want the form to NOT open, and a msgbox to display instead. I
would prefer that I do this as a macro vs. vba since I'm not familiar with
vba just yet...if possible.
Also, I am not getting email notifications of replies, even after I choose
'Notify me of replies'... can I have replies sent directly to my email or do
I have to go through here? If you can email me directly...
I finally received 2.0 to test and was trying to figure out some of the
-any ideas on how to create a matrix dimension set that will put the sizes
in the right order when adding them to PO (s, m, l) instead of l,m,s?
-in the pre-release webinars they mentioned that you will have the ability
to select a grid matrix PO when printing - I don't see that option any idea
how to do that?
I have been waiting for a copy for few weeks now ,
is there any way you can upload a copy of the program to my site ?
"kirk" ...ROUND Function with other function
I have this formula:
and the results shows me for example: +11.6 but what I really want t
show is +12.
I've been trying to put the "Round" function at a few places in th
formula but it doesn't work.
The closest I got was with this formula:
where it showed me 12, without the "+" sign before....
Can anyone help me ?
Outapin's Profile: http://www.excelforum.com/member...Returning a range from an inner function
I have a range of data, which has had the DOLLAR() function performed on it.
I would like to get the total of this range using the SUM() function. doing
SUM(F1:F4) will not work, so I need to convert the data into values that
will work. The VALUE() function is perfect for converting the data into
values that will work for SUM(), but the formula SUM(VALUE(F1:F4)) does not
work because VALUE() will not accept a range as a parameter (and also does
not return a range). I need to perform the VALUE() function on each cell
before submitting it to SUM(). There must be some way to do this,
cons...Query not working for SQL Server
I am trying to convert an Access backend database to SQL Server with an
ODBC connection and linked tables from the Access frontend to the SQL
Server backend. The SQL statements remain Jet SQL. I have a SELECT
statement with a Datediff function that works in Access but
not in SQL Server.
The following works in the existing Access:
It does not work with SQL Server. The problem is with lunchtime. I
tried removing lunchtime from the SQL Server version and that much
SELECT DateDiff(...My Reports don't display data & Built in Reports gives error
I had all my reports working successfully without any problem but recently i
found all my reports on all entities returns no data (empty report) it seems
like the crm database is empty but the DB is working fine without any lose of
data and also the reports .rdl files have no changes and it was returning
data in past !!!
I tried to check on the built in reports like "Account Overview" i found
that all built in reports gives this error
The property ‘nullable’ of report parameter ‘CRM_Locale’ is set to false.
However, the corresponding parameter (default) value is null or contai...outlook express #117
I had to reload outlook express, so I moved all of my
folders to "my Documents". I can't figure out how to put
the folders back into outlook express.
Ron <firstname.lastname@example.org> wrote:
> I had to reload outlook express, so I moved all of my
> folders to "my Documents". I can't figure out how to put
> the folders back into outlook express.
If you ask in an Outlook Express newsgroup you may get an answer.
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the name,...ANN: Database Workbench 4.0.2 released
Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:
" Database Workbench 4.0.2 Pro "
Version 4 introduced full Unicode support, 4.0.2 fixes some issues
found in that initial release, like ODBC connectivity issues, BLOBs
taking too much memory, the ability to specify file encoding when
saving SQL & Scripts and several other errors.
For a full list of fixes in version 4.0.2 and previous versions, see:
Upon a reboot of the NT 4.0 Server, we encountered errors
in the Event Viewer. The errors are for the Service
Control Manager in Exchange. The services will not start
and our client machines cannot access outlook. The first
error is "The DS1410D service failed to start due to the
The system cannot find the file specified."
What would have happened in this reboot to cause this?
Well, the first thing you need to do is figure out what the DS1410D service
is. Its not an MS related service.
MVP - Exchange
http://www.swinc.com/re....NET Runtime 2.0 Error
Never had a problem with this before, so I'm guessing it must be one of the
latest Windows Updates that has done it...
We are using Business Contacts Manager on our SBS2003 server..., and have a
single central shared database...
When I run up Outlook and select Business Tools, Share Database, then add
the new users, by ticking the boxes, it fails...
This is the error reported in the Event Viewer...
Event Type: Information
Event Source: .NET Runtime 2.0 Error Reporting
Event Category: None
Event ID: 5001
I'm trying to use for my first time, a single dimension array to use within
an external sql query.
I build the array from column A. This can be a variable amount, from 2 to 800.
However, I can only use 150 rows at a time in the query.
Below is what I have so far, in building the array. It's just the pulling
out of 150 records at a time, or the remainder to put into the sql query.
I will be building the sql query string as such:
bug_number = (bug1,bug2,bug3) --these are the numbers in the array. (must
have comma's between them)
strQuery_main = "select dis...JustifyString function problem
I'm using the "JustifyString" function (from Stephan Lebans) to right
justify three columns in a ListBox. Two of them are working fine ... one's
a simple number (long integer) and the other's currency. The third causes
an Access 2003 crash!
That third column is a long integer which is a link to the autonumber field
in another table.
Both tables are in the query as I need columns from both tables in the
If I change the JustifyString to reference the autonumber field in the other
table, I still get an Access crash.
I didn't review the Access er...Translating Query formatting
I have a query that is set up to display records ordered by plan date then by
When I use the query in a report, it doesn't appear to sort the records.
Is there a way to make the report format the results the same as the query?
Reports should always be sorted using the Sorting and Grouping dialog in
Report Design. The order in the query often has no effect on the order in the
Microsoft Access MVP
> I have a query that is set up to display records ordered by plan date then by
I am a complete novice at CRM 1.2, but want to be able to create, for
example, a workflow process that will monitor the CSR's and the queues and
automatically assign a new case to the least busy CSR.
Any input would be appreciated.
Thanks in advance
Please tell me what I would have to do and with what tools in order to create
such a workflow process.
> I am a complete novice at CRM 1.2, but want to be able to create, for
> example, a workflow process that will monitor the CSR's and the queues and
> automatically assign a new case to the lea...Maximizing window in outlook express
I used to be able to maximize the window in Outlook
Express until we switched to XP. Does anyone know how to
maximize the window when beginning a new e-mail or
opening one that has been sent to me?
> I used to be able to maximize the window in Outlook
> Express until we switched to XP. Does anyone know how to
> maximize the window when beginning a new e-mail or
> opening one that has been sent to me?
Ask in an Outlook Express newsgroup.
...Money 2004 trial
I have been a Quicken user and wanted to try MS-Money
2004. Having downloaded the trial version and after
converting my Quicken file, when i try to setup on-line
services of any financial institution it gives me
error "microsoft money has encountered a problem and
needs to close ... " . I tried it after creating a new
file with one account and no transactions, with the same
result. My system has 512 MB of RAM and still has 2.5 gigs
free on hd.
Is it that the trial version will not allow me to do this
or anything else is going on ? Any help will be greatly
Than...Returning a CHAR from a function
I have the following function that returns the path of where the
program was run from.
However I cant seem to return the butter as a CHAR. The code works if I
use it in a procedure but not where I need to return the variable CHAR
char buffer[_MAX_PATH]; //declares maimum path
//opens window maximized
//_getcwd(,)gets the current working directory
// #include <direct.h> //needed for current working directory
/* Get the current working directory: */
if( _getcwd( buffer, _MAX_PATH ) == NULL )
perror( "_getcwd error" )...Viewing Query Total in Form
I have a form where I input purchases for customers. I also have a query that
I use to make a report as a reciept to show the totals for items input. I
have tried to make a text box to show the information from the total field in
the query. However when I open the form it says "name?" is thre anyway to
show the total from the query?
Thank you for your help
...query help 04-14-10
using sql server 2005 sp3 32 bit
i have a table that looks like this (pseudo coded)
create table test (id int, parentid int, path varchar(200))
insert into test select 1, null, '/1/'
insert into test select 2, 1, '/1/2/'
insert into test select 3, 2, '/1/2/3/'
insert into test select 4, null, '/4/'
insert into test select 5, 4, '/4/5/'
insert into test select 6, 5, '/4/5/6/'
I need to produce a table that is flattened
4 ...Error: CDO.Person.1: Class not registered
I am attempting to run the code below using cscript on a Windows 2K3 SP1
server running Exchange 2K3 SP1 :
email = WScript.Arguments(0)
Set Person = CreateObject("CDO.Person")
strURL = "mailto:" & email
Set Mailbox = Person.GetInterface("IMailbox")
WScript.Echo "URL to inbox for " & email & " is: " & Mailbox.Inbox
I am getting an error: CDO.Person.1: Class not registered
(using wscript is the same error with error code 80040154)
I have registered and unregistered the following cdo*.dll's mul...how do i make a footer in Publisher
I am new to Publisher, but in the other Microsoft software I can show in the
footer both the current page number and the total number of pages in the
document. Can I do this in Publisher and how do I do it.
After you Insert, page numbers. View, Master page, type page # of XXX, (page 1
"Sharyn Bir" <Sharyn Bir@discussions.microsoft.com> wrote in message
>I am new to Publisher, but in the other Microsoft software I can show in the
> footer both t...Turning Off Error Reporting using API Functions and VB
We want to automatically turn off the error reporting options using Windows
API functions for the following functions area
Click on Start, Settings, Control Panel, System, the Advanced tab and Error
Reporting (at the bottom of the screen), which launches the Error Reporting
screen. Another way to get to that screen: Open My Computer, right-click on
Properties, click on Advanced tab and Error Reporting.
Any assistance would be welcome.
It's not a program's call. It's the user's decision.
--...Filter and Query Mismatch
When I do a filter in a table, I get 371 records but when I run a query
based on the same set of criteria I get 63 records. Does any one knows what
is going on here? This is a real problem and I can't figure out how to fix
it. Any help will be greatly appreciated.
On Tue, 22 Jan 2008 16:33:03 -0800, Ayo <Ayo@discussions.microsoft.com> wrote:
> When I do a filter in a table, I get 371 records but when I run a query
>based on the same set of criteria I get 63 records. Does any one knows what
>is going on here? This is a real problem and I can't figure ...