Recent content by pita2

Thanks, GingerR.

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.

As an FYI - I found the answer in the following website: http://support.microsoft.com/?kbid=208200

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...

Eupher, Your suggestion work exactly the way I wanted. Thank you all for your help!! You guys are the best!!

It works! It puts the cursor in the textbox. One thing though, the user still has to space out the incorrect password and retype it. How can I highligh the incorrect password, and the user can just overtype it? Thanks much!!

Sorry for the confusion. Let me clarify. In the AfterUpdate event of the text box, I called the cmdOK_click procedure. It works fine except the txtPassword.SetFocus. If a person enters an incorrect password, then the focus goes to the Ok button rather than the txtPassword field like it should...

Thanks for the reply. I tried that. It works if you entered the correct password. But if I entered the incorrect password, it populated the message, but the focus is not being set in the password field. If I have the code txtPassword.SetFocus, shouldn't the password be set correctly? Any ideas...

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...

Ken S. You are exactly right. I am trying to create an Access executable. I checked out the link that you provided. I am not seeing downloadable add-ins for the acess developer extensions. I was told that the develope extensions are not free for download. Is there anyway I could get the free...

Thanks for the reply. I tried your suggestions and it did not work. What I am looking for is to use a package and deployment wizard that will allow me to create an acess run time package. The wizard normally comes with the acess 2003 developer version, which I don't have (I only have the access...

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.

It works!! Thank you very much. You really save me the trouble of restoring the file.

I foolishly unchecked all the options on the StarUp form. Now I can't get to the database or the code. Any ideas how I can reset that? Thank you.

Thank you So very much!! Your queries work perfectly. You are a star!!