Search results for query: *

Is it possible to take the effect of this Javascript and have it directly in the CSS instead? <script type="text/javascript"> $("[src*=plus]").live("click", function () { $(this).closest("tr").after("<tr><td></td><td colspan = '999'>" + $(this).next().html() +...

Hey Everyone! I'm building a Sales Order page that has three layers to each sales order: [ol 1] Customer -> Order Detail (1 to many orders)(status, date, tracking number) -> -> Items (1 to many items)(Product, color, length, quantity) [/ol] I found a simple example to follow that shows how to...

I've spent some time looking around the forums and haven't found what I'm looking for. Figured I'd post here to see if anyone has some insight. I want to get out of the "Email = Work" habit and effectively schedule my time each day/week to do email. What i'd like to do is have a script that...

Hey guys! I hope all is well. I've been working on my first Windows Phone 8 app in my spare time. It is basically a Task/Todo app that consists of Task Lists that contain multiple Tasks. I can sort the Task Lists off the title and that is no issue, the issue comes when I want to sort the Tasks...

Hey Guys - I hope this is an easy one, I couldn't find much searching. I'm trying to run a Batch file via RunAs. That part works fine. The issue comes whenI try to add some variables (Start Date and End Date). It doesn't like them, won't even prompt me for a password. Is there a way I can fix...

Hey Guys! I have 160k rows I have to do formatting on and then dump into a SQL DB. I have all the variables declared correctly but it seems that my String is being limited. strSQL = "INSERT INTO [dbo].[MATStracingVer2v0]...

I have a folder path that I need to iterate through to grab ALL the folders underneath and plot their path This is what I have so far: Option Explicit Dim strFolderToSearch, objFSO, objRootFolder, objFolder, colSubfolders, strOutput strFolderToSearch = "C:\Users\mloflin\Desktop\New folder\"...

Hi All! I am using the Non-Profit Form / Template that comes out of the box with Access. I have copied the Donors table and created a "Rotarians" table to be able to link a Rotarian/Sponsor to the Donors. I then added a combo box on the DonorDetails form that is a dropdown of the ID and FileAs...

I have created the basic code to have a macro that will set my follow up as two business days from "now". Sub SetFollowupTo2BusinessDays() Dim sel As Outlook.Selection Set sel = Application.ActiveExplorer.Selection Dim item As Object Dim i As Integer For i = 1 To...

Hi All, I have a macro and I want to sort off of three columns: A R I A - is just an alphabetical sort R - I want to do a custom sort on I - is just an Ascending value sort This is how I want it to work - sort first off Column A, Then sort column R on a custom sort by "ignoring" Red...

I have a pretty intense macro and I noticed that it takes baout 30 seconds to run... So I did my redneck timing and put: t1 = now() t2 = now() ... Then I put a break before the code ends to be able to see the constraints. I found that my macro runs in under 3 seconds if I delete this line of...

Hello All, I currently have a spreadsheet that is linking to a lot of data. I have written a partial macro to copy the worksheet and paste just the values (removing linkages). I think currently have 4 charts that I would like to copy and paste as images which would remove the links to those as...

I have the logic to loop through the Rows & Columns: Dim LastRow As Integer LastRow = ActiveSheet.UsedRange.Rows.Count 'Loops through COLUMNS, then ROWS doing the math For y = 2 To LastRow 'ROWS For x = 2 To 4 'COLUMNS 4 = D Next x Next y The data is pretty simple...

I have the following: select cast('Friday, September 23, 2011 2:04:00 PM' as datetime) and it returns an error but if i change it to: select cast('September 23, 2011 2:04:00 PM' as datetime) it works... is there a better way to remove the "Friday" or the 'day' from the datetime? - Matt...

So I created an app and I need to go and update all of the very first log entries. The app collects devices and when you add a device it writes a log entry. The status of the log entry is "in" and then the device can be checked in or out over and over. It is basically an inventory application...

Good Morning everyone! I have a pretty straight forward query: SELECT NULL as ID, NULL as Parent_ID, c.CY_CYCLE as 'Name', NULL as 'Start Date', NULL as 'End Date', isnull(bga.cnt,0) as 'Active Defects', round(cast(isnull(tcp.cnt,0) as float)/cast(isnull(tc.cnt,1) as float)*100,2)...

Hello all - i'm trying to do a left outer join onto an Alias table and it is telling me: Here is the query: SELECT Null as ID, Null as Parent_ID, US.RQ_REQ_NAME as 'Name', MIN(RCYC.RCYC_START_DATE) as 'Start Date', MAX(RCYC.RCYC_END_DATE) as 'End Date', COUNT(DEF.LN_BUG_ID) as '#...

Hello all! I have a table [REQ] it has Projects, Iterations, Releases, and User Stories. I have to come up with a way to report Project metrics. So I can get all the metrics I want from the User Story level (i believe). The issue is making it all appear like I want. If i can just get the...

Hello All - so I have a History Log that logs when something is Checked In and Checked Out. I need to create a query that will tell me the typical duration something is checked out. So step 1 is to some how pair together a Checked OUT status with a Checked IN status. If there is no Checked IN...

Hello all - just trying to do a simple left outer join and it is telling me to use correlation names... what am i missing? declare @APP varchar(25) set @APP = 'dax' SELECT BG_BUG_ID as 'Defect #', BG_USER_11 as 'User Story', BG_DETECTION_DATE as 'Detection Date', DateDiff(Day...