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 strongm 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: *

  1. ljevans

    Need first day of previous month for criteria in a SQL view.

    Yes, in going back, I am seeing the same thing.
  2. ljevans

    Need first day of previous month for criteria in a SQL view.

    But, I get the results I expect when I run the view.
  3. ljevans

    Need first day of previous month for criteria in a SQL view.

    It is a SQL server database, but the code that I used seems to work.
  4. ljevans

    Need first day of previous month for criteria in a SQL view.

    When this view is run, all of the discrepancies written the previous month are displayed. I've got the last day of the previous month, but I can't get the first day. Any help would be appreciated. A criteria example: Between 10/1/2006 and 10/31/2006 So far I have: Between 10/1/2006 and...
  5. ljevans

    Can I pass multiple values from a select box?

    I have a select box that is populated using 2 queries, each from different tables. They both pass pkey for value. Based on which table's value is selected, determines another setting when an update takes place. I may have a pkey value of 8 for a department and a pkey value of 8 for an...
  6. ljevans

    Using a lookup table to search for records

    There is no relationship between Table1 and Table2 other than a possible reference of Table2's airport code within Table1's description field.
  7. ljevans

    Using a lookup table to search for records

    I am using Access 2003 SP1. Table1 has a description field. Table2 is a lookup table that has airport codes. I want to loop through Table1's description field looking for any reference to each airport code. Can I do this with an Access query?
  8. ljevans

    Reserved Words

    Does anyone know where I can find a list of reserved words for ColdFusion MX?
  9. ljevans

    Code reverting back to original version after save

    There are only 2 of us that work with ColdFusion and I am the only one working with this code. I thought that I had heard that there was an auto-correct setting somewhere. I thought maybe this was enabled and that is why this was happening. Does this sound familar to anyone?
  10. ljevans

    Code reverting back to original version after save

    I do check the file in and the changes are reflected when I refresh the page.
  11. ljevans

    Code reverting back to original version after save

    The problem is that I am saving the code after an edit. The change is reflected when I refresh the page. It is when I go back and open the code itself that it has reverted back to its original revision. Example: I am trying to fix these line of code <!--- FROM: <A...
  12. ljevans

    Code reverting back to original version after save

    I already have SourceSafe installed and have used it with ColdFusion for 6 years. This is something that has started happening since I have installed ColdFusion MX. There is a Code Rewriting setting under Files/Preferences, but none of the boxes are checked.
  13. ljevans

    Code reverting back to original version after save

    I am using ColdFusion MX. I edit code and save. Refresh page everything is fine. The next time I go back in to the same code, the changeds I made have reverted back to the original version. If I make an edit unrelated to the first edit and save, I lose the first edit. I am using SourceSafe...
  14. ljevans

    DTS to Excel, Destination field size

    I am creating the package manually. I know how to adjust the size if I am exporting to a text or csv file, but I can't see how to do it if I am exporting to Excel. I may give up and just export to csv.
  15. ljevans

    DTS to Excel, Destination field size

    I am using DTS to export data from SQL to Excel. I have a large text field that is being truncated at 255 characters. When I look at the Destination field size for the package, I see that the Data Type for all the fields is VarChar and the size is 255. How can I change this so the text is not...
  16. ljevans

    Sounds Library

    Macromedia Flash MX 2004 - Version 7.0.1
  17. ljevans

    Sounds Library

    I understand that there is suppose to be a Sounds Library under Windows - Other Panels - Common Libraries. My installation of Flash does not have a Sounds Library. Do I need to reinstall?
  18. ljevans

    Outlook 2000 forms opening with Outlook 2003

    I have upgraded to Office 2003 from Office 2000. I have an Outlook form, which is a vacation request used company wide. The user opens the form, fills in vacation info then clicks send. The e-mail then sits in the Outbox. Normally, this would have been sent to the user's supervisor. Is...
  19. ljevans

    Converting Access 2000 Secured database to Access2003 Secured database

    My Network Support Group has installed Office 2003 on several computers for test purposes. Unfortunately, the development group was not one of the test computers. I have a secured database that will not run as is in Access 2003.
  20. ljevans

    Converting Access 2000 Secured database to Access2003 Secured database

    I am getting ready to look at Access 2003. We are currently using Access 2000. In previous upgrades I have had to do a considerable amount of work to convert my secured database to the latest version. Can someone point me in a direction for good information about Access 2003, specifically...

Part and Inventory Search

Back
Top