Search results

Hi Something that's proving to be a little tricky. Here's the scenario: I have a table of Clients, each of which can have zero or more Contacts. Clicking the Contacts button on the Client form opens a pop-up form that displays the Client's Contacts. Each Client can have a default Contact...

When I run this code to delete the form's current record, the Me.Requery throws error #3167 (Record is deleted) and leaves "#Deleted" in all of the fields. Any thoughts? Thanks in advance. Patrick ========================= Private Sub DeleteProfessional_Click() Dim MyDatabase As...

Hi I have a main form (Client) from which I open another form (FilterCriteria). Since FilterCriteria code references the Client form, I want to ensure the user can't close Client while FilterCriteria is open. I'm thinking I need to intercept Client's 'Unload' event and cancel it - but I can't...

Hi I have a table in my Access 2007 database called Professional, which is linked to a Client table by its rClient field. The relationship from Client to Professional is one to many. There is a ProfessionalLead field in the Professional table that is bound to a checkbox. I'm trying to run a...

Maybe I'm being a bit slow here, but is there an easy way for me to see posts I have made?

I am developing a database in A2007 for a customer who only has A2003. I have split the database in 2007 but when I try to save it as 2003 I get "You cannot save this database in an earlier version format, because it uses features that require the current file format". Any suggestions?

Hi all I am a software engineer of around 20 years experience but I am relatively new to Access. I live in Edinburgh, Scotland and I do software development on a contract basis. I'm so grateful to the people in this forum for their generosity in helping others out. Hopefully I can make...