vksingh24
Last Activity: Jul 30 '10, 08:42 AM
Joined: Dec 20 '07
Location: India
-
I don't get any such error. Please post your code/query you are using -
You can follow the following steps in order to fix your problem
1) Write a query that will return the desire result
2) Create a report and set it recordsource to query (of step 1)
3) Create a macro and name it "autoexec". In this macor Selct "openReport " as the action and select report name ( of step 3)
Please write back if you have any question.Leave a comment:
-
what is the criteria of latest date? Is it the today date?...Leave a comment:
-
I am not sure but you can use the column name which you have added at run time as the first column in your SELECT Statement...Leave a comment:
-
If you are using SQL Server 2000 ver. use IMAGE data type...Leave a comment:
-
It doesn't work.
Server: Msg 3903, Level 16, State 1, Line 1
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION....Leave a comment:
-
I have not used any
begin transaction, commit transaction or rollback transaction
I simply open the SQL Query analyzer and fired the Query...Leave a comment:
-
Rollback Of Modification
Hi,
I have a question regarding the rollback of transaction
I have a table EMP
table structrue is: EmpID, DeptID
I fired this query accidently
update EMP set DeptID=10
NOW, its has modified all the rows.
How can I rollback this transaction.
Plsae let me know -
To compare the NULL with NULL we use IS Operator:
...Code:DECLARE @i VARCHAR(20) BEGIN SET NOCOUNT ON CREATE TABLE #temp (Item varchar(20)) INSERT INTO #temp(Item) VALUES('erty') SELECT @i = Item FROM #temp WHERE Item = 'we' DROP TABLE #temp PRINT @i IF(ISNULL(@i, NULL) IS NULL) BEGIN PRINT 'Null' ENDLeave a comment:
-
No sure what you want. But it seems that you have two Access database and you want to access data of both databases.
You can create a Link Objects (Table /Query) of Database A, into Database B and Query them....Leave a comment:
-
I tried this:
[CODE=vbnet]using System;
using System.Collecti ons.Generic;
using System.Componen tModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows. Forms;
namespace test
{
public partial class Form2 : Form
{
public Form2()
{
InitializeCompo nent();
}...Leave a comment:
-
I hope this work
...Code:private void Form1_Load(object sender, EventArgs e) { MyCollection mycoll=new MyCollection(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AutoGenerateColumns = false; BindingSource bs = new BindingSource(); bs.DataSource = mycoll.GetRecords(1); DataSet Ds; Ds = new DataSet(); DataTable DT;Leave a comment:
-
Not necessarry.
If you are concerned with that, use XML as your database....Leave a comment:
-
Please provide more details. where do you want to pass parameter. to the stored procedure
execute storedprocedure parameterlist seperated by comma...Leave a comment:
-
You can use the MS-Access as your database. You can carry this database with your computer anywhere. Also, If you don't want to connect to the database at all, you need to design a robust front end which does all the database chagnes behind....Leave a comment:
-
1) Create a Link Table in your ms-access database of the EXCEL File
2) Create a Query
DELETE * FROM table1 where table1.[ID] IN (SELECT [ID] FROM ExcelFile);...Leave a comment:
-
I think the column type is IDENTITY so that its creating problem.
More info is here http://support.microsoft.com/kb/319699...Leave a comment:
-
In Access 2003, we use the following code to hide all the ms-access messages
DoCmd.SetWarnin gs (False)
You can try this. May be it works or you can find some thing similar to this...Leave a comment:
-
If you have more records thanyou need to write stored procedure to get the output....Leave a comment:
-
You can chage it this way
...Code:ALTER TABLE <TABLE_NAME> ALTER COLUMN <COLUMN_NAME> NUMERIC
Leave a comment:
No activity results to display
Leave a comment: