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!

  • Congratulations TouchToneTommy 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
  • Content: Threads
  • Order by date
  1. 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!
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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
  7. 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!
  8. scc

    Bad Record Length on FileGet and FilePut

    I've created my first VB .Net application using a sample and code I found at: http://www.codeproject.com/vb/net/ybrandomfile.asp The code makes sense to me... pretty much followed what was on the website, both for the coding and the UI. However, when the code hits any of the FileGet or...
  9. scc

    Globally turn off reading pane in Outlook?

    Is there a way to globally turn off the reading pane in Outlook? I'm using Outlook 2003. Thanks!
  10. scc

    ODBC default database

    I'm curious... I just changed jobs, so new questions come up. Anyway, here's my question: If you create a new ODBC connection and name it the same name as your database and then do not click on the checkbox for "change the default database to", does the ODBC use the ODBC data source name as...
  11. scc

    Apply background to table cell

    Using Microsoft Word, can you apply a background to a cell in a table? If so, how?
  12. scc

    Limiting access to shared drives

    I have 2 PCs that are running Win 2000 Pro on a peer to peer network. Most of the other PCs on the network are also using Win 2000 Pro. Here's my problem: The PCs on the network were originally set up for all users to have administrator rights, and it appears that a user (logged on as an...
  13. scc

    Proper case in MSWord

    If you have a main mailmerge document in Microsoft Word, is there a way to format the Merge Field as Proper case? The data in the db is bad, so this would be helpful. TIA!
  14. scc

    Pound signs (#) around date or time

    I just read through some VB code where the user puts #'s around the date or time when initializing a variable. I have never heard of this in VB. I was told that this is a best practice in VB, but I wasn't able to find it in VB help. I'm using VB 6. Can someone else shed some light on this? TIA
  15. scc

    Select and Delete return different number of records

    Can someone please tell me why the Select Count(*) and the Delete transaction return a different number of records? I would like to have some confidence in my numbers before I delete them. Here's the statement I'm using: Begin Tran --Select Count (*) --returns 177,145 records Delete c --...
  16. scc

    Failed to save document

    Here's my quetion(s). Is there a limit to the size a Crystal file can be, assuming there's plenty of room on the hard drive? Is there a limit to the number of records? First of all some facts: This report was designed using Crystal 8.5. This report is being ran remotely (off-site and...
  17. scc

    Please explain the following code

    I have this piece of code in an asp page that I'm trying to edit, and I'm struggling with understanding what this javascript is doing since I know very little about javascript. Can someone please explain this line by line to help me get a better understanding. function getInfo(theForm){...
  18. scc

    How to save email with graphics

    I'm trying to save some of my Outlook 2000 SP3 email to files, but when I save it to a file it is missing the graphics. I save it as html and thought the graphics would save to a file that I could point to, but the graphics don't save at all. How can I do this?
  19. scc

    Permission to edit stored procedure

    Is there a way to give permission to edit a stored procedure without giving complete DBA permissions? Hope I'm wording this correctly, but I need to be able to edit an existing stored procedure on a database with out being given complete DBA control on all objects on the database. Is this possible?
  20. scc

    Fixing tab nuisance in Enterprise Manager

    This is petty, but it drives me crazy. When I use Enterprise Manager (SQL 2000) to open a set of records and then click to view the SQL pane, there are tabs instead of spaces in the query. So if I then copy this over to SQL Query Analyzer, I have to clean it up. Is there a way have SQL...

Part and Inventory Search

Back
Top