Search results

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

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

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.

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

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

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

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

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?

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

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

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

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

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

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

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

I have what Microsoft call a "Navigation Form" as the main form in my application. Users just click tabs to move about the application and it all works very well, looks good and was almost no work to produce. Now one of the forms that opens when you click a tab shows a summary of overdue...

I have almost completed a DB for a will writing company and they are well into beta testing. I have a comment from them regarding the visibility and ease of of use of the built in record navigator at he bottom of some of my forms. They say its too small and fiddly to use easily. Now, of course...

Thanks for the quick replies. RuralGuy had the exact answer I was looking for. I thought, wrongly, that the On Current event occurs only when a form is opened. I now know that it also fires whenever the focus leaves one record and moves to another. The clue was in the name of course - On Current...

Hello, I have a form bound (data entry) to a table; there is a text box on the form which is NOT bound to that table. It is bound to a Dlookup on another table. It all works fine. Here is the BUT. I would like the textbox.visible property to be True ONLY if there is any text in it. I cannot find...