Curious, why adp query interface does not support update, action, delete queries like mdb?
Wed, 24 Sep 2008 22:20:09 -0700
Does anyone know why the ADP query designer does not support action
queries like the mdb verions does? ...
|
Alter Column with formate Property
Wed, 24 Sep 2008 05:44:01 -0700
I want to add a column in my table with data type bit in access database, and
after add cloumn if i swith to design mode then it desply 0 or 1 by default
value,
but i want to display Checkbox for bit data type , Please help me out its,
very urgent..
I am using c#.net so please tell me in c# code, in vb not ...
|
How to get access to column description?
Sun, 21 Sep 2008 11:01:09 -0700
I am running an Access 2003 project to a SQL Server 2005 DB. SQL Server
2005 allows you to document each column with a description. Is there a
way that an Access project can get access to this property of the
column?
John ...
|
test
Sat, 20 Sep 2008 12:43:29 +0200
test ...
|
Query format
Fri, 19 Sep 2008 12:07:01 -0700
I have an access database that links in some SQL tables. There is a form
where end users select options for what they want to display. Once an option
button is selected the text box associated with it is enabled and they can
enter in thier criteria. I have this working for two but can not get the
third. I am ...
|
Editing tables linked from Access to SQL-Server
Fri, 19 Sep 2008 10:23:01 -0700
On 10/6/2004 Chicago Dave asked about updating linked tables and Steve
Jorgensen replied that adding a timestamp column to the table will allow
Access to figure out whether a record has been changed.
I'm wondering what the impact of a timestamp column has on a database.
Should we consider adding a timest ...
|
Msg when an application is opening more then once
Wed, 17 Sep 2008 20:58:47 +0200
Hi,
I created an access application for several users. At times, they forget
that have the application already open and execute a new one reducing their
available memory. I'd like them to be notified when they try to open a new
application. Can it be done, and if so, how?
TIA
Edu
...
|
|
|
nesting subqueries
Tue, 16 Sep 2008 15:24:57 +0200
Consider the following query:
SELECT
Projectid,
'fldValue_1' =
CASE
WHEN ISNULL(fldTotal_1,0) - ISNULL(fldTotal_2,0) < 0 THEN 0
ELSE ISNULL(fldTotal_1,0) - ISNULL(fldTotal_2,0)
END
FROM dbTable1 q1
LEFT JOIN
(SELECT ID, SUM(fldAmount_1) AS fldTotal_1 FROM dbTable2 GROUP BY ID) q2
ON q1.ID ...
|
Duplicating data in continuous subform linked to SQL
Mon, 15 Sep 2008 14:02:03 GMT
Ok, I am working on upsizing a FE/BE DB that I have to a SQL 200X BE. I did
the upsizing and everything works except one thing...
I have a main form that has multiple subforms under tabs...
the subforms show data linked to the main form by an autonumbered ID
The subforms show the first record repeated as ...
|
Stored procedure recordset not opening
Sun, 14 Sep 2008 16:09:01 -0700
I have SQL Server 2005 as my database and Microsoft Access 2002. I'm trying
to open a recordset from a lengthy stored procedure in VBA. I have no
trouble returning data from simple SQL queries, but I keep getting an error
that the recordset is not open when attempting to get a recordset from a
particular s ...
|
