Find MAX data in sheet (Cell)
How would one go about finding the cell that contains the MAX info, o
say any/all cells that exceeds 8,000 characters/spaces in a Excel page
confuzedagain's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2943
View this thread: http://www.excelforum.com/showthread.php?threadid=49148
1. Highlight the entire document
2. Select Format->Conditional Formatting
3. Select "Formula Is"
4. Input this formula
5. Format with something obvious like green bac...How can I access a public calendar from a custom form
I am trying to create a custom form that would allow a
employee to request a vactation time frame. This form
would then be mailed to a supervisor who could approve or
disapprove the request. I am having difficulty getting
the response posted to a public calendar vs. the managers
private calendar. Help! -Jeff
...Outlook 2007 doesn't appear in Set Program Access and Defaults
I just installed Office 2007 Pro but for some reason Outlook 2007
doesn't appear in my "set program access and defaults". Outlook
Express appears as my only option and Outlook Express appears in the e-
mail slot on my start menu. Any ideas why?
You must uninstall any prior version of Outlook and re-run setup using a =
custom installation and make Outlook available.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching...from access 97 to 2003
I am after converting a database, in work, from access 97
to 2003. I am on work experience and i have to get this
done soon. In the conversion error table. i got error -
1611: Could not find field 'Description'. I know this
might be basic but i am only a student and learning.
Please copuld ye help. What does this mean????????
"Eoin" <email@example.com> wrote:
>I am after converting a database, in work, from access 97
>to 2003. I am on work experience and i have to get this
>done soon. In the conversion error table. i got error -
>1611: Could not find...Export data in XML through Web Services
I have a WebMethod that retrive data from a DB and I want to return this
data in a XML format.
I try to do with the TextWriter class but I wasn't able to do, because I
didn't found any example thet explain how to use the Stream attribute.
Can I use the TextWriter or I have to use the XmlDocument class?
Thanks in advance
can you show us the code now, and
show us what you are getting on the wire
and show us what you would like to get on the wire?
http://www.15secon...Search box within access or third party addon to do such?
I have an access database with 6 columns. I am putting in an
inventory of all of my items with their corresponding sizes and
weights, etc. I will have over 2000 lines/records when I am done.
What I want to do, is either create something withing Access, or find
a third party add0on, that will allow me to search within the fields,
and return the corresponding results
here is what I have for example
category style size width weight notes
sample 1abc 5 2.2 2.1
sample 1add 3 2.5 2.1 for turning
stock 3bbb 3 ...Help, urgent, connection to access database
I met a problem about access database connection.
I have a program reading data from access database through ODBC.
When the access database located on local server, and created ODBC
linked to local database,the program runs without problem, but if it is a
network shared database, and created ODBC linked to the shared database, the
program prompts error: "workgroup file is missing".
Yes, I used workgroup file in current database and set correct security.
So what's the problem? is problem of the ODBC drive?
you should not be using ODBC
Access stop...Access 97 to Access 2003 DataBase conversion 08-30-07
We work in a mostly french environment. We have a standard image using MUI
Microsoft products (XP and Office 2003 are MUI) Since the convertion of an
ACCESS 97 BD into Access 2003, we experience a sort sequence problem when
DoCmd.Openform or DoCmd.ApplyFilter
A selection on a name like "Cot�" will return no record. Asking for "Cote"
will return all records including "Cot�".
I suspect a problem with MUI (multi-user interface) but I did not find any
recommandation at Microsoft.
"Jacques Tr�panier" <firstname.lastname@example.org>...new to making forms on access
I have a table whihc has column name title and some survey question.
Now i want to create a form so that when i select Name ( I guess this will
be combo box) I dont know how to do that even where i can select name ? but
when i select name the person title auto populates and so does the relevant
answers to the questions
for example i choose John and the title should auto populate and question 1
should populate also and so on but if i pick adam then everything related to
Your help will be really appreciated
The table look like this
Name Title Qu...data labels in charts
This is a probably one of the simplest questions but I'm just starting to
I have entered a category title "year" in cell A1 and entered from 1995 to
2000 from A2 to A7 that I want to appear on the horizontal axis. I have
entered a title in B1(unemployed) and 5 values B2 to B7 directly below. When
I choose a "column" chart my vertical axis appears correctly but the
horizontal axis does not include the years as labels. The labels that appear
are the numbers 1 to 6 instead of 1995 to 2000. How do I make the chart pick
up the data labels from colu...Access / System crashed while generating report
I'm on XP PRO w SP3 running Access 2003 via Office XP Pro.
I was creating a report using the report wizard and Access and XP Pro hung
up. I waited 5 minutes and the system was still hung up. I then manually
powered down the computer.
When I get back into my Access project, I immediately receive the error
message "The report name 'Report1' you entered in either the property sheet
or macro is misspelled or refers to a report that does not exist. If the
invalide report name is a macro, an Action Failed dialog box will display the
macro's arguments ...data extraction from excel
I need to pull information from one collumn. If the collumn is comprised of
yes's and no's, can excel create a list of just the yes's?
Try something like this:
Assuming your list is in A1:B100, with
D1: Question (the same col heading as A1)
E1: Response (the same col heading as B1)
Select your list (A1:B100)
List Range: (already selected)
Criteria Range: C1:C2
Click the [OK] button to filter the list in place.
To copy the matching records to another area:
Click: Copy to another location
Copy...Import Adobe Form into Access for Report
I am trying to import a PDF into Access to use as a report and populate the
fields with a query I have created. I can not find any help in getting this
Can someone help me?
...QUESTION- Simpler Way to Add a Data Series to Other Graphs?
I'm using Excel 2002 and I've got a lot of XY (Scatter) graphs.
When I add a new data series to one graph, it is defined by 3 values
(Name, X Value and Y Value)
If I want to add this data series to 7 or 8 add'l graphs, I know that
I can copy/paste these 3 values to each of them.
Is there a simpler way to accomplish this?
...pasting excel data in a powerpoint slide
I am attempting to paste an excel data table in a powerpoint slide but once
pasted, the data is cut off. If I double click and enter the excel data
table and resize the window from Powerpoint, the same data shown simply
stretches to the new size. I have tried numerous ways of pasting from the
excel sheet and it still acts the same. I tried a new workbook and was able
to resize correctly. But to recreate all of the data and formulas in a
different workbook would be difficult. Is there a setting or something in
excel that is not allowing me to resize this particular workbook?
Thanks...Excel 2007 chart color change based on the label.
I have 12 charts 1 for each person and the data changes every week and
some of the values have 0 so are filtered out. On the chart I want
0-15 to be blue, 16-30 to be light purple, 31-60 to be a cream color,
61-90 to be light blue, and 90+ to be dark purple. With the code
below I can change the color if I take the if statement out but I
would like to change the color based on the label. I have tried
several things like .text, .name, and .label. I just can't fine the
For i = 1 To A...many sheets from "master data"
In the last few days, ive posted some questions with some success, bu
not being able to completely work though my problem. Given that I a
novice/intermediate in relation to VBA, I am having extreme difficult
augmenting the code to do what i like.
Attached is the file so you can visualize what I am talking about.
What I want to do is to put each "page" of data on a new slide. As yo
can see, all the data is found on the first page. In column T, you ca
see where each new page starts (as indicated by the data and pag
I having trying tirelessly to get the code su...Create field from append query based on linked table name
Here's the setup:
Two linked tables called 'PHD' and 'XANS' bring in daily data from two
A union table-query puts the common data in both into the same name
fields. This table-query is called 'SOLS_DATA_MERGE'. I then created a
new table called 'SOLS_MAIN' and I ran an append query called
'SOLS_DATA_APPEND' to append the data in the table-query,
'SOLS_DATA_MERGE' into the new table, 'SOLS_MAIN'. The main reason for
this was so that I could assign my data a primary key.
Even though I have achieved my goal of merging the da...Prevent equation from skipping data when referencing import data?
I am referencing data that is being imported from access in table on a
seperate worksheet. When the data is refreshed, only the last new entry is
placed in my seperate table, not all of them. How do I fix this?
...Input formulas in a defined data range and convert results as valu
I have a dataset for users to view data. It has the following format till
year 2010 and have portions of topics like forecast, shipment, aging .... and
the whole dataset can go very long vertically. Within each topics is the type
of products measured, below is an extracts of my dataset:
Forecast Accuracy Jan 2007 Feb 2007 Mar 2007
Prod A x x
Prod B x x
Prod C ...Updating .nsf lotus notes server file
Using the below code i can fetch data from the .nsf file kept in the server.
Dim LotusWizard As DAO.Recordset
Dim session As Object
Dim notesdb As Object
Dim notesView As Object
Dim NotesEntry As Object
Dim notesdoc As Object
Dim Item As NotesItem
Dim doccollection As Object
Dim datetime As NotesDateTime
i = 0
Set session = CreateObject("Notes.NotesSession")
Set notesdb = session.GetDatabase("Server", "path\file.nsf")
'Check if open
If notesdb.IsOpen = True Then
...2002 data merge
I have a database of 50 names that I would like to print out as individual
labes on a standard 81/2" X 11" sheet of paper. I would like 10 labels per
page and can work out the page layout in Publisher 2002. When I go to merge
my Works database of the 50 names, I obviously only have one "field" to
insert. As you can see where this is going, when I do my merge, I get a
sheet with 10 labels of the same name. How do I get it to merge a different
name in each label? I went to the following websites:
and...HOW TO EXTRACT (or lookup) DATA FROM A PIVOT TABLE
This is a multi-part message in MIME format.
Sheet 1 contains the raw data. Sales and cost of sales for customers.=20
Sheet 2 contains the pivot table that summarizes the data in sheet 1.=20
In Sheet 3(a further summary of the Pivot Table), I would like to put in =
the customer name and extract the related sales and cost of sales =
numbers from the pivot table. How can I extract the desired information?
------=_NextPart_000_000...Pivot Table accessing data from OLAP cube
I am creating a Pivot table using OLAP cube (in Excel 2007) on Windows
Server 2003 OS and same Pivot Table using OLAP on Windows XP. The wierd
problem i am facing is that on Windows Server 2003 OS, the moment I finish
importing the cube, it shows me a screen like "Drop Row/Column Fields here"
and on Windows XP, it simply shows the structure of Pivot table.
Secondly,on functional side, if I email this spreadsheet across (created on
Windows XP), then the other person is not able to edit/modify it, getting a
warning message "Initialization of the Data Source faile...web-based authontication
I have a problem with the web-based outlook, and it is basically when a user
wants to logoff, he/she is asked to enter their password. The same thing
happens when the user click a link in a message.
Can somebody tell me what kind of setup I need to do in Exchange to allow
users to click different links without having to authonticate them after
they have already done that when they logged in to the application?
BTW, I use Exchange Server 2003.
Thanks in advance.
Rabih Najib wrote:
> I have a problem with the web-based outlook, and it is basically when a user...