Search results for query: *

Hello. I have a database to charges from vendors. We have three vendors, and all three send us a bill once a month. My DB has several tables. One for vendors which containg vendor id, address, etc. The other is for products. Each product is offered by only one vendor. This table has a product...

Thank you all for your input. Bubba, I took a look at the link you posted, and that looks to be exactly what I am trying to do. I will use that as the base and modify as needed. Thanks again.

Thank you. I will try this out. It seems like exactly what I want to do.

Hello. I have a form that is used to enter data. I would also like to use this form to enable the user to dynamically query the data. For example, if the user wanted to find every customer in New Orleans, the user would click the "clear" button, and the form would clear, and then in the City...

Hello. I have a strange request from my boss, and I cannot seem to figure it out. We have a db that we enter certain invoice information from vendors. We only receive one invoice per month. My boss wants to have two comboboxes on a form, one for the month, and one for the year. I am able to...

Hello. I have a db that is being used to track telephone charges for my company. We have two separate phone service providers, and we receive two consolidated bills per month. Each bill has over 50 phone lines (phone numbers) associated with it. I would like to set up a data entry form that...

Thank you MajP. That was very easy, and it works perfectly.

I have a db with three tables. One table has employees, and consists of an employee id field, and some other demographic info. I have a product table that contains product id field, and product description field. I have the third table that links the product sold to the salesperson, as well as...

Thank you so much. That worked perfectly. I was doing the left join, but was forgetting to do the record selection formula. Many many thanks.

Hello, I have two csv files. One file contains all checks paid for a month. The second file has all checks that cleared the bank in the month. I am trying to create a report that shows only the checks that are outstanding, which means that they are in the first file, but not the second. I...

I have an excel file with 13 sheets/tabs. One sheet for each month, and one sheet as a "recap." The twelve monthly sheets are identical, except for the data contained within, but the layout is identical. On the recap sheet, I have a cell that is validated with a list containing the twelve...

Skip, The data does have headings. Please forgive my ignorance, but how do I use MS Query in excel? I realize that I forgot to mention in my original post that I am working in excel.

Hello, I have one sheet that consists of four columns, and many rows. The first column has my different locations, and each location is listed only once. The second column contains daily sales for the period. Each row is has a value in the second column. The third column has a sum of the...

Thank you Anthony. That worked great.

I have an excel sheet that has 12 ranges, one for each month. All of the ranges are on the same sheet. All ranges are identical, except for the data. I have a combobox that has the 12 months as the options. I am trying to write a function that populates cells on a "recap" sheet based on the...

Thank you Anthony. That works perfectly.

Hello. I am trying to create a custom function that uses the offset function. I am creating this to eliminate some of the input parameters, which will allow the end users to only have to input two parameters (the rows and cols params). Here is my function: Public Function roff(x As Integer, y...

Skip and SoCal, I agree with what the both of you are saying, but however, I do have a boss. He is the one that requested this layout plan. I have tried to steer him in a different direction, but he is deadset on the layout stated above.

Hello, I am new to VBA, so please bear with me. I have an excel file with 13 different tabs. One for each month, and the last is a summary sheet. All of the monthly sheets are identical, except for the actual data in the cells. I want the summary sheet to combine and sum the information from...

Thank you both. That was much simpler that I was trying to make it.