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...Offset, sum down to the first blank row
can anyone write the formula to sum down to the first blank row it encounters?
In the sample data below I want the xx to sum only to 60
Assume the word sum is in cell A1 and the xx is in cell B1.
p.s. would this formula be considered "volatile" and therefore "risky"....if
so, what's the risk. thx.
"Tami" <Tami@discussions.microsoft.com> wrote in message
> can anyone write the formula to ...DEX ROW ID
I have a question on how does the dex row id get updated in great plains. I
noticed there a 2 tables in the tempdb database what is that for.
The DEXROWID is present in every table and is automatically incremented by 1
every time a record is added to the table.
The tempdb database is a temporary database used by the server to store
information needed for it to do its work. Its content is constantly changing
and is wiped out everytime you restart the server.
For more information check here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/...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
...How do I create a dual axes column chart in Excel
Hi...I am trying to create a dual axes column chart in MS Excel 2003. But the
moment I add the secondary axis the bars are getting overlapped.
This example should help:
> Hi...I am trying to create a dual axes column chart in MS Excel 2003. But the
> moment I add the secondary axis the bars are getting overlapped.
...Format so first column always appears
I have a wide worksheet and want
the first column to always appear
as I scroll to the other columns.
I would look it up but I can't figure
out where to look and under what
It's referred to as Freeze Panes. Position your cursor in B1 then
click on View | Freeze Panes | Freeze Panes (Excel 2007 or later), or
Window | Freeze Panes (Excel 2003 or earlier).
Hope this helps.
On Aug 20, 1:26=A0am, Gianni <gia...@gianni.com> wrote:
> I have a wide worksheet and want
> the first column to always appear
> as I scroll to the other columns.
> I would...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...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...Pivot Table- Column 2 sort
How can I sort a Pivot Table by the 2nd (or any other) column? I've selected
a cell and hit the A-Z Z-A Sort button, but it only works on column 1.
Right click on the column and select Field Settings | Advanced to access the
> How can I sort a Pivot Table by the 2nd (or any other) column? I've selected
> a cell and hit the A-Z Z-A Sort button, but it only works on column 1.
Difficult to answer without knowing the structure of your underlying data and
what, exactly...CListCtrl Setting the Focus to a Row through Code
i am taken a dialog based application. on the dialog i placed
CListCtrl.i added 3 cols and 10 row to the list control. the first
column is Checkbox.
On the dialog box i placed two Buttons with captions "Next" and
"Previous". when i run my application, when i Press "Next" Button the
selection mark in the CListCtrl should move to the next row.and when i
press "Previous" the selection mark in the CListCtrl should move to the
i am using
m_ListCtrl.SetItemState( nItem, LVIS_SELECTED|LVIS_FOCUSED,
it...Total or pre calculated column
My report provides a list of supplied products, these can range from on item
to many. I have a control which calculates the amount of product ordered
plus a wastage =[Qty]+[Wastage] to give a total quantity for that particular
I want to have a total of all the lines. In the Order footer I have placed
the control =Sum([ProdTotal]) ProdTotal being the name of the above control,
however when I view the report it ask for a perameter value.
Am I missing something or will the report not calculate from a previously
Many thanks in advance
Cha...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...Won't update row in datagrid
I have a XML file that I have bound to a typed Dataset, which goes to a
DataView, which is connected to a datagrid.
When I enter new data in the last row (empty) row of the datagrid and move
off of the datagrid's row the data disapears. AllowNew and AllowEdit of the
dataview are both true. ReadOnly of the DataGrid is False.
What am I missing?
Can you detail how the DataView is set ? I don't seem to have to same
problem on DefaultView, nor on an unfiltered DataView ...
"Trey" <firstname.lastname@example.org> wrote in message
&g...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...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...Export report templates
I would like to export the standard and modified reports from Great Plains
6.0 and am not familiar with this application. Is this feature available for
both FRx reports and the vanilla standard reports that come with Great Plains.
Any assistance in how to obtain this information either in a text, csv
format etc would be appreciated.
For FRx, you can export to Excel and other formats. Within FRx you would go
to the Report Catalog and pick the report you want to print. On the output
tab select the type of destination you want. Click the Generate report
button. There are no vanilla repo...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 ...Design issue; and finding and displaying row on other workbook
1. An academic course is divided into two sections: lecture and
discussion. The lecture section contains all classes, but the
discussion classes do not. The discussion section is further divided
into three subsections, each containing multiple classes.
The need is to coordinate student attendance and grades for all
sections. Currently we have 1 lecture section workbook with all
student names, IDs, and other info; and 3 discussion section workbooks
with the same only for the relevant subsection. And then there is a
consolidation workbook where lecture and discussion are put together
and attend...Can I assign an ip form within a program on Windows CE 6.0
I know in Windows CE 6.0 you can change the ip address on the device by
doing the following
1. Navigate to : Start -> Settings -> Control Panel -> Network and
Dial up Connections
2. Right click on the network adapter and select Properties
3. You will see the IP Settings dialog box
4. Click Specify an IP address and fill it in
I would like to do the same thing in a program. What do I wirte too? Are
they registry entries or something in the smbserver.dll? Can someone please
provide some detail on what to write too?
Just ...pictures in various shapes
Is it possible to insert a picture and make it into a circle or an oval or
various other shapes than just squares and rectangles? Thank you ahead of
with a graphics editor
Microsoft MVP - FrontPage
"Stephanie" <Stephanie@discussions.microsoft.com> wrote in message
| Is it possible to insert a picture and make it into a circle or an oval or
| various other shapes than just squares and rectangles? Thank you ahead of
> Is it possible to insert a pict...How to select the last filled row
I have a column of data and I add rows every day to that column; I just =
to see the data in the last row in another cell... whats the formula for =
that???? ex: I have A12 which reads 48 as the last data on the column A; =
next week I'll have A43 and the data will be 84... I want a cell which =
48 today and will show 84 next week....=20
PS: I managed to get a formula which shows the number of the last row =
can't use it either... ex: the data I'm interested in, is in A12 and it =
"48".... but tomorrow it will be in A13 and ...Easy Data Transfer?
Is copying Outlook.pst from my desktop to laptop the easiest way to transfer
data, including email, in order to use Outlook on my laptop while on an
extended auto trip?
"Don B." <email@example.com> wrote in message
> Is copying Outlook.pst from my desktop to laptop the easiest way to
> transfer data, including email, in order to use Outlook on my laptop while
> on an extended auto trip?
...Is this possible
I want to make a list of the files in several different
folders. Is it possible to somehow "Copy and paste" just
the filenames into a list, in either Word or Excel or
Wordperfect. I am just trying to sort the files in
several different folders to weed out duplicates. There
has got to be an easier way then typing them all or screen
printing the lists and manually weeding them out. Any
Here is some code that will start in a directory and list all files in that
and any sub directories. It uses recursion to go through all the subs.