how to recover the lost files
the file name still the same but the contain is not the same. how to recover
If you are saying that the name is the correct one but the file is now empty
i.e. no data, then unless you have a backup prepare for a very bad day
because it's gone.
> the file name still the same but the contain is not the same. how to recover
> the files
...How to sum the number of times answered in a single column with b.
I have a column of data with number answers and blanks. The numbers vary
slightly between 9 to 11, with no answers or zero's for some rows. I only
want to know the number of times in the column that an anwer is present out
of 214 rows. I thought the "DCOUNTA" function was right, but I just can't
get it. It ranges from K6 with the lablel "Corners" to K223 for 214 rows of
Condos and info on room counts and sizes. I don't seem to have the criteria
statement right. It thought it would be K7:k223>0????
=3DCOUNTIF(K7:K223,">0&...How to align columns of text in a CEdit Control?
Is it possible to align text in columns in a CEdit control?
I'm using stringstream to print the formatted text to a
When I send it to a text file , it looks good, but when I
send it to a multiline edit box - the columns don't line up..but
they are correct. Not sure if the font is the problem or what.
Is there a way to do this or do I need some other kind of control or
Thanks, Tony C.
<email@example.com> wrote in message
> Is it possible to align text in columns in a CEdit contro...Extract some fields from a Row to a column #2
Thanks for your help, Follows a sample of my database, as you'll see
try to get the info in row 2 to column B and row 3 to Column C.
Column A Column B ColumnC Column D Colum
Row 1 GEORGE CLAUDIA Row 2 Row 3 SARASOTA F
Row 2 2750 RINGLING BLVD
Row 3 Phone: (941) 954-5536
Row 1 GEORGE DESPINA CPA APALACHICOLA FL 32320
Row 2 99 MARKET ST
Row 3 Phone: (850) 653-2770
Row 1 GEORGE F CPA PA TALLAHASSEE FL 32308
Row 2 170...How do I stop saving attachments with sent mail?
I have many >5 Mb attachments in my sent mail and archive sent mail
folders. As I understand it there is no facility to afterwards strip
the attachment but keep the mail.
So how do I change my Outlook 2003 settings so that I do not save the
attachment when sending mail?
To strip the attachment open the message from your Sent Items folder
rightclick the attachment and choose Remove. Save and close the message.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Navigation Pane Tips & Tricks
-Create an Office 2003 CD slipstreamed with Se...i need to repair the office 2007 and i have lost my CD
Due to some system problem my ms word is not working and i am not able to use
work and outlook. unfortunate;y i have lost my office 2007 cd so pls adivse
me how can i repair it
"Jatin chopra" <Jatin firstname.lastname@example.org> wrote in message
> Due to some system problem my ms word is not working and i am not able to
> work and outlook. unfortunate;y i have lost my office 2007 cd so pls
> me how can i re...Lost toolbar
I have closed the toolbar in Excel 2002 that shows the current cell address
and the complete line of text if the cursor is on a cell that contains text.
Any suggestions to open the toolbar would be appreciated.
Hi, Roger. In Excel, click on View | Formula Bar.
Roger Bedford wrote:
> I have closed the toolbar in Excel 2002 that shows the current cell address
> and the complete line of text if the cursor is on a cell that contains text.
> Any suggestions to open the toolbar would be appreciated.
...column with UNIQUE and NOT NULL equivalent to a PRIMARY KEY ?
If a table column has UNIQUE INDEX and has NOT NULL property, is it
equivalent to a PRIMARY KEY column?
I guess the answer is yes if we ignore clustering (PK = Clusterd,
While other indexes may not be clustered)
Any idea is welcomed
You are mixing up logical and physical constructs.
Keys are a logical construct, just an expression of the behavior you want.
Physical constructs are the actual method of implementation.
If you declare a primary key, SQL Server will implement that with a non-null
unique index. The default is to make it a clustered...Outlook 2007. Help to recover lost data?
I have googled and come up blank, ish.
My Windows XP pro installation had problems and I couldn't get it to
run properly. It would halt on startup just where it should display
the choice of users to log on as. So rather than destroying data by
trying to repair XP or doing anything to it, I removed the untouched
(sata) drive, put a new one in and made a new install of windows.
Fully patched. Thats better, it needed that.
The old drive was replaced in the machine as one of the data (slave)
connectors and reads OK as drive F. I can explore it and pull any file
off of it. Almost.
...SECONDARY AXIS/series next to column
I have a chart with a secondary axis
the series related to the first axis = column
the series related to the secondary axis = XY scatter
the problem is that (most of) the series (and labels) related to the 2nd
axis are next to the column instead of in the column/above the column (of the
series related to the first axis)
thanks for your help !
...Internet e-mail to a public folder
I've setup a public folder with an SMTP address associated
to it. I've also set "anonymous" permissions to the
public folder to "contributor." Everyone in the corporate
address list can send to this folder but Internet
addresses can't. What am I missing? Our WebFOCUS server
uses SMTP addresses to send reports and I'd like to have
it populate this public folder. Thanks!
That is all you need to do to allow email into a Public folder. Are you
getting an error when sending to the folder? Could you please post the
details of how mail is being sent fr...Excel 2000... Missing row and column designators.
do you mean 'Tools - Options - View' and check 'Row/Column headings'
"Clarence" <email@example.com> schrieb im Newsbeitrag
...Using one column to trigger an other
I know very little about spread sheets as you will soon learn. I am making
a spread sheet to sort a grocery list for two different stores by aisle and
department. The items to be sorted are in column A, the quantity to
purchase in column B, the aisle #s in column C for one store and D for the
other. I want to be able to impute in Column B and only sort the imputed
cells row in Column C and D. This will produce a printable list of only the
item want in a sorted list for either store. I have the spread sheet and
can sort each column but when I sort it I also get the un-marked rows of
colum...change column name from letters to numbers?
I'm importing a 3rd party CSV file into Excel and then comparing some of
the contents to a printed spec. Each numbered field in the spec
corresponds to a column in the work sheet. I'd like to change the column
headers from letters to numbers. Is that possible?
Tools-->Options, General tab. Check the R1C1 Reference Style.
"Jerry" <firstname.lastname@example.org> wrote in message
> I'm importing a 3rd party CSV file into Excel and then comparing ...Go to Last in Column
How can I make the the last non empty cell in column "A" active
Message posted from http://www.ExcelForum.com
"Dave Matthews >" <<Dave.Matthews.email@example.com> schrieb
im Newsbeitrag news:Dave.Matthews.firstname.lastname@example.org...
> How can I make the the last non empty cell in column "A" active
> after Sorting?
> Message posted from http://www.ExcelForum.com/
...interstore transfer lost in HQ
We have had an ongoing problem though all the RMS versions with inter-store
transfers not completing from the sending store to the receiving store.
The tell-tale symptom is the sending store will send it through the HQ
client and will show up in the PurchaseOrder and PurchaseOrderEntry tables,
but the receiving store never gets the transfer, so their corresponding
entries never show up in the PurchaseOrder tables.
I think that the cause of this problem happens when the sending store gets
delayed while uploading the HQ Client, so by the time the transfers gets into
HQ, the receiving sto...leave left column in place as you scroll to the right
I've noticed on spreadsheets that have been sent to me that there is a way to
be able to leave the left-hand column (column A usually) showing even as you
scroll right through a very wide sheet. The obvious benefit is that it
leaves the ROW definition showing at all times.
Can someone tell me how this is done?
Select cell B1 and choose Freeze Panes from the Window menu.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"AccessNewbie" <AccessNewbie@discussions.microsoft.com> wrote in
news:E18535AE-...Delivery status notification not sent to external users
When external users send messages with the "Request Delivery Receipt.."
option, the message is delivered successfully, but a DSN success message is
not sent back to the sender.
Delivery receipts are generated correctly on messages sent between internal
users. External users do recieve NDR's for mail that is mis-addressed and
also receive read receipts correctly.
Under Global Settings, Internet Message Formats, Default format (that is the
only format), Advanced tab, I've selected the Allow Delivery Reports option.
I've tried toggling the settings on this tab in b...Adding columns to "Look Up Records" window #3
In certain places in CRM (specifically highlight a Lead, click New Email, and
press the looking glass lookup button to the right of the To field) when I do
a Lookup for contacts or accounts, the window "Look Up Records" appears with
a list of entities at the top, a search field, and two lists below. The left
list is available records and the right is selected records.
The Available Records list only displays a single column, the name of the
account or contact. I want to display more columns, and scollbars are OK.
My specific issue is that I have 4 "Rick Johnson" c...lost toolbar in Microsoft Word
after printing an Excel spreadsheet my toolbar in word disappeared. Does
anyone know how to get it back? I would really appreciate some words of
> after printing an Excel spreadsheet my toolbar in word disappeared.
> Does anyone know how to get it back? I would really appreciate some
> words of wisdom.
Really? Gee, that's just too bad. Now, what was your Publisher-related
Facon - the artificial bacon bits you get in Pizza Hut for sprinkling
Hi Aggie5250 (Aggie5250@discussions.microsoft.com),...Interstore Transfers getting lost
We have the problem that sometimes a HQ generated Interstore Transfer gets
lost- So the Receiving store has the Tranfer but the issuing does not. They
also do not show up in the HQ E´vent Log. Any idea?
RMS Distribution Europe
We've encountered similiar problems with Interstore Transfers generated at
the local stores. Our problem was related to the fact that our Inventory
transfer order numbers exceed the 14-character limit.
The transfer order number field actually accomodates more than 14
characters, but RMS appends additional characters in the backend. ...Lost Toolbar
I have Microsoft Office 2004 for Mac. I think I moved my standard
toolbar off of the screen and I cannot find it for the life of me.
Please help! How can I get it back so that I can see it? I've fumbled
around with the customize toolbars menu for hours and I'm thinking
maybe it is something wrong with my templates. I'm so lost. Please
In article <email@example.com>,
Innokenty Pyetranker <InnPye@gmail.com> wrote:
> I have Microsoft Office 2004 for Mac. I think I moved my standard
> toolbar off of ...Formula to Get the Max of a column and its definition
Let's say I have two columns...
Column Z = Product Name
Column B = Reject Quantity
Problem: Using Sheet2, How can I have the Max value of the Column
(from Sheet1) and have its Product Name from Column Z? Remember, th
Sheet1 table is modified every now and then so the max value of B migh
be different in every minute.
Desired End Result:
Reject Quantity Product Name
Please help me on this....
Shadow_Otixz's Pr...Copying Text from Access to Excel
When I paste text from Access to Excel, not all of the data displays in
Excel. Is there a limit to the amount of characters or is there a formatting
I'd play around with different ways to copy.. There's a strange, and
documented, behavior when copying from worksheet to worksheet... If you copy
the entire worksheet (click the square to the left of col A) and try to paste
it to another, any cell with more than 255 characters will be truncated. BUT
there is no such limit on the cells themselves. If you write a macro to
individually go to each cell you can copy the full t...Lost the news button
Hi all. I followed the instructions to add "news" to the GO menu. Then it
disappeard. And when I tried to redo it, "news" wasn't an option in the
toolbar mod procedure anymore. Any idea how to get it back? For now I just
open OE to read news manually. TIA
I'll assume your version is Outlook 2003.
To get the News command back, go back to the Programs tab in Control Panel |
Internet Options and change the default newsreader to Outlook Express. If
OE prompts you to make it your default newsreader the next time you launch
it, clear the "Always perform...