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

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

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

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

Here is my SQL 2000 query code which works just fine: SELECT 2012 AS completed_year, completed_week, count(completed_week) AS completed_wo FROM mwo.dbo.mwo WHERE (responsible_status = 'complete') and (completed_year = 2012) GROUP BY completed_week; My issue is that when this query runs and...

Here is the MSSQL 2000 code I am trying to use: update mwo.dbo.mwo_backup set completed_week = (select DatePart(week, responsible_date) from mwo.dbo.mwo_backup where responsible_status = 'Complete') I get the following error: Server: Msg 512, Level 16, State 1, Line 1 Subquery returned more...

This script was working well until we all upgraded to Powerpoint 2010. The purpose of this program is to open and combine, join or merge multiple Powerpoint presentations contained in a folder into one large Powerpoint presentation. I did not write this program, I found it on the internet a long...

I am having troubles to sum these 2 variables into one. I have tried many combinations of the code below but nothing seems to work... --Query for data SET @raw_gallons = (SELECT raw_gallons FROM impregnation.dbo.tank_raw) SET @day_gallons = (SELECT day_gallons FROM impregnation.dbo.tank_day)...

I really need some expert help here. I have been working on this for 2 days, trying everything I can think of. Here below is the SQL2K stored procedure. The issue is this... There could possible be anywhere from 1 to 4 hyperlinks in the email generated by this stored procedure. If there is 1 or...

Hello, I have a stored procedure in SQL2K which contains many @variables. I would like to debug my stored procedure and see the actual contents of each variable. Is it possible to step through the code or to see the contents of each variable similar as in VB/VBA ? Thank you...

I have the following Access 2003 query in the row source of a list box on my form: select Cast(avg(cast(review_quality_score As decimal(18,2))) As Decimal(18,2)) from mwo.dbo.mwo This query works perfectly in SQL Query analyzer but when I transfer it to Access I get a message error: "syntax...

Hello, I am trying to average and format. I started with this: select avg(review_service_score) from mwo.dbo.mwo and the result is 8 Then I tried this: select cast(avg(review_service_score)as decimal(18,2)) from mwo.dbo.mwo and the result is 8.00 The correct format and answer I am looking...

I have an Access combobox that contains 4 columns. I am using the following code to populate the combobox with data and is working fine: responsible_pending.RowSource = "" rs.MoveFirst Do responsible_pending.AddItem rs![work_order] & ";" & _by & ";" & status & ";" & technician rs.MoveNext Loop...

I am using Access 2003. I have this following VBA expression: overtime = monday + tuesday + wednesday + thursday + friday + saturday + sunday For example, if monday = 9 and any of the other days are null then overtime = null. How can I add this string and result with an answer of 9 ? Thanks...