Recent content by mcgilla

I'll give the first link a try. That seems to be the closest possibility.

Hello, I have a query that has multiple "customers", who can have multiple "Products" and each product has multiple ship dates. What I want to do in a Report, and I assume this is a setup needed in the underlying query is show All Customers, All Customer/Products, and the last 5 shipping dates...

I'm having an issue with a Crosstab Query/Report. Query setup. Column Headings is the Month. Row headings is Product Name and Price/Gallon. Under each Month, I can sum the gallons of product sold, but I also want to calculate sales. I can do that on a report (with other limitations), but...

Hello Everyone. At work, i've developed a database that is used on our production floor and it's working quite well for our needs. I'm using Front End/Back End on a file server since I do not have a SQL backend. Everything is office 2010 and Windows 7 on the desktop environment. I've used...

Hello, to save space, I want to open a report based on a query from two different forms. In the query it's easy enough to do and it does work, however, when I open the report from the second location, I'm asked for the information from the first location. Basically we'll say the report is...

In the listbox on click event, so it updates to the job that I have selected.

Hello all, my first issue of the new year, and Happy New Year too. I have a parent form with a list control that when a job is selected in the list box, it puts some text in a text control and does a me.requery for two subforms. The records in each subform change based on the job selected...

A little late for my reply, thanks for the input. I do have another table to track raw material price changes. It's automatically updated on the first of each month.

Raw material changes affect the cost of Intermediates and End Products. The report is for the sales people to know the cost of each product in order to be able to sell it at the proper markup. If Blue as an End Product changes, I need to put it into the Raw Material (As an intermediate) in...

A somewhat complicated question and problem that I’m sure I designed without knowing. Before you ask, I cannot show any structure so I’ll try to be as descriptive as possible in a generic sense. it’s a design for work and I cannot divulge the information. To give some perspective, I’ll...

You made me think. Instead of having the query as the recordsource setup in the properties. I used the Form_Open event to set the recordsource. I have to setup a dummy trial now to make sure the data transfers ok. Form_Open 'This is basically what I've done Me.Recordsource = "Select...."...

I have a form based on a query that I've developed over the past couple of days. When I first started, the form opened cleanly with no prompts needed. I could select my criteria, do a refresh and everything looks ok. The problem came when I selected new criteria, it wouldn't always update to...

Bob, the decompile worked like a charm. Thanks a bunch. This one had me very confused because I had imported and modified my other forms and then had the error. Then I figured I should just create it from scratch, and the error happened again. Decompile worked great and the functionality is...

I'll try the decompile and see what it says. I did try to import that new second form into a blank database and the same thing happened in the second database. That's why I was thinking my outlook code might be the cause of the issue. But now I can't even import that form, or edit it in the...

Hello, I'm putting this one in the General because the problem could one of many different areas. I'm using a query, one data entry form and a form with List, vba with Microsoft Outlook Object Library code and it is checked in the references. First, I've created a query that checks for open...