Recent content by dingleberry

For sure but its mostly duct tape and chicken wire... not very elegant lol.

I just developed one from scratch

Hey All, I work in a business where we have 50 remote locations. I am seeking a pre-made utility that allows my staff to produce "Standard Operating Procedures" in Word and then to be able to go to a page, upload them, have them ripped into a pdf, the pdf then stored publicly and keywords added...

Hey All, Question: I have two tables. One has dates: WE Date 2/28/2015 3/7/2015 3/14/2015 3/21/2015 3/28/2015 4/4/2015 4/11/2015 4/18/2015 One has Sales figures: Store Dept UPC Description SUB_CATEGORY SumOfQty     SumOfCost     SumOfRetail $     WE Date 3009 BAKERY 73314723576 BUN HAMBURGER...

Thanks Duane! I think that'll work nicely.

No Sir - No primary Key. Also, I hadn't considered the tie situation. Perhaps I need to consider a different solution.

I am embarrassed to ask - I just can't figure this dumb question out. I have a table. In that table I have Store, Department, UPC, Description, Retail $. This table has like 15K records in it. I am trying to write a query that will return the top 5 (sorted descending on Retail $) for each...

Thanks Andy, I appreciate the pointers. I really haven't refined the code at all yet. As a matter of fact, that code is from a tutorial I was following to see if writing to MySQL was even feasable. I see it is, but the connection is where the hiccup is. If I can figure out a way to proceed...

So, I would like to distribute a spreadsheet to several users. The spreadsheet (xlsm) has a button which when clicked calls a subroutine to write to a MySQL database that is shared on our local network. All users have access to the MySQL IP Address but not all users have the ODBC driver...

I inherited a database project that was authored by a co-worker when he left. I know the few key tables it depends on but it is polluted with a bunch of other tables/queries that may or may not be depended upon by the existing vital tables/queries needed to generate the report this project...

This one is tough. I dump a report from our payroll system to excel. In column A there will sometimes be a string that starts with 6JV/EPFPL. I need to write somethign that will search for that string and if it finds it, continue looking down the sheet in column F for the next instance it...

This is most excellent Skip. Thanks. Any way to make it so you don't have to have the linked workbook open - or maybe to make it so that when you do have it open and it links the values and you save and then re-open the values don't appear as #ref! errors (beacuse we no longer have source...

Hey all, just wondering if I can do this... My spreadsheet is set up like this: A1 = Date C1 = value from another spreadsheet for example for A1, I'll type in 10-2-2011 (formatted m-d-yyyy) and for C1 I have the following link: ='I:\Machining Business Unit\Production Output\[Business Unit...

I think I love you people.

Should be simple...? Model Num 254973 254970 TX_serial RTX_serial I want to query the above and return only numeric? Any ideas? Thanks,