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?

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

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

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 ?

Hello , I have a date format problem , I have an access database which when run by a macro, gives me a date format of 05-AUg-05( data type is text)and the same applies when it 's exported toexcel , it appears as 05-Aug-05. But , when exported to excel i need it in the format 05/08/05. What...

Hi, I have a query which works perfectly and deletes the unnecessary records according to the criteria i have set , but i dunt want this null values in all column to display in the exported output file. how do i delete the records which are already null . i tried delete query but it did not...

Hi, I have a query which works perfectly and deletes the unnecessary records according to the criteria i have set , but i dunt want this null values in all column to display in the exported output file. how do i delte the records which are already null . i tried delete query but it did not...