MajP's latest activity
-
MajP replied to the thread Add a pattern of sequential numbers to a query.Are you open to a code suggestion where you push the results into a temp table. The reason is you can do a query that pulls a random... -
MajP replied to the thread Report.FilterOn is not working.Yes, but only in print Preview and not in FormView You can set the filter in onopen, but you need to turn the filter on in the onload...
-
MajP replied to the thread Report.FilterOn is not working.No difference. The issue is that the filteron must be moved to the onload. The filter will be applied in the on open but for some...
-
MajP replied to the thread Report.FilterOn is not working.The reason this does not work is because you are opening the form in Report View and setting the filterOn in the on open event. I do...
-
MajP replied to the thread Filtering between Forms..I am assuming that the combo is unbound, and that it is not linked to the subform. So what code exists now in the combo to navigate to a...
-
MajP replied to the thread Solved Properties not appearing in 2016.The properties window is slidable. Check that it is not slid shut. That is why you are likely seeing a flicker, but no window. It is...
-
-
MajP replied to the thread Forms not refreshing when navigating between them.That does not do a repaint of the "database screen". That is referring to this window As stated it is to refresh objects in that...
-
-
MajP replied to the thread Forms not refreshing when navigating between them.I believe you mean it is not "repainting" the form. Refreshing is updating the data on the screen. You could try forcing a...
-
MajP replied to the thread Syntax error "=".In your approach it requires you to name your controls with a matching value in the option value. "B21 must have a value of 21". This...
-
MajP replied to the thread Syntax error "=".Pretty sure this is a "WHERE" not an "AND" Case 1 strWhere2 = " AND qryIncExp.[Hide] = FALSE" If not it makes a join that...
-
MajP replied to the thread Syntax error "=".As I pointed out if done in the after update Me.Controls(Me.Selalpha) is almost guaranteed to return an object in the Controls...
-
MajP replied to the thread Syntax error "=".I already explained how this works / does not work in detail. Did you not read?
-
MajP replied to the thread Syntax error "=".Here is a demo with the correct syntax showing why the OPs original syntax will be a random control on the form and not the caption of...
-
MajP replied to the thread Syntax error "=".I do not think that syntax looks correct. This assumes that you dropped all your controls in correct order. An options group has a...
-
MajP replied to the thread Fairly New and Need Help.This is just one of many ways to structure the interface. You can use a tab control on the form to create more real estate. You could...
