Search results for query: *

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

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

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

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

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

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

I have a form (frmProjects) for adding money to a PO fund for projects. On the form I have a combobox (cboStatus) with three options ("Approved", "In Process", "Rejected"). When a user selects "Approved", the amount inputed (txtAmount) is added to the PO (txtPOAmount). When a user selects...

I have a form (frmVendorManagement) that has a combobox(cboCompanyName)with a list of Vendors/Companies in it. When a user chooses a company from the combobox, a subform (sfrmPartners) displays the employees (in a continuous form) for the chosen company. The Link Child Field is...

Bear with me on this one. I have an invoice form that links data from three databases. The main form is bound to a table in an Invoice DB (the main DB for the form). I have an unbound combobox (cboInvoiceVendor) used to select a Vendor from the Partner DB. The AfterUpdate event of this...

I have a database with three tables: tblCompany CompanyID (PK) CompanyName Address Address2 City State Zip tblPartners PartnerID (PK) PFName PLName Address Address2 City State Zip Email Phone tblCompany_Partners CompanyID (PK) PartnerID (PK) The reason for the many to many relationship is...

On a form, I have a list of classes. When a user chooses a class, the associated materials and their price are shown in a list box. Is there a way to calculate the items in the list box (ie: handbook costs $10, notepad $3...total in textbox = $13)? Is having the items placed in a list box...

I have a form (Class) that can be opened from two different locations. The first is from a search form that is a pop-up form opened from my startup form. The second is from a Work form. On the Class form is a close form button. What I'd like to happen is if the user opened the Class form...

Not sure how to do this and was hoping for a little help/guidance. I have an employee table in my database. Every month, I get an updated excel file populated with current employees. I am able to run an update query to update job titles, department names, etc, etc. What I don't know how to...

In my report form, I have an area where a user can run a report to find out who took a course (selected from an unbound combobox) during a certain year (selected from another unbound combobox). When the user presses the run report button an OutputTo function is triggered. The resulting report...

On one of my forms I have a command button that opens a pop-up form. When the pop-up form opens, I am able to share a few values from the previous form (the form not in focus) in text boxes through the On Load event trigger. I have a combobox on the pop-up form that has two values (Flat Fee...

I have a form that employees use to process a work order for training and development. In the form are a number of combo boxes, a few with employee names. The user chooses a HR Representative from one combo box, then chooses a manager from another combo box. If a user doesn't select an...

I have developed an Access database for my group and am in the process of copying the front-end to everyone's computer. The back-end is on a share drive which is mapped differently by every user. I have a number of modules used in automating sending data to a Word template. This is the code...