Hola:

Aqui os dejo unos links,que funcionan de verdad,y donde tendreis la
oportunidad de ganar bastante dinero
no perdais la oportunidad,por intentarlo no perdeis nada.

www.depacco.com/pages/index.php?refid:agamenon
www.agamenon.ws

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

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 sure it has to do with the format the code I have is as follows:

Private Sub Command5_Click()
Dim a As String
Dim CritS As String
Dim CritW As String
Dim CritO As String

CritS = "SELECT PostJobs.COMPL_DTE_OJB AS [Comp], PostJobs.ORDER_NO_OJB AS
[Order], PostJobs.JOB_SEQ_NO_OJB, PostJobs.JOB_NO_OJB AS Job,
PostJobs.JOB_TYP_OJB AS Type, PostJobs.IR_TECH_OJB AS Tech,
PostJobs.QC_STATUS, PostJobs.QC_REP, PostJobs.QC_DATE FROM PostJobs "

CritO = "ORDER BY PostJobs.IR_TECH_OJB, PostJobs.COMPL_DTE_OJB; "

If Me.Option6 Or Me.Option9 Then
' CritW = "WHERE (((PostJobs.IR_TECH_OJB) = '" & Me.Text3 & "') And
((PostJobs.COMPL_DTE_OJB) = #" & Me.Text8 & "#))"

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 timestamp column to a) all tables, including
domain or lookup tables that rarely change - if at all, b) the tables that
are sometimes added to as well as the main data or transcational tables, or
c) just the tables that are managed through applications?

We have applications that allow for entry and edit of "field" data, but,
from time to time, there are management functions that require the use of
temporary employees to access the database for data maintenance and it's much
easier to train them through the use of Access' query designer than T-SQL,
even through SQL Server Express for the short period of time they are here.

AFAIK, Access/Jet/DAO won't let you link to a linked table.

Will your application let you link to a file DSN? Since a file
DSN and an Access mdb are both files, sometimes applications
automagically allow you to link to a file DSN without noticing.

(david)

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

"Maverick6197 via AccessMonster.com" 在郵件張貼內容主旨
8a4e555595551@uwe 中撰寫...

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=q2.ID
LEFT JOIN
(SELECT ID, SUM(fldAmount_2) AS fldTotal_2 FROM dbTable3 GROUP BY ID) q3
ON q1.ID=q3.ID

This will work.
But if I want to nest it again into

SELECT Projectid, SUM(fldValue_1) FROM ( .....previous query ...... )
GROUP BY Projectid

"Terry Olsen" hotmail.com> wrote in
news:OeNFe5gFJHA.768@TK2MSFTNGP05.phx.gbl:

You can't run and Access/Jet app across a wireless connection.

Windows Terminal Server would be the easiest solution to your
problem.