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...
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...
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...
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...
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...
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...
To open a specific Word document from Excel (Office 2003), I have the following (obviously on a button):
Private Sub CommandButton1_Click()
On Error Resume Next
Err.Clear
Set wrd = GetObject(, "Word.Application")
If Err.Number = 429 Then
Err.Clear
Set wrd =...
I have looked everywhere and tried everything I can think of.
I took a project saved it, modified it and saved it with a different name.
I changed the File>Properties>Title on the second project to a new name
Then I wanted to consolidate the two so I opened a new window with the two in it and...
Ok, to be humorous, I will say I made a database for lemonade.
I have a table for a pitcher of lemonade, tblPitcher and one for the glasses from the pitcher tblGlasses and a junction table tlnkPitGls. I am using the junction table to ensure that no glasses can be chosen that have not been made...
Ok, to be humorous, I will say I made a database for lemonade.
I have a table tblPitcher and a one tblGlasses and a junction table tlnkPitGls.
I had created a form for the information about creating the pitcher of lemonade (tblPitcher) with a subform to create the records for the junction table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.