Recent content by fenfool

Well, my query turned out to work as needed, the problem was solved with this: "=[cmbIndexReport].[Column](1)". This put the Location name next to the combo box, and a slight modification put it in the report as well. So this much is resolved.

I'm not entirely sure how to summarize this quickly and correctly in the Title box, since I'm not sure where the solution lies as yet...ultimately, all I need to do is get a number and it's associated location name passed to a report headers. So here's my problem: I have inherited an Access...

No, I didn't write any code at all (my SQL is REALLY rusty, so I tried to avoid that for this project). I've turned off filter on load and allow filters now, which should prevent it from happening again, but I'm still curious as to why this would happen...the filter permeates itself, and can't...

Well, I figured out clearing the datasource property, where the filters seem to be entangled, but I'm still not sure why they are saving. They should reset after the report is closed.

I'm using Access 2010, and have been having an issue with report filters. I'm creating some flexible reports that let the user filter by year or location, then the next time they can apply different filters, that kind of thing. The problem is that some of these filters seem to be sticking. I do...

And now they are back. I THINK I found the problem, if I can't, I will post later today. I've just never heard of saving a report being an event that can change it! I'll dig some more, I have a feeling it was the query I was using.

I have a meeting database...one table has individual meeting information, a second has information on the meeting series...so all the meetings are part of an annual series, one table tracks the meetings, the other has higher-level meeting series info. The meeting series table has a field for...

I'm getting there! I have it in a form, now I'll see if I can use your code to get it in a report. Slowwwwwly but surely getting there!

Well, this would bring the question of how to get it to a form...I'm kind of a newbie. There HAS to be a relatively simple way to do this, the charting feature in the queries is all nice and pretty, I can't belive there is no easy way to actually apply this to a report...

I'm working in Access 2010, and used a crosstab query to make a pivotchart. It's a pretty simple bar chart. The question is that now that I've made this chart, how do I use it? I can't seem to figure out how to put it into a report...I made a report based on the crosstab query data, but it...

Yeah, I think the junction table will do it. Once the database is set up, it will be updated with 1-2 projects a month, and there's a 50/50 chance there will be no company involvement with what gets updated. I think a form with a selection of project number, one for the company, then a box...

I think that's exactly where I wanted to go, my mind just wasn't taking me there. Thanks!

I'm hoping that writing this out will help me figure out how to do this. I'm setting up a database in Access 2010. One field is a list of outside companies that assist on a particular project (the main data item is a project...project number, name, date, budget, then company). I can do this...

That did it, thanks!

I'm importing data from Excel 2010 to Access 2010. The data is fine, except that for one field in particular, there are about 9-15 spaces at the end of the data (which is city names). This will become a problem, because I need to concatenate the city name with the country name at some point...