Error opening a document in Sales Literature
Anyone see this error instead of the document?:
...Creating a new field based on conditions
I have a database that tracks insurance information for our various vendors.
Each insurance type has 2 fields - a requirement field (yes/no), and an
effective field (some show an expiration date, some are yes/no). I have
created a query that will return only the records for which insurance is
required but is expired/missing. My problem is that I want to create a new
field that is calculated based on the values in the other two fields in order
to make the resulting report more user-friendly.
For example, if GLRequired is True and GLExpiration is <Now(), I want the
new field to say...Having problem of Outlook not receiving new e-mails
I have been using Outlook for over 1 year with Comcast
Broadband. Suddenly last week, I received a message that
Outlook 2000 was experiencing a problem when receiving new
e-mails and was going to shut down. I re-opened Outlook
and it looked different and then it asked for me set up a
profile and I canceled it. But after that window coming up
a couple of times after it shut down, I decided to put in
a new name and then I could not get to my old e-mails and
it acted like a new set up. Then I really got frustrated.
I was eventaully able to get back to my old e-mails and
have been able t...Report.SalesPlusTax
I don't know if you guys have ever try to show the total tax sale on the z
report, but when i make the modified on the z report it came out that the
total tax is 0. It didn't show me anything, i don't know if the script is
wrong or the script is not working for RMS V1.3?? Has anyone ever tried
<ROW> "Taxable Sales|" Report.SalesPlusTax </ROW>
I posted a question a couple of days ago and have not yet received any
answers. Therefore, I'm wondering now if anyone knows of a good place to go
to get the answers I'm seeking regarding what's probably a complicated
calculation in a report (concerning calculations when working with grouped
data). I'm not even sure if what I'm wanting to do can be done.
On Thu, 7 Feb 2008 09:22:04 -0800, Jen wrote:
> I posted a question a couple of days ago and have not yet received any
> answers. Therefore, I'm wondering now if anyone knows of a good place t...Controlling multiple TCP connections from Outlook 2003 clients
I've noticed that Outlook 2003 clients can have multiple TCP
connections to the mailbox store on Exchange. As the following web
"This behavior is by design. Outlook can open multiple connections to
parallelize its data communications with the Exchange server. The
actual number of connections will vary according to the version of
Outlook that you're using and the mode in which you're using it. For
Microsoft Office Outlook 2003 in Cached Exchange Mode, you'll see four
connections for the mailbox, ...moving payables data from open to history
A client says that someone imported data about a year or two ago into Great
Plains from their AS400.
Many payables documents that were imported should have been coded during the
import as open, instead of history. The client knows that she can take care
of this herself within two hours, by simply turning off the posting to the GL
and entering and posting the payables documents to move them to history.
But, she is wondering if there is a quick and easy way to do this on the
I'm familiar with the open and history payables tables within GP. And, I
know through a T...SharePoint (WSS) 2007 / Outlook 2007 - Alert
This is a multi-part message in MIME format.
We have setup a SharePoint Server (WSS) 2007 and are using the alerting =
After we changes stuff on WSS, an alert message is generated and sent to =
an email account.
This e-mail account is hosted on an Exchange 2003 server.
When using Outlook 2007 to open the e-mail, we get:
Cannot open this item.
Wenn using OWA the e-mail can be opene fine.
Does somehow have an explanation for th...Select all of a certain column across multiple worksheets
Is there an easy way to simultaneously select (or do a find-and-replace) on
column H on every worksheet of an entire multi-sheet workbook, without
having to select that column on each individual worksheet by hand?
Right-click on first sheet tab and "Select all sheets"
In activesheet select the column............will be selected on all sheets.
Gord Dibben MS Excel MVP
On Mon, 24 Aug 2009 16:43:02 -0700, "Charles Belov"
>Is there an easy way to simultaneously se...Report CRM 3.0
I would need to find out the detailed procedure (step by step) to customize
Could anybody inform about any links or documents concerning this issue?
I'm not sure if it's detailed enough, but the technical training manual has
a section on creating and customizing reports. You can find it here:
Jeffry van de Vuurst
"Marco Rocca" <Marco Rocca@discussions.microsoft.com> wrote in message
news:CEF80683-EC26-456C-82C...disable Review toolbar which came up automatically when opening a.
How can I disable the Review Toolbar which comes up automatically when
opening a file?
In the Workbook VBA actions.
The top left hand corner there is an Excel logo, not the one in th
blue program bar, but in the menu bar.
Right Click and select "View Code"
There will be two drop down boxes one that will probably say General
if this has never been entered previously.
Change the box on the right to Workbook.
Then Change the right hand box to "Activate"
Insert the following code
Application.CommandBars("Reviewing").Visible = False
exit the VBA screen and t..."the wizard is unable to open your query in datasheet mode, possi
"the wizard is unable to open your query in datasheet mode, possibly because
another user has a source table open in exclusive mode. your query will be
opened in design view"
what this message mean ,and how can i solve it
Please provide more details as to what you are doing when you get the error,
what your database setup is (i.e. split Fe/BE?, multiuser?, version? etc).
Without more information, we can only guess.
>"the wizard is unable to open your query in datasheet mode, possibly because
>another user has a ...Sumproduct with multiple date criteria
Having a tough time with this one.
Column A = Start Date, Column B = End Date, Column C = Quantity.
Row A = Start Date, Row B = End Date.
I would like Row C to sum quantity from sheet 1 where ever the two date
The date ranges on sheet 2 represent the beginning and ending of a week
Column A Column B Column C
01JAN2010 24JAN2010 1,000
Row A 04JAN2010 11JAN2010 18JAN2010 25JAN2010
Row B 10JAN2010 17JAN2010 24JAN2010 31JAN2010
Row c 1,000 1,000 1,000 0
Do the Sheet 2 Star...Use Form to prompt for report criteria
I have a form that I am using to prompt for report criteria. When I run the
query outside of the form, it works fine - prompting me for both criteria.
However when I run from the form, I get #Error#. Can you see what I am doing
wrong? Thanks in advance.
I have two combo boxes that I have put in my underlying query. In the
fields of the query are:
[Forms]![frmSelection Criteria Form]![OfficeNumber]
[Forms]![frmSelection Criteria Form]![Manager]
On the OnClick event is the following:
Private Sub Command6_Click()
On Error GoTo Err_command6_Click
Dim stDocName As String
st...crosstab qry as report source breaks Access2007
We have 3 reports whose record sources are crosstab queries. All have work
fine on the pc's running Access2003. But, the one pc running Access2007
doesn't like the crosstab queries as the report source. We don't get an
error - only the dreaded 'Access has encountered a problem and has closed...'
It totally shuts down the access application. I stepped through the little
bit of onOpen code while opening the reports and all works fine. I open the
crosstab query and it opens just fine. To test the theory that it is a
crosstab source problem, I tried to recreate one of the...web slices
This seems like a good idea, but I have yet to find a web site, product or
anything else that provides access to a web slice. Much to do about nothing.
Great ad gimmick for IE8, but I have found it elusive.
"Herb Mann" <HerbMann@discussions.microsoft.com> schreef in bericht
> This seems like a good idea, but I have yet to find a web site, product or
> anything else that provides access to a web slice. Much to do about
> Great ad gimmick for IE8, but I have found it elusive...Add new record through Form view
I have a table which is linked to a form, i would like to have a command
button which will add a new record to my table.
On the click of command button it should view the last empty row of my table
in a form.
On Sat, 26 Dec 2009 11:11:01 -0800, Ranjith Kurian
>I have a table which is linked to a form, i would like to have a command
>button which will add a new record to my table.
>On the click of command button it should view the last empty row of my table
>in a form.
The Click event should show [Event Proced...CRM 4.0 Custom Report Filter Problem
I am using the Report Wizard to create a simple report.
Report is using Quotes and Quote Products
I have a custom field in Quote Products which is a bit field Yes-No
When I use that field as a filter for report output, I get all records. The
filter criteria appears to be ignored
Is this an inherent problem with Report Wizard or Am I doing something
depends on your business logic and what you want to see.
If you have three quotes:
Quote-1 has three products, all with the custom field set to Yes
Q2 has three products, two set to Yes, 1 to No
Q3 has three products, all set...Filling Web Form
Dear freinds Hello,
I have written code in vc++ using MFC to fill the Webform using HTTP post
method and I'm able to fill the form but I'm facing a problem that I'm
unable to fill login name and password. So any one amongst you have any Idea
or help then please help me
...Excel 2000 vs. Excel 2002
I am having troubles with a workbook that I created that is havin
I created it in 2002, and it opens fine in Excel 2002 for other people
However, when I send it to someone who has Excel 2000, it takes over a
hour to open.
Now I also made a very similar report that works just fine whe
trasferred to excel 2000.
Here are a couple of stats on the workbook that is having problems:
500+ externel links
200+ simple calculations (a1+b1; a1/b1;etc..)
1 Worksheet in the book.
2 columns with conditional formatting
Message posted from http://ww...Querying multiple records in two tables
Hi, in my database I have tables for users (UserID, UserName),
projects (ProjectID, Project Name), and qualifications (QualID,
QualName). I have join tables for users_qualifications (UserID,
QualID), and projects_qualifications. (ProjectID, QualID).
What I need to do is run a query for a project to show which users
have the exact matching qualificiations.
Users can have many qualifications, projects can require many
qualifications, users may only work on a project if the qualifications
required/held match exactly.
Assuming that ProjID, and QualID are numeric, the following sho...Frx Susbcript 9 error
I am running a consolidated Income Statement in FRx and I get an Error
9 when it hits this one company. It consolidates 5 different
companies, one that is translated. I just can;t figure it out. I have
a very similar Balance Sheet that runs just fine. I have tried
everything, change the output names, etc. I can run the report if I
just select that one company but when I run the total company it won't
run, it stops with the error. I am using row linking and currency
translation. I can run the report for all companies individually. I
just don't get it. I have gone through the various kb...stock variance report
Is there any way to edit that stock variance report at HQ? There are no $$
values and this is quite important at HQ.
How do others work with this?
Create a custom report using the Quantity Discrepancy List as a template,
add the SnapShotCost, SnapShotLastCost and/or SnapShotReplacementCost column
from the ItemDynamic table times the qty difference.
"Ivan Brebner" <firstname.lastname@example.org> wrote in message
Is there any way to edit that stock variance report at HQ? There are no ...Office 2004 issue with documents NOT BEING ABLE TO OPEN APPLICATION, but application can open documents.
Just migrated all my files and apps from a G4-400 to a new Mac Mini
1.87ghz Intel running pre-installed OSX10.4.10.
Used CD to install 'normal' version of Office 2004 Mac on the new Mac
Mini. In fact its the same disk that I used originally to install Office
on the G4-400.
Neither old .xls and .doc documents (made on old Mac, nor new .xls and
..doc documents (made on new Mac)will not open their respective
applications, when clicked upon.
However, when I use either of the the application's "Open" feature,
theres is no pr...Opening .prn files in XL2000
I am using a software that does not save data/reports in .csv or .xls
formats; only in printed versions. Is there a way to save the printed
report in a file and open the file in XL2000? If there is, how is the print
file produced, where is it saved, etc? A friend suggested setting up a
generic printer but didn't know how to go about it.
You may want to give that other software just one more chance--look under File
and see if there is a SaveAs option. You may find something upon further
But if you want to add a generic printer, I think it'll depend on your version