Search results for query: *

Andy is correct. I am trying to view the code in a project that states it is locked but does not appear to have a password. Essentially I have an add-in that was programmed to extract data from a custom binary file for a system that is long obsolete. I would like to update the add-in to work...

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...

Worked beautifully! Thanks! Pat Russell

The original table is in SQL2000 but I do have an SQL2008 server that I can move the data to. I tested the query in the 2008 server and it worked great. I think I need to learn more about the newer query options/commands. Thanks for the help! Pat Russell

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...

That made an incredible difference in time. I went from timing out to under 3 seconds. Considering that there are ~90 million rows to work through I'm happy with it. Thank you! Pat Russell

Here is the query using the paramater: SELECT TOP (100) PERCENT AMS_PCE_PDO_MDL_SETUP.C_PCE_ID AS [Coil ID], MAX(AMS_PCE_PROD.Q_PROD_OFF_LOC) AS [Discharge Time], MAX(AMS_PCE_PDI.C_ALLOY_CODE) AS [Alloy Code], MAX(AMS_PCE_PDI.F_STRIP_WIDTH) AS Width...

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...

George, With a few modifications specific to my set up the query you gave worked great! Thank you. Markros, I did look at the links you provided and there is definately some good information there but it will take me some time to digest it. Right now the quicker solution for me (and the...

I just verified that the source database is SQL2000. Sorry for the confusion if this messes things up. Pat Russell

George, I tried the query you suggested but am getting an incorrect syntax error near the keyword 'Over'. I checked the online help for this function but cannot see anything wrong with the syntax. Here is what I have: SELECT DISTINCT attendance.laborcode, labor.name...

Sorry George...I'm using SQL2008. I thought about using the temp table but was not quite sure how to set up the query to do that. I tinker with SQL but am by no means very proficient. Pat Russell

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...

That was it. Thank you. Pat Russell

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...

Thanks for the tips. I ended up doing a complete reinstall of NT4 up to Sp6. Once that was done the app installed and is running fine. Not exactly sure what was happening but I didn't have the luxury of a lot of time to figure it out. Pat Russell

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 gave up on getting the Compaq HD to work as the master. I knew it would be a longshot but wanted to try anyway. Got everything working with it as the slave and the PC is ready to be returned to it's now very happy owner. Thanks for the help and your time. Pat Russell

Everything works with the old HD as the slave in the Dell. I was hoping to be able to use the old HD as is but it doesn't look like this will work. Thanks. Pat Russell

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...