Recent content by MajP

I would put my money that is what is going on. The OP forgot to bind the checkboxes, because that is about the only way you can return a null value. An unbound checkbox on a form or report returns null. In a form if you click it will become true, then false. Only if triple state is selected...

This is probably why the suggestion was made to use Dot notation and not Bang (!). With Dot you should get intellisense so when you type Me.l then it will show all the objects starting with "l". Bang does not provide intellisense. In the format event it will run through every record. If you...

also if you do a lot of this I recommend a function like the CSql. Then you code is ... JR_ID, "& Csql (me.TrnDate) & ", " & csql(me.TrnType) &. It will figure out if it is a string or text or numeric...

A couple things to make it easier. 1.Debug dim strSql as string strSql = .... debug.print StrSql look at the debug and ensure it makes sense. 2. When working with string literals in sql use single quotes. Much easier to read and no doubling up ...Where Rank = 'Junior Firefighter' and Status =...

FYI, This sounds like a "split form". A detail section and a continuous section. If so you may like https://www.access-programmers.co.uk/forums/threads/emulating-the-split-form.294421/

I can think of at least three ways 1 recordset.findfirst 2 set the bookmark 3 use docmd.goto record with a bookmark With Forms!frmMain.RecordsetClone .FindFirst "ID = 123" If Not .NoMatch Then Forms!frmMain.Bookmark = .Bookmark End If End With with a docmd ' Go to a...

FYI, I had to check this in chat because I would not think it would do anything so I am suprised it worked at all. So it should not go to that record and should not cause a requery.

That code is usually to open a new form. As you describe it, it sounds like you have a main form, with one or two subforms on it. Is this a split form where the main form is the details and the subform is a list. If you click in the list you see the details. If so then the code should be...

I am not sure what that means. I interpret that to mean that after you C&R the corrupted backend you lose some features in the front end? That seems strange and I can only guess that the backend is still corrupted but to a lesser extent. Can you explain the features that you lose? I have never...

It might still be worthwhile to see your button code and then we can see if there is something that may cause this under certain conditions.

Can you provide the code behind the button to do this. If you click on a record in the subform and that code move to the details in the main form for that record. the subform should stay in place unless you have code that moves it away. This could be done if you have something like a requery in...

If you are going that route why not get rid of all the reference tables and make a single table Make tblProperties -- PropertyID -- PropertyTypeID -- PropertyName Now you can enforce RI and simplify the UI. However, I do not think I would recommend this approach to novices unless I envision a...

You can support it, but I would say you cannot really "manage" it. You can simply keep the instance open without an external means to hold the reference. To me "manage", means you have a way to reference one of the specific open instances. That is demonstrated here. I can close the instance...

For those who have never worked with multiple form instances, here is a good example of how multiple form instances can have utility. It shows you one way you can manage the instances externally by opening and closing them from using the multi select listbox. Usually you would use something...

Yes I was confused because you showed this in your original and not the event procedure you put in the example. Public Sub CloseMe() Set me_ = nothing End Sub Since the original thread seemed to be referring to closing instances external from the form, I was trying to understand how you...