Search results

Hi there all. Thank you for all the feedback. My apologies if you feel that I did not give you proper feedback on why the code did not work. All of your code work if the Add New Record is inside the subform. When the Add New Record button is outside the subform unfortunately the code provided...

Hi there. This program has been has been working for the last 3 years with no problems. All I would like to do now is an upgrade to the application so that a barcode scanner can be used to scan the books out on issues and scan in on return.

Hi there. This was all I ask. I would like to know if there are code which I can put in a button outside a subform to select the new record on a subform. I do not want my user to click on the asterisk(*) to add data. Adding a new blank record I made a video if this was unclear to all.

Thanks . I will look at the db. I appreciate everyone's effort to assist me.

Here is my ERD again. I know I can use auto numbers as primary keys. I know that there are not two books and persons with the same name in my application. If there is anybody interested to see how my application work I am prepare to make a video and show you what I am asking in this post. Thanks.

Hello guys. All I ask was: Instead of the user clicking the asterisk(*) where we going to insert a new record with the mouse I wanted to know if there is code that will do this automatically when a button is clicked. This is what my application requires at the moment. I appreciate all your...

Hello all. I highly appreciate all your input. What I am asking might be confusing and maybe you do not see my logic. I like LarryE's comment. Thanks Larry :giggle: "This is just crazy. What are you doing?" I have design a text Book System originally without a scanner. It has been implemented...

Thanks MajP. Now if anybody can just show me how to get the new record selected please than my weekend is made. Thanks.

This is the code I used just add new record. Private Sub cmdAddRecord_Click() With Me.frmStudentBooksSubform.Form.Recordset .AddNew .Update End With

S Sir. You are correct. We are overthinking this simple problem. I am going back to basic just try to navigate as the records. That is what I am going to try now. I will download you and maybe you have simple solution. Thanks. Will let you know if it solve my problem. Okay I looked at the...

S Sir. You are correct. We are overthinking this simple problem. I am going back to basic just try to navigate as the records. That is what I am going to try now. I will download you and maybe you have simple solution. Thanks. Will let you know if it solve my problem.

Hi there . The error is not with the setFocus. The error is with the DoCmd... line

This is what I need after ADD RECORD is pressed. I have to click on asterisk otherwise I cannot add a record . I do not want my users to go click on the asterisk.

Hi there. Same error with this code too. Private Sub cmdAddRecord_Click() frmStudentBooksSubform.SetFocus DoCmd.GoToRecord acActiveDataObject, , acNewRec End Sub

Code in the Add Button Private Sub cmdAddRecord_Click() frmStudentBooksSubform.SetFocus DoCmd.GoToRecord , , acNewRecord End Sub

Hi there Private Sub cmdAddRecord_Click() frmStudentBooksSubform.SetFocus DoCmd.GoToRecord acNewRecord ------> this line creates an error. After subform has setFocus End Sub Thanks

Thanks I will try this.

If If I set the focus for the subform I think the first record will get the focus and not the new record Is this correct or is there a way for the new record to get the focus.

Hi all. I want nothing to be added to the new record. I have code that will add the data in the new record. All I require is that the new record in the subform must get the focus and ready to accept the data. I hope this may help. Any suggestions. Thanks.

Hi there. I tried post #3 code in the ADD NEW button but the current focus does not go to the asterisk(*) for new record.