Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by smuthcrmnl777

  1. smuthcrmnl777

    using SHELL to create a folder

    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?
  2. smuthcrmnl777

    last record on continuous form

    I don't want it in descending sort.
  3. smuthcrmnl777

    Reel Data groupings need improvement

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

    Reel Data groupings need improvement

    I get 3 errors
  5. smuthcrmnl777

    Reel Data groupings need improvement

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

    Delete query gives error from JOIN

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

    Creating a Stored Procedure to group data together

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

    Creating a Stored Procedure to group data together

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

    Creating a Stored Procedure to group data together

    nevermind. You are the man!!
  10. smuthcrmnl777

    Creating a Stored Procedure to group data together

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

    Creating a Stored Procedure to group data together

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

    Creating a Stored Procedure to group data together

    Absolutely correct!!
  13. smuthcrmnl777

    Creating a Stored Procedure to group data together

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

    last record on continuous form

    I am using yours boxhead
  15. smuthcrmnl777

    last record on continuous form

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

Part and Inventory Search

Back
Top