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

    Need to replace FTP with a SQL Server stored procedure...

    Good morning to all... I am currently using a Windows 2012 Server with a MSSql 2012 stored procedure that calls the Windows FTP program to transfer a text file from one location to another. I am pretty sure that FTP is not multi-threaded which is why I am having problems using this program to...
  2. Webkins

    Close first Access db from second Access db

    Good morning Is anyone familiar on how to do this task? Thank you
  3. Webkins

    Close first Access db from second Access db

    I open an Access db, call it db1 Using VBA from db1 I open a second Access db, call it db2. This is working fine. The issue I am having is to close db1 using VBA in db2. Once db2 is open and has focus the VBA code in db1 quits executing and therefore cannot reach my DoCmd.Quit line of code...
  4. Webkins

    Help with an update query from 1 table to another...

    ABSOLUTELY PERFECT, THANKS FOR THE HELP! Have a * on me. :)
  5. Webkins

    Help with an update query from 1 table to another...

    I am using MSSql 2000 I have 2 tables within 1 database: coilspec and wirespec Both tables have these 2 columns and datatypes in common: coil(varchar) and wire1(varchar) The column in wire1 in table coilspec is blank. I am tring to populate the column coilspec.wire1 with the data from...
  6. Webkins

    Remove part number prefix and suffix to determine the root number and save...

    Ahhhh, I was going to mention that but I forgot, sorry. All the varchar part numbers are 9 characters long.
  7. Webkins

    Remove part number prefix and suffix to determine the root number and save...

    I am usnig SQL 2000. I have a SQL table with column name MATERIAL, datatype VARCHAR. In this column is data which has this format: A00671001 What I would like to do is to remove the first 2 positions, "A0" and the last 3 positions "001" to end up with the root part number "0671". I would like...
  8. Webkins

    SQL 2000 Alter Table not working in stored procedure...

    Hello... I am using SQL2000. The following code works just perfect in the Query Analyzer but fails when executed in a stored procedure: ALTER TABLE partspec.dbo.double ADD auto_number INT identity I am trying to insert a column with an automaticlly generated ID number. Any suggestions? Thank...
  9. Webkins

    Wierd SQL2000 query sorted numerically

    OMG, That worked, THANK YOU SO VERY MUCH !
  10. Webkins

    Wierd SQL2000 query sorted numerically

    Here is what I have so far that pulls the 2 records from the table which contains thousands of records: select master, part1, part2, part3, part4, part5, part6, part7, part8, part9, part10, part11 from coilspec.dbo.coilspec where coil = 2222 union select select master, part1, part2, part3...
  11. Webkins

    Wierd SQL2000 query sorted numerically

    At this time I have nothing other than this idea. I just started working on this today and I am searching here and Google for possible answers.
  12. Webkins

    Wierd SQL2000 query sorted numerically

    Here is my table with column names and data. Column part is datatype varchar, part1-part11 are datatypes real: master part1 part2 part3 part4 part5 part6 part7 part8 part9 part10 part11 2222 132 154 264 308 0 350 0 0 0 0 351 4747 128 134 190 254 260 285 0 0 0 0 286 Here...
  13. Webkins

    Access 2010 report header...

    I have a report in Access 2010. This report contains 31 pages. On each page are approximately 32 part numbers with descriptions, sorted ascending, numerically by part number. What I am trying to do is to put the first and last part number contained on each page of the report in the header or...
  14. Webkins

    Disable double click on Access form title bar

    I am using Access 2010. My form is set to Pop Up. But no matter what I try I cannot seem to disable a user from double clicking in the title bar and resizing my form. I don't really want to set the Border style to none, but I will if I have to and if this is the only option available. Is there...
  15. Webkins

    How to validate Access 2010 form text box, integers only (0-9)

    GREAT, THANKS PHV, YOU'RE AWESOME !
  16. Webkins

    How to validate Access 2010 form text box, integers only (0-9)

    In Access 2010 I have a form with many text boxes. I want to validate the data before saving it. I want only integers (0-9) in this box, anything other than (0-9) will bring up a error msgbox. The data will always be a 12 digit part number. I am having a hard time and have been searching for...
  17. Webkins

    Hello and happy new year everyone.

    Yes, I know. I am not sure how that got there in the title and was disappointed to see that after I had submitted the post. I didn't preview the post, not my intention, sorry :-( There are 2 MSSql 2000 tables involved: 1. mwo.dbo.mwo 2. mwo.dbo.numbers Here is the query which works perfect in...
  18. Webkins

    Hello and happy new year everyone.

    Hello and happy new year everyone. I am having troulbe with an Access 2010 query. There are 2 MSSql 2000 tables involved: 1. mwo.dbo.mwo 2. mwo.dbo.numbers Here is the query which works just fine in SQL 2000 Query Analyzer but in an Access 2010 query I get the following error: "JOIN...
  19. Webkins

    Force data to appear from query...

    OMG! THAT'S IT! THANK YOU! Wish I could give you 10 stars for your help! Thanks again!
  20. Webkins

    Force data to appear from query...

    Oops, sorry, here is the correct query: SELECT 2012 AS completed_year, Numbers.Num As completed_week, Coalesce(count(completed_week), 0) AS completed_wo FROM Numbers Left Join mwo.dbo.mwo On Numbers.Num = mwo.completed_week WHERE Numbers.Num Between 1 and 52 And (responsible_status =...

Part and Inventory Search

Back
Top