Writing to multiple fields with one text box
Set db = CurrentDb Set sn = db.OpenRecordset(“SELECT * FROM databasename ORDER BY ID DESC”, dbOpenDynaset, dbSeeChanges sn.addnew sn!fieldname = Me.textbox sn.Update sn.Close
View Answer
| February 17, 2012 2:03 PM
Access Database, Access query, Access Tables, MS Access 2007
Set db = CurrentDb Set sn = db.OpenRecordset(“SELECT * FROM databasename ORDER BY ID DESC”, dbOpenDynaset, dbSeeChanges sn.addnew sn!fieldname = Me.textbox sn.Update sn.Close
View Answer
| February 17, 2012 2:03 PM
Access Database, Access query, Access Tables, MS Access 2007
max query expression
You would have to use the <a href=”http://www.techonthenet.com/access/functions/numeric/max.php”>MAX function</a>
View Answer
| February 14, 2012 2:58 PM
Microsoft Access 2003, Microsoft Access queries
You would have to use the <a href=”http://www.techonthenet.com/access/functions/numeric/max.php”>MAX function</a>
View Answer
| February 14, 2012 2:58 PM
Microsoft Access 2003, Microsoft Access queries
vb.net development environment
You can install and use the express version of Visual Studio, which can be found there: <a href=”http://www.microsoft.com/visualstudio/en-us/products/2010-editions/express”>Visual Studio 2010 Express Products</a> You can also use the express edition of SQL Server, which can be found in the above link as well. MySQL can also be downloaded and used for free. Here’s a link: <a [...]
View Answer
| February 7, 2012 3:08 PM
MySQL, Visual Basic 6, Visual Studio 2010
You can install and use the express version of Visual Studio, which can be found there: <a href=”http://www.microsoft.com/visualstudio/en-us/products/2010-editions/express”>Visual Studio 2010 Express Products</a> You can also use the express edition of SQL Server, which can be found in the above link as well. MySQL can also be downloaded and used for free. Here’s a link: <a [...]
View Answer
| February 7, 2012 3:08 PM
MySQL, Visual Basic 6, Visual Studio 2010
I just narrowly avoided getting scammed (corrupted files)
Wrongly posted text removed.
View Answer
| February 2, 2012 11:44 AM
Corrupted database, Remote access, Spyware, Viruses
Wrongly posted text removed.
View Answer
| February 2, 2012 11:44 AM
Corrupted database, Remote access, Spyware, Viruses
Biometrics
I wrote a paper and did a presentation about a year and a half ago on the same topic. Here are some of the better sites I found handy for gathering the information I needed. <a href=”http://www.biometrics.org/”>Biometrics.org</a> <a href=”http://www.biometrics.gov/”>Biometrics.gov</a> <a href=”http://www.biometricscatalog.org/default.aspx”>Biometrics Catalog</a> <a href=”http://www.answers.com/topic/identix-inc?cat=biz-fin”>Info on Identix – a Biometric Equipment company</a> <a href=”http://www.amag.com/documents/AMAG_Are_Biometrics_Ready_Article.pdf”>An older but [...]
View Answer
| February 1, 2012 9:16 PM
Biometrics, Business presentations, IT careers
I wrote a paper and did a presentation about a year and a half ago on the same topic. Here are some of the better sites I found handy for gathering the information I needed. <a href=”http://www.biometrics.org/”>Biometrics.org</a> <a href=”http://www.biometrics.gov/”>Biometrics.gov</a> <a href=”http://www.biometricscatalog.org/default.aspx”>Biometrics Catalog</a> <a href=”http://www.answers.com/topic/identix-inc?cat=biz-fin”>Info on Identix – a Biometric Equipment company</a> <a href=”http://www.amag.com/documents/AMAG_Are_Biometrics_Ready_Article.pdf”>An older but [...]
View Answer
| February 1, 2012 9:16 PM
Biometrics, Business presentations, IT careers
Public folder database maintenance?
This database should be getting the same maintenance as your other mail store data bases to remove white space. You can also do an offline defrag using eseutil to ensure it is in good condition. Check the properties of the database store to make sure it is on the nightly maintenance schedule. ================= If you [...]
View Answer
| February 1, 2012 8:50 AM
Database maintenance, Exchange, Exchange Public Folders, public folders database
This database should be getting the same maintenance as your other mail store data bases to remove white space. You can also do an offline defrag using eseutil to ensure it is in good condition. Check the properties of the database store to make sure it is on the nightly maintenance schedule. ================= If you [...]
View Answer
| February 1, 2012 8:50 AM
Database maintenance, Exchange, Exchange Public Folders, public folders database
how can we login into sybase using an encrypted password
Hi to and thanks to every one who r reading my problem My interface is not working and showing the error if i stop and start the soa server and managed servers. i am getting the below error …<a href=”http://www.steelpipechn.com/ERW-steel-pipe.html”>ERW pipe</a> | <a href=”http://www.steelpipechn.com/API-drill-pipe.html”>Drill pipe</a>| <a href=”http://www.steelpipechn.com/LSAW-steel-pipe.html”>LSAW pipe</a> | <a href=”http://www.steelpipechn.com/SSAW-steel-pipe.html”>SSAW pipe</a> | <a href=”http://www.steelpipechn.com/DSAW-steel-pipe.html”>DSAW [...]
View Answer
| January 31, 2012 9:29 AM
Sybase
Hi to and thanks to every one who r reading my problem My interface is not working and showing the error if i stop and start the soa server and managed servers. i am getting the below error …<a href=”http://www.steelpipechn.com/ERW-steel-pipe.html”>ERW pipe</a> | <a href=”http://www.steelpipechn.com/API-drill-pipe.html”>Drill pipe</a>| <a href=”http://www.steelpipechn.com/LSAW-steel-pipe.html”>LSAW pipe</a> | <a href=”http://www.steelpipechn.com/SSAW-steel-pipe.html”>SSAW pipe</a> | <a href=”http://www.steelpipechn.com/DSAW-steel-pipe.html”>DSAW [...]
View Answer
| January 31, 2012 9:29 AM
Sybase
MYSQL DATABASE!!!
The simplest approach would be to use the mysqldump command as follows to make a backup of the database – “mysqldump -u username -p databasename > backup.sql”, then transfer the backup.sql file to another machine with MySQL installed and use the following command to restore the database -”mysql -u username -p databasename backup.sql” where database [...]
View Answer
| January 28, 2012 12:42 PM
Mysql 5.1, MySQL Database, Windows 7 OS
The simplest approach would be to use the mysqldump command as follows to make a backup of the database – “mysqldump -u username -p databasename > backup.sql”, then transfer the backup.sql file to another machine with MySQL installed and use the following command to restore the database -”mysql -u username -p databasename backup.sql” where database [...]
View Answer
| January 28, 2012 12:42 PM
Mysql 5.1, MySQL Database, Windows 7 OS
Open IT Forum: What do you want to see from IT Knowledge Exchange in 2012?
Some hot topics I would like to know more about are Virtual Desktop technologies (VDI), SQL Server 2012, and Cloud Computing. It would also be nice to be able to search across all TechTarget Search*.com sites at once when researching a topic. -Tech Talker
View Answer
| January 28, 2012 2:26 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Some hot topics I would like to know more about are Virtual Desktop technologies (VDI), SQL Server 2012, and Cloud Computing. It would also be nice to be able to search across all TechTarget Search*.com sites at once when researching a topic. -Tech Talker
View Answer
| January 28, 2012 2:26 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Compressing Old Files
Hi there, I have been working with PC’s for a long time and I have been compressing files through disk cleanup with no problems at all. When I re-format a machine I also have no problems. I would recommend you do this on a regular basis to keep your machine operational and responsive. Compression does [...]
View Answer
| January 26, 2012 11:16 AM
Access, Adapters/Interfaces, Administration, Backup & recovery, Business/IT alignment, Career development, Certifications, CRM, Data analysis, Data management and storage, Data mining/analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, Disk drives, E-business, Ecommerce applications, Exchange, Exchange security, Fax and print management, File, Hardware, Hardware selection and management, Management, Microsoft Windows, Monitoring, Online transaction processing, Oracle, OS, Patch management, PC/Windows Connectivity, Performance and availability, Project management, Replication, Sales force automation applications, Security, Servers, Software, Spam, SQL Server, Storage, Storage management, Storage products and equipment, Storage servers, Systems management software, Tape drives/Libraries, Tech support, Training, Web development
Hi there, I have been working with PC’s for a long time and I have been compressing files through disk cleanup with no problems at all. When I re-format a machine I also have no problems. I would recommend you do this on a regular basis to keep your machine operational and responsive. Compression does [...]
View Answer
| January 26, 2012 11:16 AM
Access, Adapters/Interfaces, Administration, Backup & recovery, Business/IT alignment, Career development, Certifications, CRM, Data analysis, Data management and storage, Data mining/analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, Disk drives, E-business, Ecommerce applications, Exchange, Exchange security, Fax and print management, File, Hardware, Hardware selection and management, Management, Microsoft Windows, Monitoring, Online transaction processing, Oracle, OS, Patch management, PC/Windows Connectivity, Performance and availability, Project management, Replication, Sales force automation applications, Security, Servers, Software, Spam, SQL Server, Storage, Storage management, Storage products and equipment, Storage servers, Systems management software, Tape drives/Libraries, Tech support, Training, Web development
personal storage disabled?
Maybe you’d previously enable pst in exchange settings
View Answer
| January 24, 2012 1:16 PM
.pst, Exchange server software, Import
Maybe you’d previously enable pst in exchange settings
View Answer
| January 24, 2012 1:16 PM
.pst, Exchange server software, Import
oracle
You can use Oracle’s Change Management Pack, TOAD for Oracle from Quest Software, or Oracle Schema Compare from Red Gate Software to compare the structure and contents of two tables. You can use the “describe” command in SQL*Plus also to show the structure of a table and determine differences.
View Answer
| January 22, 2012 12:52 PM
Oracle Schema, Oracle Table, Toad Data Modeler
You can use Oracle’s Change Management Pack, TOAD for Oracle from Quest Software, or Oracle Schema Compare from Red Gate Software to compare the structure and contents of two tables. You can use the “describe” command in SQL*Plus also to show the structure of a table and determine differences.
View Answer
| January 22, 2012 12:52 PM
Oracle Schema, Oracle Table, Toad Data Modeler
How can do iSQl*Plus login for DBA
Oracle stopped supporting iSQL*Plus starting with Oracle11g. I would recommend switching to SQL Developer which can be downloaded for free from http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html. SQL Developer can do all of the same things iSQL*Plus can do, plus more. There are other third-party Oracle DBA/Developer tools available for purchase which I will not promote in this post, but [...]
View Answer
| January 17, 2012 7:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server
Oracle stopped supporting iSQL*Plus starting with Oracle11g. I would recommend switching to SQL Developer which can be downloaded for free from http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html. SQL Developer can do all of the same things iSQL*Plus can do, plus more. There are other third-party Oracle DBA/Developer tools available for purchase which I will not promote in this post, but [...]
View Answer
| January 17, 2012 7:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server
Letting users upload pictures MYSQL Database
I would recommend using the Drupal open source content management platform (www.drupal.org) as it integrtes seamlessly with MySQL and has easy to install, configure, and use image/photo upload functionality known as Modules.
View Answer
| January 17, 2012 1:08 AM
MySQL, MySQL Database, SQL
I would recommend using the Drupal open source content management platform (www.drupal.org) as it integrtes seamlessly with MySQL and has easy to install, configure, and use image/photo upload functionality known as Modules.
View Answer
| January 17, 2012 1:08 AM
MySQL, MySQL Database, SQL
Access 2007 DB Project
OK, so first be careful with a database like Access for applications like this. Access doesn’t exactly scale very well as the use of the application grows. 1. Your question doesn’t make a lot of sense. It looks like part of the question got eaten. Please repost that question into the comments. 2. Now, that [...]
View Answer
| January 15, 2012 5:04 AM
Access 2007, Database, SQL
OK, so first be careful with a database like Access for applications like this. Access doesn’t exactly scale very well as the use of the application grows. 1. Your question doesn’t make a lot of sense. It looks like part of the question got eaten. Please repost that question into the comments. 2. Now, that [...]
View Answer
| January 15, 2012 5:04 AM
Access 2007, Database, SQL
Exporting a (.csv) file from SQL 2005
welcome to: http://www.plzzshop.com The website wholesale for many kinds of fashion shoes, like the nike,jordan,prada,****, also including the jeans,shirts,bags,hat and the decorations. All the products are free shipping, and the the price is competitive, and also can accept the paypal payment.,after the payment, can ship within short time. free shipping competitive price any size available [...]
View Answer
| January 14, 2012 2:57 AM
CSV, SQL
welcome to: http://www.plzzshop.com The website wholesale for many kinds of fashion shoes, like the nike,jordan,prada,****, also including the jeans,shirts,bags,hat and the decorations. All the products are free shipping, and the the price is competitive, and also can accept the paypal payment.,after the payment, can ship within short time. free shipping competitive price any size available [...]
View Answer
| January 14, 2012 2:57 AM
CSV, SQL
Creating DB of stories from documents for a website
I would recommend the Open Source Drupal content management (www.drupal.org) platform to create a searchable fanfiction database/website as all content is stored and searchable in the database which can be MySQL, Oracle, or SQL Server.
View Answer
| January 13, 2012 7:16 AM
Access Database, Access Database Design, Database design, Database Development, Database issues, Web development, Web development tools
I would recommend the Open Source Drupal content management (www.drupal.org) platform to create a searchable fanfiction database/website as all content is stored and searchable in the database which can be MySQL, Oracle, or SQL Server.
View Answer
| January 13, 2012 7:16 AM
Access Database, Access Database Design, Database design, Database Development, Database issues, Web development, Web development tools
DB2 database on Iseries
The DSPOBJD command will give you the size of an object. You can output that to an OUTFILE and then total it up.
View Answer
| January 12, 2012 1:48 PM
Database, iSeries
The DSPOBJD command will give you the size of an object. You can output that to an OUTFILE and then total it up.
View Answer
| January 12, 2012 1:48 PM
Database, iSeries
Career Advise DW & BI background + MBA
The benefits of a Graduate degree such as a MBA or Masters in Information Systems come down to future marketability and equalization with many other potential job candidates who also hold Graduate degrees which is becoming more and more common. Nothing beats hands-on experience, but when combined with a Graduate degree and IT certifications, the [...]
View Answer
| January 12, 2012 1:59 AM
Data warehousing, ETL, IT careers, IT certification, IT certification and training
The benefits of a Graduate degree such as a MBA or Masters in Information Systems come down to future marketability and equalization with many other potential job candidates who also hold Graduate degrees which is becoming more and more common. Nothing beats hands-on experience, but when combined with a Graduate degree and IT certifications, the [...]
View Answer
| January 12, 2012 1:59 AM
Data warehousing, ETL, IT careers, IT certification, IT certification and training
getting ORA-01422: exact fetch returns more than requested number of rows. while setting up UK bank branch
As the error states, your query is returning more than one row, when a single row/value is expected, the options to resolve this error are: 1. Rewrite your SELECT INTO statement so that only one row is returned. 2. Replace your SELECT INTO statement with a cursor. Additional helpful information about this error with examples [...]
View Answer
| January 9, 2012 4:36 PM
Database, Oracle, Oracle installation
As the error states, your query is returning more than one row, when a single row/value is expected, the options to resolve this error are: 1. Rewrite your SELECT INTO statement so that only one row is returned. 2. Replace your SELECT INTO statement with a cursor. Additional helpful information about this error with examples [...]
View Answer
| January 9, 2012 4:36 PM
Database, Oracle, Oracle installation
