Search results

Hi Mr George. Yes you 100% correct. I am trying the foreign key option and just have to point my control source where necessary. Thanks

Hi there thanks for all the suggestions. The lookup is from a table called BookNumber. I just wonder if this was possible. If it is more difficult then combobox then I then I will switch to foreign keys to fill in field. I you do have a solution I will try that as well. Thanks

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...

Thanks for you assistance and helpful advice

Hi. Colin. Thanks for the nice video and code. I will definitely experiment and see what I need.

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.

Thanks much appreciated for the info.

The total of books are calculate. The total_in_store is being deducted by 1 if a book is issued and added by 1 if a book is returned

I am on this form. When I add the book Top Class Life Skills 1 i must get a autonumber in Student BookIssue_ID and the checkbox must be ticked. as the book above it. Current I have typed 1,2,3,4,5,6,7 and the issued checkbox was ticked and total_in_store was was update. I need to achieve...

I am still busy with my book control application. When a book is issued an autonumber will be assigned and a checkbox must be activated to indicate that a book was issued and the store count must update by subtracting 1 from the total. Not sure if you understand my scenario.

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...

Ok. I will definitely was not sure if each thread is for my own question only.Thanks

Hi there. Thanks for your suggestion.You were spot on with the requery of the listbox in the after update event. I was about to give up and try the requery and it works. At first I was not sure where to requery. But after a few tries. I realise I must List45.requery in the after update in the...

Hi there. Thanks for the suggestion of the IS Null. It does bring up the records in the List box but my actual fault was that I did not requery my List Box in the After Event of my combobox selection.

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...

Hi all. Just tried that conditional formatting out and it works like a charm. I never knew about conditional formatting or had the need for conditional formatting in Access. Thanks again.

Hi there. Let me explain a bit how it works. We have a total of a specific book text book in the store. As the same book is issued the number in the store decrease. When a learner returns that specific book the total in the store increase again. I just used letters and not actual books. I will...

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...

Thank you very much for the person who posted this code. This code works very nice. I used the code and just changed my table names and key names. Thanks BMAccess Private Sub BTtoevoegen_Click() Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim ctl As Control Dim...