Search results

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

jzwp22, That did not work get an error when trying it. I may be going about it wrong.

Unfortunately that may be a problem. There are 22 different companies and only 6 of them have characters on the end that would need to be deleted. Is it possible to there write an if then statement for the 6 properties in the on format event of the report to accomplish this. Not sure of how...

Just wondering if there is a way to edit a value from a table and change it in a report. For example, Property is listed on an invoice as Company (WMP) and is stored in the property field of table tblinvoice. I have a report called rptEnvelope that pulls the fields property, contact_person...

Sorry about that. Didn't think about that originally. Thank You for the help. This seems to be working and should solve the problem. Thank You again for the help.

That doesn't seem to work, but it may be because you select the employee from a combo box that then fills in the first name and last name. I wonder if the code to copy the name in the name textboxes overrides the code to lock the text boxes. I opened the vba editor and went to the code for the...