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...
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...
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...
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...
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
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.