Search results

Amazing. Works like a charm. Thank you very much!

Thank you. Essentially, I don't understand the part about the boolean variable and how that can be used to prevent the error.

That error doesn't cause any problems, so I'm wondering, is there a way to just suppress it is that the user won't have to see it?

I'm afraid I do not quite follow. :D But would checking the date field directly in a third subform make any difference? Something like below? Or would that produce the same error since the one subform is loaded before the other? If Len(Forms!frmRSC!sfrmDisclosures1!DisclosureDate & "") = 0...

Ok, I fixed the incorrect display by putting the code into the On Current event of the main form as well. Still getting that initial error message... Maybe I have an error elsewhere.

Thank you! I am getting some very strange behaviour now - when I start the form, I receive an error message - error 2455: You entered an expression that has an invalid reference to the property Form/Report. After I click that error message away, the form isn't shown the way I want it but if...

Hello, I want to put code in the On Current event of a continuous subform on my main form so that when I click on different records and thus change what's shown in another subform right next to it, the second subform is hidden under certain conditions. Those conditions are the presence, or...

Hello, To my knowledge, there is no way to retrieve your data from the database itself, because the moment you delete records, they are gone. And you even compacted the db afterwards... The only chance for you to get the data back is to find a backup of the db. Or, to try to undelete an earlier...

All right, I shall follow your advice and see how it works out. Thank you very much. But first, I'll have to change a few things in my db design.

The disclosures are speaker specific, ie. need to be tracked for every speaker. So in that regard, this is a one-to-many relationship between speakers and disclosures. I designed the database that way but then thought that this setup won't allow the user to pick an old event, see who the...

The more I think about it, the more confused I get. :confused: Originally, my disclosures were tied to the speaker, the goal there was to just pick a speaker, and the disclosure information would be filled in automatically. That method would have replaced old information with new information...

No, not quite, because the disclosures get updated every year. I need to retain the old disclosure information and create a report that says in 2005, speaker x made a disclosure and sent it in on date a, whereas in 2006, he made another disclosure and sent it in on date b, and in 2007, he sent...

Interesting idea, but I don't think that'll work for me because I have to be able to go back in time and look up disclosures for previous years for a particular speaker. The disclosure data is simply a checkbox to see if there was a disclosure, and a date that records when that disclosure was...

Hello, I have a table "Speakers". For each speaker, there can be more than one disclosure [say, in the table "Disclosures"]. Yet at the same time, only one of those disclosures is current, the others are old data that needs to be kept around for analytical purposes. When I link speaker and...

That would be great if it would work... But what do you mean with "not link it to the main form"? Could you possibly post an example file?

It looks like the side-by-side method only shows additional information for one record at a time. Unfortunately, I have to be able to view, and more importantly print, all the information at the same time.

My coding isn't all that great either, but maybe your use of a combo box isn't such a good idea if you just have a yes/no situation. For that, I would think a yes/no field would be better which could be displayed as a checkbox, or as an option group. You could then unhide your image depending on...

Hm, I'm not sure that this will solve my problem, but it's certainly a new idea... Thank you.

Hello, For the life of me, I cannot think of a way to make this work. :( I have this continuous subform, and I need to put additional fields onto it. The easiest way to do this would be to create single record sub-subforms, but that won't work because Access won't let me put another subform on...

Oh, that's a neat idea, thank you! I shall certainly give it a try.