Recent content by lostwithaccess

When I opened the database this morning, and went to enter data into a subform, I was given an error message saying something along the lines of "link master fields return without gosub" but after closing the error message the problem went away, and even after further open/closing of the db it...

I have been trying to change my combo box (searching by last name) so that the bound column is the primary key rather than the last name, but I have been unable to successfully change the filter code to work with this. My main form holds pkStaffID, which I want to match to the combo box...

The record source of the main form is tblStaff And the subform Mast is PkID, Child fkID The macro is a command button on the subform also. I checked the whole dataset and it was only the details for one staff member that were duplicated with the different nationality so I deleted and...

Thinking I may have a relationship wrong I checked a few different staff records to find that not all of those staff with dual nationality have been recorded as 2 staff. tblStaffNationality shows the same pkStaffID for 2 nationalities -which is correct, whereas for a couple of others it shows...

I tried using the primary key, which alerted me to a problem - for those staff with dual nationality my form has recorded them person with two records - one for each nationality. In my data entry form there is a subform which records nationality, and if it is dual then you click...

Nearly there... on this last bit I have a combo box to filter records by last name, but for those people who share the same last name, my db is combining the data into one report. I have now put 2 columns in my combo box to display last and first name, but cant quite work out how to get it to...

Thank you so much for all the help you gave me with the problems I came across in building my database, I really appreciate you taking the time to help find a solution! Helped me learn a lot on top of just applying a solution so thank you. Si

Hi all, I have a report to show a number of "priority institutions" from my main table of institutions, and each institution has one or more records associated with it. So far I can get the first part of this report to work with a filter based on a table listing these priority institutions...

This is frustrating, I am still getting 'unrecognised database format', not sure what to try now? I have tried opening it on another computer, just in case mine is doing something funny, but it still wont have it. Still struggling to find a way to make this filter work..

Just double checked - when I download and extract a new copy that you posted it is still unzipping as an mdb, maybe still something to do with me uploading a weird / mdb copy?

Access is still telling me that the copy you posted is in an unrecognised database format, even though I changed the filename extension to accdb. Not sure what else to try with it? I believe I changed it correctly - I changed the filename ext by displaying it in my Folder Options, and edited it...

Strange, looking at my backup copies along the way it changes from accdb to mdb about 3 weeks ago, but I hide file type extensions so that I cannot change them accidentally if I make any filename alterations. I have now made another copy of my database, changed the extension to accdb, and...

Thanks, but unfortunately now I cannot open it! I am getting "unrecognized database format" Would you be able to just post the code? / Is there another way to do this? Bit confused as posting db on here has worked before, I am definitely using access 2007

I'm using access2007, maybe I did not zip it properly, different version attached this time. I have changed to using the pkID which is a lot clearer. What if I build a new table with pkPriorityPartnerID and fkInstitutionID? Then use strSQL = strSQL & " (tblPriorityPartners.fkInstitutionID)='70'...

I've had a good look through but not managed to get anywhere with it. I have done my best to remove any sensitive data without breaking anything. Let me know if you have any problems with it as is and I will make any necessary changes. I have copied the code from the immediate window below...