Search results for query: *

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.

Thanks guys, I've gotten to the same point here, the dropdown is working, the cell link is in and I'm ready to write the code to send the user to the text I want them to see. Zathras, I think it does limit keystrokes in the user's mind if not in actuality, the list is short, 7 items, so they...

There is an available space issue on the form and I'm trying to limit keystrokes. There are a limited number of help topics. I just want to simply select an item from the short list and jumb to that named cell. If this is not possible or very difficult, I will do it the other way, but it's...

Hi all, I'm nearing the end of my current project to automate some redundant data entry in Excel. To wrap things up, I want to create a "Help" section on my one form that is needed to set up the data variables by the user. To save space, I'd like to have a drop down list of Help Topics and...

Thanks PH, have a star. It makes sense that the Font name needed to be FIRST! Skip, everytime I recorded the macro the font name was last, maybe it was the order I was selecting things in, I don't know, but re-recording it wasn't helping in the first place. Thanks for all the help guys...

When I save a file or close a file I always get an Excel Generated Message box. I successfully turned these off in my Access macros, but not in my Excel Macro/VBA code. How can I get a Save as statment to save without asking if the file should be overwritten (if one already exists) -- I'm...