Duplicating records in a table with a SQL query
How can I duplicate every record in a table with a query in SQL?
Answer Question
| January 14, 2009 4:54 PM
Duplicate records, SQL queries, SQL tables
How can I duplicate every record in a table with a query in SQL?
Answer Question
| January 14, 2009 4:54 PM
Duplicate records, SQL queries, SQL tables
What is the market value/salary for a Exchange system administrator and MCSA on messaging
What is the market value for a system administrator in Exchange and how much salary a MCSA on messanging can get in delhi NCR
Answer Question
| February 19, 2009 4:29 AM
Certifications, Exchange administrator, IT careers, IT salaries, MCSA, Microsoft Certified Systems Administrator, System administration, System administrator
What is the market value for a system administrator in Exchange and how much salary a MCSA on messanging can get in delhi NCR
Answer Question
| February 19, 2009 4:29 AM
Certifications, Exchange administrator, IT careers, IT salaries, MCSA, Microsoft Certified Systems Administrator, System administration, System administrator
Problem with Microsoft Access 2003 write permissions
users have read and write permission to certain forms in the database but after loggin, they could not enter any data to the form,please could help,i checked users&groups account,users&group permission everything seem to be okay but still.is there something i over looked or have not done yet.
Answer Question
| January 14, 2009 3:52 AM
Access 2003, Database write permissions, Microsoft Access 2003, Microsoft Access 2003 permissions, Microsoft Access 2003 security
users have read and write permission to certain forms in the database but after loggin, they could not enter any data to the form,please could help,i checked users&groups account,users&group permission everything seem to be okay but still.is there something i over looked or have not done yet.
Answer Question
| January 14, 2009 3:52 AM
Access 2003, Database write permissions, Microsoft Access 2003, Microsoft Access 2003 permissions, Microsoft Access 2003 security
Access Error importing data from Lotus Notes
I have a user that is importing data from Lotus Notes into Microsoft Access and is receiving a Microsoft error. I’ve already verified with IBM that it is not a Lotus Notes issue in any form. Here is an explanation of the process and the error: How the process is done: Opens lotus notes does [...]
Answer Question
| January 15, 2009 6:26 PM
Access and Lotus, Lotus Notes, Lotus Notes import/export, Microsoft Access, Microsoft Access import/export
I have a user that is importing data from Lotus Notes into Microsoft Access and is receiving a Microsoft error. I’ve already verified with IBM that it is not a Lotus Notes issue in any form. Here is an explanation of the process and the error: How the process is done: Opens lotus notes does [...]
Answer Question
| January 15, 2009 6:26 PM
Access and Lotus, Lotus Notes, Lotus Notes import/export, Microsoft Access, Microsoft Access import/export
Edit data in an Access Form
I have done this before, but cant get it to work in my new database. I have created a form that is based off a query in my database. I want my users to be able to type data into one of the fields on my form and the table driving the query will update [...]
Answer Question
| January 14, 2009 10:25 PM
Access, Database, Microsoft Access, text box
I have done this before, but cant get it to work in my new database. I have created a form that is based off a query in my database. I want my users to be able to type data into one of the fields on my form and the table driving the query will update [...]
Answer Question
| January 14, 2009 10:25 PM
Access, Database, Microsoft Access, text box
Iseries Queries.
Hello, I have a query schedule that runs Daily and looks for events for the previous day and, it’s access in access database, but on Mondays I don’t get anything because is set for previous day and Sat and Sunday overwrite the query so I get ZERO results. I’ve set for YESTERDAYX. How can I [...]
Answer Question
| January 13, 2009 7:06 PM
Access Database, AS/400 queries, AS/400 scheduling, Microsoft Access
Hello, I have a query schedule that runs Daily and looks for events for the previous day and, it’s access in access database, but on Mondays I don’t get anything because is set for previous day and Sat and Sunday overwrite the query so I get ZERO results. I’ve set for YESTERDAYX. How can I [...]
Answer Question
| January 13, 2009 7:06 PM
Access Database, AS/400 queries, AS/400 scheduling, Microsoft Access
Adding a password to a SQL Server 2005 database
We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?
Answer Question
| January 14, 2009 4:32 PM
Access Database, Microsoft Access, Password management, SQL Server 2005, SQL Server databases
We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?
Answer Question
| January 14, 2009 4:32 PM
Access Database, Microsoft Access, Password management, SQL Server 2005, SQL Server databases
Data Structures
I need to rename a field within a data structure? what code format do i use.
Answer Question
| January 12, 2009 3:15 PM
Data structures
I need to rename a field within a data structure? what code format do i use.
Answer Question
| January 12, 2009 3:15 PM
Data structures
Microsoft Access 2007 Data Input & Report
I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 [...]
Answer Question
| January 12, 2009 4:03 AM
Microsoft Access, Microsoft Access 2007, Microsoft Excel, Microsoft Excel 2007
I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 [...]
Answer Question
| January 12, 2009 4:03 AM
Microsoft Access, Microsoft Access 2007, Microsoft Excel, Microsoft Excel 2007
RPG edit code for signed value
Hi I have moved a numeric value to a ds. I have used this EVAL F1 = %EDITC(ABC:’3′)-here F1 is part of flat file DS and there are decimals required in the output file.I am getting the decimals but my problem is that ABC field from i/p file could be negative but am not sure [...]
Answer Question
| January 13, 2009 2:58 PM
Flat files, RPG Flat Files, RPG ILE
Hi I have moved a numeric value to a ds. I have used this EVAL F1 = %EDITC(ABC:’3′)-here F1 is part of flat file DS and there are decimals required in the output file.I am getting the decimals but my problem is that ABC field from i/p file could be negative but am not sure [...]
Answer Question
| January 13, 2009 2:58 PM
Flat files, RPG Flat Files, RPG ILE
How to check the existence of a Column in SQL Server 2000?
- using SQL Server 2000 , Would like to know how to check any specific column exist in a database. Any method to search through the list of tables in a database. Thanks.
Answer Question
| January 12, 2009 9:30 AM
SQL queries, SQL Server 2000, SQL Server 2000 queries
- using SQL Server 2000 , Would like to know how to check any specific column exist in a database. Any method to search through the list of tables in a database. Thanks.
Answer Question
| January 12, 2009 9:30 AM
SQL queries, SQL Server 2000, SQL Server 2000 queries
Slow JDBC DB2 Connection
Hello, Having an issue with a new server we are setting up. The server is Linux RHE 4, running DB2 8.1 and Domino 7.03. Our DB2 databases reside an a separate dedicated DB2 server and are cataloged on our new server. Connections to these databases are working fine using SQL tools and from the server [...]
Answer Question
| January 8, 2009 9:12 PM
DB2, DB2 8.1, DB2 8.x, DB2 Performance, Domino 7.0.3, Domino 7.x, JDBC, Linux RHE 4
Hello, Having an issue with a new server we are setting up. The server is Linux RHE 4, running DB2 8.1 and Domino 7.03. Our DB2 databases reside an a separate dedicated DB2 server and are cataloged on our new server. Connections to these databases are working fine using SQL tools and from the server [...]
Answer Question
| January 8, 2009 9:12 PM
DB2, DB2 8.1, DB2 8.x, DB2 Performance, Domino 7.0.3, Domino 7.x, JDBC, Linux RHE 4
Export Access to Outlook
Is there a simple way to export an Access Database to Outlook? There seems to be an export to Lotus 123 but not one for Outlook, am I missing something?
Answer Question
| January 9, 2009 7:02 PM
Access Database, Export Access to Outlook, Microsoft Access, Outlook
Is there a simple way to export an Access Database to Outlook? There seems to be an export to Lotus 123 but not one for Outlook, am I missing something?
Answer Question
| January 9, 2009 7:02 PM
Access Database, Export Access to Outlook, Microsoft Access, Outlook
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
| January 8, 2009 5:05 PM
Access 2003, Access 2003 forms, Access forms, Microsoft Access
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
| January 8, 2009 5:05 PM
Access 2003, Access 2003 forms, Access forms, Microsoft Access
AS400/iSeries Queries on a schedule
I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.
Answer Question
| January 8, 2009 12:22 AM
AS/400 import/export, Microsoft Access, Microsoft Excel, SBMSCHJOB, Submit Scheduled Job
I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.
Answer Question
| January 8, 2009 12:22 AM
AS/400 import/export, Microsoft Access, Microsoft Excel, SBMSCHJOB, Submit Scheduled Job
Crystal Reports can’t connect to Access 2007
We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB’s. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB’s.
Answer Question
| January 8, 2009 8:58 PM
Access 2007, Crystal Reports, Crystal Reports XI, Crystal reports Xi to Access 2007, Microsoft Access
We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB’s. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB’s.
Answer Question
| January 8, 2009 8:58 PM
Access 2007, Crystal Reports, Crystal Reports XI, Crystal reports Xi to Access 2007, Microsoft Access
Code to upload CSV file to AS400
I am looking for code to convert .CSV file to AS400 automatically. I need to automate this feature. Thanks in advance.
Answer Question
| January 7, 2009 5:46 PM
CSV, CSV to AS400
I am looking for code to convert .CSV file to AS400 automatically. I need to automate this feature. Thanks in advance.
Answer Question
| January 7, 2009 5:46 PM
CSV, CSV to AS400
What should our next contest be on ITKnowledgeExchange.com?
We want to kick off the new year with an exciting contest and want your input. We have done a variety of contests from the top 3 Knowledge Point earners winning prizes like an XBOX 360. Also we have had Amazon.com gift cards for the top 10 point earners who achieve over 500 Knowledge Points. [...]
Answer Question
| January 11, 2009 4:02 PM
AS/400, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, SQL Server, Storage, Virtualization, VoIP
We want to kick off the new year with an exciting contest and want your input. We have done a variety of contests from the top 3 Knowledge Point earners winning prizes like an XBOX 360. Also we have had Amazon.com gift cards for the top 10 point earners who achieve over 500 Knowledge Points. [...]
Answer Question
| January 11, 2009 4:02 PM
AS/400, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, SQL Server, Storage, Virtualization, VoIP
What is the best & quickest way to get a networking job?
Is it the Microsoft way/ CISCO way / Red hat way/ Comp Tia way, for an inexperienced person.
Answer Question
| February 19, 2009 9:24 AM
Certifications, Cisco certifications, IT careers, IT education, Linux certifications, Microsoft certifications, Red Hat
Is it the Microsoft way/ CISCO way / Red hat way/ Comp Tia way, for an inexperienced person.
Answer Question
| February 19, 2009 9:24 AM
Certifications, Cisco certifications, IT careers, IT education, Linux certifications, Microsoft certifications, Red Hat
Career advice for moving from development to SAP
Hi, iam Aditi , i have 1 year experience in java and flex, and now i want to change my domain, as iam not very comfortable with development anymore….. i wanted to ask that which in domain i can go, i want to be in IT industry only. Can i shift in SAP, but in [...]
Answer Question
| February 2, 2009 7:20 AM
Career development, IT careers, Java developer, SAP careers
Hi, iam Aditi , i have 1 year experience in java and flex, and now i want to change my domain, as iam not very comfortable with development anymore….. i wanted to ask that which in domain i can go, i want to be in IT industry only. Can i shift in SAP, but in [...]
Answer Question
| February 2, 2009 7:20 AM
Career development, IT careers, Java developer, SAP careers
