Deleting Names in Excel 2003
How do I delete names (name ranges) all at once, rather then having to do it
On Wed, 5 Jan 2005 19:25:06 -0800, steve_nelson
<firstname.lastname@example.org> wrote in
>How do I delete names (name ranges) all at once, rather then having to do it
Dim myName As Name
For Each myName In Names
Qualify Name as required: Application, Workbook, Worksheet. Unqualified,
Names will refer to ActiveWorkbook. See Help: Names Property
(<mk:@MSITStore:C:\Program%20Files\Microsoft...Overflow error on calculate field in query
Hi all Access Gurus:
I am calculating field (actual a percentage based on the values of two other
fields in the query) and am getting an overflow error when I try to sort on
this field after the query has been displayed. If I do not try to sort on
this field after the query has been displayed my calculation displays the
My calculation is:
In the table where [Good] and [Bad] come from they both have the data type
Number (field size double).
Can anyone please tell me how I can prevent the overflow error? I don't see
ho...Left Join query not working in Access 2010
I have a query that works correctly in Access 2003, but not in Access 2010.
Here is the SQL:
SELECT qrySysSelectEeSS.EmployeeID, qrySysSelectEeSS.Name,
qrySysSelectEeSS.ListOrder, Sum(IIF(tblPRItem.Preserve,1,0)) As
CountOfPreserved FROM (qrySysSelectEeSS INNER JOIN tblPRItemPayWork ON
qrySysSelectEeSS.EmployeeID = tblPRItemPayWork.EmployeeID) LEFT JOIN
tblPRItem ON tblPRItemPayWork.EmployeeID = tblPRItem.EmployeeID WHERE
((tblPRItemPayWork.RunTypeID = 44) And (qrySysSelectEeSS.Active=True)) GROUP
BY qrySysSelectEeSS.Name, qrySysSelectEeSS.EmployeeID,
qrySysSelectE...Convert Excel to XML
What's the easiest way for me to convert excel to XML without getting extra
markup (cause I noticed that happens if you save your file as xml).
I'm looking for a way to take like the headers in my spreadsheet, and use
those as xml tags, and then the data in the cell is what goes between the tag.
Is their an expansion pack for this or something?
I am a novice in Excel. I have a excel file with 20 to 25 sheets, is it
possible to use Ms-Query to filter the data from the same file show in a new
worksheet of the same file. And the query should contain nearly 10 to 15
Is it possible, if it is kindly help me how to filter the data with Ms-Query.
thanks in advance.
...Formula query #2
I am trying to identify a formula which will add and then display th
number of times a number appears in a range.
For example, the range looks like this
The numbers which appear in the applicable range e.g. 1110, could b
any number between 1110 and 9999 and as such I cannot simply predefin
which number to look for.
I am hoping the output could like as follows:
4.....98 to xp excel
ive been doing work on excel on 98 brought a new pc running xp when i put my
floppy in and try to open its all jumbled up can anyone help?
How did you open it?
First, copy that file from the Floppy to the harddrive (using windows
explorer). Then open, modify, save there. Then use windows explorer to copy
back to the floppy (if required). (Working directly off removeable media is a
Try opening excel, then file|open your file to see if that helps.
And if it doesn't, go back to the old pc and get a fresh copy and test it out
(from the harddrive).
>...To Query or not to Query??
Hello all -
I'm a newbe to Access but have made great progress. I'm using Acess 2003. The
db is up and running prefectly. Now I need to tackle the reporting. I have
seen posts about reports and queries and am a little confused. Do I need to
create a query to run my reports off of? I have a tabbed subform in the main
form. There are seven tabs breaking up all the services we provide. Like
"Promo Items", "Leads", "Client Printed Material","Internal Print Material"
and so on. The main form has the User, Branch and Marketing Rep.
I need to...How do I print a textbox in Excel?
...Excell will not take data
I am working on a file on the excell program and it will
not accept data. It is as if the cells are blocked but I
can't even bring up a new sheet. As a matter of fact, I
can't even use my Word
have you tested your file is not protected?
Do you get an error message then you try to enter data? If yes whcih
one do you get?
Alicia Contreras wrote:
> I am working on a file on the excell program and it will
> not accept data. It is as if the cells are blocked but I
> can't even bring up a new sheet. As a matter of fact, I
> ...Updateable Query
Why can't access just read my mind. It would be easier.
I have 2 table
tblStudents-Stores Name, ID#s, Ethnicity, Etc
tblTests - Stores which particular tests the students should take Math,
Reading, Science Etc.
Currently tblTests is empty. I would like to set up a query that links the
tblStudents with tblTests via the LocID number with all records from
tblStudent showing. LocIDis the primary key for both tables. When I tried
to link them it makes the query uneditable. I looked on the site and tried
to include all the fields from tblTests and only last and first name ...Selecting Maximum Values in a Query with joins to other tables
I'm having difficulty with a query and hope someone can help me out.
Basically, I'm looking to select the maximum amounts from a table based on a
column in one of the tables named StateID.
It works fine when I do this:
SELECT TOP (100) PERCENT dbo.Bids.StateID, MAX(DISTINCT dbo.Bids.Amount)
AS Amount, dbo.States.StateName
FROM dbo.Bids INNER JOIN
dbo.States ON dbo.Bids.StateID = dbo.States.StateID
GROUP BY dbo.Bids.StateID, dbo.States.StateName
ORDER BY dbo.States.StateName
However, when I start to join fields from other tables in...web query query!
I've developed a worksheet that retrieves external data from a web page
(stocks & shares info).
At the moment I display the data at a certain cell in the worksheet so other
cells in the sheet can calculate values of my shares.
As I don't need the all the external data to be viewed (I only need one
values), is there a way to extract the data I need from the web query
without displaying it all in the worksheet?
Thanks in advance
...Requery a parameter query
I have a main form with a parameter query as the recordset. There is a
worksheet embedded on the main form as a subform. The data in the worksheet
(subform), upon running an update, alters the data of the underlying table,
from the underlying query, of the main form. Basically, the worksheet updates
the data on the main form.
When the user initially opens the main form, parameters are entered. I would
like to be able to update the data, while retaining the parameters that were
entered when the form was opened. I don't want the user to have to enter the
parameters again eve...IIf works in query but not in report
Does the IIf function work differently in queries from the way it works in
For example, this works in a query:
(I can hid the last name "Smith" in the lastName field.)
However, I cannot use the same IIf as a control source in a report. It
generates a circular reference error message.
(If the name is not "Smith", then print it.)
Is this just how IIf works?
I am trying to create a new field in which it shows the sum total of 10
fields (Charge Time, Charge Time 2, Charge Time 3, etc.); what is the easiest
way to do this?
NewFieldName: [Charge Time] + [Charge Time 2] + [Charge Time 3] .... etc
> I am trying to create a new field in which it shows the sum total of 10
> fields (Charge Time, Charge Time 2, Charge Time 3, etc.); what is the easiest
> way to do this?
I tried this, and it doesn't work. Is there something I'm forgetting?
...Microsoft Map ...
Does anyone know what happened to the Map that used to be
an option under Chart in Excel 97. We are now using
Office XP, the help says it's an Add in. My company
insists that the installation was a complete on. Any
Microsoft removed this feature in Excel 2000 or XP, in favor of
MapPoint, which I understand is something that must be purchased separately.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Sharon R. wrote:
> Hi all,
> Does anyone know what happe...Using a query as base for report
I have created a table where I run a query picking the columns I want in the
query. From the query, I create a report.
My question is this: Whenever I open the report, I want it to show only the
open items. Example: My query has 10 columns, when ALL the fields are
populated, the record is complete and does not need to be in the report (i.e.
open items report). If the 10 fields are NOT all completed, it's still
considered opened and will be on the report when it is run.
I think I'm thinking too much about it and making it sound harder to myself.
Can you please...Excel work sheets
I need a formula that will automatically pull information from one worksheet
I need to be able to seperate all of the plans, procedures ect from the main
work sheet to there own.
I have no idea how to do this, so any help with be appreciated.
You don't provide enough information for anyone to help you. Pulling
information from one worksheet to another is fairly simple. But what
information? Where is it? Where do you want it to go? You say "to their
own". How is the destination identified in the source sheet? You have t...down loading EXCELL
A management company in Calfornia needs to send me reports
here in Colorado.
They use excell, I don't know what version they use. I
don't have excell on my computer. Do I need to install the
same version they have? Is there a charge to install
Excell on my computer?
You cannot download excel to your computer. You must buy it. If they have a
newer version than yours, there MAY? be problems. If you do not need to do
anything but view the workbook you can get a FREE viewer from the microsoft
Granite Shoals, TX
"Richard Or...Query or code?
I have two fields: Category and NumberOfContracts. Category takes 3 values,
call them A, B, and C. For each record there are a number of Contracts
associated with the choice of Category. So my records look like:
There are other fields as well, of course.
What I want is to sum the number of contracts for each Category. I want to
generate a report that looks something like:
Count of All Contracts: 14 Total of A: 1 Total of B: 5 Total of C: 8
Can I do this using a q...Powerpoint chart -> Excel
all the questions I found in the newsgroups was how to paste an Excel
chart into Powerpoint. But that what I want is the other way round: I
am searching for a way to convert a Powerpoint chart (probably a MS
Graph Object?) to a real Excel chart.
Is there a way?
Thanks in advance
...Hyperlink to excel worksheet
This is my first post so I hope you can help me.....
I want to create a hyperlink file from an intranet site to an excel
file on our organisation server.
The excel file is quite large with more than 25 worksheets.
I would like to create a separate hyperlink to each worksheet in the
Unfortunately I can only create a hyperlink to my excel file that opens
at the last point I saved the excel file.
I hope that makes sense and anyone who can help me would be much
Jamie from Australia
Message posted from http://www.ExcelForum.com/
...In crosstab query, how do I count not including duplicates?
I have a table which lists contacts with people including the field
'FamilyID'. I want to count the number of different families the
organisation has had contact during a quarter with a crosstab query. If I
use the Count function it double counts families we have seen twice, so
showing us the overall number of contacts, but not the number of families we
had contact with.
Post your crosstab query SQL and sample data with example of what the output
should look like.
Build a little, test a little.
> I have a table which lists con...backing up Excel workbooks.
At work we have several extensive Excel worksheets. Is there a way to
automatically create a backup of these files?
Thanks ahead of time for any help in this matter.
Here is what I use in addition to the autosave feature
Sub Backup() 'kept in personal.xls & assigned to toolbar button
On Error GoTo BackupFile
MkDir CurDir & "\Backup"
MyWB = .Path & "\BACKUP\" & .Name