AS/400 Profile getting disabled by MS Access
Is this profile shared by a user who may be disabling it by exceding the sign-on attempts? We have some user that have macros set up to log them in and they forget to change them when they are forced to change their password. If this profile is not shared, you may consider changing the [...]
View Answer
| June 8, 2012 2:55 PM
iSeries, Microsoft Access, ODBC
Is this profile shared by a user who may be disabling it by exceding the sign-on attempts? We have some user that have macros set up to log them in and they forget to change them when they are forced to change their password. If this profile is not shared, you may consider changing the [...]
View Answer
| June 8, 2012 2:55 PM
iSeries, Microsoft Access, ODBC
Printing the contents property of an EXCEL file
File > Print, select Entire Document. You can also choose to set landscape to see more across a single page. You can set a Zoom percent before printing to reduce a large printout to more manageable size.
View Answer
| June 8, 2012 3:34 AM
Excel macros, Microsoft Access, Microsoft Excel
File > Print, select Entire Document. You can also choose to set landscape to see more across a single page. You can set a Zoom percent before printing to reduce a large printout to more manageable size.
View Answer
| June 8, 2012 3:34 AM
Excel macros, Microsoft Access, Microsoft Excel
Vista and Office 2007
The biggest issues were training users to use the Office ribbon and printing Acrobat documents to HP printers. The printer would lock and the application would freeze.
View Answer
| June 4, 2012 11:03 PM
AS/400, Microsoft Access, Microsoft Excel, Microsoft Office 2007
The biggest issues were training users to use the Office ribbon and printing Acrobat documents to HP printers. The printer would lock and the application would freeze.
View Answer
| June 4, 2012 11:03 PM
AS/400, Microsoft Access, Microsoft Excel, Microsoft Office 2007
execute dbms_utility.analyze_schema
When you put in a call, you need to point to a file first. If this is not happening on the front end, that could be the source of the missing file error. On the other hand, this is a really old question. You have probably figured out the answer Can we close it?
View Answer
| June 4, 2012 9:43 PM
Database, DB2, Oracle
When you put in a call, you need to point to a file first. If this is not happening on the front end, that could be the source of the missing file error. On the other hand, this is a really old question. You have probably figured out the answer Can we close it?
View Answer
| June 4, 2012 9:43 PM
Database, DB2, Oracle
Access, Searchable Combo Box within a Form?
After they pick the month(es) take the results and open a new form and change the filter on the open based on what they picked.
View Answer
| May 25, 2012 7:58 PM
Database, Microsoft Access, MS Access
After they pick the month(es) take the results and open a new form and change the filter on the open based on what they picked.
View Answer
| May 25, 2012 7:58 PM
Database, Microsoft Access, MS Access
Creating a database from an already created database
Is there a reason you cannot just use the database that you import? Are you importing the completed database or just changes? What type of DB do you want to setup? DB2, SQL, … Once you have answered those questions, and you decide you want to create a relation DB; just design it however you [...]
View Answer
| May 24, 2012 4:13 PM
Database
Is there a reason you cannot just use the database that you import? Are you importing the completed database or just changes? What type of DB do you want to setup? DB2, SQL, … Once you have answered those questions, and you decide you want to create a relation DB; just design it however you [...]
View Answer
| May 24, 2012 4:13 PM
Database
What Oracle 10g software is needed to download and install on the system for Running JDBC Programs on the system.
there is no number of oracle 10g softwares its only one oracle 10g and doing the jdbc programs as normal java programs but u must install the database software and while writing the jdbc programs u must know the pattern of the program like the database port number 8080 the pattern should be perfect http://www.oracle.com/webapps/dialogue/ns/dlgwelcome.jsp?p_ext=Y&p_dlg_id=10410771&src=7327902&Act=15&sckw=WWMK11054736MPP008.GCM.9362 [...]
View Answer
| May 21, 2012 1:54 PM
JDBC, Oracle 10g
there is no number of oracle 10g softwares its only one oracle 10g and doing the jdbc programs as normal java programs but u must install the database software and while writing the jdbc programs u must know the pattern of the program like the database port number 8080 the pattern should be perfect http://www.oracle.com/webapps/dialogue/ns/dlgwelcome.jsp?p_ext=Y&p_dlg_id=10410771&src=7327902&Act=15&sckw=WWMK11054736MPP008.GCM.9362 [...]
View Answer
| May 21, 2012 1:54 PM
JDBC, Oracle 10g
Pass table name to procedure including fields
Use a varible to create your statement. Pass tablename as @tablename declare @sql as varchar(1000) set @sql = ‘Select column1, column2, column3 from ‘ + @tablename + ‘ order by column1′ exec (@sql) Note ( ) around @sql
View Answer
| May 14, 2012 1:31 PM
MySQL, MySQL Database
Use a varible to create your statement. Pass tablename as @tablename declare @sql as varchar(1000) set @sql = ‘Select column1, column2, column3 from ‘ + @tablename + ‘ order by column1′ exec (@sql) Note ( ) around @sql
View Answer
| May 14, 2012 1:31 PM
MySQL, MySQL Database
SQL TAGS
can u provide any example what are the tags you used and what type of errors u get and if u r using any personal web server specify
View Answer
| May 11, 2012 9:37 AM
MySQL, MySQL Database
can u provide any example what are the tags you used and what type of errors u get and if u r using any personal web server specify
View Answer
| May 11, 2012 9:37 AM
MySQL, MySQL Database
QEXECSQL command source
Clarke use the command prompt to ask for what command is use for (Accessed through run than typein cmd). i.e. the commant XCOPY is used for coping network file and if you just want to copy an item use COPY ##(# is the item name).
View Answer
| May 10, 2012 10:12 AM
CSV, OS/400
Clarke use the command prompt to ask for what command is use for (Accessed through run than typein cmd). i.e. the commant XCOPY is used for coping network file and if you just want to copy an item use COPY ##(# is the item name).
View Answer
| May 10, 2012 10:12 AM
CSV, OS/400
VB 6.0 Database
Hello, everybody, the good shoping place, the new season approaching, click in. Welcome to ==== http://www.fashion-long-4biz.com == Air Jordan (1-24) shoes $35 Jordan (1-22)&2009 shoes $45 Nike shox (R4, NZ, OZ, TL1, TL2, TL3) $35 Handbags ( Coach Lv fendi D&G) $30 T-shirts (polo, ed hardy, lacoste) $14 Jean (True Religion, ed hardy, coogi)$34 Sunglasses [...]
View Answer
| May 3, 2012 12:59 AM
Microsoft Access, VB 6.0
Hello, everybody, the good shoping place, the new season approaching, click in. Welcome to ==== http://www.fashion-long-4biz.com == Air Jordan (1-24) shoes $35 Jordan (1-22)&2009 shoes $45 Nike shox (R4, NZ, OZ, TL1, TL2, TL3) $35 Handbags ( Coach Lv fendi D&G) $30 T-shirts (polo, ed hardy, lacoste) $14 Jean (True Religion, ed hardy, coogi)$34 Sunglasses [...]
View Answer
| May 3, 2012 12:59 AM
Microsoft Access, VB 6.0
Open IT Forum: Do you feel good about the IT job market?
I feel that the more experience folk are OK. Newbies – not so sure
View Answer
| April 28, 2012 7:23 AM
IT careers, IT industry
I feel that the more experience folk are OK. Newbies – not so sure
View Answer
| April 28, 2012 7:23 AM
IT careers, IT industry
Free online practice exercises on SQL/Oracle
A Gentle Introduction to SQL http://sqlzoo.net/ SQLCourse – Interactive Online SQL Training for Beginners http://sqlcourse.com/ SQLCourse2 – Advanced Online SQL Training http://sqlcourse2.com/ SQL Exercises – Online SQL (DML) Training <a href=”http://www.sql-ex.ru/”>www.sql-ex.ru/</a> w3schools you want online free test check this: it is more usefull………… www.wiziq.com/tests/sql ///////////////////////////////////// www.sqlzoo.net //////////////////////////////////////
View Answer
| April 17, 2013 3:56 AM
MySQL, Oracle, SQL Server
A Gentle Introduction to SQL http://sqlzoo.net/ SQLCourse – Interactive Online SQL Training for Beginners http://sqlcourse.com/ SQLCourse2 – Advanced Online SQL Training http://sqlcourse2.com/ SQL Exercises – Online SQL (DML) Training <a href=”http://www.sql-ex.ru/”>www.sql-ex.ru/</a> w3schools you want online free test check this: it is more usefull………… www.wiziq.com/tests/sql ///////////////////////////////////// www.sqlzoo.net //////////////////////////////////////
View Answer
| April 17, 2013 3:56 AM
MySQL, Oracle, SQL Server
Image(Photo and Picturtes) in FoxPro 2.6
i need to print an image in foxpro 2.6
View Answer
| April 6, 2012 3:39 PM
FoxPro, FoxPro 2.6, FoxPro 2.6 for DOS
i need to print an image in foxpro 2.6
View Answer
| April 6, 2012 3:39 PM
FoxPro, FoxPro 2.6, FoxPro 2.6 for DOS
Seeking Masters Degree and Certs at once
Since you have this background check out the Masters in Information systems that Stevens-Henager college is offering. They might be what you’re looking for. Don’t worry since it is an accredited college and you can read <a href=”http://colleges.cliffsnotes.com/stevens–henager-college—-murray”>Stevens-Henager student reviews</a> too. I hope this helped!
View Answer
| April 5, 2012 11:44 AM
Cisco certification, IT careers, IT training, IT training and certifications, Microsoft Certification
Since you have this background check out the Masters in Information systems that Stevens-Henager college is offering. They might be what you’re looking for. Don’t worry since it is an accredited college and you can read <a href=”http://colleges.cliffsnotes.com/stevens–henager-college—-murray”>Stevens-Henager student reviews</a> too. I hope this helped!
View Answer
| April 5, 2012 11:44 AM
Cisco certification, IT careers, IT training, IT training and certifications, Microsoft Certification
What is the next career path for Software Test Engineer?
It depends if you want to stay in the same area or not. Improving skills such as communication, working with people and experience in different industries can help. If you want to stay in testing, perhaps a testing manager could be the way to go? The pay is usually more and you get to stay [...]
View Answer
| March 6, 2012 9:14 AM
IT career, IT career advice, IT career planning, IT careers, Manual Testing, Software Test Engineer
It depends if you want to stay in the same area or not. Improving skills such as communication, working with people and experience in different industries can help. If you want to stay in testing, perhaps a testing manager could be the way to go? The pay is usually more and you get to stay [...]
View Answer
| March 6, 2012 9:14 AM
IT career, IT career advice, IT career planning, IT careers, Manual Testing, Software Test Engineer
columns in table (Access)
Have you tried the orientation on the property sheet in design mode for the table. It allows for “Left-to-Right” or “Right-to-Left”. Hope this helps
View Answer
| March 5, 2012 4:53 PM
Microsoft Access, Microsoft Access tables
Have you tried the orientation on the property sheet in design mode for the table. It allows for “Left-to-Right” or “Right-to-Left”. Hope this helps
View Answer
| March 5, 2012 4:53 PM
Microsoft Access, Microsoft Access tables
Query for records that have certain numbers in them
Under assumption that your table has a unique column named id, you could use the following query SELECT id, count(*) as “quantity of numbers” FROM table, search where fieldone=f1 or fieldtwo=f1 or fieldthree=f1 or fieldfore=f1 group by id; where the “table” is your table and “search” is a table with (different) numbers to be search: [...]
View Answer
| February 1, 2013 2:04 PM
Microsoft Access, Microsoft Access queries
Under assumption that your table has a unique column named id, you could use the following query SELECT id, count(*) as “quantity of numbers” FROM table, search where fieldone=f1 or fieldtwo=f1 or fieldthree=f1 or fieldfore=f1 group by id; where the “table” is your table and “search” is a table with (different) numbers to be search: [...]
View Answer
| February 1, 2013 2:04 PM
Microsoft Access, Microsoft Access queries
Road to become a Security Auditor?
It sounds like your focus has been on the technical certifications, while valuable may not fully prepare you for an auditing position. You should consider the CISA and/or CISM certifications from ISACA. CISA certification is well recognized in India for IS Audit. Coupled with CISSP or ITIL or Lead Auditor27001, and training with audit firm [...]
View Answer
| February 29, 2012 4:36 AM
CCIE, Certified Information Systems Auditor, CISA, Cisco Certified Internetwork Expert, Information Security Management System, ISMS, IT careers, Security auditing, Security Auditor, Security audits, Security careers
It sounds like your focus has been on the technical certifications, while valuable may not fully prepare you for an auditing position. You should consider the CISA and/or CISM certifications from ISACA. CISA certification is well recognized in India for IS Audit. Coupled with CISSP or ITIL or Lead Auditor27001, and training with audit firm [...]
View Answer
| February 29, 2012 4:36 AM
CCIE, Certified Information Systems Auditor, CISA, Cisco Certified Internetwork Expert, Information Security Management System, ISMS, IT careers, Security auditing, Security Auditor, Security audits, Security careers
Schedule SQL job to run and export to CSV file
We use BCP: set @sql = 'select * from [server].dbname.dbo.tablename' set @bcp = 'bcp "' + @sql + '" queryout serverpathFileName.csv -T -t, -c' exec master..xp_cmdshell @bcp -t, references comma separated values Depending on the version of the BCP utility you may or may not be able to use temp tables.
View Answer
| May 8, 2013 2:22 PM
CSV, SQL Jobs, SSMS 2008
We use BCP: set @sql = 'select * from [server].dbname.dbo.tablename' set @bcp = 'bcp "' + @sql + '" queryout serverpathFileName.csv -T -t, -c' exec master..xp_cmdshell @bcp -t, references comma separated values Depending on the version of the BCP utility you may or may not be able to use temp tables.
View Answer
| May 8, 2013 2:22 PM
CSV, SQL Jobs, SSMS 2008
