What is the SQL command to limite the number of rows being displayed?
Select * from cust where name=smith;
The above sql statemenat generates 500 records. But I only want the first 20. Any idea how I can narrow the results without adding extra criteria? Any help would be appreciated. Thanks.
Hi,
I have a field in a table that is set as hyperlink. Users can click on the link on a form and bring out file. It works perfect. However, if I want to edit a link, I tab to the field, then the whole field is highlighted. So when I click the field, and try to edit, it just brings out the...
Hi,
I have a login screen to check for valid passwords. It has a password text box, an Ok button, and a Cancel button. It works fine if the user click the Ok button. However, if the user chooses to press the enter key once the password is entered, they have to press the enter key twice before...
I created an application in access 2003. It did not have the package wizard. I now have Visual Studio (Microsoft Development Enviroment). Does Visual Studio has this wizard? If so, how can I get to it. I did not see it in the menu and the Add-in manager. Thanks.
Hi,
I have the follwing tables:
Equipment Table:
EquipmentID(PK) EquipmentName UserName
1 IT57 Smith
2 IT54 Jack
etc
SoftwareInventory Table:
SoftwareID(PK] SoftwareVerison Type
1 MircosoftWord Base
2...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.