Search results

Thanks JR, that did the job perfectly

Thank you, that seems to have done the job. I have been trying to make a forms to allow the user to choose the report they want to view, with the idea being that once chosen and open they can apply whatever filter they may need. By using code and directions from...

It is showing as unfiltered at the bottom of the page, however when I go to advanced > advanced filter, the right filter is there. I tried changing to filter on load but that wouldn't work either. There was the original "example" record, and I added "example2". When I select 'example2' from the...

Thanks jzwp22, it is opening the right form with a record in, but I tried the code with more than one staff detail and it is just bringing up the same first record each time. Do you know how I could change this?

Zipped file attached, it is empty with one example record run through it. All data entry is through frmStaffMAIN

I tried both a textbox and combo box with the command button but I am running into the same problem with both methods - after 'open form and find specific data to display' the textbox/or combo box is not appearing in the list, so I have an empty list on the left, but a fully populated list on...

The row source of the combo box is: SELECT tblStaff.pkStaffID, tblStaff.txtLastName, tblStaff.[txtLastName] FROM tblStaff ORDER BY tblStaff.[txtLastName]; I now see how you mean it will only pull one record, is there a way to pull all related records? Unfortunately because the data I may...

After adding data to my database, I am now finding the need to edit this occasionally (if info gets wrongly entered etc) but presently I don't have a way to do this without finding the table and record, then entering the data there. I have tried making a copy of my data input form, then adding...

Star! That's got it, thank you very much! That has had me stuck for ages. Out of interest and for future reference, at what stage does that go wrong? Can Access pick the wrong fields or is that as a result of something I did wrong at some point?

To the best of my knowledge the form is working properly, when I check tblStaffInstitutionNatureofRelationship it is creating a new record when necessary, storing: pkStaffINstNatureRelateID fkStaffInstitutionID fkNatureofRelationshipID I am not sure how to go about checking the way table...

Just checked that but no luck unfortunately. Currently the subform and subsubform are linking master field pkStaffInstitutionID to child field fkStaffInstitutionID. Any other ideas? I'm pretty stumped. I would have thought that because the form is able to put data into the right table it would...

In checking my subforms (I have a subform in a subform in a form) it appears some data is not carrying through properly, which is strange because in some ways it is working. I have: tblStaff tblStaffInstitutions tblStaffInstitutionsNatureofRelationship When I look at tblStaff, then hit the...

If I could question your technical know-how once more - I now have most of my database built, and have been looking at creating some reports, but because of the primary and foreign keys throughout my database, my data is now all stored in numbers (which refer back to what I have called the...

Commenting it out did the job, so I have now deleted it, thank you. Things are coming along now, but I seem to have hit an old stumbling block - My main form frmStaff has 2 subforms on it for tblStaffInstitutions and tblOverseasBusinessLinks, but when I enter a new Staff Institution, the...

Thanks jzwp22, NotInList seems to be the ideal solution, I have started working with some code I was able to copy and paste in, some of which I have been able to adapt as necessary, and although this seems to be working (the combo box is drawing universities from tblInstitutions, and allowing...

Hello to the both of you :)

I did also have the two subforms on separate tabs off of the main form, which I just deleted, moving the subforms both onto the main form, which has got rid of the parameter value message box, however then on opening the form I got another message box - "The expression On Current you entered...

I thought I had managed to fix the parameter value problem, I added the primary key value of each subforms' corresponding table to it, also making it invisible, and this seemed to solve the problem. But now after a few computer problems, leading to a restart, I now open my DB and once again it...

Because I am unable to get hold of a reliable and complete list of world universities - with related city and country details, I have been trying to make a combo box on my form that sources its info from the very field it puts data into, so that the list self-populates as the database grows...

tblOverseasBusinessLinks is a recent addition, and you are right to pull me up on it, although field natureofrelationship will by coincidence have some overlap with the same in the other table, it will have different data so I will change the name now. Thanks for pointing that out, saves a few...