sent emails are not showing up in SENT folder; + signs, duplicate recved emails
first time user of this bb... of bb in general for that
matter / where and how do I check for a reply?
some of my sent emails are not showing up in SENT folder
while others do...
and sometimes when I send a SINGLE email, progress bar
shows up and says "1 of 4" or "1 of 5" being sent
also getting these weird "little grey +" symbols in boxes
to the left of the envelopes in the MAIN window... appear
to be random... can be next to a "read/opened" envelope or
when you click on the '+' symobol,
.... th...repeating formulas by the same row or colum increment as the last. #2
I need to repeat formulas in a sheet by the same #of rows. I mean I might
increase the copied value by 22 rows. How can I enter that without typing
each row increment. So if I was to copy row 22 and then row 42 and then row
62. I might have one that looked like +sheetnameb22. The next one would be
+sheetname b42, the next +sheetnameB62
...M04 Paycheck not showing in budget
I entered my paycheck in M04 Bill section.
The actual amount shows in the budget, but not the budget. The budget shows
I just realized that the paycheck date was set for february and I was
looking at my january budget.
That's why it was not showing up as a budgeted item.
...Access External Tables Using SmartList Builder
Can I access external SQL tables in SmartList Builder? We want to query
tables in the Tensoft Fabless Semiconductor Manufacturing (FSM) software
module that is bolted to GP. Thank you.
You certainly can! If your tables reside in another database, you will need
to create views from within your GP company database as follow:
create view vwTensoftTable as
select field1, field2,...,fieldN from YourTensoftDatabase.dbo.tensofttable
You will need to then grant permissions to DYNGRP on those views. From there
on, you can pull into SLB.
Mariano Gomez, ...how do I setup a pie chart that does not plot zero values ?
I have a set of rows and columns were column 1 is the description and column
2 is the value (in percentage). I have setup a pie chart linked to these data
to display these categories and their respective percentage. Howver, when a
cell from column 2 has a zero value, I would like this whole row (description
+ zero percentage), not to be displayed on the pie chart as it is
meaningless. Can you please suggest to me how to do it ?
Have a look here.
> I have a set of rows and columns were column...SmartList Security for New SmartLists
I'm having a problem with version 9 SmartList Security.
I create a SmartList and then open SmartList and let it add the new object.
I go to Advanced Security and the SmartList is marked automatically but
nobody that is marked for it can see it. I have to unmark and remark the
Is there a setup issue or a software issue?
Charles Allen, MVP
I have you gone into Smart list Security. I have found that even though the
New Smartlist object is checked in Advanced Security, it will not be checked
in the Smart List Security.
I believe that this has been writt...Imported Activities do not show up in Calendar
I've been working on importing Data from ACT! to Microsoft CRM and
have 90% of the information pulled over and working correct. The last
thing on my need to fix list is the calendar.
We imported all Activities and Notes using Scribe, our 45 day license
is expired and I cannot pay for another. So I'm stuck getting this
working by hand.
The ActivityPartyBase Table is populated with a ton of stuff. The
AppointmentBase table has a bunch of entries, however only 1 column
(ActivityID) is populated with something. (all others are <NULL>).
I can't seem to figure out what n...SmartList/SmartList builder
I was training a group of customers today on SmartList builder and they were
creating trying to create a SmartList report. Everything goes well until at
least 4 or 5 of them were having errors saving the SmartList in the
SmartList Builder window. The error was something about a duplicate key
being created on the SLB11000 and the SLB 11100 tables (I cannot recall
which users have errors on which tables) but after attempting to save the
SmartList ID and building the SmartList ID on the actual SmartList view, I
cannot see the favorite there. (They say they may have, at one point in...a field automatically change every year
I'm working on an elementary database. There is a specific field for grader.
For example, there is a student who is first grader so I put G1. He will
become the second grader in Sept. I would like the field automatically change
to G2 in Sept. We have a thousand students. It's hard to change it manually.
I'm talking about something like age. The age field will change every year.
You raise an important point about database design, Anna.
It is imporant to store the data so it does not go out of date, so don't
store a student's age. Instead, store the date of bi...Nothing shows up in windows ME forum so im puting it here
I have an old windows ME that i am trying to clone on to a flash drive and
half way through the proccess the program gives me an error saying hd error
cannot read try running chkdisk to fix any errors but then i run it and there
is no errors. is there any program that can clone the whole hd including OS
and errors it contains just a complete clone. the computer only holds 4gb
and i am using a 8gb flash drive.
Sure Norton Ghost 15 can perform a cold image of your system. This means,
you just bootup your system using the recovery CD and it can save the image
file on your flash...HOW DO I SHOW VAT CONTENT
trying to set up a spreadsheet and final column must show vat content but
can't work it out
Assuming you have the total price in D2 then you can use
to get the VAT
Since we are dealing with money you might want to add ROUND to it
"josudare" <email@example.com> wrote in message
> trying to set up a spreadsheet and final column must show vat content but
> can't work it out
...How do I get a cell to show the fifth character of another cell?
I have a number in cell N7 which is 8 characters long. I am using =LEFT(N7,3)
to refer to the first 3 digits of that cell and =RIGHT(N7,3) to refer to the
last three digits. How do I get it to refer to the 2 center digits without
showing any of the rest of the number?
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
"dedsky" <firstname.lastname@example.org> wrote in message
>I have a number in cell N7 which is 8 characters long. I am using
> to refer to...Budgeted Item Shows Zero Amount When Tied to a Bill that reoccurs.
This applies to Microsoft Money 2004 Standard OEM Version 12.0 Update 1
I noticed in my budget report it shows that I have a monthly budget for
Automobile: Automobile Insurance of $0.00. However, if you click edit budget
on the common task page and then click next. Then you arrive at the "Enter
Your Expenses" page. I have a budget group called Automobile. If you drill
down and expand Automobile it looks like this:
Automobile: Automobile Insurance
( red arrow) Safeco Insurance
Other Expens...Received Not Invoiced
GP 9.0 contains a prewritten Smartlist under Receivings line Items entitled
"Shipments Received but Not Invoiced*". I, erroneously, expected the results
to match the Received Not Invoiced report (Reports - Purchasing - Analysis -
Received Not Invoiced). However, it does not. In my instance, the Smartlist
contains numerous items that are not on the report.
It appears that the Smartlist is simply querying POP10500 file and comparing
the QTY Shipped field to the QTY Matched fields and displaying those items
where these amounts are not equal.
When I attempted to examine the Rece...Storage Limits not being accepted or showing up in ESM
I am running Exchange 2003 with Service Pack 2 applied. I have taken off
storage limits for a particular user and it still does not show up in ESM.
How long have you waited? It can take a couple of hours to take.
"Sabo, Eric" <email@example.com> wrote in message
>I am running Exchange 2003 with Service Pack 2 applied. I have taken off
> storage limits for a particular user and it still does not show up in ESM.
I do not know whether i can use excel in this or not. but I am trying
to find the non-zero solution to the following equation:
but i always get a zero solution. How could i obtain the non-zero
solution?I know that there is a non zero value of t satisfying the
Here's one way.
Let A1 contain values of t, and initially enter 1 (or your choice of
starting value) in A1.
Let A2 contain the left side: =0.6*EXP(A1*1.0986)-0.6
Let A3 contain the right side: =0.99994572*A1
Let A4 contain the difference, which...RPC over HTTP shows not enabled?
I think I have follwed the instructions properly for setting up a single
exchange server for rpc over https.
but when I view the server from Exchange System Manager it shows RPC over
HTTP "not enabled"
what could I have missed?
Gary M wrote:
> I think I have follwed the instructions properly for setting up a
> single exchange server for rpc over https.
> but when I view the server from Exchange System Manager it shows RPC
> over HTTP "not enabled"
> what could I have missed?
Hmmm - see
OK... SmartlIst Builder.... V10
Where did they now hide the Smartlist Security window to give User/User
Class access to the new objects????
Access to smartlists is controled through the Alternate/Modified forms and
Reports (Tools->Setup->System->Alternate......) Select the profile (forms
and reports group) to be modified and then select Smartlists. View the list
of Smartlists and mark which ones this profile should have access to.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and ch...external data doesn't show all data...
I am trying to access a SQL database (MS CRM 4.0) using the Connections
feature in Excel 2007. I am able to connect to various tables and views,
however, some key columns of data do not appear. I am wondering if they are
hidden or I have a security issue. If I try to access the data using SQL
Server BI 2005, all data is available. However using Excel 2007, the columns
I need to connect the data to other tables is missing. Any thoughts?
I've encountered a similar problem in the past when SQL columns were 'raw'
data. Once cast to appropriate data type things worked fine....Default column layout in Smartlist Builder
When generating new Smart list using the Smartlist Builder tool it would be
great to allow for a means of identifying what the default column layout to
be rather that having to create a favorite to do that. For Example. If SLB
wanted to place columns 1, 2, 3, 4, 5 as such you could tell it to make it 5,
4, 3, 2, 1 instead in the root folder of the new SL created
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 th...why does named range only show up on some worksheets?
XL 2003, SP2
The title about sums it up. On sheet A I create a range Resource_List. I
can access the range, it shows up when I hit F3, etc. If I move over to
another worksheet and hit F3 it is not listed. It seems some ranges are
"universal" and others I create only live with the sheet whence they were
created. This seems bizzaro to me. Especially when the range used to show
up everywhere. Any ideas on how to get these things to work ubiquitously?
I did add a DB query to drop data into the area of the range. Seems like it
hasn't worked since then. Could the query ...2002/2003 Last Edit Problem
I've embeded "Last Edit" Date field in a 2002 document's Doc Box which
generally works fine, except.....
If the document is opened using 2003 (instead of 2002 where it was
created), the Last Edit Date gets updated even though nothing on the diagram
It's clear from the XML versions that 2003 is doing lots of changes to the
underlying file structure which is probably what's triggering the
"Edit/Update", but is there any way to turn this off? I've tried opening
the file Read-Only, but even that doesn't appear to help.
Thanks in a...Smartlist Creation
New User - Went into Smartlist under Customer Balance and added the aging to
it but when it refreshed everything was 0-30 days. I know if I run an AR
aging report it will not reflect everything in 0-30 days. Where does the
Smartlist pull its data from.
Go to Tools->Routines->Sales->Ageing and run this process. It ages the
accounts just like the report but it writes the data back to the tables.
This provides the data for the SmartList as well as updating the agening
displays and information printed on statements.
Richard L. Whaley
btw.....more informat...Windows Installer Runs / Show Office as a "Hybrid"
I am having serveral issues. All started when I noticed my Start menu button
was lagging for at least 30 sec before expanding, and/or whenever I click on
an office program the Windows Installer would run, and then try to re
install/config Office, but as a Hyrid program.
I have uninstalled and reinstalled and nothing has been fixed, just made
worse. I have associated my Excel file with the office program. I click on
the file IE excel file, and as it opens the Config screen pops up. I cancel
it. I get an error message that I should repair/restore the program. The
file cont...SMARTLIST REPORTS
i can't modify smartlist reports is there a way to modify reports from
smartlist. can i modify smartlist reports in version 9 or in the succeeding
If you are talking about creating you own smartlist reports, you can use
Smartlist Builder. This will allow you to create your own smartlist, as well
as use SQL Views to pull into Smartlists.
If this is not what you are looking for, can you please explain a little
more about which reports you want to modify in Smartlist.
> i can't mod...