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...
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...
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...
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...
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...
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...
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...
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 =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.