Search results

Hi there. I would like to set the focus on a component cmdBookNoTitle in my main form from an Error Event handler of a subform. The name of my subform is frmStudentBooksSubform. The parent form is frmLearnerBaseDetails The component on the main form is cmdBookNoTitle. Thanks Error Event code...

Hi there. My records are filled from my combobox. The problem I am having is when I try to add the next record from my combobox it overwrites the first record in my subform. I must physically click on the asterisk(*) which is the next record to have a new record added. Any help please. I have...

Hi there. When I run my application the data entered appears in my FORM but not all fields are saved in my TABLE. The field in that are not saved is my BookTitle field which is derived from the combox StudentBookIssue_ID. [BookTitle] Control Source : = StudentBookIssue_ID .Column(1) . The...

Hi there. I am busy with my book system. I want to lookup the ISBN in a table and I need to populate the title with the book name as well. Thanks for any help. Hi all. I have read all your suggestions and I appreciate all. I understand that lookups is not a good way to fill in fields but in my...

I have set most options to false but the file menu still appears in back ground when my application is running. Anybody can assist me how to do I completely remove it please.

Hi. I need help with the following please. When I type in a number in the StudentBookIssue_ID the code runs perfectly and the checkbox get checked. When I set the field to an autonumber the number gets inserted but the code does not get execute. And my IssuedLearner.Value stay false. Private...

Hi there. This is my form details. I need to show only the Names of learners selected from a specific based on the selection in the combobox named cmbGradeSelect. But when I run it I get a blank List When I hardcode it with “1A” I get the correct result. I think I have some reference issue...

Hello all. I have been developing programs with Access for some quite time now. I use to start with Access 95. I am not a full time programmer but develop programs on a part-time basis. I hope that you can assist me with any of my problems. Nice to know there are people still passionate about MS...

I am trying to lock a specific field in a row. When I do manage to locked the field it locks the whole entire column. Below is a screenshot and some code attached to some of the check boxes so that you can see the variable names I am using...

Hi there I have this one problem that I am struggling with. I have a listbox (multi selection). The listbox contains all the subjects a school can offer. Students only take seven subjects. I would like to allocate the selected subjects to the child records by clicking a Button on the form to...