Is it possible
I would like to know is it possible to make million dollar in the internet, if you have any suggestions, write on my forumhttp://isitpossible.truemillion.comMark...Trendline and multiple data series
I have a scattergraph with four data series. Is there a way of inserting a
trendline which covers all four series?
Thanks in anticpation
Create a helper column that combines all the data series ...
> I have a scattergraph with four data series. Is there a way of inserting a
> trendline which covers all four series?
> Thanks in anticpation
...Personal Folders in OWA
I have just enabled OWA on our Exchange 2003 SP2
through ISA Server 2004. Is there any way to
access personal folders in OWA?
Thanks in advance.
If by personal folders you mean .pst files, the answer is NO! Sorry.
C C wrote:
> I have just enabled OWA on our Exchange 2003 SP2
> through ISA Server 2004. Is there any way to
> access personal folders in OWA?
> Thanks in advance.
"C C" <email@example.com> wrote:
>I have just enabled OWA on our Exchange 2003 SP2
>through ISA Server 2004. Is there any way...Charts & Hidden Data
If I hide the row/columns containing the source data of a chart the
respective series disappears from the chart.
Is there any way to hide chart source data without affecting the chart?
In XL2003 (and before) with chart selected: Tools | Options |Chart and
uncheck the box "Plot visible cells only"
In XL 2007: Follow this path: click the chart; use Chart
Tools|Design|Selected Data; look for button
labelled "Hidden and Empty Cells"; complete dialog box as needed.
Bernard V Liengme
remove caps from ema...is this possible? reload a form that is based on a query with new query that is defined in the form.
I have a basic form.
The form is based on a query, so when I open the form, a pop comes up
where I enter in what I want to query.
So instead of 30,0000 records, I get 1-10 records.
on the form, I have a text box. I want to be able to enter in what I
want to query next and afterupdate have the recordset/form reload with
that query instead of my original qeury.
I figure this has to be done with VB. I am just starting to learn some
VB but I am lost.
Any info would be great, thank you.
You need to apply the new query or table name, or the sql string to
the forms recordsource, then...Bought a house! How to add into Money?
I just bought my first house a few weeks ago.
I have been using money for about a year now to track all my expenses,
budget, investments, etc. and have found it very useful. However, i
am wondering what is the best way to add a mortgage into money so i
can track what i have paid? Should i just do it as an normal expense
and maybe just break down the payment into subcategories (insurance,
taxes, mortgage) or is there an actual better way to do this?
I would suggst that you create an asset account for the house and a loan
account for the mortgage. Then create a payment in the bil...Help to add email account
I am unable to add my AOL email account to Outlook. Does anyone know the
addresses or how to do that?
We have some engineers that have fairly intesive graphs with tons of
data points on them. When we open the Excel 2003 graph with Excel 2007
and try to print the graph there is no data line or curve. Our axis'
and titles show up, even our 2 pt colored vertical lines appear. Now,
when we take all the data from this 2003 excel sheet and create a new
2007 sheet and create the graph from the data it prints fine. Also the
2003 graph will print frin ewhen opened from excel 2003. We've tried
the convert tool in 2007 when opening a 2003 workbook and still no
graph. We have a multit...How can I automatically enter repeating data from one table to ano
Hi I am a novice so if you can help please do. I have set up a database and
have a range of tables established for each of my categories and they seem to
be working well. How do I get the database to automatically fill in
repeating data (ie names) from one table to the next so I don't have to keep
retyping? Hope this makes sense.
Please help in simple English.
In a properly designed relational database system, you shouldn't have the
same data in multiple tables. You may want to read up on Database
Normalization. Jeff Conrad has some goo...Add text to formula?
I have this formula kindly given to me in one of these Excel ngs:
=COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You Lost*")
The challenge is that any custom text I add to the cell formatting
doesn't show up in the cell. Would it be possible to add something
like this text below to the above (but also including line breaks)?:
Formula result of: =COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You
*********************...Editing XML data relation line
I am working on a program where I am retrieving data from an Access
database through one common dataset. I have already put the database
connection component on the form as well as the two data adapters.
Here is where I am having problems.
I double click on the .xsd file and then go to the schema menu and
select add|new relationship. My table names are Employee and Payroll.
Employee ID is a primary key in the Employee table and a foreign key
in the Payroll table. I need to define a DataRelation link with
Employee ID. The problem is that when the parent table is set to
Employee and the ch...Missing Data in Spreadsheet Contained in a Disk Image
Operating System: Mac OS X 10.6 (Snow Leopard)
I used Migration Assistant to copy all my applications and files to my new iMac i7. When I attempt to open a vital password protected Disk Image, the .dmg opens OK but the Excel file contained within doesn't have any data in it. Taking a copy of the .dmg from a backup disk results in the same thing. <br><br> What's really peculiar 'though is that if I right click the file before actually opening it, using Quick Look, it shows all the data is there. But the file still won't open the Ex...Downloading Statements Directly Not Possible
I have Money 2002 installed on an Win XP Pro SP1 machine. Something
happened and I probably did it, that causes the statement downloads not to
go directly to the account. Rather they want to be saved in a file and then
opened into Money. I then have to delete the download.
I have tried several things in order to fix this:
1. I verified the file associations of OFC, OFX were correct. They were.
2. Lowered all my security settings in IE. Even put banks into Trusted site
zone. No go.
3. Made new accounts. Didn't help.
4. My IE cache is large (500MB) and regularly cleaned out.
5. I made s...Moving an old transaction from one account to another.
I have a *very* strange situation here...
Once upon a time, Mr. Pat Smith married Ms. Pat Jones. The Mrs. Pat Smith
was a cute oddity for the duration of the marriage. Sadly, the marriage
ended. Mrs. Smith did not change her last name back to Jones...
Now we have two people in town with the same name. 'Pat Smith'. Mr. Pat
Smith bought a mattress set. In RMS, the mattress is on Mrs. Pat Smith's
account. This probably would have gone unnoticed for along time, possibly
forever, except for the unfortunate demise of the mattress under warranty.
Now we need to return the m...Possible to detect changes to an XmlDocument object?
If I instantiate an XmlDocument object, the load a file through the Load
method, is there a way, later on in execution, to easily determine if the
XmlDocument object has changed from the original version loaded?
I'd like to be able to check a condition to see if the document in memory
has been editted (i.e., nodes added, attributes changed, etc.) so that my
user can decide whether or not to commit changes to the disk file before
moving to another file.
Will I have to resort to re-loading the file, and comparing OuterXml
Gabe Covert wrote:
> I'd like t...Trying to add or save a record.
I tried this awhile back and gave up. Trying again.
I made a form with two tables, customers & calls.
When I enter the phone number from the customers table that exists it
populates the form the way I want it and I can save the form or add a new
record and I think it is saving it in the calls table.
If I enter a phone that doesn't exist and try to exit or enter a new record,
I get the following.
The microsoft jet database engine cannot find a record in the table
'customer' with key matching field(s) 'Phone#'.
What I am trying to do is save the form even though ...Wanting to not add a blank element to the XML
I'm serializing a class and some of the elements end up with blank results.
This is fine. When I serialize the class the elements show up in the
resulting XML as something like
If it's blank how can I prevent this element from getting into the XML
completely . It is optional according to the schema but fails on validation
when it's in there in this form.
Could you post some code of your class and the serialization code, so that
we can try to make a repro on this issue?
"This posting is provided "AS I...Subreports not Viewing on one Page
How can I get my subreports on report to print on one page? I have a main
report and subreport within the subreport there are 5 reports. When I
Printview my main report my subreports show up in the middle of the page at
the end of the page on the next page - how can I fix this? I have tried and
look at everything available and can't find a fix. Can someone please help
me with this? Thank you in advance for any help you can provide.
it can be difficult to cram alot of info into one report page....particularly
lots of subreports...
make sure you have the 'CanShrink' pr...Add multiple domains to spam deny list and real time sbl
What file can I open in Exchange 2003 to add a list of
domains I want to prevent from sending spam, so that I do
not have to add each one individualy. Also, how do you
set up Exchange 2003 to check the sbl.spamhaus.org real
time listing. They list the sites to block and say you
can connect to them for free. Can anyone please help?
...Export Access Data Project Queries to old Access .mdb file
I want to copy Access Data Project queries from a project into a new .mdb
file. What is the best way to do this?
In the new .mdb go to the menu bar, click file, Get
external data, and Import.
Select the orignal .mdb file and then the items.
>I want to copy Access Data Project queries from a
project into a new .mdb
>file. What is the best way to do this?
Any idea about the Data consolidation in excel . I have multiple excel
sheets and want to consolidate it without losing the data. other than
RDB data merge .
If those files have all the same schema, you can do it with a VBA macro using mso.
Le 2011-10-20 21:47, shivaprasad . shetty a �crit :
> Hi Team,
> Any idea about the Data consolidation in excel . I have multiple excel
> sheets and want to consolidate it without losing the data. other than
> RDB data merge .
> Thank you,
...Is it possible to compare a string and a field name
I have the following tables: Membership, Subscriptions, OfficeUseOnly. The
Office Table contains a Year, Year To and From [financial year] and the other
fields are the 5 membership types (regular, student etc) and these 5 fields
contain the different amount each type of member has to pay.
I want to create a form whereby on entering the financial year and the
membership type the correct amount is automatically inserted into the
FinancialYear - in current form = OfficeUseOnly SubsFinYear
and then if MemberType = 'Student' find Student field ...sizing pie chart category data label
I would appreciate advice on re-sizing pie chart category data labels.
When I click on the label, I get a box around the text, just like
other microsoft applications, but when I click and drag on the points,
the text label box does not re-size...it stays the same size. Any
suggestions? Thank you.
I think it auto-adjusts to suit the font-size and text that you have
in there. Try right-clicking on the label, then you usually have
access to other features.
Hope this helps.
On Mar 9, 4:41 pm, susanh...@ou.edu wrote:
> I would appreciate advice on re-sizing pie chart category data labe...want show result in spread sheet, in the form
I have a form with a combo box , listed with 5 items.
when each item is selected it will execute a query and result will in spread
sheet window like how normally appears when a query is executed.
but I want to add some thing like spread sheet, in the form at the bottom.
when a query is executed the result should appear in the bottom attached
pls help me here in 2 things.
1. where and what should i add at the bottom which seems like spread sheet
and how to add it.
2. how to make possible the result will appear on it.
thanks in advance....
Operating System: Mac OS X 10.6 (Snow Leopard)
I want to group data: <br>
all transactions that took place in time intervals (per hour) <br><br>How can I display the total number of all transactions per time interval? <br><br>Thank you for your response!
It depends on the nature of the data & how you have it arranged. The first 2
options that come to mind is the Subtotals feature found in the Data menu as
well as the use of a Pivot Table.
See the following topics in Excel Help:
Add up totals for sales data
Analyze your data with P...