DD

I am building a employee performance review portal for my office (intranet). I want the respective person (user level) to be able to design their own layout of the Questionnaire Page (drag and drop stuff) and once clicked on save, the actual page will be generated (CSS/Javascript/PHP+HTML) and the url to the created page will be displayed in a new Window. How could i include this drag and drop layout builder in my web page? And also create the layout as designed?

I'm trying to consolidate inventory records in db. (I'm displaying the result in a table form but for this post I'm putting it simple)

table_name= PC:

department - msoffice

IT - 2000

IT - 2002

IT - 2000

SNM - 2000

SNM - 2003

Finance - 2003

-----------------------------------

expected output:

msoffice - dept - qty

2000 - IT - 2

2000 - SNM - 1

2002 - IT - 1

2003 - Finance - 1

2003 - SNM - 1

Group total by msoffice:

2000 = 3 (2+1)

2002 = 1

2003 = 3 (2+2)

Grand Total : 7

----------------------------------

i have tried this method in 2 different queries that give me 2 outputs. 1 displays the Group Total and the other one displays the grouped result.

Query#1:

$qry=mysql_query("SELECT `msoffice`,`department`, COUNT(`msoffice`) as 'qty', COUNT(`department`) as 'dept' FROM pc GROUP BY `department`");

while ($result=mysql_fetch_array($qry)){

echo $result['msoffice']." - " .$result['qty'] ."<BR>";

}

output for query #1:

2000 - 3

2002 - 1

2003 - 2

---------------------------------------------

Query #2:

$qry2=mysql_query("SELECT `msoffice`,`department`, COUNT( `department`) as 'qty' FROM pc GROUP BY `msoffice`,`department`");

while ($result2=mysql_fetch_array($qry2)){

echo $result2['department']." - ' . $result2['msoffice'] . " - " .$result2['qty']. "<BR>";

}

output for query #2:

IT - 2000 - 2

SNM - 2000 - 1

IT - 2002 - 1

Finance - 2003 - 1

SNM - 2003 - 1

--------------------------------------------

problem:

1) ***MAIN Issue*** I don't know how to get the group total by msoffice. And the overall total i think i can use the row count (is there any better way?)

2) Can the 2 query be combined as 1? If can what is the best method (guide me with example)?

You help is greatly appreciated.

I'm planning to develop intranet for my office PC inventory where each user will be given the access to the intranet and upon clicking on a button the hardware information of that particular PC is displayed then the user just have to click on "Save" to save in database.

i have a few (http://www.devarticles.com/c/a/JavaScript/Retrievi... ) using javascript but unfortunately the onboarddevice class is not working properly as it does not give any results.

now i'm opting for other solutions available to have this feature in my intranet.

is there any other way to obtain the PC hardware infor mainly (HD size, CPU serial, processor speed, processor type, RAM, removable drives, default printers , IP address, computer name, installed sofwares)

hi guys,

i'm planing to have my own "radio" to play my own songs (ripped from original CDs). Currently I am using Zymichost.com as my free add-free hosting. Unfortunately they do not support mp3 files. So I am trying to host all my mp3s on another file server and link it to my player in zymichost.

is there any free file servers that will allows the files to be access by a flash music player?

i have tried:

1) Free File Hosting.com

2) FilesAnywhere.com

3) MediaFire.com

all these allow mp3 files to be uploaded but my player cannot access it as it appear as a download links.

so guys, can you guys suggest me on

1) any free online mp3 player & storage

2) or any free mp3 file storage that allow to be played via URL link

This is for my church... guys please

http://praiseevangelical.zzl.org/

Guys need your expertise.

I'm trying to put up a "Financial Transaction Form".

This form has a sub form.

Main Form : contains Transaction Details

Sub Form: contains Payment Details (Payee name and so on.) linked by Transaction number (TrxNum) from main form

My question:

I would like to add the transaction number (TrxNum) from the main form to the "trx-num-field" (hidden field) on the subform for every new payment (row) is entered.

how do i do this?

I'm planning to use simple scrolling text using external file link to marquee in main HTML file. but unfortunately the Yellow Security Alert stripe appears on top of the IE. I have seen website with that effect and no security alert appears, how is it done? did i miss anything?

