Development Questions


Determining data from a certain date range

I have an Access 2003 database that has weekly dates and weights enter for a weight loss program. Ech program session is 8 weeks and people sign up for anywhere from 1 to many more sessions at a time. I want to find out the average weight lost in the first 8 weeks that a…



Answer Question   |  July 30, 2012  12:40 PM
Data access, Database management, Date calculation, Microsoft Access 2003
asked by:
65 pts.

How to migrate legacy documents?

We are moving from traditional to iterative and going forward might move to “Agile”.As a BA how to update and migrate all the legacy requirement documentations which are captured in Activity diagrams and Use case .Currently all the update on the features and functionality are overwritten on the existing documents, what tools do I need…



Answer Question   |  July 27, 2012  6:43 PM
Java API, WebLogic
asked by:
5 pts.

How to migrate legacy documents?

We are moving from traditional to iterative and going forward might move to “Agile”.As a BA how to update and migrate all the legacy requirement documentations which are captured in Activity diagrams and Use case .Currently all the update on the features and functionality are overwritten on the existing documents, what tools do I need…



Answer Question   |  July 27, 2012  6:43 PM
Java API, WebLogic
asked by:
5 pts.

convertion of html to ear file

how can we convert HTML file to .EAR FILE



Answer Question   |  July 23, 2012  4:51 AM
WAS Express
asked by:
421
370 pts.

Options for compiling VB code to executable

Hello everyone, I have a question about the making of .exe file using Visual Basic I don’t think it matters what version but I’m using VB4. When doing the compiling from code to executable I press the File tab then go down to make exe. File and then I have a button for options I’ve…



Answer Question   |  July 20, 2012  7:31 PM
Visual Basic
asked by:
1,940 pts.

VBA Array Loop

Hello, Can anyone help me with VBA code that creates an array from a range of cells (A1:E1), loops through the array and performs a function. I already have the function now I need to create the array and loop. Thank you…



Answer Question   |  August 10, 2012  2:18 PM
Array, FORALL loop, loop, VBA
asked by:
40 pts.

VB6 Search Function

How can I search in vb6 that when I clicked on the search bar, the information will be inserted to the text boxes.



Answer Question   |  July 19, 2012  3:52 AM
Search, Search string, VB6
asked by:
5 pts.

VB6 Search Function

How can I search in vb6 that when I clicked on the search bar, the information will be inserted to the text boxes.



Answer Question   |  July 19, 2012  3:52 AM
Search, Search string, VB6
asked by:
5 pts.

rpgle web services

How to modify a pf through rpgle web services



Answer Question   |  July 16, 2012  12:04 PM
Web development
asked by:
1,240 pts.

Meaning of 100% zoom

Hi, I am using print preview control, but when i make zoom = 1(100%), i cannot see the full page of a document, then what really 100% zoom means here? 100% of what? Thanks ANd Regards Santosh



Answer Question   |  July 14, 2012  11:20 AM
Windows Forms
asked by:
10 pts.

Crystal Reports Duplicating Records

Hi, I hope that someone can help me. We are currently replacing a system with a new version and as such we are building a new SQL DB. Although the two DBs store the same information they don’t share a common layout. I have created a basic report to see if the record count for…



Answer Question   |  July 14, 2012  10:52 AM
Crystal Reports, SQL, SQL Server
asked by:
5 pts.

STRSQL query

I need to know how to get the record count for a particular year. the date field is in YYYYMMDD format. I tried the query select SUBSTR(PLGLDT,0,4) AS YEAR, COUNT(*) AS “RECORD COUNT” FROM BPCSF60/APL GROUP BY SUBSTR(PLGLDT,0,4) ORDER BY SUBSTR(PLGLDT,0,4) DESC. But I am getting error “Argument 2 of substringing function not valid”. Can…



Answer Question   |  June 14, 2013  5:26 AM
AS/400, AS/400 error messages, SUBSTR
asked by:
280 pts.

Select Statement & Where Clause ….

On an ASP web page there is a Text Box with default Values for different records. The records are stored in a SQL2008 table called dbo.SOFTWARE and have been type in manually over time and contains many duplicates. The field is called ‘BUSINESS_UNIT’. On the same page i have created a Combo Box populated by…



Answer Question   |  July 11, 2012  3:31 PM
ASP, SQL Server 2008, VBScript
asked by:
40 pts.

Lotus notes to Sql

I have text files as attachments to emails in Notes Database and I would like to get the information from the attachment and store it in Sql database. Could any one suggest the best possible way to accomplish this I have set of data in the text file It goes like this // Name: Tom…



Answer Question   |  July 9, 2012  4:42 PM
Lotus Notes, SQL
asked by:
0 pts.

create,delete,validate dynamic tables

hi, i need to create dynamic tables like this. https://20db.banner-admin.com/order/configure please any one can send model code for this. i am web design trainee. i try to do like this please any one teach me.



Answer Question   |  July 9, 2012  3:56 AM
HTML, JavaScript
asked by:
5 pts.

Prefix Number

please assist here:entry missing for test system client 120.How can i resolve this issue?



Answer Question   |  July 9, 2012  12:30 AM
Workflow definition
asked by:
5 pts.

How to create User Xml tags Based on SQL data

I have a sql table which contains the details of controls used in the application. Now I want to create a xml file for the data in the same table based on the ControlType in the table. I need to get different tags and subtags for controls based on the control type. How do i…



Answer Question   |  July 7, 2012  11:23 PM
SQL, XML, XML Tags
asked by:
5 pts.

Look at query results & pass a value to form in ACCESS 2003

I need to be able to look at the results of a query & based on the values in one field (?) on a subform/table enter a Pass/Fail value to the main table. Here is a basic breakdown of what I have: t_Main: table defining dimensional layout requirements. There can be multiple parts of the…



Answer Question   |  July 7, 2012  7:39 PM
Access 2003, Access 2003 forms, Access forms, Microsoft Access
asked by:
85 pts.

Video hosting

I am including a video howto section to my business website. I have minimal experience in php and sql but have already created a SQL database for the information. I want this to be both dynamic and directable through the title of the video. can someone please give me direction.



Answer Question   |  July 6, 2012  9:46 PM
PHP, SQL, SQL Database, Video hosting, Web development, Website design
20 pts.

Relative hyperlinks to start a CD/HDD application

I’m trying to make a game CD with a html menu from where game (converted flash games in to exe file) will start but if, I use html pictures’ of the games as buttons all will point to CD but I like to make it neutrally so I can just copy CD to each computer…



Answer Question   |  July 6, 2012  8:06 PM
ActionScript, Flash development, HTML editor, Namo 2008, Relative references
asked by:
65 pts.