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

...1 0 0 0 1 6/9/2006 2:41 1517 0 1 0 1 1 *************************************************************************************** 6/9/2006 2:43 0 1 0 0...

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