Search results

The global variable solution works and it's not as messy as I thought - I have an aversion to globals & avoid them as much as possible. I am originally from Dublin but I've lived in Edinburgh for the last 25 years. My background is originally software development but I've been doing more IT...

Hi JHB Thanks for your reply. That's what I did have, but that introduced a problem: The form also has a Cancel button. If Contact1 is currently the default contact and the user sets the default contact for Contact2, this will remove 'default' status from Contact1 (after a warning message)...

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...

Using DoCmd.RunCommand does the trick nicely if you switch the warnings off. Thanks for sharing your expertise. Also good to know why using update queries is not a good idea in this situation - effectively pulling the rug out from underneath myself.

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...

Ahh - found it! Sorry - false alarm. FYI, the solution is to intercept the Unload event (which can be canceled) as follows: ============================================ Private Sub Form_Unload(Cancel As Integer) If (CurrentProject.AllForms("FilterCriteria").IsLoaded) Then Cancel...

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 Paul Well, that was an eye-opener! I had used a Recordset instead of DCount as I needed to access some fields further down in my code. But I popped a DCount into the code (as you suggested) and it gave sensible results. I found some more stuff on Recordsets posted in TechNet. Apparently...

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 just solved this myself as follows: * Open the 2007 back end and save as 2003 * Open the 2007 front end, go to Database Tools and open the Linked Table Manager * Check 'Always prompt for new location' * Click 'Select All' & then OK * Navigate to the 2003 back end & click 'Open' - the...

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...