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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: scc
  • Order by date
  1. scc

    Can you resize all pics in MS Word?

    Thanks! Worked great! Always wondered how to add a module to the Normal.dot
  2. scc

    Can you resize all pics in MS Word?

    Skip, Can you walk me through how I would go about implementing this code and then running it in MS Word? Thanks!
  3. scc

    Can you resize all pics in MS Word?

    I have a document with lots of pictures in it. Is there a way to resize all the pictures at once instead of going through the document and resizing them one by one? TIA!
  4. scc

    Toolbox empty

    Curious where you find the Reset. I alphabetized my controls and I don't like it that way and would like to reset them back like they were originally (which seem to be most used at the top). Anyone know how? TIA
  5. scc

    Group By and select most recent record

    Thank you!!!! I had to "tweak" a bit, correcting a misspelled word and giving the Max column a name, but after that it worked liked a charm. I look forward to feedback from the Customer as it took the records for one day down from 269 to 27! Thanks again...
  6. scc

    Group By and select most recent record

    Thanks, I'll let you know when I get to this office whether this works or not... Here's a star for you efforts!!!
  7. scc

    Group By and select most recent record

    I'm sure it won't let me have 2 WHERE clauses on that last select. I'll try playing with it when I get in to the office.
  8. scc

    Group By and select most recent record

    ...what I would do? Unfortunately, I'm not at the office at the moment to try it, but will be in a few hours and need to get this resolved. Select * from FROM dbo_vw_Stor_Del_2 AS a Where... (my original criteria) inner join (Select trackingnumber, max(deliverydate) from dbo_vw_Stor_Del_2...
  9. scc

    Group By and select most recent record

    First of all, I just realized that I posted the following question in the SQL Server Group, but probably should have posted it here instead. Don't mean to "over-step" boundaries, but I really need some help, so hopefully someone will come to the rescue... I have the following SQL statement...
  10. scc

    Help grouping and checking the max record

    As I'm reading back through my post, I realize I didn't state this correctly, so I will correct it. I really need some help, so hopefully someone will come to the rescue... I have the following SQL statement, however there may be multiple records for a TrackingNumber. The TrackingNumber and...
  11. scc

    Help grouping and checking the max record

    I tried this, but get an error message that says "syntax error in FROM clause" and then highlights the word JOIN in the statement. Remember this is MS Access with a link to a SQL Server table. SELECT a.TrackingNumber, a.InboundDate, a.InboundUser, b.DeliveryDateTime, a.ScannedBy, a.Recipient...
  12. scc

    Help grouping and checking the max record

    I have the following SQL statement and there may be multiple records for a TrackingNumber. The TrackingNumber and the DeliveryDate (which has a time stamp in it) make up the unique key. I need to look at the most recent DeliveryDate and then check the criteria, but I'm not sure how to do this...
  13. scc

    Change text to datetime

    Exactly what I needed! Thanks!!
  14. scc

    Export or Print Modal Pop-up Report?

    Can you give me a bit more info on how to do this? Thanks
  15. scc

    Change text to datetime

    I'm having problems getting either of these to work. dbomrrsm: I don't know how I can use a field to bring back the data instead of hardcoding it... mwolf00: this brings back an error that says-- The data type int is invalid for the substring function. Allowed types are: char/varchar...
  16. scc

    Export or Print Modal Pop-up Report?

    I have a Modal Pop-up report that is called through an Access form from within another application. Everything works fine, the Access window is not visible, however, the user needs to be able to print or export the data from this report. Is there a way to do this, such as a command button on...
  17. scc

    Change text to datetime

    I have a field that is char(14) and I would like to write a query (for a view) that will return a datetime field that will be recognized by MS Access as a datetime field. Here's a sample of the data in stored in SQL Server: 20041215163407 the field is named DeliveryTime Can someone help with...
  18. scc

    Understanding a barcode

    ...Extended 3 of 9 (Code 3 of 9 wouldn't allow me to do this) and put in the commands for a carriage return - line feed. However, I did not use and *'s before or after. (I just looked at the program again and Code 3 of 9 won't let me put in an * or a \ to create a control character and Extended...
  19. scc

    Understanding a barcode

    I have a barcode. It is used to add a record to a program. I tried creating one, with no sucess. Here's my question... is there a way to tell what barcode language this barcode is using and what control characters were used to create the barcode? TIA
  20. scc

    Reply email option?

    Does anyone know of an option in Microsoft Outlook where your reply to an email is positioned at the end of the email instead of the beginning... in other words, when reading several generations of an email they are in chronological order from the top down? TIA!

Part and Inventory Search

Back
Top