Recent content by A10 Instructor

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

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

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

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

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

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

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

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?

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.

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?

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

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

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.

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