Search results for query: *

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

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

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

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

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

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

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

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

OMG, That worked, THANK YOU SO VERY MUCH !

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

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.

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

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

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

GREAT, THANKS PHV, YOU'RE AWESOME !

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

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

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

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

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