Hotel database in Access 2007
See, this is very long to answer. I am providing a full details with a good link : http://office.microsoft.com/en-us/access-help/create-a-new-database-HA010037837.aspx
View Answer
| November 22, 2010 1:11 PM
Access, Access 2007, Access 2007 form creation, Access Database, Access Database Design
See, this is very long to answer. I am providing a full details with a good link : http://office.microsoft.com/en-us/access-help/create-a-new-database-HA010037837.aspx
View Answer
| November 22, 2010 1:11 PM
Access, Access 2007, Access 2007 form creation, Access Database, Access Database Design
About JSP
The JSP is translated into the appropriate Servlet code, which is a .java file. Many application servers provide the option of keeping the generated .java files. Once it is translated into the .java file it is compiled into the bytecode file (.class). The .class file is executed and the output HTML document is generated and [...]
View Answer
| November 22, 2010 12:58 PM
Java Servlets, JSP, Web development
The JSP is translated into the appropriate Servlet code, which is a .java file. Many application servers provide the option of keeping the generated .java files. Once it is translated into the .java file it is compiled into the bytecode file (.class). The .class file is executed and the output HTML document is generated and [...]
View Answer
| November 22, 2010 12:58 PM
Java Servlets, JSP, Web development
Sending Email in Excel using Macro
U can assign this code to a command button or extricate the portion(s) you want and place there . Modify body text and password as and other info as per ur requirement: this is a sample code …. Sub Email() Dim testPassword As String testPassword = InputBox(prompt:=”Please enter the password:”, _ If testPassword <> “Password” [...]
View Answer
| November 22, 2010 9:18 AM
Access 2000, excel, Excel macros, Outlook, VBA Access 2000
U can assign this code to a command button or extricate the portion(s) you want and place there . Modify body text and password as and other info as per ur requirement: this is a sample code …. Sub Email() Dim testPassword As String testPassword = InputBox(prompt:=”Please enter the password:”, _ If testPassword <> “Password” [...]
View Answer
| November 22, 2010 9:18 AM
Access 2000, excel, Excel macros, Outlook, VBA Access 2000
How can I disable Java security warning?
I was able to find this for unsigned applets, I think it might be the right direction. Also I think the developer can program the Java applet to force a certain version for compatibility reasons, or disable the “required version” option.
View Answer
| April 19, 2013 3:11 PM
Java applications, Vista compatibility, Windows Vista security and patches
I was able to find this for unsigned applets, I think it might be the right direction. Also I think the developer can program the Java applet to force a certain version for compatibility reasons, or disable the “required version” option.
View Answer
| April 19, 2013 3:11 PM
Java applications, Vista compatibility, Windows Vista security and patches
The prototyping approach in Software Development Process Models?
It is the development approach of activities during software development the creation of prototypes. The prototyping approach in SDPM is mainly depends on : 1. Identify basic requirements: Determine basic requirements including the input and output information desired. Details, such as security, can typically be ignored. 2. Develop Initial Prototype: The initial prototype is developed [...]
View Answer
| November 20, 2010 11:16 AM
Development, process model, Software, Software development, Software Development Models, Software Development Process, software development process models
It is the development approach of activities during software development the creation of prototypes. The prototyping approach in SDPM is mainly depends on : 1. Identify basic requirements: Determine basic requirements including the input and output information desired. Details, such as security, can typically be ignored. 2. Develop Initial Prototype: The initial prototype is developed [...]
View Answer
| November 20, 2010 11:16 AM
Development, process model, Software, Software development, Software Development Models, Software Development Process, software development process models
ACCESS 2007 setting up repetitive entry form
A form with a subform is probably what you need. Take a look at this: <a href=”http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-a-one-to-many-form-HA010098674.aspx”>Create a form that contains a subform (a one-to-many form)</a>
View Answer
| November 19, 2010 10:53 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions, Access forms, Forms Creation, Windows XP
A form with a subform is probably what you need. Take a look at this: <a href=”http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-a-one-to-many-form-HA010098674.aspx”>Create a form that contains a subform (a one-to-many form)</a>
View Answer
| November 19, 2010 10:53 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions, Access forms, Forms Creation, Windows XP
Using an ampersand in JCL
Generally a single ampersand is used for a variable. example: 001150 // SET PARM1=’some.dataset’ —- //JCLIN DD DSN=&PARM1.,DISP=SHR Two ampersands can be used for a temporary dataset. example: 002500 //SYSUT1 DD DSN=&&WORK,SPACE=(CYL,(5,5)),UNIT=DASD You state “in my jcl after replacement of my variables, it is coming like ‘&&’. ” What does your JCL look like? Can [...]
View Answer
| November 19, 2010 3:26 PM
Date in JCL, JCL, Job Control Language, Programming Languages
Generally a single ampersand is used for a variable. example: 001150 // SET PARM1=’some.dataset’ —- //JCLIN DD DSN=&PARM1.,DISP=SHR Two ampersands can be used for a temporary dataset. example: 002500 //SYSUT1 DD DSN=&&WORK,SPACE=(CYL,(5,5)),UNIT=DASD You state “in my jcl after replacement of my variables, it is coming like ‘&&’. ” What does your JCL look like? Can [...]
View Answer
| November 19, 2010 3:26 PM
Date in JCL, JCL, Job Control Language, Programming Languages
IT career that will use both my software engineering & electronics degrees
Of course, u go for software development. There r so many options in SW development field. U can join as JAVA developer or .net framework. For Java u have to persue for global certification from Sun or Microsoft Certifications. But it is better if u do similar kind of job also. It takes u high [...]
View Answer
| November 19, 2010 1:00 PM
IT career development, IT career planning, IT careers, Software engineering, Software Engineers
Of course, u go for software development. There r so many options in SW development field. U can join as JAVA developer or .net framework. For Java u have to persue for global certification from Sun or Microsoft Certifications. But it is better if u do similar kind of job also. It takes u high [...]
View Answer
| November 19, 2010 1:00 PM
IT career development, IT career planning, IT careers, Software engineering, Software Engineers
Embedding instructions into Microsoft Word
Word does not provide any intrinsic “pop-up” feature that results in a small window containing information when you click on a word or a link. The closest that can be found in Word is the ScreenTip feature, which displays a small ToolTip-like “hint” when you hover the mouse pointer over a hyperlink. The procedure is [...]
View Answer
| November 19, 2010 10:23 AM
Embedded programming, Microsoft Word, Microsoft Word features, Object Linking and Embedding
Word does not provide any intrinsic “pop-up” feature that results in a small window containing information when you click on a word or a link. The closest that can be found in Word is the ScreenTip feature, which displays a small ToolTip-like “hint” when you hover the mouse pointer over a hyperlink. The procedure is [...]
View Answer
| November 19, 2010 10:23 AM
Embedded programming, Microsoft Word, Microsoft Word features, Object Linking and Embedding
Which user end is lightweight and faster in client server design, Java or Netbeans?
As far my knowledge NetBeans is a tool / SW for those who build web applications and for software developers. It is an IDE ( Integrated Development Environment ) which is available as open source software. U can run this program on most operating systems including Windows, Linux, Mac OS X and Solaris. With NetBeans [...]
View Answer
| November 19, 2010 7:22 AM
Java, Java IDE, NetBeans, Open source applications, Programming Languages
As far my knowledge NetBeans is a tool / SW for those who build web applications and for software developers. It is an IDE ( Integrated Development Environment ) which is available as open source software. U can run this program on most operating systems including Windows, Linux, Mac OS X and Solaris. With NetBeans [...]
View Answer
| November 19, 2010 7:22 AM
Java, Java IDE, NetBeans, Open source applications, Programming Languages
How to write text into word doc using SQL 2000 query analyzer
I am using this procedure to create and append the doc file but no result get till now why ??anybody clear it ?? alter PROCEDURE sp_AppendToFile(@FileName varchar(255), @Text1 varchar(255)) AS DECLARE @FS int, @OLEResult int, @FileID int EXECUTE @OLEResult = sp_OACreate ‘Scripting.FileSystemObject’, @FS OUT select @OLEResult IF @OLEResult <> 0 PRINT ‘Scripting.FileSystemObject’ –Open a file [...]
View Answer
| November 19, 2010 7:05 AM
SQL 2000, SQL Query, SQL Query Analyzer, SQL Server 2000, SQL Server 2000 queries
I am using this procedure to create and append the doc file but no result get till now why ??anybody clear it ?? alter PROCEDURE sp_AppendToFile(@FileName varchar(255), @Text1 varchar(255)) AS DECLARE @FS int, @OLEResult int, @FileID int EXECUTE @OLEResult = sp_OACreate ‘Scripting.FileSystemObject’, @FS OUT select @OLEResult IF @OLEResult <> 0 PRINT ‘Scripting.FileSystemObject’ –Open a file [...]
View Answer
| November 19, 2010 7:05 AM
SQL 2000, SQL Query, SQL Query Analyzer, SQL Server 2000, SQL Server 2000 queries
converting a macro
Dear Tootsie, it is possible and the steps are : 1. Open WordPerfect and run the macros that u want to convert 2. Type the name of the macro, and then press ENTER 3. Press ALT+F10, it displays the following prompt at the bottom of the screen MACRO NOTE: To run a macro that uses [...]
View Answer
| November 19, 2010 6:30 AM
Conversion, Macros
Dear Tootsie, it is possible and the steps are : 1. Open WordPerfect and run the macros that u want to convert 2. Type the name of the macro, and then press ENTER 3. Press ALT+F10, it displays the following prompt at the bottom of the screen MACRO NOTE: To run a macro that uses [...]
View Answer
| November 19, 2010 6:30 AM
Conversion, Macros
Tomorrow at 4PM ET: ITKE Rolls Out New Badge System
cool.. all the best with the rolling out changes
View Answer
| November 19, 2010 4:22 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developement, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server 2003
cool.. all the best with the rolling out changes
View Answer
| November 19, 2010 4:22 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developement, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server 2003
Errors printing Java code
You are successfully creating your PrintWriter, which is named ‘out’, but when you do this: <pre>System.out.println(upper);</pre> Your are printing to the console not to your print writer. The above line should be: <pre>out.println(upper);</pre> Any content that was previously in the file is being erased because you are opening it for writing (but you are not [...]
View Answer
| November 18, 2010 11:52 PM
Java, Java applications, Java code, Java developers
You are successfully creating your PrintWriter, which is named ‘out’, but when you do this: <pre>System.out.println(upper);</pre> Your are printing to the console not to your print writer. The above line should be: <pre>out.println(upper);</pre> Any content that was previously in the file is being erased because you are opening it for writing (but you are not [...]
View Answer
| November 18, 2010 11:52 PM
Java, Java applications, Java code, Java developers
ORA-1555 insert table with 3 billions rows in Oracle with SQL
The problem is probably being caused by the commits you are issuing every 200,000 rows. When the number of transactions created after the cursor was opened increase, the chances of getting this error also grow if you continue fetching data from the cursor. From the DBA perspective, maybe increasing the number and/or size of the [...]
View Answer
| November 18, 2010 8:20 PM
ORA-1555, Oracle 9i, Oracle Tables, SQL
The problem is probably being caused by the commits you are issuing every 200,000 rows. When the number of transactions created after the cursor was opened increase, the chances of getting this error also grow if you continue fetching data from the cursor. From the DBA perspective, maybe increasing the number and/or size of the [...]
View Answer
| November 18, 2010 8:20 PM
ORA-1555, Oracle 9i, Oracle Tables, SQL
Can I direct query the Oracle database with SQL Plus?
With the appropriate credentials, you could connect to the database from SQL*Plus, and you would be able to query it if you know the appropriate object names and the user account has the appropriate privileges. So, it depends.
View Answer
| November 18, 2010 3:08 PM
ERP, Oracle, Oracle 10, Oracle Database, Oracle Query, SAP, SQL, SQL Plus, Unix
With the appropriate credentials, you could connect to the database from SQL*Plus, and you would be able to query it if you know the appropriate object names and the user account has the appropriate privileges. So, it depends.
View Answer
| November 18, 2010 3:08 PM
ERP, Oracle, Oracle 10, Oracle Database, Oracle Query, SAP, SQL, SQL Plus, Unix
Saving and opening forms in Visual Basic 6
To open a form, you would use the Show method: <pre>Private Sub Command1_Click() Form2.Show End Sub</pre> To hide (without unloading) a form: <pre>Private Sub Command2_Click() Form2.Hide End Sub</pre> To unload a form: <pre>Unload Form2</pre>
View Answer
| November 18, 2010 3:04 PM
VB 6.0, Visual Basic, Visual Basic 6.0, Visual Basic developers
To open a form, you would use the Show method: <pre>Private Sub Command1_Click() Form2.Show End Sub</pre> To hide (without unloading) a form: <pre>Private Sub Command2_Click() Form2.Hide End Sub</pre> To unload a form: <pre>Unload Form2</pre>
View Answer
| November 18, 2010 3:04 PM
VB 6.0, Visual Basic, Visual Basic 6.0, Visual Basic developers
How to Test for Numerics in AS/400
You can put a monitor around the %dec function as so: Monitor; SomeNumber = %dec(someAlpha:5:0); On-Error; //Do whatever you want if field is not numeric ENDMON; This will attempt to convert the string to numeric and catch the error if the field does not contain valid numeric data.
View Answer
| November 18, 2010 2:48 PM
AS/400, Numeric, RPG/400, RPGILE
You can put a monitor around the %dec function as so: Monitor; SomeNumber = %dec(someAlpha:5:0); On-Error; //Do whatever you want if field is not numeric ENDMON; This will attempt to convert the string to numeric and catch the error if the field does not contain valid numeric data.
View Answer
| November 18, 2010 2:48 PM
AS/400, Numeric, RPG/400, RPGILE
null v/s ” “(empty string) in Java
Null has no bounds, it can be used for string, integer, date, etc. fields in a database. Empty string is just regarding a string; it’s a string like ‘hgjko0p’ is, but is just has no length. If you have no value for a field, use null, not an empty string. Null is an absence of [...]
View Answer
| November 18, 2010 8:41 AM
Java, Java code, Java developers, NULL, String name
Null has no bounds, it can be used for string, integer, date, etc. fields in a database. Empty string is just regarding a string; it’s a string like ‘hgjko0p’ is, but is just has no length. If you have no value for a field, use null, not an empty string. Null is an absence of [...]
View Answer
| November 18, 2010 8:41 AM
Java, Java code, Java developers, NULL, String name
Rename Printers in logon for Windows Server 2003, with VBScript
Best I can tell you is go to the server and change the share as name to printer1, printer2, printer3, etc. Then your users will see printer1 on server, printer2 on server, etc. As long as he printer is a shared printer in a windows network you will have the “on servername” appened to the [...]
View Answer
| November 17, 2010 7:07 PM
Login scripts, VBScript, Visual Basic Script, Windows Server 2003 R2, Windows XP Professional SP3
Best I can tell you is go to the server and change the share as name to printer1, printer2, printer3, etc. Then your users will see printer1 on server, printer2 on server, etc. As long as he printer is a shared printer in a windows network you will have the “on servername” appened to the [...]
View Answer
| November 17, 2010 7:07 PM
Login scripts, VBScript, Visual Basic Script, Windows Server 2003 R2, Windows XP Professional SP3
