Search results

You're correct in all your assumptions, but I want access to prompt the user to save any changes made prior to moving to a new record or closing the form. I want the user to manually click a SAVE CHANGES button so that the user does not accidentally change some of the info. If the SAVE...

Hi, I have a form that shows records one by one. The form shows all information in textboxes that are enabled and not locked. A user can view a record and make changes by typing in the textboxes. How do I make it so that anytime a change is made (adding/deleting info), the form requires the...

Hi, I have a form that displays "memo" records one at a time. Each record has a Memo id and a date. I would like the memos to be ordered from earliest date to most recent date. How would I do this? Also, after this is done, when the form loads, I would like it to automatically show the...

I'm kind of a newbie. So what does all that mean? How can I change it to correct to problem?

Hi, I need help with another combo box. my database has information about car manufacturerss and their id numbers: ie honda, ID 50-1 honda, ID 50-2 honda, ID 50-3 toyota, ID 99-1 toyota, ID 99-2 I have a form that displays each of these records. There is also a combo box that the user can...

Hi, I have a form that displays information about students and their hobbies. This form has the following data: student first name, last name, ID #, and hobbies. There is also a combo box that lists all students (there are 5 students in this database). When adding a new student using this...

I actually don't want the form to close, I would like the form to just move back to the last record. Any suggestions on this?

Hi, I'm having trouble with a CANCEL command button. When a user is entering a new record on a form, they may decide to cancel it. But if no information is entered in any fields, the cancel button produces an error message. The CANCEL button only works if info is first entered into any field...

ok, i added to code which will go to the previous record after hitting the CANCEL button: DoCmd.GoToRecord , , acPrevious I just copy and pasted that code from the Access created VB for a "Previous Record" button. The concern I have is, what happens if there is some sort of error with the...

Here's an easy question I can't figure out... I have a CANCEL button for when people are creating a new record and decide to cancel it. How do I make Access go to the last existing record when the user clicks the CANCEL button? Currently, when pressing CANCEL, Access still remains on the new...

awesome, it works. thanks!

I'm thinking I would need to have some VB code that says, if you are at a new record, then make CREATE button invisible and make SAVE and CANCEL button visible but I just need to know what the code is to signify that you are at the very last record (which is the new, blank record)... something...

Hi, I have a problem with a form. I have a command button for CREATE NEW RECORD, SAVE NEW RECORD, and CANCEL NEW RECORD (I have not displayed the default record navigation buttons). When the form loads, only CREATE NEW RECORD is visible. Once this button is clicked, CREATE NEW RECORD is...

I have two questions regarding autonumbers: 1. In the table, I have my primary key as an autonumber. I also have a form that allows people to input/edit records. The autonumber field has been locked because the computer will automatically assign a number for this, but the field still says...

I changed the relationship and that worked! Thanks! But I have another question... I am trying to add up all their ages (adults+their kids). But it will not add up the ages of the adults with no kids because for example, if the adult is 45 yrs old and he has no kids, then it seems that Access...

I have two tables : 1. Adults 2. Kids I want my report to list all the Adults (from the Adults table) and also list the kids they have if any (from the kids table). Currently, my report only shows the adults that HAVE kids. I want the report to show ALL the adults (even if they don't have...