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 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
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
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 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
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
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
I need to rename a field within a data structure? what code format do i use.
Answer Question | January 12, 2009 3:15 PM
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
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
- 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
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
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
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 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
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
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
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
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
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