The reason is i know some people don't like to click on the Allow Blocked Content (coz they don't know) so guys help me out here... i'm building a website for my church.

Hi,

I'm trying to do a news highlight in marquee scroll up, but i do not want to use Java script (its annoying Allow AxtiveX Script Yellow stripes appear on top)

So is there any other way i can use in HTML to read external txt file into a marquee?

is it possible to create a function in css that can call multiple classes?

i am trying to call multiple classes at one time, i know i can use it in html element by calling each of its class' name. but i have 8 classes to call and i have to key all of it whenever it is needed

simply put:

im creating a css curved box using .png images and i want a function to control it. if not possible is there any other way that can be used (i have 4 corners, top, bottom, left & right images)?

please help.

where can i find an article on this? or can any one explain to me what are the benefits of changing IP address network wide to be organized and to be in sequential order?

if an organization is having and unorganized range of IP address for its departments in local network what are the benefits of reorganizing the IP range? and perhaps what are effects of unorganized ranged of IP?

im just preparing a thesis and can't seem to find information on this

please help

I am trying to create a report in MS Access with a Check Box which appears as Checked for selected month.

I.e:

I have fields from a table tblTrx (Student Name, TrxDate, Amount)

I want the report to display Student Name and a checked [Check Box] for the respective month from Jan to Dec

Example Output (Report)

Student Name Jan Feb Mar .... Dec

Student 1 /

Student 2 / /

Student 3 / /

(/ =indicates checked [Check Box])

I hope you get what i mean (Just like an Attendance Report displayed from Jan to Dec -12 Columns)

I have restricted users from running windows media player using Group Policy (direct access using double click). but unfortunately the users got smarter trying to use the "Open with command" on right click context menu. I have removed the command using Regedit. but the users got even smarter

now the users are using the "Change" (file association) button on the Properties Windows (right click context menu - General Tab) and change the association to Internet Explorer and the #$#$% windows media player is still running !!! suprisingly!!!

My question is how do i disable this function?

scenario:

FormName:frmSearch

objects: (all unbound)

txtBeginDate

txtEndDate

cboNameList (contains Names from tblNameList onLoad event)

cboCategoryList (contains Category from tblCategoryList onLoad event

() Show Detailed report (option bution to open dtlMonthlyReport)

() Show Summarized report (option bution to open smrMonthlyReport)

() Search Reciept (option button to open rcptReport)

() Search Voucher (option button to open vcrReport)

btnSearch

[ I want to display search result here within the form ... but dont konw how?]

================= end of frmSearch ==============

notes:

all the reports are link to its own form and the date field formated to accept input from within the form

the purpose of this form (frmSearch) is to show the search result based on user defined criteria and then from the search result user can double click to open the designated report with the parameters from the sellected search result.

question:

1) how do I display the search result(s) within the form itself (in VB its dataGrid) for the option 3 & 4 only.

2) I have tried using the "SELECT " method in sqlCriteria string using

doCmd.OpenReport .......,sqlCriteria

but an error msg appears saying "....there are more than 1 record based on ..... consider using EXISTS reserved word ......"

So how do I open the designated report based on the search criteria?

I have heard of this PARAMETERS in querydef but not sure how to use it.

can you guys help me? Im stuck. whenever I want to display the reciept of a certain transaction I have to manually browse to the records (in frmTransaction) then click the button to generate the report. The same goes to the monthly detailed report, where I have to execute the form , enter the date range and click the button. For the summarized report its more troublesome for me to generate the report because it goes through many process. That is why i want to have this "short cut"

i wannt to use logical statement for vlookup result.

if(vlookup(serachthis,inhere,returnthis,true) ,if_found ,

if_not_found)

is there any way to determine the vlook function does carry a non empty value? how do i set the if statement above?

im currently using

if(vlookup(serachthis,inhere,returnthis,true)<>"","Found","Not Found")

but it doesnt return the result that i want.

please provide example.

how do i insert a value in a cell from another cell

cell A1=if(sum(A5:A12)>25,F12="Good Result", F12="Bad")

the calculation will be displayed in cell A1 and cell F12 the result. I dont want cell F12 to contain any formula but just the result of the calculation in A1. is it posible?

p/s: i dont want to use VBA though its easier.