Search results

@theDBguy and @isladogs I copied both of your solutions to the query and I received no results each time.

Hi. I'm trying to do a dual criteria, but I either get errors or the wrong person for the DLookup. This part works fine: Expr1: DLookUp("[PersonFullName]","Person","[IDPerson]=" & [fkPerson]) When I try to add in the second criteria, that the fkRole =2 is where I'm stuck. (The fkRole is...

@Minty & @Pat Hartman Thanks. I appreciate the help.

Hi. I need to have the query render the results vertically, into a single row for exporting to Excel for mail merge. I've read that I need multiple crosstab queries to do this, but I am not really sure where/how to start. Table: ID, Team, Color, Sport Wish list results: TeamA, TeamAColor...

@plog Awesome! I just couldn't think of how to approach the second table for many to many.

Thank you. @jdraw Richard Rost is my go to, as well. I already watched one of his Genealogy courses this morning. Learned a few tricks and tips. @plog I will try your suggestions tomorrow.

@arnelgp what is a BOM table?

How to link to the same field in same table? People table ID, FirstName, LastName 1, Jane, Doe 2, John, Doe 3, Scott, Doe 4, Sue, Doe Family Tie table ID, Family Tie Mother, Father, Wife, Husband, Sister, Brother Jane = Wife of John, Mother of Scott, Mother of Sue John = Husband of Jane...

I appreciate the help. I did a work around, based on a query with DSum and created one field subreport.

My questions come down to this: #1: How do I reference the totals text box from the payments subreport on the Main report (see above for the names of the controls, report and subreport) #2: How do I handle the possibility that there will be no info available in the subreport's payment total...

I am trying to have a text box on the main form reference a totals text box from subreport for payments. At times the payments subreport may have no data, but it still shows the subreport and displays a total of $0.00 in those instances (which is what is needed). I am stuck and keep getting...

@Uncle Gizmo the different forms are because each subform goes to a different table. But, @arnelgp, @MajP and @Uncle Gizmo thank you all, I got it work.

A tab control won't really work for what I need. I envision this scenario having 20-30 subforms. I'm trying to take the guesswork out for the data entry, and faster function (instead of going to a particular tab and finding the subform.). Too, each of my subforms (tree, shrub and flower) have...

Hi. #1: I have been trying to figure out how to make a subform visible based on combo box selection on main form. I've tried doing this with both after update event and the on click event with a command button, but I just got error after error. Main form "frmPlants", has combo box...

@theDBguy Sorry about not answering your questions. I want a temporary default value (the last value entered), with the temporary value staying until the form is closed, which could mean after 5-30 records are entered. I will try your code tomorrow when I'm back on my computer. THANK YOU.

Would you mind sharing the code, and where it goes? I'm a newbie, so....

No I just want the same value until the form is closed.

I have a form with a combo box. I don't want the value of the combo box to change as I go to the next form tecord. Is there a way to stop the change? Why: I have a form that I use for data entry for projects. The same project is involved for record after record. When I close the form, then when...

I wanted to thank everyone for your help. I ended up with a work around for the issue. @June7 thanks for the nudge to get me started with VBA. I've started learning it and can already see how essential it is. @Isaac your help got me thinking about another issue I had, which is now resolved.

@June7 The combo box is bound as I need to track when the client gets the recap and what date range is involved. The recap report is only generated for the client selected via combo box, and just for date range specified. Thanks for the tip on where to start with VBA. Will check it out...