I have the following code on the tab of an excel worksheet.
Sub change_cell_color(ByVal Target As Range)
Dim icolor As Integer
Worksheets("sheet1").Activate
areaCount = Selection.Rows.Count
If areaCount = 1 Then
If Not Intersect(Target, Range("C2:AH85")) Is Nothing Then
Select...
Hello!
I have two very similar tables.
T1 (only has today's data) with an index on time field
T2 (exactly like T1 but with historical data) no index
Is there a way with hints to utilize the time index from T1 on T2?
Forgive me if this is very simple, just trying to get a grasp of what's...
Hello!
I'm fairly new to Crystal Enterprise 10. This wierd thing is happening to me. I have created several folders with copies of reports in them all. In all but 1 folder, I'm able to schedule reports to be emailed out (excel format) with no issues. In this one particular folder...
I was wondering if there is anyway to query the database to find out what CCTs have a comment on them? I'm thinking it will have something to do with the cctwit table, in particular the image field with a long raw datatype, correct?
Thanks in advance!
I copied a table in Access,added _bak to the name, made changes to it, and then renamed the original _bak1, and renamed my modified copy to the original.
Now when I'm trying to add a new record from a form, I get a message, "You cannot add or change a record because a related record is required...
I created a macro in Excel 2002 that some offsite users are trying to use in Excel 2000. I do not have access to Excel 2000 to re-create this macro. Can someone help me.
They are receiving the following error:
run-time error '448':
Named argument not found
Debugging brings them to the...
Gradley, thanks for your input. I have a ticket open with my techinal support services. Hopefully they'll be able to help me. To do the email, I actually use a step in the job with the following TSQL code:
declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM =...
I have over 20 jobs where step one is a DTS package to create an excel spreadsheet with query results. The 2nd step is to email out that spreadsheet to people outside my organization. This process has been working great for over a month. As of yesterday, the email step doesn't work. In the...
a query would be written this way...
SELECT (SELECT Code
FROM Location AS A
WHERE A.ID = Location.Parent) AS typecode,
(select CODE from type where Location.type=type.ID) as tCode,dbo.OrderRecommendation.Amount...
I have several DTS packages scheduled to generate an excel spreadsheet and email them to various individuals. They work just great. However, now I'm getting requests to "format" the spreadsheets prior to emailing. I think I can add a step to the job to "format" the spreadsheet prior to...
Okay, but the cell value isn't exactly, "Total". It ends with the word total, but begins with varying Store numbers, i.e. "101 Total", "102 Total", "103 Total", etc...
Thanks again!
this is the query I'd like to use as a subquery...
[code]
select store.name, a.date,min(b.date)-1
from
location parts
inner join inventory a on parts.id = a.id and a.shipin > 0 and a.shipout > 0
inner join inventory b on parts.id = b.id and b.shipin > 0 and b.shipout > 0 and b.date > a.date...
I have a query that gives me a list of dates (3 columns, id, from date, and to date). I want to incorporate this query result using between in the where clause. Is this possible?
i.e.
Query results
id from to
1 1/1/05 1/3/05
2 1/2/05 1/5/05
etc...
I want to select...
I've tried, but I don't know how to repeat the find and insert portion...
My recording generated this...
Selection.Find(What:="Total", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
MatchCase:=False...
Thanks so much John!
Yes, that's how I want the ins and outs rolled up
so my results should look something like...
id date in out
1 03/22/2005 15 8
1 03/24/2005 13 4
2 03/21/2005 10 8
2 03/23/2005 12 4
2 03/25/2005 12 2
3 03/22/2005 20 11
3 03/25/2005 10...
I have the following
I want create a macro that finds the word "total" in a specific column and inserts a page break immediately after that cell. Can this be done?
Thanks in advance.
I've used something similar myself, but don't have the exact code with me.
it should look something like the following...
SELECT case grouping(CCHDBA.III_RESULT_MESSAGE_XREF.MSG_CD) when 0 then CCHDBA.III_RESULT_MESSAGE_XREF.MSG_CD else 'Total' ,
CCH_MESSAGE.MSG_TEXT...
TB1
id m t w th f
1 0 1 0 1 0
2 1 0 1 0 1
3 0 2 0 0 2
4 2 0 2 0 2
Shipments made on days where <> 0, so id 1 gets shipments on Tuesdays and Thursdays, ids 2 & 4 on Mondays, Wednesdays, & Fridays, and id 3 on Tuesdays &...
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.