Open Form to new record, etc.

[lemieux66c]

Hello guys,

I was just wondering if you could help me out with a few things. I'm using Access 2003 for the first time and I'm currently stuck with a few things. When I hit my add button on my menu, I want it to open to a blank record so I can input the student information. It currently opens to the first (and only) record so far in my table. I would also like (if possible) for my form to clear itself when I hit save so I can add another record if I wanted at that moment.

I also have an edit button. When I hit the edit button, it brings me to a search in which I (obviously) search for the record that I want to edit. After I hit continue at that point it brings me to the correct record. However, it would still enable me to go to another record after that. If possible, I would like to be able to lock that feature down so one can only search for the record that they initially wanted to edit.

I'm sorry if these questions are really easy (or don't quite make sense). I tried looking by search to answer these questions but I might not be using the correct terminology.

Thanks.

 

[Wiz47]

Hello guys,

I was just wondering if you could help me out with a few things. I'm using Access 2003 for the first time and I'm currently stuck with a few things. When I hit my add button on my menu, I want it to open to a blank record so I can input the student information. It currently opens to the first (and only) record so far in my table. I would also like (if possible) for my form to clear itself when I hit save so I can add another record if I wanted at that moment.

I also have an edit button. When I hit the edit button, it brings me to a search in which I (obviously) search for the record that I want to edit. After I hit continue at that point it brings me to the correct record. However, it would still enable me to go to another record after that. If possible, I would like to be able to lock that feature down so one can only search for the record that they initially wanted to edit.

I'm sorry if these questions are really easy (or don't quite make sense). I tried looking by search to answer these questions but I might not be using the correct terminology.

Thanks.

The easiest way to receive help on this one (since you have a number of issues) is to upload a stripped down version of the db and let some of us take a look at it.

 

[lemieux66c]

Here is a stripped down version of my database. I left the forms in that I was referring to in my previous post. Thanks.

 

[Wiz47]

Two of three problems solved. I'll work on it some more later.

 

[lemieux66c]

Thanks for the help. I've made the changes to my database project, and I think I will be able to replicate that in the future if I need to. I'm looking forward to any additional help you can give . Although now that I'm playing with the database a bit more I've discovered a new flaw in related to the images I'm trying to add to each individual student record.

 

[Wiz47]

Thanks for the help. I've made the changes to my database project, and I think I will be able to replicate that in the future if I need to. I'm looking forward to any additional help you can give . Although now that I'm playing with the database a bit more I've discovered a new flaw in related to the images I'm trying to add to each individual student record.

Yep, images are a tricky subject depending on what you are trying to do.

 

[Wiz47]

Three of three solved now. Just needed to tweak the stLinkCriteria statement in the studentsearch form.

 

[Wiz47]

Three of three solved now. Just needed to tweak the stLinkCriteria statement in the studentsearch form.

Had to make a minor adjustment because the ADD record was still filtering the form when it opened if an EDIT has been previously selected (and I don't believe you want that). I now have it close, then reopen before it goes to the new record.

 

[lemieux66c]

Thanks - I think I got this part of my database under control now...only if I could say the same for my reports!

 

[Wiz47]

Thanks - I think I got this part of my database under control now...only if I could say the same for my reports!

Glad to hear that you have it under control now. If you need some help with the report side, ask the question intelligently, let the board know what you have done already to resolve it, and chances are excellent that you will get a response.