input filtered data from table
I have a dbase with 5 tables [Trainees] [Schools] [Mentors] [Subject] and
I have [Placement] set up to accept input from [Trainees], [Schools] and
[Mentors] has relationships with [Schools] and [Subjects]. (Each School can
have several Mentors and each Mentor specialises in a Subject.)
How can I set up [Placements] to input from [Mentors] filtered by [Schools]
Any help gratefully received.
On Fri, 7 Mar 2008 07:41:03 -0800, Obeide115654
>I have a dbase with 5 tables [Trainees] [Schools] ...OWA Login #8
I am having a problem with the OWA login. I have it all set up with a
slash "\" in the domain field. I can log in with the username and
password under Firefox with no problems. But, when I try to use IE,
it continues to ask for login information. The username and password
is not working.
What do I have set wrong?
Thanks for any help you can offer me.
Jeff Grossman <email@example.com> wrote:
>I am having a problem with the OWA login. I have it all set up with a
>slash "\" in the domain field. I can log in with the username and
>password u...Graphic Data Marker in Excel 2007 Charts
I would like to add some pictures as data markers in my line chart using
excel VBA. I tried recording a macro to do this but the code is not generated
for the insert picture part. Does any one have an idea for this.
Create a line chart with 2 series. Then with the chart selected run this
Make sure you change the UserPicture filename to one that is on your system.
' from file
.MarkerSize = 20
' from s...Bring Data from other worksheets....
Good Evening and thank you for looking at my problem....
I have a workbook that is a schedule for a staff of 5.
Each worksheet is a month in the year Oct, Nov etc., then
at the end of this workbook I have a worksheet named Whole
Year. I want to see each respective month on the whole
year by referancing each already filled cell on the
various months. Unfortunatly when I auto sum a specific
cell on any of the multiple months I populates with a 0
instead of "D" or "N" as indicated on the schedules. On
the individual pages I use =IF (X7="",X6,X7) to allow...Exchange 2003 Domain Seperate from User Login Domain
DomainA = Windows 2000, one domain & DC. Users log into this one
DomainB = Windows Server 2003, one domain & DC. Outlook is pointed to this one for mail
*This is was setup this way to keep things seperate and to not modify the existing Windows 2000 domain
Of course the users have to always type in their password to load up Outlook, because the Exchange domain is different from the domain that they log into Windows with. Besides this annoyance, any other problems that I could run into
Yes, if you have a password expiry policy on your 2003 domain the users may
not b...Deleting decreasing data and naming rows.
I have a list of data in columns B:H that I want to delete specific values
The data in column C is in the format example below. The numbers are not
necessarily whole numbers or increasing or decreasing in even amounts. The
example is simplified as each data set can have thousands of streams where
the data increases then decreases, repeating again and again in a constant
stream. I want a data set of numbers that are continually increasing or
restarting the sequence with no decreasing values or zeros.
Searching column C, when the next cell is < the preceedin...Is user login ?
How can I check from service if user is logged to system?
...data duplication in other worksheets
Does anyone know why data I enter in one worksheet, shows
up in other worksheets?
You probably have several worksheets grouped together. Right-click one of
the tabs and select Ungroup Sheets.
"Markus" <firstname.lastname@example.org> wrote in message
> Does anyone know why data I enter in one worksheet, shows
> up in other worksheets?
...I have data in a time series that starts from 0 but i dont want x.
I have data in a time series that starts from 0 but i dont want x axis to
start at zero I want it to start earlier but to not show on the graph
If it is an XY chart, or a line chart with a date scale, you can double
click on the X axis, and adjust the axis minimum scale.
What exactly don't you want to appear on the chart?
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Zoe" <Zoe@discussions.microsoft.com> wrote in message
excel 2003 - office professional.
I have data for water temperature from two reservoirs taken over 5 years. I
want to match the water temperatures from the two reservoirs from samples
taken on the same day as not all samples were taken at the same time. I
therefore have four columns: 1) date of sample res 1; 2) nitrate res 1; 3)
date of sample res 2; 4) nitrate res 2.
There are uneven sample numbers for each reservoir where there was data
missing from one of the reservoirs.
Peter, how do you want to match these two sets of data - not sure I
understand? Can you attach a s...auto hide data
I want to do any of following thing
(1) On day2 when I open excel sheet, data that i entered on day1 in
perticular sheet (say sheet1) should be hidden automatically.
(2) On day2, when I open excel sheet & enter today's date on sheet1,
data entered on day1 should go hidden.
i want to do this daily basis.
Pls also tell me how to unhide this.
thanks an advance
Possibly, all you need to do is Data filter but you may need to use VBA
http://office.micr...delete data bases
I am very new to access and have been playing with data bases and now would
like to delete them. is there a way to delete them from my recent database
Why? The only time anyone would see those is when launching Access from
your PC, and you know which ones have been deleted...
There's a KB article at Microsoft.com that covers how to remove the Recent
.... list from earlier versions of Access (you don't mention which version
you are using) -- KB95569.
Microsoft Office/Access MVP
"mobeer1958" <email@example.com...colors of bar charted data don't follow data after sorting
I created a bar chart that has 14 variables. I changed the color of 2 bars to
yellow, 5 bars to blue, and 6 bars to red. When new data is ploted and sorted
in a desending order. the colored bars don't follow the variable, they stay
in their original location. I have to manualy change the colors to match my
The columns will not be sorted along with you data.
You will be to change the colour of the columns after the sorting.
You can do this manually or with code or with the use of formula and
multiple data series.
For the formula/multi series approach see this explanatio...Conditional Data Validation
So I have two columns of Data Validations:
Column A we'll call Cost Centers
Column B we'll call Accounts
If somebody puts in a Cost Center for a specific department which we
will call Advertising, then a different list shows up in Column B of
only Advertising Accts. I use the following formula in Column B for
my Data Validation:
"accounts" is all accounts and "advaccts" is only advertising
That works ok. I'm sure that is not the best way of doing it; but
here is my ...Plotting point of data #2
lets say 1 have a worksheet and the values are as a sampl
I want to plot a chart that has a point at 3,5 (x,y) labeled 15, and another point at 6,9 labelled 23 what chart do I us
how do I do this
try the following
- first create a XY Scatter chart for columns B+C
- to label these points you may use one of the following Add-ins (as
Excel has no build-in functionality to do this automatically):
> lets say 1 have a workshee...Drop-Down from Data/List box vanished
Using data validation, selecting "list", using "=name" the drop dow
list won't appear. The drop-down list was working just fine til
started to copy the lines with drop-downs, and now it won't make th
drop-downs appear. Other pages in the workbook are displaying drop dow
lists just fine. i've tried protection (unlock) and a few othe
fruitless attempts. I check the "name" for correct reference an
spelling an that is correct Got any Ideas???
The Fruitless Floundere
---------------------------------------------------------------------...Dynamic column chart
I have a column/bar chart that updates every day using defined names. It
shows the last 30 days of data summed together in one bar for 23 different
machines. The first column of the data is the date; the first row is the
machine discription. I want the data to auto sort in the row whenever it is
updated. This will in turn sort my column chart from high to low.
Can anyone help?
...MS Money freezes at login
Hi, I've been using MS Money for about 4 years now and I have been using MS
Money 2007 for over a year now but suddenly it is freezing every time I try
to logon. It takes up about 97-100% of cpu which forces me to close it using
task manager. I don't know why it is suddenly acting like this.
I have tried reinstalling it with no luck. I normally synchronize my money
files with my pocket pc using sbf finance pocket version (since money no
longer offers pocket pc synchronization). Recently my pocket pc crashed so I
had to reinstall all of its programs and it seems like that is whe...How import data???????
Hi my name is Edson, and I need impor data to new entity create for
my, named participante.
The infomation is in SQL SERVER.
I try with DMP but the CDF haven=B4t my entity..
How can I make it???
If I need some software when can I download???
...How to Login
Hi To All,
My application is jest create login id and password and store it
in a file and using that id and password jest i have to login.For that
I created one login dialog box before login iam creating a account
means id and password which is storing in a file.It is running and
storing in a file which i given as id and password.
My problem is when iam using that id and pwd to enter it is
taking as string and showing invalid.
...list with multiple repeated data
Hi, i have a column with a list of numers and letters, unsorted. the
data in this column can be repeated, it goes like this
I Need a way that this codes are copied into another column (col2) but
only once. if the code is 2 or more times in col1 it should be only
once in col2. is there a formula that allows me to do this on the fly
wothout recording any macro? the result shoul look like this:
all the codes are in col1, but they appear only once in Col2
Sorry to bother.
Thanks for all
Data|Fil...External Data Warning Message
I have a question about Microsoft Excel, but I don’t think it’s an issue to
call into the help desk. I have been working today and yesterday on building
a new template for my SAP Part Tracking Process. I finished it up today by
adding Validation Lists [with names], Pivot Tables, and my regular part
tracking tables. When I went to save it as a template, a message came up:
"THIS WORKBOOK CONTAINS EXTERNAL DATA. DO YOU WANT MICROSOFT OFFICE EXCELTO
CLEAR THE DATA BEFORE SAVING THE TEMPLATE, AND THEN AUTOMATICALLY REFRESH THE
DATA WHENEVER THE TEMPLATE IS OPENED?"
I...DATA VALIDATION #48
I have a field asking for a county name. There are 77 possible counties to
enter. I want to ensure that the user enters a valid county and has it spelt
correctly. Is there a way to do this? Can I have the validation point to text
file with all the acceptable entries? Also is there a way to format the cell
to convert anything entered into all upper case?
In a convenient empty column in the workbook, preferably out of site eg a
hiddeen worksheet, enter all 77 County names (laborious I know). Name this
range 'county' or whatever and in your input field go Data Validation,
choo...Is there an Update on the Login Issue???
Haven't seen an update in many hours. Any news??? I
need to run my financial life!!!
>Haven't seen an update in many hours. Any news??? I
>need to run my financial life!!!
>Me either. I can't believe it. I'v ben using Money for
more than five years and never happen to me anything like
...laboratory data model design
Any one of you have any idea about Lab data model design. I am trying to
create an efficient datamodel ( with all different normalized tables ) from
As of now I have one table with demographic data and another table with
'Tests details', one with instrument details( machine on which test is
I am planning to develop mid -level model, i.e is not too simple nor too
Most of the times I see marketing or sales or Academic data model and had
never come across Lab models, are there any URL's to get a quick view?
Thanks in advance