Search results

Hello all. I think my problem looks like it is not understood properly so I simplify it. What code must I add to the button ADD NEW, which is on the parent form to got to a new new record in the subform please. This should be very easy for you guys. So I want the BLUE LINE current record to goto...

The problem is I do not want to go and click on the asterisk(*) and then go back to the combobox to go select the item. I want to select the items from the combobox quickly without going to the asterisk(*) on the subform and it must be added to the subform one after each other Thanks for those...

Me!cmbBookNoTitle.Value = "" Me.frmStudentBooksSubform.Form.Recordset.AddNew Getting an AddNew Error

All I need is some code to to activate the the row with the asterisk(*).

Hi there I am trying to accomplish the following. But everytime I must first go to the subform click on the empty row below before I can add a record from the combobox.

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 GaP42. I hope you are doing fine. I have been sitting the last few days figuring how to solve my problem. I used my original ERD as intended. I decided to make a new Form to as shown below which will update my previous form when the records are updated. 1) Because only the BookTitle field did...

Hello GaP42. This part is 100% correct what you said. "What you are trying to do, as in scan (read a barcode) into "BookNo" is not the focus of your what you application is about. I would guess, from what is shown, that your db application attempts to track the borrowing of books by students...

Hi GaP42. I reverted back to my original ERD as follow. What I am trying to do is scan or enter in the BookNo then the BookTitle must be automatically be entered in the LearnerBookIssue. I started the application not with this idea in mind. I am trying to change my application to achieve this...

Thanks for the advise. Much appreciated.

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. I posted the wrong database query. Here is the correct one..Thanks for reminder BookNumber is correct table. Any suggestions how to fill both fields if i only search a number?

Hi there. I put a wrong query there.Here is the new db.Thanks Hi there. I place the wrong database. I did get title from BookNumber. I will put correct database.Thanks

Hello. No the StudentBookIssue_ID is going to be a number i will be scanning in using a barcode scanner. I need to populate the corresponding BookTitle wit the book name.I hope you understand what I am trying to do. You can download and open my database ans see how it will work.Thanks

Hi there. First of all this is not a combobox. I am looking up a value from a table. If I get the booknumber then the name must be added to the BookTitle field. So if if choose StudentBookIssue_ID no 11 then the corresponding book name must be added to the field BookTitle which is the next field...

What I need is that the BookTitle field which is empty must be populated with the name. So 11 will go in first field and the book name must go in BookTitle field

Hi there. Is it possible for you to try to assist me please . I need help fixing my rowsource problem. This is still my original problem. As you can see in the image and if you open the database. When I lookup 11 for StudentBookIssue_ID which will be inserted in the StudentBookIssue_ID field...

Hi there. The lookup is from a table. So I decided to modify and use foreign keys and the correct control source to fill in fields. Thanks for advice