Recent content by AOSB

  1. A

    Debugging. I need to break on writing to a backend table.

    Thank you. I didn't know about that, I am sure I will be using in some future debugging exercise. In my case I have been continuing to look at data macros. First I had to temporally change the problem table from Linked to Local. Then I can can attach a Raise Error event on Updating, Inserting or...
  2. A

    Debugging. I need to break on writing to a backend table.

    I have built a complex split accdb database which has run well for many months. The users have only just started to use one of the features and a problem has arisen as a result. In order to debug the problem I need to break the program execution whenever there is a write attempted to a...
  3. A

    I consider myself to be very well up in Access especially in those special magical places most...

    I consider myself to be very well up in Access especially in those special magical places most people are afraid to go. I can see that you are all that and more and I would feel privileged to be in your circle. Regards Alan Balding, St Breward, Cornwall, UK.
  4. A

    using variables in Forms!frmName.controlname etc

    Thank you so much, it now works perfectly. I have marked it SOLVED
  5. A

    using variables in Forms!frmName.controlname etc

    Thanks for the quick reply. Your syntax for the subform is correct but only if I replace the two string variables with the actual subform and textbox names Dim subformname As String Dim controlname As String subformname = "time line wills" controlname = "txtdGuard" Forms!frmsummary.[time line...
  6. A

    using variables in Forms!frmName.controlname etc

    Solved: Using variables in Forms!frmName.controlname etc I use this vba in a form to set a textbox background on another open form like this; Forms!frmsummary.[time line wills].Controls![txtdGuard].BackColor = vbYellow This works fine of course. Now the challenge is to use variables for the...
  7. A

    Can the built in record navigator controls be made bolder?

    Brilliant! The first link above was EXACTLY what I needed, thank you so much. Alan
  8. A

    Can the built in record navigator controls be made bolder?

    Thanks. So I tried to duplicate the built in Navigation controls including the search box. I thought I would make everything look like the Access built in ones but about twice as big and black. I can do it all with buttons and text boxes in the form footer but that doesn't look the same. Any ideas?
  9. A

    Problem using Expr1 in an Unmatched Query

    I have had a go myself but without much success Here is the qryPending code SELECT NewClients.FullName FROM NewClients LEFT JOIN qryLongName ON NewClients.[FullName] = qryLongName.[Expr1] WHERE (((qryLongName.Expr1) Is Null)); and here is the "Longnames" query referred to in the above SELECT...
  10. A

    Problem using Expr1 in an Unmatched Query

    Yes Brian, thanks for the speedy reply, you have understood my exact problem. I cannot make a left join to the alias and I suspect you are correct and it it not supported. Could you be a bit more specific with your suggested workaround please. I am not rusty - I just never knew how to do...
  11. A

    Problem using Expr1 in an Unmatched Query

    Hi all. In my database I have a linked table called NewClients (produced by another application and thus beyond my control) which has a field called [Fullname]. Typical contents are "John Paul Smith". I have a local table called tblEmployees which includes two fields [LastName] and [FirstNames]...
  12. A

    Access 2010 "Navigation Form" VBA code to Click a tab

    I pasted the code in and this editor inserted a space between Navigationsub and Form. This space is obviously not required.
  13. A

    Access 2010 "Navigation Form" VBA code to Click a tab

    Solved! Private Sub btnGo_Click() DoCmd.BrowseTo ObjectType:=acBrowseToForm, _ ObjectName:="frmBrowseTestators", _ PathToSubformControl:="frmNavigation.NavigationSubform", _ WhereCondition:="ID = " & txtTID, _ Page:="", _ DataMode:=acReadOnly End Sub Does the trick. The lesson seems to be...
  14. A

    Access 2010 "Navigation Form" VBA code to Click a tab

    Its not really like that in 2010. The Wizard opens an embedded macro sheet to fill in. A screen shot is attached. The Where Condition is wrong, I am still trying to work it out. But you make me think - perhaps I can scrap the embedded macro and put an On Click event in for the button instead...
  15. A

    Access 2010 "Navigation Form" VBA code to Click a tab

    OK I am halfway there. I find that you can achieve the result I am looking for with a Browseto embedded macro. The syntax is hellish but I now click the button and the right form opens up in the Navigation Form Frame. I really cant figure out how to get the Criteria syntax right so the correct...
Top Bottom