Recent content by jukus

Thanks. That will work. It gives me a new page for each id.

I get an error that states - You tried to execute a query that does not include the specified SellerID as part of an aggregate function. I have a query that links 2 table (of course tables are a 1 to many relation) where SellerID is primary in tblseller and is a field in tblitems. I am trying...

I have a table with peoples information and a yes/no check box for volunteer, and then a table for items with a person id. The 2 tables are linked under person id. person table has person id as primary key and items has person id as a field in the table. I am creating a report that will pull...

Seems to work fine. Thank you for all of your help.

When I use that code it gives me an error. Can not find form when clicking on control button from main form. If opening just the subfrom, it still works correctly.

I am having trouble with a control button on a subform. I have the button set when it is click to view a report based on the current Primary field [ID]. Here is the code I have placed in the on click event. Of course that is between the two bits of code provide when you enter the code builder...

I have a database for an apartment complex that generates all of the legal doucments, etc. when people move in. One of the reports pulls fields from a main form and several subforms. One of the reports pulls info from a subform that conatins rent amount, pro-rated rent amounts and has a check...

Never Mind, I figured out my error. I typed in the field name instead of the ComboBox name. Thanks again for the help. The code works fine, but the person typing it does not :)

The code does not seem to be working properly. It always opens to the first item of the form and does not open to the one selected. Here is my code. DoCmd.OpenForm "frmGarageUnitInfo", , , "GarageID = '" & Me.GarageID & "'" It always opens the form to A1 instead of A2, A3, etc. if that one...

Thanks. I will give it a try. Appreciate the info

Here is what I would like to do. I have two tables. tblGarageUnits and tblGarageUnitInfo PK for GarageUnit is A1, A2,... and this is the only field in the table (GarageID). GarageUnitInfo has PK which is autonumber, and FK which is same as GarageUnit, and has other fields in the table...

Brian, that seems to do the trick. Every instance of the ( ) are erased. Thanks alot. Appreciate the help

Brian, to answer your question, Yes the endings that would need to be erased are always in ( ).

Got the function to work, had to be IIF(right()..... to get it to pull off the end. George your idea seems like a good one, just not sure how to do it.

After further review it is not removing the (WMP) with the IIF statement