Recent content by metrodub

Perfect. Thank you for your quick reply.

Hello, I have a main form (frmClass) that contains a subform (sfrmMaterials). The materials subform populates when a user chooses a course from a course combobox. The fields that populate in the subform are Instrument, Cost, Vendor and a checkbox (chkSelected). What I would like to do is...

Wow...is it Monday? Time to turn my brain on. Thanks Leslie!

I am now getting an "Undefined function 'WHERE' in expression" error when I try to run this SQL: SELECT tblCompany.CompanyName, Sum([AirCost]+[DeliveryCost]) AS [Total Spent] FROM tblCompany INNER JOIN (tblInvoices INNER JOIN tblPO ON tblInvoices.POID = tblPO.POID) ON tblCompany.CompanyID =...

I have three databases that interact with each other. One is a vendor asset management db that houses vendors that my company uses, their contact information as well as contract data. Another db contains data on Purchase Orders that we use to pay these Vendors. The third database is an...

I'm unsure how to do this, or if this can even be done. I have four tables: tblCompany CompanyID (PK) CompanyName ...company data My company works with outside vendors (companies) to do facilitation. Before a vendor is brought in, we need to get authorization from Finance to increase the...

I am creating a database to track training for my company. We use outside facilitators to teach these classes. There are some instances where a facilitator (partner) works for more than one company (vendor). The second vendor is usually the partner working as a sole proprietor. My table...

That did the trick. The detail section was not set to Can Grow. Thanks for your help! Here's a star.

The can grow setting was set to yes, so it isn't that. The strange thing is that this worked yesterday.

Sorry, facilitator and partner are the same person. I will look at the can grow setting.

Both are set to PartnerID, but there isn't a distinction between the two. One PartnerID comes from the query used for the main report, the other comes from the query for the subreport. Should I change them?

Not sure how this happened... I have a subreport that shows classes taught by a facilitator. The main report shows facilitator data such as address, phone, etc.. For some reason, the subreport is only showing 8 results no matter which facilitator is chosen. When I run the query on its own...

I have a form for Projects. On this form are 11 controls: cboProjectCompany - Unbound combobox with Company Names. cboPONumber - Bound (POID) combobox that contains Purchase Order Numbers associated with the Company chosen from the Company combobox. cboPOExist - Bound (POExist) combobox...

nevermind. fixed.

I have a form (frmVendorManagement) that contains 10 controls: cboCompanyName - an unbound combobox that lists, you guessed it, Company Names. txtVendorNumber - a textbox with cboCompanyName.Column(2) as its control source. 4 other text boxes - all with their control source set to a column from...