Recent content by davesmith202

Haha, indeed!

Client no longer wants this part, so its aborted for now. :)

Client has cut the budget so they don't want me to do this part. Not for now anyway! But for the record, there was no button for saving records. Just click off the subforms datasheet row.

I have a command button that opens a report with a where filter. The report has a main section and a detail section. Its a Organisation and its Contacts. The Contacts are in the detail section. How can I suppress the detail section (and a label) if there is no records to show in the detail section?

Thanks @vbaInet. How do I trigger the code? My subform is in datasheet and after I enter a record, I click off the row anyway to save. But perhaps that's where the "dirty" thing comes in.

@vbaInet, I tried that but if I do a Me.Requery, I get an errory Type Mismatch when I try to run my combobox search. Not sure why. Any ideas? @Mile-O, I am not a full time programmer.

I have my Contacts form open. My Company form is also open, with a subform having contact data. I add a record to my subform. But, if I then go to my Contacts form, I see the record is not in my Contacts form unless I reopen that form. Do I need to do a requery or something? I ask because I...

All done now. I used a junction table after all. :)

I'm wondering on the correct structure to do this. Can I do this: Contacts table, Organisation table, OrganisationContactsSub table. The idea is, you have Organisation table that has a 1 to many relationship with OrganisationContactsSub table. Then, in that sub table, you have ContactID that...

Thanks guys. Its as I thought but was just feeling a bit rusty!

I have Contacts that can be linked to many Organisations. Each Organisation can have many Contacts. So, does that mean I need a Many to Many relationship with an intermediate table? Contacts - ContactsOrg - Org Also, for each Organisation, I need to have a memo field, so that specific...

pr2-eugin, the requery is me trying to requery a field (Forms!tsTimeSheetMain!ProjectMonSum.Requery) on the main Form. Maybe you can't requery a field, just a Form?? I am finding if we change values in the subform, the dsum on the main form doesn't auto update. CJ London had an idea, although...

I used to use DAO before when I did more development, but thought that the ADO was Microsoft's new improved version. Good to know DAO is still hanging in there. :)

Well, I have already written the code to create the WHERE condition. I just need to use the DAO query code in my other post you kindly answered and tack the WHERE condition on the end. Simples!

Ok. I tried to create something that my client could easily replicate herself. She can do a very small amount of code but I was trying to do a work around so she could create other examples herself. Looks like its going to be a full vba solution for her and she will just have to grit her teeth...