Search results

I have two tables in sql One is a supplier table with an autonumber supID,supname Another is a product table with productID,supname,supaddress,start year and end year. Now I get data for supname,supaddress,startyear and endyear using inputbox in vba. I have to use ADO connection to insert it...

Hi, I have a supplier table in sql with an autonumber field ,supplier name and supplier ID field.. I need to get the supplier name and ID using Inputbox in excel. Then I need to send that data to the supplier table in sql server? How do I do that? Thanks a lot...

Hi, I have a supplier table in sql with an autonumber field ,supplier name and supplier ID field.. I need to get the supplier name and ID using Inputbox in excel. Then I need to send that data to the supplier table in sql server? How do I do that?

Hi, I have a supplier table in sql with an autonumber field ,supplier name and supplier ID field.. I need to get the supplier name and ID using Inputbox in excel. Then I need to send that data to the supplier table in sql server? How do I do that?

yes, I figured it out. Thanks

I have a problem. I need to design a simple SSIS package, wherein I use an input excel source and an output SQL server table. All I need to do is to import data from excel to SQl server table by using a check condition on date column in excel sheet. In the package, I have an excel source...

Hi, I use SQL Server 2005 version and I am trying to built a simple SSIS package where I need to pass a variable with a preset value to a SQL command statement. The whole purpose of the package is to select some data from the SQL server with a particular Jobno and then put it into an excel...

Hello, I am having a problem with subqueries.The code works but i do not get the correct calculated output. I have the table structure and the expected output below. I need to basically find the max and min for each row within a table. the code needs to compare load_1 ,load_2 and load_3 on...

Hi, I have an IF statement Where I compare three variables If [@calendar_ID1]<>[@calendar_ID2] OR [@calendar_ID1]<>[@calendar_ID3] ELSE Else,I want to exit out of the Stored procedure.. What should I use. GOTO END is not working.. Can't use EXIT Thanks...

Hi Brian , How do I specify the 'else condition wherein exit out of stored procedure.. Thanks I can't use exit proc or end.. any ideas?

Hello, I am having problem in setting up an if statement where I have 3 calendar_id -@calendar_ID1,@calendar_Id2,@calendar_ID3. I need to check and see if (@calendar_ID1<>@calendar_ID2) OR if(@calendar_ID1<>@calendar_ID3) then I need to exit out of the stored procedure. How can I implement...

I have a question relating to subforms. I have a form1 from table1 and created subform1 using table2. Each table has a common field where it is linked.Now , I need to display a field from table2 in the form1? If i make a combo box in form 1, it does not work . it just remains the same for...

Hello I am new to .net. All I want to do is to design a web form which will collect details from users and then put it to a database. Now i know how to save details in a database. but I dont know to make a simple web form which can collect details from users . Also what is dataform wizard ...

Hello , I have a problem , I need to highlight a row in a table .How can I do it ? can i make it using query ?

Hello , I have a problem .i want to highlight a complete row ina table . how do I do it ? then I need to make this work in a macro ?

How to display an error message if the specified criteria is false in a query ? what function should be used for that ? I have a query which has to check 3 conditions and if the 3 conditions are true then it should display an error message . What should be done for that? Thanks for your help...

When used short date it works in correct format in access but when the macro runs and exports the file to excel it ges back to the same format like 17-jun-05. Any ideas?

HOw to use the format function . I had tried to use it but does not work for me . when i click properties of the particular column in a query and go to format tab , i type in mm:dd:yy( i want to change the format of date ) and then execute the query but nothing happens. can someone help me ?

HOw to use the format function . I had tried to use it but does not work for me . when i click properties of the particular column in a query and go to format tab , i type in mm:dd:yy and then execute the query but nothing happens. can someone help me ?

got the answer ! Hello , I solved the proble m , i had to use ' '( single quotes ) in criteria fields to remove all empty fields in a table . Thanks