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

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

Part and Inventory Search

Back
Top