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/...Change dflt Journ Entry from PHONE to TASK?
I use journal heavily - but not for recording phone calls,
for recording time spent on tasks and other details about
them. Each newly-created journal entry defaults to
entrytype "Phone". How can I change this to default to
....Allen Kitchen / firstname.lastname@example.org
You can change the name of that entry, but I don't believe you can change
the fact Outlook uses it as the default for new Journal items.
You can read more info here:
PATRICK REED [Outlook - MVP]~~~~~~
-Micr...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...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...Deleting Duplicate entries #2
I have a huge spreadsheet with over 7500 rows which has
been given to me. A large number of the entries are
duplicated many times within the sheet. Is there a way to
run a macro or a worksheet function which will
automatically find and erase the duplicate entries based
on one unique column that I can use?
Check out this site
And this page "Delete duplicate Rows"
Regards Ron de Bruin
"email@example.com" <firstname.lastname@example.org&...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 + ...purchase history entry
We have recently setup RMS, and are now entering client data. Can anyone
please tell me if it is possible, and if so how, to enter past purchases
clients have made going back several years..I have heard mention of a
"transaction table", is that the way to go?Thanks in advance for any
YES we have an import utility that does this. Though you need to have the
original data exported to excel or to a CSV or Text file. For more
information contat me.
Afshin Alikhani - [ email@example.com ]
CEO - Retail Realm
= = = = = =
"KDS" <KDS@discussions.micr...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 ...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...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...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...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...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...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 Batch Marking Possible?
I am doing a mass mailing from Outlook. I will print 50 address labels per
day. Is there a way for me to batch-mark the contacts for which I print a
...Conditional Insert Row
Hello...I need to automatically insert my entire first row of data at
each increment where the value in Column A has changed. Is there a
function I can establish to do such a task automatically?
File format as it appears currently..
File format as it needs to appear..
Message posted from http://www.ExcelForum.com/
try the following macro. It tests column B and inserts a row if
the values change
Dim lastrow As Long
D...Address book shows LDAP style entries
This may be standard, but when I go into my address book (Tools > Address
Book) to look at the Global Address list, the e-mail addresses are listed
LDAP style (OU=MyCompany/, etc.). Is there a way to display these as
firstname.lastname@example.org (SMTP) formatted addresses?
...Is it possible to make cmd window to flash?
I have an existing VC2003 windows console program. Now I want to add a alarm
feature to it, the simpliest way is to make the cmd window to flash. Can
this be implemented?
>I have an existing VC2003 windows console program. Now I want to add a alarm
>feature to it, the simpliest way is to make the cmd window to flash. Can
>this be implemented?
If the console is running in a window, I presume you can use the
FlashWindow(Ex) API. In newer OS's you can find the console window
handle using the GetConsoleWindow API. For older OS's here's...