How do I fix this?
I used the Startup tool to setup my application but I unchecked the Menu Bar
and the Shortcut Menu Bar checkboxes. I need to make some changes but I can't
get the Tool menu back.
Hold down the Shift key when you open your database.
"Ayo" <Ayo@discussions.microsoft.com> wrote in message
>I used the Startup tool to setup my application but I unchecked the Menu
> and the Shortcut Menu Bar checkboxes. I need to make some changes but I
> get the Tool menu ba...Need to convert 2002 back t0 while laptop is fixed
My laptop with Money 2002 died and had to be sent in for
service which will probably be about a month. The good
news is that I backup up all my data files the day before
and burned them to CD. My office machine is running
Windows 98 SE and Money 2001 but it will not read the
2002 files. I can't install XP because the machine will
not support it.
I used a friend's machine and can open my backup file but
I don't want to leave my financial data there. Is there
some way I can transfer the data to Excel or save it in a
backwardly compatible format? I tried to synchronis...Listbox columns
I have an access form with a Microsoft Forms 2.0 Listbox which I defined to
have four columns. I am unable to add any item to anywhere apart from the
Listbox7.additem callnum ......works fine
adds to the first column
Listbox7.column(1).additem callnum ...... fails and I
expected it to add to the second column
Can anyone help with the method of adding data to the Listbox columns.
First of all, why are you using the Forms 2.0 listbox? What's wrong with the
one that's built into Access that you'r...column width changes
I have two seperate workbooks (Excel 2000)with exact same
formatting. I save them as Excel 97 formats for use by
colleague with older version of Excel. One workbook is
okay but other will have one column width reduced, which
causes cell to display ####. I've compared the workbooks
one for one and cannot locate the problem. Any help?
The first question I have is what's in that cell? Is it a date?
Excel picks up several date formats from windows regional settings. For
example, if you format as m/d/y and I use mm/dd/yyyy as my windows (8 digits and
2 slashes). If you use m/d/yy,...Fixing column width
I have a spreadsheet in which I have set the widths of certain columns
using Autofit. The problem is that I often have to add to the
spreadsheet by importing data from a text file. Every time I do that,
the column width changes to the width of the new data (which is
usually narrower than what I wanted). Is there a way to prevent that
Assuming you're using the Data, Import Data command, when you get to the
final "Import Data" dialog there is a "Properties" button (in Excel 2003 at
least). One of those properties is Adjust column w...sum column based on single cell match?
This seems so simple and yet the solution eludes me...
In row 2 I want Excel to match a cell's contents (ex: find 3200). Once
finding the column that matches, I want it to sum rows 3:94.
Thank you in advance for your assistance.
Something like this:
In this example, you have columns A-G for your data.
"adodson" <firstname.lastname@example.org> wrote in message
> This seems so simple and yet the solution eludes me...
...Copy column headings AND formula totals to blank spreadsheet
Hi Everyone! I apologize that this was likely asked before but could
someone show me how I can copy my 'column headings, column widths and totals
formula' to a blank spreadsheet tab? I have set up budget spreadsheet where
I input my receipts to keep track of monthly expenditures.
Could someone explain how to copy the column headings, the column widths,
AND the formulas of each column to a blank spreadsheet tab so each month
will contain the 'same headings, same column widths and the same formula for
Thanks so much for any help!!!
Assuming you alr...A scatter plot with a 2 column data source
I am using the Series tab (i have done a scatter plot) - i have put in 1
series of X and Y data. then i extended the "x values" data to include two
columns of data. the scale is now different and my graph is in 2D still, i
am wondering what relationship is now being described by my scatter plot.
Excel doesn't know how to interpret your two-column X values, so it uses the
values it always does when this happens: 1, 2, 3, etc. Excel uses these
counting numbers if the X values consist of text (even a single text value
in the range), or if no X values are even s...Row and column Headers formating
When I open a particular workbook i always find the
headers are strikethrough, I need a help on how to remove
this strikethrough, note this is not on the cells but
rather on the headers i.e A, B , C etc
This is set via menu Format/Style/Normal.
Message posted from http://www.ExcelForum.com/
Check out Format>Style>Normal. Modify the Font to eliminate the
Gord Dibben Excel MVP
On Tue, 15 Jun 2004 23:40:53 -0700, "Salim"
>When I open a particular workbook i always find the
>headers are ...The great disappearing hot fix
Has anyone experienced anything like this?
Yesterday, one of our users complained to me about some quirk in GP eConnect
processing that I had thought we fixed in December of 2007 via a Hot Fix to
Well, when I checked our server it was as if the hot fix was never installed
(the eConnect release version was the basic 22.214.171.124, instead of 126.96.36.199). The
Hot Fix was also missing from Add/Remove Programs.
I went to reinstall the hot fix, and when the install program started it
gave me the option to either Repair or Remove the hot fix. So, something was
still present tha...Selecting a Range of Columns for Variable Rows
I want to do something like this:
Select a sheet
for row=3 to 17
select cells A:F
copy the cells
Select A2 on another sheet
Paste what I copied.
Shift down 1 row
I have verything down pretty well except selecting A:F for each row as it
I would appreciate any help you can give me.
It would be helpful if you post the code you have so far. It helps to fill
in the gaps in your narrative.
"BillR" <BillR@discussions.microsoft.com> wrote in message
>I want ...Cell Box - one of the 4 cell lines is open
What was the set of search "words" to find the answer... please? I have
spent an hour. ( I don't want to tell you that I spent more time -
mentioned). Oh yea!
The lines are call borders and are part of cell formatting.
Format > Cells... > Border > Outline > OK
Gary''s Student - gsnu200826
> What was the set of search "words" to find the answer... please? I have
> spent an hour. ( I don't want to tell you that I spent more time -
> mentioned). Oh yea!
No worky. Excel 2007 - home tab - cells (ins...how do I transpose columns and rows
I have a spreadsheet as follows:
DonorId Date Amount
1 5/4/04 100
1 7/5 04 50
2 1/5/04 200
I'd like to change it to:
DonorId Date Amount Date Amount
1 5/4/04 100 7/5/04 50
2 1/5/04 200
There are about 3,700 rows and the number of dtes per donor vary.
Any ideas oon how I can do this?
You could add a column to your table, to count the donation occurrence,
then use a pivot table to summarize the data.
For example, in cell D1 enter the heading DonationNum
In...Combination of text in 2 columns
Have a list of names--
first cell contains FirstName, MI; second cell contains LastName;
Need to combine data into 3rd cell;
output of 3rd cell:
What is the easiest way to do this??
Thanks for your help!
Maybe this with your names in A1 and b1
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
> Have a list of names--
> first cell...Error importing dates from fixed width txt files
I'm trying to revise an existing Import Spec to include new fields added to a
fixed width text file. If I import without making any revisions the dates
import correctly. They are on the file as CCYYMMDD and the data field in the
Spec is Date/Time and I've deselected 4 digit year. My new date fields were
added to the text file as YYMMDD and I select Date/Time data field for the
new fields. However, with the revisions made adding the new fields none of
the date fields import now with the revised spec.
Another user created the spec and we're both using Access 2003 with th...Excel Column Charts
I am looking at trying to create a dual column chart which contains 8 sets of
data, four of which are for plan data and four are for the actual data. Is
it possible to create two combined columns, one for each set of data on the
one graph. I cannot find any information to achieve this. Can anyone help.
One approach would be to plot two series, one for plan, the other for
A [data] [data]
B [data] [data]
C [data] [data]
D [data] [data]
Select the range, create a clustered column chart. Each cluster will have
two columns, pl...Formatting an Excel column as a hyperlink
In my application I create and format Excel files using Excel automation.
Is there a way to format a column in a spreadsheet as a hyperlink using
Visual Basic? For example if a column contains the text
j:\images\myimage.tif, can this be formatted as a hyperlink when the Excel
file is being created and formatted?
I forgot to mention that I'm creating the Excel spreadsheets using VBA
inside of my Access application, so that's why I'm asking it here. I'll
also try the Excel newsgroup as you suggested.
"Pete D." <pduffy211@CAPS_AREcox.n...how do i setup a database that columns add up at the end of the we
i am new at this so please send me any info to email@example.com
Most people might say put a formula at the bottom of the list of numbers.
For example, you have numbers in column B and they go from row 2 to row 154,
in B155 (or anywhere else, pretty much), you could put this formula:
The 'problem' with that is that you can't just add to the bottom of the
list, you have to keep inserting rows to push that formula on down the sheet.
Try putting a SUM formula near the TOP of the column. Let's say you have
the title for a column in row 1, then you sta..."Click to add" column in Access 2010
In Access 2007 you are able to right-click on the "Click to add" column in
Datasheet view of a table and hide it so that it's removed from view. Cannot
find where I can do that in Access 2010... Are we stuck with that annoying
extra column remaining in the view? :) My users will be using a form to enter
data, so it's not that big of an issue, but I'd like to hide it if possible.
If anyone knows a way to hide/remove it, please pass the info along.
If I recall correctly, that only shows when you/your users are working
directly in the ...Fix
What does the word FIX mean on Excel 2000? It is in the lower right
hand corner 3 boxes away from NUM, 4 boxes from CAPS.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
It means you have turned on fixed decimals places under tools>options>edit,
so if you have 2 fixed decimal places and enter 20 in a cell it will change
into 0.2 Just uncheck it if you don't want it
"zacharias" <firstname.lastname@example.org&...Fixed Assets Quick Links
Does anyone know why I cannot customize the homepage with links to Fixed
...Negative NBV in Fixed asset module
Does anyone konw why negative NBV will be happened in the fixed asset module
and how to avoid this happen ?
example like the asset cost 10,000 but it total deprecation amount (fully
deprecaited) is 15,000.
I am still unable to get into hotmail. I've tried several attempts at fixes
that were on the intranet but to no avail.
pbrown said the following on 11/11/2004 2:09 PM:
> I am still unable to get into hotmail. I've tried several attempts at fixes
> that were on the intranet but to no avail.
Unless you are not a MSN Premium customer, you are no longer able to
access Hotmail mailbox using Outlook. There are third-party utility
that can allow you to retrieve Hotmail mails.
This posting represents my own opinion, and in no way cl...how to merge data from multiple columns to one column #2
I have first, middle, and last names in A, B, and C. I want to merge
everything into A. Ho do I do that?
In column D use the formula
=A1&" "&B1&" "&C1
The " " would put in your spaces in between the names.
Then go to column D & do Edit Copy, move to column A & do
Edit Paste. Then you should be able to delete columns B,
C & D.
Hope that helps!
>I have first, middle, and last names in A, B, and C. I
want to merge
>everything into A. Ho do I do that?
=CONCATENATE (text1,text2,....Why rows get larger when move a column?
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
Sometimes I move a column and then ALL THE rows in a workbook become very large and equal in size. Happens all time. why? thanks.