Search results

That is an interesting suggestion. What I was finding was that no matter what I did, once I clicked on a different page, it was too late to hide the yucky painting. Same with on load. It just does all the work, before I have a chance to see the form and give them a better message. I went a...

Thanks, Ridders! That is smart. Then I don't have to count, which hurts my brain lol

@Mark_ that is an interesting solution. Ridders, thanks for taking all the time to show me all that. It is very similar to what I am trying to accomplish. Those pics are the exact behavior, of how I wanted it to look. I decided @static is right. I will just load them and not keep unloading...

So let me clear up some things. The rowsource and requery steps is working. That is not the issue here. I have 2 pages on a tab control, and each page has 1 or 2 listboxes. when a user switches from one page to the other, I set the row source of the listboxes on the active page, and clear the...

ok, new thread is here: https://www.access-programmers.co.uk/forums/showthread.php?p=1557732#post1557732 If you want to see where I'm going now, as I work through all this. :-D Totally understand if you all want to run screaming away from me, and toward a life of drinking.

This application is Access 2010, with a SQL backend. I have a form, which has a tab control, with 2 pages. 1 page has 1 listbox and the other has 2 listboxes. I use some code, on change of the tab control, to determine the active page, and set the listbox(es) row source(s) for the one(s) on the...

ok thanks :-)

I moved on to a new issue, but I'm wondering if I should make it a new post. I feel like I'm dragging this thread out lol. It's about using a text box to hide the work being done to change from one tab page to another. Let me know if you think I should post it here or start a new thread.

nevermind! I spelled the query name wrong (I'm such a damn moron) Me.lstAllprojects.RowSource = "Select * From qryprojectsYes" Me.lstAllprojects.Requery Me.lstAddprojects.RowSource = "Select * From qryAddprojectsNo" should be Me.lstAllprojects.RowSource = "Select * From...

ok, I took the public function and made it into a private function in the form module, just to simplify things. It looks like this now (with some debugging print steps to let me see the state of things) Private Function projectFindAddPage() Dim ctl As Control Dim cmd As ADODB.Command Set cmd...

So I found this: https://access-programmers.co.uk/forums/showthread.php?t=42701 and I changed the public function to this: Public Function ProjectFindAddPage(frm As Form) As String Dim ctl As Control Dim cmd As ADODB.Command Set cmd = New ADODB.Command Dim cSQL As String For Each ctl In frm...

Thanks to both of you. I'll answer part first, and then I need to go check into some of the stuff you asked and see what I can verify. The frmMainEntryForm is the form I open. The SubEntryForm is the subform CONTROL on that form. Iset it's source object to a form called...

So I'm running into a hurdle, attempting to move some code to a public function. It's just bare bones, but this will help with eventually determine what should be loaded and what should not be. I've made the lines that are failing, bold: Public Function ProjectFindAddPage() Dim Listctrl As...

Thanks. It's a lot to think about. I think it will be cleaner to unload the form, instead of bogging down the memory with potentially every form being open at once. I will probably run some of that debug testing too. That sounds like a really good idea, so I can see whats up. I have a...

Thanks for your thoughts and for taking the time to respond. I think part of the draw back of the combo, is that it isn't directly (or easily) possible to search a partial string. For instance, if the project, someone wants to find, is called "ABC Excellent Stinking Project (2439387)" and they...

Thanks, JLeach. Not sure I understand exactly what that code will help me do, but I trust it would be helpful. I'm just starting to get myself set up to do 1 maximized form, with the nav bar, with a subform control, which will take on any of the other forms, by a button click on the nav bar...

That really does! Thank you. I know your approach is right. I just need to work out how to rewrite at lot of my code (opening and closing of forms, referencing of controls on specific forms, etc ) to use your approach. The advantage to the subform nav bar would have been less of a rewrite...

ok, so I'm confused. If you use tabbed forms, or panels as you call them, you can also have pop-up forms? or are you just saying I should have 1 maximized form with the nav, and all other forms should just sit inside that, in the subform control, and if the subform control is set to can...

JLeach, I'm still unclear how I can compensate for different sized forms. All my forms are not a maxmized window. I used overlapping forms, instead of tabbed. I also always have forms sized to the biggest they need to be, based on the controls on them. So, often times no 2 forms are the same...

The attachment works for me. Ridders it is a pic (a png) not a db. It illustrates what he is describing and looks even nicer than I imagined. I really love the look of it. I think I can still do it as it's own subform component, which I can put as a piece into every form, where I need it...