Search results

  1. A

    resetting a subforms textboxes

    Re: LagBolt, I do better than that. I teach the maintainers on how to maintain the Hawg! A catch phrase we use that infuriates the pilots is this: "It may take a college degree to fly them, but it takes GED's to fix them." As far as the docmd.close...I probably can get rid of them. I...
  2. A

    resetting a subforms textboxes

    I have a Form/subform that is used to allow editing of a user selected record from a table called personnel. When the form/subform is first opened, all text boxes are blank. The user selects the desired record from a combo box that uses a dropdown list to display all records of the table...
  3. A

    Preventing a record from being deleted

    Pat, Thanks for all of your help and suggestions. This is exactly what I was looking for! Again thanks for all your help.
  4. A

    Preventing a record from being deleted

    Re: Pat, Thank you for the advice. I did make the form "unbound" and use the code you posted. I do not understand the "...and put it back after the form is open." though. The text boxes that have the control source connected to each field in my table will appear with " #Name? " in them...
  5. A

    Preventing a record from being deleted

    Re I have a several forms that use the same table. I created a combo box to allow the user to pick a particular record and the forms display all fields of that record. I use a blank record so that when the form is first opened, it won't show the first populated record. If you know of a...
  6. A

    Preventing a record from being deleted

    I have a table with a blank record at the begining and populated records thereafter. I used the cmd button wizard to create a delete button for that table. Is there a way to prevent the blank record (record 1) from being deleted by the command button but still allow all other records to be...
  7. A

    Record selection

    I've created a form by selecting a table and use the insert menu command. I placed all fields from the table onto the form along with a combo box set to find a record based on the value I select in the combo box. Everything works great. I've noticed that when ever the form opens, the combo...
  8. A

    Edit cmd button image created by cmd button wizard

    I created a cmd button that when clicked will exit access. I used the Stop sign picture as the button image. I would still like to use the stop sign image, but replace the word "STOP" within that image to display the word "QUIT" Any ideas on how to do this?
  9. A

    edit existing command button icons

    I understand changing the caption, but I don't see a picture property on the ALL tab Can you point me in the right direction? I'm fairly new to access.
  10. A

    edit existing command button icons

    I want to create a command button to close the access application and use the "EXIT" style picture. But I would like to modifiy the picture so that instead of the text "EXIT", it displays the text "QUIT". Anyone have any ideas on how to perform this?
  11. A

    Deleted records still appear in combo box

    I have a table that lists names. I've also set up cmd buttons to add new names, edit existing names, and delete names. Everything works great except for the Delete function. The delete function works, as the record is deleted. But if I go and try to delete a second name, the combo box...
  12. A

    How to edit records in a table?

    Sorry about that Christopherusly, I seem to have problems posting the table and form. Can you give me pointers on how to do that?
  13. A

    How to edit records in a table?

    Christopherusly, Thanks for taking a look and trying to help me out, I greatly appreciate it. If you comne up with any suggestions, please don't hesitate to voice them.
  14. A

    How to edit records in a table?

    Hi, I'm new to access and seem to be running into a problem. I have a table called personnel. Each record conatins their rank, last, first, MI, and duty position. I'm having trouble setting up the process to select an individual within the table, showing the current data in the applicable...
Back
Top Bottom