Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Cyberjake

  1. Cyberjake

    Search for record and save as a new record

    This has not worked for me. It keeps telling me that it would cause a duplicate entry. I believe what is happening is when I change the field entry, Access auto-saves that change to the current record which causes a duplicate entry error. Are there any more suggestions at this point? Thanks...
  2. Cyberjake

    Search for record and save as a new record

    Thanks for that info, I will try that and see if it will work for me. Thanks, Cyberjake
  3. Cyberjake

    Search for record and save as a new record

    I have an Access 2000 DB that allows the user to search on a particular field. After the user finds the record they searched for, I want the user to be able to change the entry in that field and save it as a new record (and still retain the original record) using the data from the entry they...
  4. Cyberjake

    Reserved Error (-1517)

    Can anyone tell me what this error code means? "Reserved Error(-1517) There is no message for the error." I am getting this message when I perform a search on a particular field in my DB and every time after that when I try to close the form. It seems to only happen after I do a...
  5. Cyberjake

    On Key Press

    Hey Tony, I set the submit command button to default = yes and it works the way I want it to...I will have to remember that one. Thanks again...
  6. Cyberjake

    On Key Press

    That is what I am wanting to do. I have two buttons on the form a submit and a cancel. The submit checks for a true statement and then closes the form and the cancel clears the entries and closes the form. Thanks...
  7. Cyberjake

    On Key Press

    I asked the user about that and they would like to be able to just hit the enter key and submit. I have been trying to find some information on KeyDown and KeyUp coding to see if that would help, but I have not found anything that helps.
  8. Cyberjake

    On Key Press

    Hello, I have a customer who would like to press the enter key to submit a command. I have never programmed On Key Press. How would I program On Key Press so that when the customer presses the enter key, it performs a submit function? Thanks, Anthony
  9. Cyberjake

    Form Order

    Thanks Randall. I had the properties of both forms set to dialog and I thought that would work but I guess I was wrong. I coded the form to open as dialog and it works great. Thanks again. Anthony Robert
  10. Cyberjake

    Form Order

    I have a form that when the Zip Code field gets focus, it opens another form where the user can select a city associated with a zip code entered when the query is run. My problem is that when the second form opens, it is behind the main form and I cannot select the correct city without closing...
  11. Cyberjake

    ListBox Auto Row Selection

    That was it...Thanks a million. I have to say that I have only begun to use this site and already it has proven to be more helpful than I could have ever dreamed. I look forward to utilizing this site in the future.
  12. Cyberjake

    ListBox Auto Row Selection

    I have a need to automatically select the first row of a list box. Is there a way to automatically select the first row of the list box when the list box gets focus? The user uses the first row in the list box 95% of the time and would like to have it automatically selected when they tab into...
  13. Cyberjake

    vbYesNo MsgBox Functionality

    Thanks, that worked out great. For the longest time I have avoided using the MsgBoxes because I could not get them to function properly. You have enlightened me on how to use them. Thanks again!!
  14. Cyberjake

    vbYesNo MsgBox Functionality

    I have selected to use the vbYesNo MsgBox in my coding. My dilemma comes when the message box appears. I click on Yes and it runs the remaining code; I click on No and it still runs the code instead of ending the sub routine. How do I make the Yes and No buttons on the MsgBox work so that...
See more

Part and Inventory Search

Back
Top