Search results

Any chance anyone else can offer some advice please? :o

Hi Bob Thanks once again for the advice. In your reply, in step 1 you say not to unlink the first subform, but in step 4 you then say to unlink the first subform? Or have I missed something? Re step 2, down here in New Zealand we use the date format dd mmm yy, so the masks work for me. I've...

Hi Bob Thanks for having a look at the problem for me. I can see the changes you have made, but I still get the same errors as last time when I open your version. If I open the Cutdown.mdb and use the main form record selector to select a new record, as soon as I enter data in any text box...

I am going around in circles. I am trying to design a database to submit for an assignment but it is driving me mad! I am not sure if the problem is with my actual database structure (eg the relationships) or the way I am trying to use the forms? What I am trying to do is have a main form with...

Can someone please decipher the following error that I have received while designing my database: "The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'Tbl_Faults.'' I get two choices, click 'Ok' or 'Help'. When I click on help I...

Hi Spasticus Thanks for the assistance, you've solved the conundrum for me - I can't believe how simple that was! :o Keep up the good work. Crash

Hi there. I've been racking my brains the last few days trying to figure out how to hide a subform based on the results of a query. It seems I don't know as much as I thought I did! Essentially I have a main form with several checkboxes, a single button that runs the query, and the subform to...

Thanks for all your help RG. I've tried the DLookup and have managed to get the photo's to display when I want. Now I'll just experiment with some error code for if there is no valid photo path (or photo). Hopefully there is something in this forum I can use as an example. So once again...

I don't quite follow you there? I don't want to edit any fields in this form. I want the user to select a course, and then the student on that course. The photo of the student should then display for confirmation you've selected the right person. After that all other fields should be new...

Well RG, I think I've been a nutter all along!? Thanks to your latest sample DB I got the photo's to display, but then I noticed that some "old" data was appearing in the other fields. I also saw that you had set the two first combo's to "" in the OnLoad event, and then the penny dropped...

I've had a quick look and yes thanks that looks like what I'm after. I'll copy bit's across to my proper database and see if it works with "full" paths for the photos. I'll let you know how I go. Thanks very much for your help and the awesome response times.

Hi again What exactly did you change with the photo field? Because as you can see from my original sample, I was using full path names. I can't actually see what you've changed to make it all work? (I do see your code in the OnCurrentEvent). I have noticed that the second combo box "student...

Hey that's great thanks, at least I can see it can be done! But, I've seen a couple of things in your sample file: 1. I now have to use the record buttons at the bottom of the form (weren't there previously) to see the records. Because we have lots of students I'd prefer to still use the two...

Hi thanks for helping. I've attached part of the database for you to look at. You'll need to adjust the path in the table to find the photo's included in the zip file. The form giving grief is "frmInputData". Thanks

Ok this is getting frustrating. I have done as suggested and referenced the form to a query containing the fields I want, and yes, now the field can be linked to the text box. I can see the "file locations" in the text box, but now my image frame won't display the photo's. I've tried the...

Hi, I'm probably overlooking something real simple, but it's been a while since I played with access. I have a form (frmInputData) based on a table (tblStudComments), which contains comments about student performance. The form also contains combo boxes, the second combo box list is based on the...