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/...Jumping to a hidden cell on enter
I've got 3 drop down lists in which the source cells are located i
hidden rows above the data cell. Each of these 3 data cells are righ
on top of the other (of the unhidden cells) and every time I use one o
them and hit enter, rather than going to the next unhidden cell down
it goes to a hidden cell. I can see it displaying the cell destinatio
and it's contents in the input window. I try to unhide then rehide an
it's always the same cell it goes to upon enter. Does anyone have an
ideas about what is causing this glitch?
---------------------------------------------...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...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...finding a cell address
I am still working on a vlookup table to return more All values for
given lookup value. I have found a way but need a little help.
my first value is easy it just looks at the range of the whole databas
lookup range= a:d
The second value is tricky, what I need is a formula that will give th
me address of the 1st match+1 cell down
what will give me lookup range = a2:d3
The third would be the value of the 1st match +2 cell down
My data is sorted by col. A in ascending order -- thats why once i
finds the 1st one if there are any more it will be in the next row.
I have an example if needed
...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...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...working out which colour text is used to populate a cell
Fingers crossed someone out there will be able to help me.
I have been tasked to provide a spreadsheet at work to monitor a number of
applications and written applications that we receive and the number of days
we respond by.
I have the following cells ‘application received’(Cell B), ‘enquiry
received’(Cell C), ‘date completed’(Cell E) I then have the following formula
in Cell H =NETWORKDAYS(IF(B4<>"",B4,C4),E4,$A$119:$A$158) which determines
which cell has the date in (B or C) and then works out the number of days it
has taken looking at cell E (the...How can I execute my macro for every row in worksheet
I'm a macro newbie...
In my worksheet, I want to use a macro to find the word "RETENTION" and
insert a blank (new) row after this word until all the rows in the worksheet
Any suggestions? Thanks.
try the following macro. It tests column A and inserts a row if
the value is 'RETENTION'
Dim lastrow As Long
Dim row_index As Long
lastrow = ActiveSheet.Cells(Rows.count, "A").End(xlUp).row
For row_index = lastrow - 1 To 1 Step -1
If Cells(row_index, "A").Value ="RETENTION" then
Cells(row_index + ...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...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 ...selecting like cells in a column
First time poster...wish I would have found this place a long time ago!
I need to select 'like' cells (i.e. same value) from a column (for use
in a macro so I can't just point and click). The like cells are
actually grouped together. Sounds easy enough but I can't find a
shortcut key to do it and am trying to avoid writing vb for this part
of the task.
Message posted from http://www.ExcelForum.com/
-- View and post Excel related usenet messages directly from http://www.ExcelForum.com
-- Hundreds of free MS ...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...Excel 2002 SP3 CSV Format Cell 'Special' Leading Zero
Excel 2002 SP3, CSV File, Format Cell 'Special' for Zip
Code Leading Zero does not work.
Is there any way to maintain the Zip Code Leading Zero
(New England States) in a CSV File? I have tried
Format 'Special' and 'Text' and have found the only
solution to be to place a leading ' with each zip code.
This is not a very practical solution.
Is this a configuration problem, a bug, or a limitation of
the CSV file?
you may use an adjacent cell with a formula for this. e.g. enter in B1
or something similar according...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...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 ...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.
Just ch...using the cells property for use with Application.WorksheetFunction.Sum
Has anyone had any success with using the Cells Propery when using the
Application.WorksheetFunction.Sum function? My code is below:
Sub AddDataMorningMil(mon As String, Day As String, yr As String,
intDOW As Integer) 'DOW = Day of Week
Dim x As Integer, row As Integer, colStart As Integer, colEnd As
Integer, varSum As Variant
' -- Friday column & starting row
colEnd = 6
row = 15
' -- Get the start column & row
Select Case intDOW
Case 2 'Monday
colStart = 2
Case 3 'TuesDay
colStart = 3
...Adding a row in all workbooks within a spreadsheet
I have 5 workbooks that link to one workbook. If I need to add a row how do
I do that in all workbooks at one time?
Select the first sheet tab, then with the SHIFT key depressed select the last
sheet tab. You will notice that the file name will change to GROUPED.
Inserting a row on a sheet will ensure that the row is inserted in all the
PLEASE ENSURE that you ungroup the sheets (right click on the tab name and
then select ungroup) as soon as possible because in a grouped format ANYTHING
you do will affect ALL sheets (even if you delete).
"ndpocohantas" w...Is this Possible ?
Have a newsletter document with text boxes that have no outlines but
internal gradient colour fills.
Is it possible that a macro could remove all colour fills in one hit just
leaving the text in place ?
Dim oShape As Shape
For Each oShape In ActiveDocument.Shapes
If oShape.Type = msoTextBox Then
If oShape.Line.Visible = msoFalse Then
oShape.Fill.Visible = msoFalse
should clear the fill from text boxes that are filled and have no border.
<>>< ><<> ><&l...High Availability/Clustering
We need to deploy MSCRM as a High availability solution. Microsoft state's
that MSCRM has not been tested or supported in a clustered environment.
Therefore they are not supporting a clustered solution. Has anyone tested
this? What other High availability options are there? Thanks
Your right in that clustering has not been tested yet or at least Microsoft
have said nothing but there are a few options. SQL Server of course can be
clustered and this is the main data store for CRM. The CRM web servers
simply act as a front end to the data. To make the system more redundant you
could at lea...