Register and Join the most happening forum of Sikh community & intellectuals from around the world.
I keep getting that error msg with this statment:
UPDATE UserIDandPassword SET Password = ? WHERE UserID = ?;
UserIDandPassword is a table...
I have written a DLL that raise several events. I want to use this DLL and
the associated events within Access 2003 but cannot seem to find...
I wrote this code in SQL View Query window but when I try to save it, I
get an error box that says "Syntax Error in FROM clause" I've...
I'm trying to check to see if the user has already added a Truck/Date
combination (with Status = A), before the accmdSaveRecord.
I have been...
WHERE ((tblTenant.ContractEndDate)>=Date()) AND
(tblVarRent.VariationNo)=(SELECT Max(tblVarRent.VariationNo)) AS MaxVarNo
I am having a little trouble with this IIF expression-- IIf([PFS 1]=0,("
"),[PFS 1]) --placed into the control source text box of a...
This is my first post, and my first attempt at this type of programming.
This is from MS Access 2003. I get the following error:
Here is the statement...
SELECT *, rand() as random_number
ORDER BY random_number DESC LIMIT 1
I suspect that the rand() is not...
down loaded from big pond, a tool bar,all went wrong after that.cant get into
own web site.everything else is working.