Search results for query: *

Greetings, When exporting qry resuts to CSV one column is so wide it wraps to the next row and the columns after it. Is there a way to 'force' all columns on one line? or a format besides csv that I could export to? Here is my batch code... C: cd Program Files\Microsoft SQL...

Greetings, I have been given a report that contains 2 report tabs and a 3rd tab containing several graphs. The first 2 tabs of the file are generated weekly out of a Business Objects (BO) scheduled export to Excel. The 3rd tab is something upper managament slammed into the Excel file and they...

Greetings, I have a situation where I need to check if a call occurs between 2 dates. This is easy, the problem I am having is it needs to consider business days only which in my situation would exclude Sundays. So if it was Monday morning and a call had occurred Saturday morning at the same...

Greetings, I have a SQL 2000 (I also have 2005) qry file that runs through several steps. The qry file initially creates a table with a key column and several empty columns and then runs through a series of inserts. At the very end I execute a qry that rolls it all up into the view I need. I...

Greetings, Thanks in advance for your time and help. I have a sheet containing data in tabular format in Excel (2003) that I am using as a data source for another worksheet in the same workbook where I have calculations (product formulas mostly). At the top of the latter described sheet I...

Greetings. My sincerest apologies if this is not the correct forum. I am trying to get my Website up and running. We are hosting using .MAC, but our domain name is through another company. We have 2 domains www.abc.com and www.def.com that should point to the same Website. The site...

Greetings, Many thanks in advance for your help. I have a report template in Excel and I added a button with macro that copies and pastes the desired portion of the template to a new Excel file. My question is how could I automatically save the file per a value in the template and the file...

Greetings, I keep getting a no lock error and it is very frustrating. The same code runs fine, normally. It seems like this issue occurs during peak times likes beginning of the month when reports are due across the company. Here is the error. Server: Msg 601, Level 12, State 3, Line 146...

Greetings, What is the best way to check to see if a temp table exists in SQL 2000? I have a step that creates the table and would like to programatically handle the drop/create. Thanks for your help, Cary

Hello everyone, I have a question related to emailing in SQL Server. I am using SQL 2005. I am using msdb.dbo.sp_send_dbmail. I have a script that works beautifully for tables that already exist, but I recently got permissions on the db to create tables, and when I created a test table and...

Hello, I have a SQL procedure that creates a temp table initially and then runs several updates to columns within the table. At the end I query the table for the result set. I have used a pass through before but never quite like this. Here is where I am at this point... I ran the same SQL...

I am an anlsyst, not a developer by trade, working in my operations department and I am venturing on a project and I do not know where to get started. I can code SQL well enough to create a script that will give me the desired result. The issue is around my access to the tools necessary to do...

Greetings, Please let me agologize in advance as this is probably going to sound vague and/or weird. It sounded simple at the beginning, but now has me scratching my head. Basically, I need to create a report that has no flow to it. I need to place text boxes on a report (representing metric...

Greetings, I am running an sp that usually takes about 45 minutes to complete. I am a bit frustrated because I keep getting knocked off the server for some reason. Here is the error message: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider...

I have a formula in Excel that concatenates text with a date from another cell and the date is showing up as 39264 rather than July 1, 2007. Is there a way within an Excel formula to get the desired format of July 1, 2007? i.e. ... Date Range of July 1, 2007 to July 31, 2007 Rather than...

Hello, I have a question related to looping through rows and columns and grabbing the last cell location containing data. This is hard to explain so please bear with me. I have started with something like below to search in column 1. For Counter = 6 To 500 Set curCell = Worksheets("Project...

Hello everyone, In my Excel VBA code I have the following statement to save the active workbook - ActiveWorkbook.SaveAs Filename:= _ "\\Fs3\is\Project_Management\Time_Tracking\" & lanid & " " & Format(Date, "MMDDYYYY") & ".xls" If there is a file that already exists at this location with the...

I have searched the forum, but I cannot find an example of prompting without a filename hardcoded in the VBA. I tried recording the macro and copying the code, but it made me save to a location before it would allow me to stop the recorder. How would I prompt to Save As and allow the user to...

Hello, I am geting the run time error 1004 'Select Method of Range Failed'. I am attempting to copy data from the active workbook and then paste the data into a new workbook. It is pasting fine, but when I try to select row 1 to bold the header the code errors out. Here is the code...

Hello, In Excel how could I auto populate a combo box (list) for a cell with a list of distinct values from a column in an Access DB using VBA? Thanks!