Search results for query: *

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...

wow, can't believe it was all about a space. Thanks AceMan!

I have a textbox on a form that I use to search for invoices. When I enter an invoice number and press the search button, an invoice form opens but does not contain any data. The invoice number is in the invoice table. Here is my code: rivate Sub cmdInvoiceSearch_Click() Dim strDocName As...

The control source for cboPONumber is already set to POID in tblPO. Where else should a source be set?

Didn't work. As cboPONumber is dependent on the unbound control (cboProjectCompany), when the form is opened cboPONumber (for some reason) is empty as well.

I have a project form (frmProjects) that contains an unbound control. This control (cboProjectCompany) has a list of vendors/companies. A second dropdown (cboPONumber) contains account numbers associated with the chosen company. This control is bound to the project table, but the...