Reply:

input filtered data from table
I 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 #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 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 Charts
Hi, 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 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 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 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. -- 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...

Excel
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. 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 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. 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 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 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 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 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 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: =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 #2
lets 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 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??? THAKS ...

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 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 #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!!! >-----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 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 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 -- ...