Search results for query: *

I need to have access create a folder on the user's root directory and then copy some files to it. I tried ... Shell "md c:\test" I could not create the file. Could someone guide me on this?

I don't want it in descending sort.

Below in Red is what I added to your original code this morning. I think I just can not visual what this code is doing for me. Using this code it produces NO results. I am sure the logic is off, but I know that for instance my line 1 has produced 2 more reels since I first Inserted the table...

I get 3 errors

http://www.tek-tips.com/threadminder.cfm?pid=183 This is a continuation of the above link. I have the below query inserting into table tM_FR_WIP_UnitID_FastStops and I would like to have the query JOIN on ENDGROUP and LINE to the table so it can determine whether or not the data is there and...

When I try to execute this Delete query, I get an error asking me to specify which table I want to Delete. I want to delete the data that match Query2 from tM_FR_WIP_UnitID_FastStops. DELETE tM_FR_WIP_UnitID_FastStops.nLine FROM Query2 INNER JOIN tM_FR_WIP_UnitID_FastStops ON Query2.EndGroup...

I detected a slight problem with the query. Since the table is too big to test this query, I had to only return data for the past 8 hours. So the query could potentially slice the middle a group of records. (example below) When this happens, your query then detects 2 start times with the same...

I have taken your code and added my insert to a table. I am getting an error on the datatype for nline. I thought it was Integer, but I get an error. Here is my code. Declare @Data Table (RowId Integer Identity(1,1), tRSSQL_TRANS DateTime, bEND_OF_REEL bit, nLINE...

nevermind. You are the man!!

Where can I modify the query so it will compile all of the lines I have instead of just line #1?

I need to be able to identify that group with a field that will number each record for that group.

Absolutely correct!!

I have a unit that will start off with zero or close to zero lbs and when it completes there will be either 1500 lbs or 2000 lbs. During the time it's weight is growing there are things that could go wrong and make the unit stop growing. This is indicated by either a Slow Stop or a Fast Stop...

I am using yours boxhead

Does not work when I am opening the form. It works if I am switching between design view and form view. And by the way I have the command on load.

Box head: I am able to go to the last record. I am asking how to make it so it displays abunch of data on the screen instead of having the last record appear at the top of the page.

I have an external data source that is refreshed when the Word doc opens. The problem I am facing is that Word asks the user if it is OK to load the data and to press YES to continue. I would like this message to never appear. How can I do this?

I have a continuous form that when I open the form it goes to the last record. It does everything I want it to do except I would like for it to go to the last record without placing the last record at the top of the screen. I would to have it go to the last record and have the record displayed...

I do not have access to the domain controller. I only have access to the computer I need to update. I think I can get away with having one of my computers act like the time server and I will periodically monitor this computer to make sure it is up to date. Can someone point me to the right...

There is a program that sits on top of the Operating System (called SiteKiosk). These computers have a webpage desktop that is blank except hyperlinks to their programs and documentations. In a normal environment, I would agree with you and just type in the IP Address, but this is not a normal...