Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dingleberry

    document upload + convert to pdf + make searchable utility

    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...
  2. dingleberry

    combining tables

    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...
  3. dingleberry

    top 15 of one field for each department

    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...
  4. dingleberry

    distribute spreadsheet to several users to write to MySQL

    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...
  5. dingleberry

    Table relationships

    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...
  6. dingleberry

    Search for a string and if found copy/paste value...

    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...
  7. dingleberry

    Excel 2007 - insert text from another cell into path?

    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...
  8. dingleberry

    return only numeric

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

    Subtracting dates and adding number of fields

    Sample of data: PartID BatchSer DateTime ISEPart 48 38487 1/8/07 7:57 AM 233960 48 38488 1/8/07 8:14 AM 233960 48 38489 1/8/07 8:16 AM 233960 48 38490 1/8/07 8:18 AM 233960 48 38491 1/8/07 8:20 AM 233960 51 24128 1/8/07 3:57 PM 826014 51 24129 1/8/07...
  10. dingleberry

    compare field in subsequent rows of one table

    Can I compare this using a query c1 c2 10 data 1 10 data 2 11 data 3 11 data 4 11 data 5 11 data 6 12 data 7 12 data 8 12 data 9 13 data 10 and have it return just where C1 changes so the return would be 10 data 2 11 data 3 11 data 6 12 data 7 12 data 9 13 data10
  11. dingleberry

    populate form field with selected cell

    Hi All, I've written a bit of code to do some formatting. The problem I have is it is very rigid. I'm trying to add some flexibility. So instead of running a macro and having it just fly through, I'd like it to present a form. In this form, I'd like to populate a textbox with a selected...
  12. dingleberry

    Query results of previous query

    Hey all, Please help. I'm trying to do something that I know would be very easy to do if I could use a programming loop but I can't. I want to search for a list of part numbers to populate a report. From that array, I'd like to perform another query on each entry in the same report. Please...
  13. dingleberry

    hiding samba shared drive

    Looking for a way to hide a mapped drive on a server running win2k3. The only kicker is that this is a network resourse that is shared through samba. I'm only mentioning this in the off chance there is a way to configure samba to provide availabiltiy for a network share but not broadcast it...
  14. dingleberry

    prime number function

    I was bored about a week ago and that got me to thinking. I did not know of a function to calculate prime numbers (and there might be one but I couldn't find it.) I decided to write one. Basically it starts with a range of numbers (10000) and starts at 1. It takes every number up to that...
  15. dingleberry

    undefined function preg_grep()??????

    Hey, I'm installing owl which is a doc management utility and it keeps barking at me about some undefined function preg_grep() call. I researched it but It seems like the most cut and dry function of all time. It simply searches through array strings for patterns and spits them out. Anyone...
  16. dingleberry

    mod_php4 only gives me 3 options...

    Okay, I've been wrestling with this for about a week now and am pulling my hair out. I recently upgraded by bsd server to 5.3. I installed apapche1.3 and mysql-server 4. I'm trying to compile php to use mysql but when I go to /usr/ports/www/mod_php4 and do a make it only gives me three...
  17. dingleberry

    only three options on install?

    Okay, I've been wrestling with this for about a week now and am pulling my hair out. I recently upgraded by bsd server to 5.3. I installed apapche1.3 and mysql-server 4. I'm trying to compile php to use mysql but when I go to /usr/ports/www/mod_php4 and do a make it only gives me three...
  18. dingleberry

    neon sign

    Hi All, This may be deemed stupid, and if so, please accept my pre-emptive appology. That being said, anyone know what I need to do to create a neon sign affect? It's for a christmas card I'm making for my dad. The word is Squiggy's but it's really not important. It could be any old word...
  19. dingleberry

    cross browser compatibility

    Hi, Curious if anyone has had problems with form elements (input boxes and text areas specifically) not maintaining the same size between browsers. More specifically, I've got a layout I created in fireworks. Sliced it up, and exported to dreamweaver. I then inserted form elements into new...
  20. dingleberry

    gd functionality

    Hey Everyone, <brownnose> I have not posted on this forum for some time however I really might be in trouble here so I thought if there was any group of people out there who could give me some help, I'd find it here. </brownnose> Here goes: I'm using the gd functionality in php to dynamically...

Part and Inventory Search

Back
Top