Recent content by LTillner

Not and keep the current form design/VBA code, etc. I'm redesigning the whole thing, eventually. What I need is a short term work around. The best I found so far, was to create a copy of the "look up" table and modify it so that the autonumber field was a text field. Then I created a query...

PS - I'm using Access 2003 but this is an Access 2000 mdb.

I'm working with an old table design that was a single table (tblMain) and then "look up" tables for vendors, transportation carriers, users, etc, etc. I'm being limited by the way these "look ups" were integrated. Ex.: tblMain includes prjmgr_id field (as TEXT) (field displays prjmgr name...

I have a report that is a single page of labels (4 labels per page for the same record). If their enrollment for any grade is above 200 I want the page of labels to print twice (so they would receive 8 labels rather than just 4). How can I write this into my report? My pseudo-code is...

Thanks, got it. Why the heck is it called "MID" like for Middle? that makes no sense to me!

I want to find a substring or a string within a string and use that substring as a variable. this is the data that I need to parse: 3 ELA ApS T3 3 MA ApS T6 4 ELA Bsk T7 4 ELA ApS T5 5 SC ApS T8 10 ELA Aps T1 10 ELA Bsk T2 10 MA Aps T1 So the problems for me are: 1 -- what is the VBA...

I understand your point. However, I can't change this dynamic.... I'm just the contract person trying to automate some legacy reports. They like what they like. Sorry that it pushes your buttons!

SKip, You and I have discussed this before :-). All I'm doing is creating the final "pretty" spreadsheet of data. This is the way the data will be seen by Management. It's the way they want to see it. The actual data is all in one place, in fact, it's on the mainframe. All I'm doing is...

SKip, I'm using one template, that will be written as different tabs in the final workbook (one tab for each grade level) Your idea is the best, like you said no copy and paste. I will have to set the autofilter though for different criteria with each grade level, subject (English, Math...

OK, Thanks, however, in playing with what I need to do, I don't need to go to the extra step of naming the ranges at all. I just need to filter and then get the filtered range to the right place in the template. This is my recorded macro code now: Range("B2").Select...

Is there a way to dynamically create named ranges? I have a worksheet created from a query that I can filter and subtotal such as: Workbooks.Open Filename:=vTmpASO Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:=vGLevel Selection.Subtotal GroupBy:=2...

Skip, I appreciate your comments. I'm not segmenting the data, just the specially sorted data for the final reports in the format that Management requires. This is automation of something that has, in the past, always been manually done, season after season. The original data comes...

Skip, My rationale is that the final spreadsheet has a tab for each grade level. (This is the way management wants to see the final data). I figured, why not put the data where it will end up from the start? There are 2 queries that feed into the spreadsheet. If I start with one then I...

I have a query that groups by grade level. I output the query to Excel. I need to do 2 things 1 - Add subtotals by a secondary grouping ('Objective_Code") - as a new row at the bottom of the query subgroup 2 - Output my query with each grade level as a separate tab to a new Excel workbook...

Gerry, Good Idea! I think I will move it to the toolbar once I get it all working... Thanks and have another star! I've assigned a Macro to the combobox so that is where the code is going -- in the macro.