Search results for query: *

Is it possible to have a protected VBA project without having a password? I have a project that was written in Excel97 that is "locked" so that I cannot view the VBA code. I have tried two commercial tools for unlocking the project but both stated that the project was not password protected. I...

I have a time based table that is written to every 5 seconds. I need to write a query that will only pull data from the table when one of 3 values has changed. A simple select query is below with a sample of the data. SELECT timestamp, ACIDHFTOT_GALS_VAL0 AS HF...

I have a query that works great when I use a hard filter value for testing but when I use a parameter to allow the end user to customize the query I get a timeout. This happens even when using the hard filter value for the parameter value. I have run the query in SMSS and from reporting services...

I have a query that is supposed to pull all employees that have clocked in for the past 16 hours but have not clocked out. We are using this for a head count should and emergency occur. The problem I am having is that with the query below I search on the clock in time and look for a null in the...

I have the following code that needs to compare two values to determine what value to save. I had everything working until I added the IF...THEN checks on whether value b is larger than a. When I try to compile I get the "Else without If" error at the second check (b1002). I know this is...

I have a VB app that was running on an NT4 PC until I updated it and recompiled. When I reinstalled using a package from the deployment tool the install updated system files and since that time I either get "cannot create directory" errors or "mscomm32.ocx" errors. I have tried to register...

I'm trying to move a WD Caviar 80GB HD from an old Compaq into a Dell Optiplex GX240. I can boot from the original HD in the Optiplex and the CD. When I install the WD drive it has to be by itself on the controller with the jumper removed for the BIOS to recognize it but I cannot get the OS to...

Using this query I am very close to getting the results I want but cannot find where I am going wrong. I will post the initial query with results and then explain what I am looking for. SELECT b.CoilID, MIN(a.[Entry Tower]) as [Min Tower Hgt], AVG(a.Grade) as [Grade], AVG(a.Gauge) as...

Using FAQ333-1498 I have an asp page that populates two drop downs. The problem I am having is that no matter what I do the page always resets itself and I am always starting over. I have added a response.write to monitor the request count of the form and it is only 0 on the first load. The...

I have an installation of SQL2000 that was set for per processor licensing but needs to be per seat. Do I have to reinstall to change this? Is there a need to change it if I have the CALs required for per seat? Does the fact that this server has 2 processors impact this? Thanks for the...

I am receiving the "general network error" when trying to backup my database. I am not working across a network at all, everything is on my server. I get the error when I run the job manually or set it up on a schedule. Any ideas on what I should look at here? Thanks, Pat Russell

I have an application that requires numbers to be displayed with a fixed number of decimal places, regardless of the number entered. For example, 5.123 would display as 5.12300. I have not been able to find anything that helps with doing this. Thanks for your help and time. Pat Russell

I am trying to check the SQL memory manager counters but cannot find anything in the Performance Monitor that is related to these. Am I missing something or is there some option I need to enable to see these counters? Pat Russell

I have the following RPC showing in my SQL trace and am looking for help on how to optimize the query shown. I have several queries that are similar to this on and no control over the structure of the query as it is run from an external data trending software. declare @P1 int set @P1=1 exec...

I have the Adv Server w/SP2 cd and have installed SP3 on my current Win2k Server install. Because of this I cannot do the upgrade. Is there any workaround that I can use or am I looking at a reinstall of the OS? Thanks! Pat Russell

I have created a chart using Office Web Components and ADO recordsets. All was working well until I was asked to add a second category axis to the chart. I can add a second axis but cannot get data assigned to this axis. Has anyone out there done this? I have tried using the help file for...

Using help from this site and others I have been able to code my asp page to generate an Excel chart using web components and then post that chart as a .gif to the web page. What I would like to do is format the category axis so that the axis labels are aligned vertically rather than...

I have a recordset that retrieves data using a parameterized DE command. The parameter is set in a textbox where the user enters a date then clicks a button to retrieve the data. I can get this page to work the first time I load it but after that I get an ADODB error and have to reload (not...

I am not getting any connection/command choices in my recordset controls. I have a connection configured and a command that uses a view in my database under that connection but cannot get anything in the recordset. I am very new to this and am in great need of help here. Thanks for any time...

I am receiving the following error when loading ASP pages on my website. Server object, ASP 0177 (0x800401F3) Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp...