Search results for query: *

I know I can run a macro and specification to export results from a query to an excel file. Is there a way to purge the existing records in the sheet and then export the results? I have a pivot table that is set to refresh on open so I can't just delete the file I need to actually have the...

I have some time fields that I have to run a quick update to just get rid of the 1/1/1900 before the time to just the time? Any ideas all. Thanks

Hello all. I have a query where I am getting a total QTY by month/year. I need to now break it up into weeks. Is this possible? Thanks all. Here is the functions I am using for year and month. Year([DateShipped]) AS [Year], Month([DateShipped]) AS [Month]

How do you surround a single quote in an exec command to get it to stay as a single quote and not close the string?

Hello all. I have a batch file that I want to call based on criteria in a stored procedure. How do I within an IF statement switch to the command shell and run command shell lines? Also is there a way to pass into one of the command shell lines a variable? I have a program that auto emails...

If I restart a machine through terminal services will I be able to term in still to logon again?

Ok i have narrowed down the issue. I have installed mdac 2.8 again as well. I am getting an automation error on the line Set db = New ADODB.Connection Set rs = New ADODB.Recordset it was working fine then I had to kill the application mid process I am now getting an automation error. I...

Hello all. I tried installing VB and I had to kill the install. Now when I try and bring up setup its going to InstallSheild and it shows Launch Backoffice and then it goes right to the last screen for register. What do I have to do to get it back to the start of the install so I can select...

Hello all. I have a VB app that utilizes crystal and MS-Fax. The program ran the first time but I had to kill the application. Now I am getting this automation error but it was working. Any idea what I can look for in processes or anything? I dont want have to reboot. Thanks all

I have a query where I am summing sales for the current year 2004. This query is grouping by year and month based in criteria for the current year. I need to also though in a column summarize 2003 all data not by month, but grouped the same way on the channel. Here is the query any help...

Is there a way to drill into data on a crosstab in Crystal. I need to somehow create a crosstab because I need months across the top of the report and then certain rows. However I want to setup some drill down for this report as well. Any way to setup drill down for this.

I am looking to query the RM20101 table of unapplied documents and I want to also link to the GL distribution records for each document. Does anyone know what table that breakout is stored in? For example, if I look up a document and then I click the document and then the distribution what...

Hello all I am getting confused with this. I have a group by query where I am trying to sum a result but it is asking me for a field in a CASE statement where if I add it to the group by I get multiple records. Here is the query: The first part works if I take out the [0-30 Days]. I had to...

I have a SQL job that does an extract of data from a view to an excel file. I have been then opening the file and creating a pivot table and chart. I would like to automate the pivot table creation somehow as the next step after the creation of the excel file. Is this possible?

Hi all. Is there a way I can return a -1 to a job that is running a vb exe so it knows the job failed? I have basic error trapping but want to somehow echo a -1 if the job fails.

I have alot of code to write to a file but I was looking for the simplest way to just open a text file and write to it and if it exists then append to it. Anyone have any example code? Thanks all

I have a comma delimited file that has the first row is row headings. How can I read this into a recordset in VB6? This program was in Access 2K and the code was first creating a temp table. Thanks all

Can anyone give me an example how to set a bookmark in a form in access? I have a recordset on a form that I need to requery but I do not want the record to move from that record. How can I accomplish this? Thanks all.

Hello all. I have a form where after the user updates a field on the form I have to requery the form. When I do this it is a long grid and I see the record selector fly through the records to back to the bottom record that I am editing. When the list gets long it takes a minute to come back...

Hello all. Is there a way I can backup my sql jobs because a machine we are currently running is starting to look bleak. I just need the SQL jobs on the machine backed up. Thanks all