Access 2003 – command button to show query in pivot format
I have a form with a comman button. I want the user to be brought to a query when they press the button. The query is built in a pivot table format, but when accessed by the command button, it appears as a datatable instead. What am I doing wrong?
Answer Question
| September 28, 2010 2:54 PM
Access 2003, Access query, Data Tables, Pivot tables, VB Code, Visual Basic
I have a form with a comman button. I want the user to be brought to a query when they press the button. The query is built in a pivot table format, but when accessed by the command button, it appears as a datatable instead. What am I doing wrong?
Answer Question
| September 28, 2010 2:54 PM
Access 2003, Access query, Data Tables, Pivot tables, VB Code, Visual Basic
Embedded SQL in RPGLE
I am trying to get some counts and totals from one file and put them in another. My SQL statement works fine with STRSQL, not in the RPGLE. Do I have to declare/set a cursor, exec sql and close the cursor just to put the total in another file? C/EXEC SQL C+ INSERT INTO outputfile [...]
Answer Question
| September 29, 2010 2:02 PM
Embedded SQL, MySQL, RPGLE, SQL, SQL statements
I am trying to get some counts and totals from one file and put them in another. My SQL statement works fine with STRSQL, not in the RPGLE. Do I have to declare/set a cursor, exec sql and close the cursor just to put the total in another file? C/EXEC SQL C+ INSERT INTO outputfile [...]
Answer Question
| September 29, 2010 2:02 PM
Embedded SQL, MySQL, RPGLE, SQL, SQL statements
MSQL Auditing
Hello. I’m dot.net developer, and i’m working a lot with MSQL. My current task is when some user executes select query on database, i should ”catch” the query data. What do i mean is if select query is “select * from UsersTbl where UserID = 5″, i have to get ’5′. Does somebody have any idea where to start??? Thanks [...]
Answer Question
| April 9, 2011 8:25 AM
Auditing, dot.net, MySQL, MySQL query, SQL, SQL audit, SQL Query
Hello. I’m dot.net developer, and i’m working a lot with MSQL. My current task is when some user executes select query on database, i should ”catch” the query data. What do i mean is if select query is “select * from UsersTbl where UserID = 5″, i have to get ’5′. Does somebody have any idea where to start??? Thanks [...]
Answer Question
| April 9, 2011 8:25 AM
Auditing, dot.net, MySQL, MySQL query, SQL, SQL audit, SQL Query
Infinite recursion in SQL Server 2000
consider a recursive query in SQL.How to handle infinite recursion to make the query evaluation optimized?
Answer Question
| October 2, 2010 6:52 AM
Query optimization, Recursion, SQL Query, SQL query optimization, SQL Server 2000
consider a recursive query in SQL.How to handle infinite recursion to make the query evaluation optimized?
Answer Question
| October 2, 2010 6:52 AM
Query optimization, Recursion, SQL Query, SQL query optimization, SQL Server 2000
SQL Server I/O
Hello, we have a database that contains three tables. Each table has more than 25,000,000 rows in them. All three tables are in the same file group, array, and drive. Our daily Avg physical I/O is 1,000,000. Our users are complaining that the system is slow daily. Everytime a user writes to any of thos [...]
Answer Question
| September 24, 2010 8:36 PM
Average Disk Queue Length, SQL, SQL Server, SQL Server 2005
Hello, we have a database that contains three tables. Each table has more than 25,000,000 rows in them. All three tables are in the same file group, array, and drive. Our daily Avg physical I/O is 1,000,000. Our users are complaining that the system is slow daily. Everytime a user writes to any of thos [...]
Answer Question
| September 24, 2010 8:36 PM
Average Disk Queue Length, SQL, SQL Server, SQL Server 2005
Exporting Active Directory user info to CSV
Can we export all of our AD data to a CSV file for backup purposes? Can we export the passwords as well? Will they be encrypted? Where can we find the encryption key so we can make heads or tales of them.
Answer Question
| September 28, 2010 4:15 PM
Active Directory User Profiles, CSV, Security in 2010, Windows, Windows Server 2008 R2, Windows Server Security, Windows Server User Profiles
Can we export all of our AD data to a CSV file for backup purposes? Can we export the passwords as well? Will they be encrypted? Where can we find the encryption key so we can make heads or tales of them.
Answer Question
| September 28, 2010 4:15 PM
Active Directory User Profiles, CSV, Security in 2010, Windows, Windows Server 2008 R2, Windows Server Security, Windows Server User Profiles
Import AD data from CSV file to 2003 ad
We have 3500 new ad users. How can we import their usernames, full names, phone numbers, email addresses from a CSV file.
Answer Question
| September 28, 2010 4:14 PM
Active Directory, Active Directory 2003, Active Directory Users, AD, CSV, Windows, Windows Server 2003
We have 3500 new ad users. How can we import their usernames, full names, phone numbers, email addresses from a CSV file.
Answer Question
| September 28, 2010 4:14 PM
Active Directory, Active Directory 2003, Active Directory Users, AD, CSV, Windows, Windows Server 2003
Windows go blank while running reports in 10g
I have oracle 10g as the database and front-end. When I run my application in 2 different windows and run a report in one of the windows, the other goes blank until the report is finished running. Any ideas why? Appreciate your help.
Answer Question
| September 24, 2010 2:07 PM
Database frontend, Oracle, Oracle 10g, Oracle 10g Database, Oracle Database, Oracle Reports 10g
I have oracle 10g as the database and front-end. When I run my application in 2 different windows and run a report in one of the windows, the other goes blank until the report is finished running. Any ideas why? Appreciate your help.
Answer Question
| September 24, 2010 2:07 PM
Database frontend, Oracle, Oracle 10g, Oracle 10g Database, Oracle Database, Oracle Reports 10g
MCA – Oracle or .Net career
I have done Higher Diploma in software engineering from NIIT New Delhi. Now I am persuing MCA second sem from MDU distance. I want to know that in which field I should go like there is lots of different way Like .net , oracle. I realy don’t know that which field is baneficial my career. [...]
Answer Question
| May 20, 2011 2:13 PM
.NET, IT career development, IT career planning, IT careers, MCA, Oracle Careers
I have done Higher Diploma in software engineering from NIIT New Delhi. Now I am persuing MCA second sem from MDU distance. I want to know that in which field I should go like there is lots of different way Like .net , oracle. I realy don’t know that which field is baneficial my career. [...]
Answer Question
| May 20, 2011 2:13 PM
.NET, IT career development, IT career planning, IT careers, MCA, Oracle Careers
How to implement crosstab query in Access?
How to implement crosstab query
Answer Question
| September 23, 2010 4:24 AM
Access, CrossTab Query, SQL Server, SQL Server 2000
How to implement crosstab query
Answer Question
| September 23, 2010 4:24 AM
Access, CrossTab Query, SQL Server, SQL Server 2000
ERP career planning
Hi Peers I have completed my B.tech in Information Technology. I wish to do my Masters in field of ERP. Can u able to predict how abt the demand for ERP in forecoming years and so so. And if it s not so.Then list some of the valuable courses. Eagerly Waiting for your answers. Regards [...]
Answer Question
| September 22, 2010 10:33 PM
Enterprise Resource Planning, ERP, IT career development, IT career planning, IT careers
Hi Peers I have completed my B.tech in Information Technology. I wish to do my Masters in field of ERP. Can u able to predict how abt the demand for ERP in forecoming years and so so. And if it s not so.Then list some of the valuable courses. Eagerly Waiting for your answers. Regards [...]
Answer Question
| September 22, 2010 10:33 PM
Enterprise Resource Planning, ERP, IT career development, IT career planning, IT careers
Trying to Design a Split Database Access 2007/SQL Server Express
Hi, This post will be long, as I have several questions related to this project, but please feel free to only answer any piece you want, however small. Every bit of knowledge will be helpful. One of the programs at my office is in need of a database. I’ve been researching this for awhile, and [...]
Answer Question
| September 30, 2010 5:07 PM
Access 2007, Database frontend, SQL Server, SQL Server Express, VB .NET, Visual Basic .NET
Hi, This post will be long, as I have several questions related to this project, but please feel free to only answer any piece you want, however small. Every bit of knowledge will be helpful. One of the programs at my office is in need of a database. I’ve been researching this for awhile, and [...]
Answer Question
| September 30, 2010 5:07 PM
Access 2007, Database frontend, SQL Server, SQL Server Express, VB .NET, Visual Basic .NET
Migrate MYSql database to SQL 2005
We are looking to migrate from MySql to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?
Answer Question
| September 21, 2010 3:14 PM
MySQL, MySQL Database, MySQL functions, SQL, SQL 2005, SQL Server 2005, SQL Server migration, Windows
We are looking to migrate from MySql to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?
Answer Question
| September 21, 2010 3:14 PM
MySQL, MySQL Database, MySQL functions, SQL, SQL 2005, SQL Server 2005, SQL Server migration, Windows
Excel date format
I am trying to copy data from one of our systems into Excel. Everything copies into Excel except the dates. My source data date format is MMM DD, YYYY (example Jul 14, 2004). I have tried changing the Excel from general to text and also tried changing the date formats.
Answer Question
| September 22, 2010 1:15 PM
Database migration, Excel 2003, Excel 2003 functions, Excel Database
I am trying to copy data from one of our systems into Excel. Everything copies into Excel except the dates. My source data date format is MMM DD, YYYY (example Jul 14, 2004). I have tried changing the Excel from general to text and also tried changing the date formats.
Answer Question
| September 22, 2010 1:15 PM
Database migration, Excel 2003, Excel 2003 functions, Excel Database
Visual Basic Email Script
I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?
Answer Question
| September 21, 2010 11:13 AM
Access 2007, Access 2007 functions, Access Database, Access database permissions, Visual Basic, Visual Basic Script
I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?
Answer Question
| September 21, 2010 11:13 AM
Access 2007, Access 2007 functions, Access Database, Access database permissions, Visual Basic, Visual Basic Script
SAP fico consultant career with 3 years domain experience
Hi friends, I studied B.com and MBA finance and having 3 years experience in finance and accountsing with tally & Oracle finace.Now planning to learn SAP FICO can you please tell me about SAP FICO consultant career for me.
Answer Question
| September 21, 2010 7:58 AM
IT careers, SAP careers, SAP consultant, SAP FICO
Hi friends, I studied B.com and MBA finance and having 3 years experience in finance and accountsing with tally & Oracle finace.Now planning to learn SAP FICO can you please tell me about SAP FICO consultant career for me.
Answer Question
| September 21, 2010 7:58 AM
IT careers, SAP careers, SAP consultant, SAP FICO
Changed Foxpro 2.6 .dbf file and change doesn’t show up when I run the .exe
Hi, I am hoping I am posting this in the correct forum. I work for a company that is running a simple tickets database program to track who uses what sports tickets. There is a .exe file and a few .dbf files, etc. About 10 files in a folder to run this Tickets program from [...]
Answer Question
| May 26, 2012 5:56 PM
Database Files, FoxPro, FoxPro 2.6, FoxPro 2.6 for DOS, FoxPro for DOS
Hi, I am hoping I am posting this in the correct forum. I work for a company that is running a simple tickets database program to track who uses what sports tickets. There is a .exe file and a few .dbf files, etc. About 10 files in a folder to run this Tickets program from [...]
Answer Question
| May 26, 2012 5:56 PM
Database Files, FoxPro, FoxPro 2.6, FoxPro 2.6 for DOS, FoxPro for DOS
“Network Security Engineering” vs “computer software engineering”
Which degree is better to do on the basis of scope and skills?
Answer Question
| September 20, 2010 4:01 PM
Computer engineering, IT careers, IT certification and training, Network security, Network Security Management, Software engineering, Software Engineers
Which degree is better to do on the basis of scope and skills?
Answer Question
| September 20, 2010 4:01 PM
Computer engineering, IT careers, IT certification and training, Network security, Network Security Management, Software engineering, Software Engineers
Using SELECT with LIMIT clause on a physical file
Hi – I’m new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.
Answer Question
| September 24, 2010 1:18 PM
iSeries, MySQL, Oracle SQL Pagination, Pagination, SQL Select
Hi – I’m new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.
Answer Question
| September 24, 2010 1:18 PM
iSeries, MySQL, Oracle SQL Pagination, Pagination, SQL Select
I completed my MCA in pune University 2010
i completed my MCA in Osmania University 2009, now am thinking to choose a path in networking. i have a little bit knowledge in networking. can u suggest any thing on dis?? shall i proceed r not??
Answer Question
| November 20, 2010 6:30 AM
IT career development, IT career planning, IT careers, MCA, Networking careers
i completed my MCA in Osmania University 2009, now am thinking to choose a path in networking. i have a little bit knowledge in networking. can u suggest any thing on dis?? shall i proceed r not??
Answer Question
| November 20, 2010 6:30 AM
IT career development, IT career planning, IT careers, MCA, Networking careers
