Search results

Thanks for that.....I have taken the frustrated Left join approach and now have it working.. Much appreciated

You might be referring to the different name in the Contact History table for the ContactID matching to the ID in the Contact table. These are the same types of fields and I have a relationship established in the database on those fields with Contact to Contact History being 1 to many Scott

Hi, I am having trouble with a query that is joining two tables... The first table is Contact which has fields ID, CompanyName, AddressLine1, etc The second table is Contact History which has the fields ID, ContactID, CommunicationID, CreateDate The Contact History table contains a...

Thanks for that..... I will try one of the suggested methods and I am sure it will work....I had thought that the behaviour of the Frame control would be the same in Access as it is Excel....looks like I was wrong Scott

Hi, I am using Access 2007 for this first time and I am trying to group a set of controls (textbox, combo and listbox)....so that I can then enable that frame or disable it in one statement. I was able to do this in Excel forms, but I cannot seem to get the Frame control to recognise the...

Hi, I am using Access 2007 for this first time and I am trying to group a set of controls (textbox, combo and listbox)....so that I can then enable that frame or disable it in one statement. I was able to do this in Excel forms, but I cannot seem to get the Frame control to recognise the...