Search results for query: *

Let me start by saying I am pretty computer savvy and consider my self pretty good with software. I am a Quality Engineer with enough IT skill to be dangerous :) I do not have the ability to do much with our SharePoint site but add content. I cannot change CSS (I can change the "theme" but...

Nobody has any ideas? I thought this might be a network thing but does the same with the database copied onto my desktop...

We have Office 2002. Hopefully we will get 2010 this year... I am trying to "Import External Data" into an Excel spreadsheet from a password protected Access database. I know the password and can get into the Access database directly using it. I do not want to go into the database as it is...

Those tables are one to many and these are many to many...although the subcategory does not need to be many to many, can be many to one category. I will look more carefully but there must need to be some kind of junction table to store the subcategory value for each category for each...

This has probably already been asked many different ways...but I am not sure so: I have the following tables: tblTask tblOwner tblCat tblSubCat with junction tables jnctTaskCat jnctTaskOwner jnctCatSubCat - this one is iffy whether we need to use the same subcategory for different categories...

=SUM(IF(columnD="retest",IF(columnB="C",1,0),0)) Then hit Ctrl-Shift-Enter to make it an array. It should then have { } around the formula.

Not sure what you want... I found http://www1.towson.edu/adminfinance/ots/training/documentation/Outlook%202003/Outlook_2003_Customizing_Form.pdf#search=%22Outlook%202003%20Form%20%22 that tells how to have CC autopopulate. Same thing can be done with the To: field. Might want to make a...

Wow...great answers! When I want to do this (like randomizing experimental trials), I just put 0-9 in column 1 in order, use the rand() in column 2 and then sort by column 2... When you sort column 2 changes so if you don't like the mix, you can sort again...otherwise, I typically delete the...

I often plot data as distance from target so it can be positive or negative. Is there a way to make the X-axis labels be at the bottom of the graph or another position so the graph is readable? I have done this the awkward way by removing the axis label, adding data labels using the XY Chart...

Thanks for your help...I used SkipVought's suggestion which lets me do what I want...I have to make duplicate records when there is Good and Bad on the same line...(why you would have good parts with a defect code I don't know but that is how the database I am using is sometimes completed). I...

Darn...no way to edit or delete a post after you submit!!Date Reason Good Bad 9/17/06 Dropped 0 5 9/17/06 12 0 9/18/06 Kicked 0 8 9/18/06 Dropped 0 2 9/19/06 24 0 9/20/06 25 0

We have data in a spreadsheet that comes out: Date Reason Good Bad 9/17/06 Dropped 0 5 9/17/06 12 0 9/18/06 Kicked 0 8 9/18/06 Dropped 0 2 9/19/06 24 0 9/20/06 25 0 Obviously this is a snippet of total data. I use a pivot table to...

Reply...yep that works too. I was hoping to have the solution in the same workbook without adding more data/bulk but this may be a better solution. If anyone tries this solution by SkipVought and wants the lines to be complete, don't forget to go to Tools>Options>Chart and check the Interpolated...

Another solution that my co-worker reminded me of which I ended up doing just now was creating a column E that had the formula in that column starting with E2: =IF($C2=1,D2,#N/A) and a column F starting with F2: =IF($C2=2,D2,#N/A) and copying these formulas down for all the records. The "#N/A"s...

What I do is display the Web toolbar in any Office program (e.g. View>Toolbars>Web), click in the address box, copy and paste what is in there into the body of the message in Outlook. If there are any spaces, you need to put < > around the pasted text e.g. <\\myfile\test 1.xls> You may need to...

What I do is display the Web toolbar in any Office program (e.g. View>Toolbars>Web), click in the address box, copy and paste what is in there into the body of the message in Outlook. If there are any spaces, you need to put < > around the pasted text e.g. <\\myfile\test 1.xls> You may need to...

Thanks Skip but that did not get me what I wanted. I think I am much closer thanks to a thread on: http://www.mrexcel.com/archive/VBA/14192.html where a solution was posted anonymously. Using that and the data file in the original post saved in an excel spreadsheet titled Sub Update() Dim...

Have you tried a form with a really big window? I did that (but that is where I input my really long text) and was able to see all that I put in when I could not see it in the datasheet or Excel (Only 1,024 characters display in a cell) Access specifications say: Number of characters in a Memo...

Perhaps you can have another profile for offline use which does not reference the pst files but has all the other settings the same. I do not have permission to do this on my computer at work or I would try it out and give you more info :)...

OK, long subject but I was just asked to take our regular report and graph it differently without sorting. Our format is: Date Run Batch Value 9/1/2006 1 1 0.62229978 9/3/2006 2 1 0.477822602 9/3/2006 3 2 0.473598063 9/4/2006 4 1 0.82828949 9/5/2006 5 1 0.346625262 9/6/2006 6 2...