input filtered data from tableI have a dbase with 5 tables [Trainees] [Schools] [Mentors] [Subject] and
[Placement].
I have [Placement] set up to accept input from [Trainees], [Schools] and
[Subject].
[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]
and/or [Subjects]
Any help gratefully received.
On Fri, 7 Mar 2008 07:41:03 -0800, Obeide115654
<Obeide115654@discussions.microsoft.com> wrote:
>I have a dbase with 5 tables [Trainees] [Schools] ...
OWA Login #8I 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
Jeff Grossman <jeff.nospam@stikman.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 ChartsHi,
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.
Regards,
Mohan
Hi,
Create a line chart with 2 series. Then with the chart selected run this
routine.
Make sure you change the UserPicture filename to one that is on your system.
Sub MyMarkers()
' from file
With ActiveChart.SeriesCollection(1)
.Format.Fill.UserPicture "C:\Waterfall.jpg"
.MarkerSize = 20
End With
' 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 DomainDomainA = 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
Thank you
....D
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
within.
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 worksheetsDoes 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.
--
David Hager
Excel MVP
"Markus" <anonymous@discussions.microsoft.com> wrote in message
news:0dce01c398a2$ea5ca590$a101280a@phx.gbl...
> 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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"Zoe" <Zoe@discussions.microsoft.com> wrote in message
news:006FF703-D56C-438E-8343-B14962E8D5DA@microso...
Excelexcel 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.
Many thanks
Peter, how do you want to match these two sets of data - not sure I
understand? Can you attach a s...
auto hide dataI 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.
Or
(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
programming language.
Data filter:
XL2003
http://office.microsoft.com/en-us/excel/HP051998001033.aspx?pid=CH062527971033
XL2007
http://office.micr...
delete data basesI 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
list.
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.
Good Luck
Regards
Jeff Boyce
Microsoft Office/Access MVP
"mobeer1958" <mobeer1958@discussions.microsoft.com...
colors of bar charted data don't follow data after sortingI 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
ledgend.
Hi,
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 ValidationSo 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:
=IF(ISERROR(VLOOKUP(A5,advertising,1,0)),accounts,advaccts) where
"accounts" is all accounts and "advaccts" is only advertising
accounts.
That works ok. I'm sure that is not the best way of doing it; but
here is my ...
Plotting point of data #2lets say 1 have a worksheet and the values are as a sampl
15 3
23 6
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
Hi
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):
http://www.appspro.com/utilities/Labeler.asp
http://j-walk.com/ss/excel/files/charttools.htm
Frank
twilight wrote:
> 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???
thanks,
The Fruitless Floundere
--
spydo
---------------------------------------------------------------------...
Dynamic column chartI 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 loginHi, 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???
THAKS
...
How to LoginHi 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 dataHi, i have a column with a list of numers and letters, unsorted. the
data in this column can be repeated, it goes like this
Col1
054T
034K
056L
045L
045N
054T
076H
034K
045L
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:
Col2
054T
034K
056L
045L
045N
076H
all the codes are in col1, but they appear only once in Col2
Sorry to bother.
Thanks for all
Arturo
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 #48I 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!!!
>-----Original Message-----
>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
this
...
laboratory data model designAny 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
scratch.
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
performed.
I am planning to develop mid -level model, i.e is not too simple nor too
complicate.
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
--
...