Search results for query: *

Using the code below, I am trying to get the latest facility info for each facility, based on user input. The facility detail table stores the info, and only has rows for when data changes i.e.: FACILITYCODE MONTHNO YEARNO RATE PLANT_A 1 2006 100 PLANT_A...

That's what I am looking for. I know similar capability exists when printing Excel spreadsheets that overlap multiple pages...

FYI, You can set the default printer used for a report in the Page Setup dialog. Also try PDF Creator on sourceforge: http://sourceforge.net/projects/pdfcreator/

Thank you for the quick response. I was hoping for an automatic way of doing this similar to the page break control for horizontal breaks. Does such a thing exist?

Th only method that I am aware of is setting the left and right margins as well as the report width. So I have to know the page size, and manaually set the columns on a new page?

I have a report with many fields: |-----| A | B | C | .... | xyz | 1 | 2 | 1 | .... | wxy | 4 | 4 | 3 | .... etc. Question: Is there a way I can have access automatically insert a page break between column B and column C? The page break control in access seems to allow...

As you only have one value for each PlantID,ProductID pair you may use the First (or Min, Max, Last, ...) aggregate function on ItemCount Once I added in the Year field, I now have more than one value for a PlantID, ProductID pair, and using the Crosstab gives the SUM for ALL of those rows.

CrossTab only allows me to do aggregate functions. I added a new field to the new table called year, and want to show actual counts broked down by year. Report would look the same, but would have Year set to 20XX in the Record Source query. I tried using grouping, but that gives me this...

Followup question: How do I re-assemble the original data for a report from the new table? The report looks like the orginal table: |---------| Cars | SUV | Trucks | | Plant A | 4 | 5 | 6 | | Plant B | 3 | 4 | 2 | Thanks

Great. Thanks for the quick response.

PH, Your idea worked great, and I still need to do more research on INNER JOIN. I tried the code below, and it also seemed to work (your use of AS keyed me to it). Will this work the same as your solution, since it uses WHERE and IN which I am more familier with. Thanks. SELECT A.Plant...

I have the following info in a table: |---------| Year | Rate | | Plant A | 2005 | 5.00 | | Plant A | 2006 | 4.00 | | Plant B | 2005 | 3.50 | Not every plant has its rate information changed every year. What query can I use to ensure I always get the most current...

Perfect! Thanks for the quick response. Note to users: In access, to create a UNION query see this link: www.ehow.com/how_13580_create-sql-query.html Then create a separate append or create table query to insert the data into the required table.

Hello all. I currently have the following table: |---------| Cars | SUV | Trucks | | Plant A | 4 | 5 | 6 | | Plant B | 3 | 4 | 2 | I would like to convert this to the following, with PlantID and ProductID as the primary keys. A separate table would contain PlantID and...

No, no and nope. Thanks all, but I guess I'll have to just redo the wizard. I also tried deleting the dependancy from the dependancy window, but i could not delete from there. Thanks again.

No code at all.

I used the Access form wizard to create a form with two subforms on it. Subsequently, I decided to remove one of the two subforms. I did this by selecting the subform in design view, and pressing the 'delete' key. Now, whenever I open the form I get an access error message stating "Microsoft...

It's 3 years later (Original post from 2002), and I'm having the same issue. Is there a way to show the gridlines without using a border?

I have subsequently discovered that I should not use the Resize method to pass a single row... For lngCtr = 1 to Range("namedRange").Rows.Count myFunction namedRange.Rows(lngCtr) Next lngCtr Duh... [hammer]

Thanks, but how would I use the resize method if i only wanted to pass a specific row?