How do I keep the original value of a field in Access 2010?
You would need to alter your products table structure to add an additional field (column) which you can store the original price in. And your form would need to be modified to assign the original value when inserting new records. Feel free to add more details or ask for clarification or further help if needed.
View Answer
| November 25, 2010 2:53 PM
Access 2010, Access Database, Access forms, Access Forms Database, office 2010
You would need to alter your products table structure to add an additional field (column) which you can store the original price in. And your form would need to be modified to assign the original value when inserting new records. Feel free to add more details or ask for clarification or further help if needed.
View Answer
| November 25, 2010 2:53 PM
Access 2010, Access Database, Access forms, Access Forms Database, office 2010
Backing up a Joomla website without plugin
You would need to know what ur web site consist of and thus what should be backed up/restored. Usually sites are composed of files and databases. U must take care of them all if u want to have ur site exactly the way it has been before. There are two parts to a complete back [...]
View Answer
| November 23, 2010 4:58 AM
Backup and Recovery database, Backup and restore, Database Recovery, Disaster Recovery, Disaster Recovery Database, Joomla
You would need to know what ur web site consist of and thus what should be backed up/restored. Usually sites are composed of files and databases. U must take care of them all if u want to have ur site exactly the way it has been before. There are two parts to a complete back [...]
View Answer
| November 23, 2010 4:58 AM
Backup and Recovery database, Backup and restore, Database Recovery, Disaster Recovery, Disaster Recovery Database, Joomla
Get the latest unique entries for user ID in Access database
An SQL query like this should work (but there are more ways to do it): <pre>SELECT y.* FROM your_table y INNER JOIN (SELECT uid,MAX(id) AS max_id FROM your_table GROUP BY uid) t ON y.id = t.max_id and y.uid = t.uid</pre>
View Answer
| November 22, 2010 4:51 PM
Access, Access Database, Access Database Format, Access Tables
An SQL query like this should work (but there are more ways to do it): <pre>SELECT y.* FROM your_table y INNER JOIN (SELECT uid,MAX(id) AS max_id FROM your_table GROUP BY uid) t ON y.id = t.max_id and y.uid = t.uid</pre>
View Answer
| November 22, 2010 4:51 PM
Access, Access Database, Access Database Format, Access Tables
Hotel database in Access 2007
See, this is very long to answer. I am providing a full details with a good link : http://office.microsoft.com/en-us/access-help/create-a-new-database-HA010037837.aspx
View Answer
| November 22, 2010 1:11 PM
Access, Access 2007, Access 2007 form creation, Access Database, Access Database Design
See, this is very long to answer. I am providing a full details with a good link : http://office.microsoft.com/en-us/access-help/create-a-new-database-HA010037837.aspx
View Answer
| November 22, 2010 1:11 PM
Access, Access 2007, Access 2007 form creation, Access Database, Access Database Design
Sending Email in Excel using Macro
U can assign this code to a command button or extricate the portion(s) you want and place there . Modify body text and password as and other info as per ur requirement: this is a sample code …. Sub Email() Dim testPassword As String testPassword = InputBox(prompt:=”Please enter the password:”, _ If testPassword <> “Password” [...]
View Answer
| November 22, 2010 9:18 AM
Access 2000, excel, Excel macros, Outlook, VBA Access 2000
U can assign this code to a command button or extricate the portion(s) you want and place there . Modify body text and password as and other info as per ur requirement: this is a sample code …. Sub Email() Dim testPassword As String testPassword = InputBox(prompt:=”Please enter the password:”, _ If testPassword <> “Password” [...]
View Answer
| November 22, 2010 9:18 AM
Access 2000, excel, Excel macros, Outlook, VBA Access 2000
I completed my MCA in pune University 2010
Of course u may proceed. If u r interested, u may join for CISCO course, this is the best course for networking.<a href=”http://www.phpkolkata.com”>
View Answer
| November 20, 2010 9:03 AM
IT career development, IT career planning, IT careers, MCA, Networking careers
Of course u may proceed. If u r interested, u may join for CISCO course, this is the best course for networking.<a href=”http://www.phpkolkata.com”>
View Answer
| November 20, 2010 9:03 AM
IT career development, IT career planning, IT careers, MCA, Networking careers
ACCESS 2007 setting up repetitive entry form
A form with a subform is probably what you need. Take a look at this: <a href=”http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-a-one-to-many-form-HA010098674.aspx”>Create a form that contains a subform (a one-to-many form)</a>
View Answer
| November 19, 2010 10:53 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions, Access forms, Forms Creation, Windows XP
A form with a subform is probably what you need. Take a look at this: <a href=”http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-a-one-to-many-form-HA010098674.aspx”>Create a form that contains a subform (a one-to-many form)</a>
View Answer
| November 19, 2010 10:53 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions, Access forms, Forms Creation, Windows XP
IT career that will use both my software engineering & electronics degrees
Of course, u go for software development. There r so many options in SW development field. U can join as JAVA developer or .net framework. For Java u have to persue for global certification from Sun or Microsoft Certifications. But it is better if u do similar kind of job also. It takes u high [...]
View Answer
| November 19, 2010 1:00 PM
IT career development, IT career planning, IT careers, Software engineering, Software Engineers
Of course, u go for software development. There r so many options in SW development field. U can join as JAVA developer or .net framework. For Java u have to persue for global certification from Sun or Microsoft Certifications. But it is better if u do similar kind of job also. It takes u high [...]
View Answer
| November 19, 2010 1:00 PM
IT career development, IT career planning, IT careers, Software engineering, Software Engineers
Cloud computing and SAN career suggestions
Dear Ravi, It depends on ur grasping power and ur capacity. If u going for SAN it is better to do SAN Training EMC Storage Area Network Training certification. Cloud computing is also a very good start about ur career. Now u have to decide what ? SAN or Cloud. my opinion is SAN Good [...]
View Answer
| November 19, 2010 5:02 AM
BPO, Cloud Computing, IT career development, IT career planning, IT careers, SAN, Storage careers
Dear Ravi, It depends on ur grasping power and ur capacity. If u going for SAN it is better to do SAN Training EMC Storage Area Network Training certification. Cloud computing is also a very good start about ur career. Now u have to decide what ? SAN or Cloud. my opinion is SAN Good [...]
View Answer
| November 19, 2010 5:02 AM
BPO, Cloud Computing, IT career development, IT career planning, IT careers, SAN, Storage careers
Tomorrow at 4PM ET: ITKE Rolls Out New Badge System
cool.. all the best with the rolling out changes
View Answer
| November 19, 2010 4:22 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developement, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server 2003
cool.. all the best with the rolling out changes
View Answer
| November 19, 2010 4:22 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developement, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server 2003
Copy BLOB to BLOB using TSQL
You could use an UPDATE statement (almost) as you would with other type of columns, but this could not be recommended depending on the amount of data being moved. —————
View Answer
| November 18, 2010 4:01 PM
BLOB, BLOB TSQL, SQL Server 2008, SQL Server 2008 R2
You could use an UPDATE statement (almost) as you would with other type of columns, but this could not be recommended depending on the amount of data being moved. —————
View Answer
| November 18, 2010 4:01 PM
BLOB, BLOB TSQL, SQL Server 2008, SQL Server 2008 R2
Can an Access 2003 query exclude the results from a previous query?
I’m not familiar with the Access’ query design view or the query wizards, but you could create a query in SQL view with a code similar to this: <pre>SELECT * FROM donor d WHERE NOT EXISTS ( SELECT 1 FROM donations WHERE id = d.id AND year = 2010 AND amount > 0)</pre> Let us [...]
View Answer
| November 17, 2010 8:36 PM
Access 2003, Access Database, Access query, Query Parameters
I’m not familiar with the Access’ query design view or the query wizards, but you could create a query in SQL view with a code similar to this: <pre>SELECT * FROM donor d WHERE NOT EXISTS ( SELECT 1 FROM donations WHERE id = d.id AND year = 2010 AND amount > 0)</pre> Let us [...]
View Answer
| November 17, 2010 8:36 PM
Access 2003, Access Database, Access query, Query Parameters
Career possibilities after IT help desk
It is completely depends on the IBM company. If u have handsome expertise on the same field, u may consider for coding. See BPO / Voice process associates doesn’t have chance for coding, cause this BPO job only for Customer care rather say for meet various customer queries. So there is no hope for coding [...]
View Answer
| November 17, 2010 12:20 PM
.NET, .NET development, Help Desk, IT careers, IT Help Desk, IT professional
It is completely depends on the IBM company. If u have handsome expertise on the same field, u may consider for coding. See BPO / Voice process associates doesn’t have chance for coding, cause this BPO job only for Customer care rather say for meet various customer queries. So there is no hope for coding [...]
View Answer
| November 17, 2010 12:20 PM
.NET, .NET development, Help Desk, IT careers, IT Help Desk, IT professional
Find Due Date From X months in Access 2007
You could use the <a href=”http://www.techonthenet.com/access/functions/date/dateadd.php”>DateAdd Function </a> <pre>= DateAdd(“m”,[recurrence],[Date completed])</pre> If you want to update it with a SQL statement, it should be something like this: <pre>UPDATE your_table SET [due date] = DateAdd(“m”,[recurrence],[Date completed]) WHERE <conditions></pre>
View Answer
| November 16, 2010 5:59 PM
Access 2007, Access Database, Access Database Design, Access Database Format
You could use the <a href=”http://www.techonthenet.com/access/functions/date/dateadd.php”>DateAdd Function </a> <pre>= DateAdd(“m”,[recurrence],[Date completed])</pre> If you want to update it with a SQL statement, it should be something like this: <pre>UPDATE your_table SET [due date] = DateAdd(“m”,[recurrence],[Date completed]) WHERE <conditions></pre>
View Answer
| November 16, 2010 5:59 PM
Access 2007, Access Database, Access Database Design, Access Database Format
Delete all tables in SQL Server database?
Sql Server has an option of navigating to all tables using stored procedure sp_MSforeachtable For e.g the following command will drop all the tables in the database: exec sp_MSforeachtable 'DROP TABLE ?' The below command will clear all the tables: exec sp_MSforeachtable 'DELETE FROM ?' So by using the procedure sp_MSforeachtable you can navigate to [...]
View Answer
| April 19, 2013 4:15 AM
DELETE statement, SQL Database, SQL Server, SQL Server database, SQL tables
Sql Server has an option of navigating to all tables using stored procedure sp_MSforeachtable For e.g the following command will drop all the tables in the database: exec sp_MSforeachtable 'DROP TABLE ?' The below command will clear all the tables: exec sp_MSforeachtable 'DELETE FROM ?' So by using the procedure sp_MSforeachtable you can navigate to [...]
View Answer
| April 19, 2013 4:15 AM
DELETE statement, SQL Database, SQL Server, SQL Server database, SQL tables
Free IT Book: Next-Generation Data Center Architectures from Cisco
Hello, Just answared the question <a href=”http://itknowledgeexchange.techtarget.com/itanswers/cisco-config-nat-and-dhcp/#viewquestion”>here</a> about Cisco router 2821 configuration NAT and DHCP. HTH. Regards, Luis
View Answer
| November 15, 2010 10:32 PM
Cisco Routers, Giveaways, IT Books, ITKE, ITKE Contests, Linux firewalls, MySQL Database, SonicWALL, Symantec Backup Exec 12
Hello, Just answared the question <a href=”http://itknowledgeexchange.techtarget.com/itanswers/cisco-config-nat-and-dhcp/#viewquestion”>here</a> about Cisco router 2821 configuration NAT and DHCP. HTH. Regards, Luis
View Answer
| November 15, 2010 10:32 PM
Cisco Routers, Giveaways, IT Books, ITKE, ITKE Contests, Linux firewalls, MySQL Database, SonicWALL, Symantec Backup Exec 12
Question on achieving ultimate network security
If the Softtalk shared server is accesible from the internet, that would be one point that needs to be properly secured. How do external users access it ? How is it connected to the internet ? how does it connect to your sugarcrm server ? One general security measure is to have all operating systems [...]
View Answer
| November 15, 2010 6:59 PM
Firewalls, IDPS, IDS, Linux applications, MySQL Database, Network security
If the Softtalk shared server is accesible from the internet, that would be one point that needs to be properly secured. How do external users access it ? How is it connected to the internet ? how does it connect to your sugarcrm server ? One general security measure is to have all operating systems [...]
View Answer
| November 15, 2010 6:59 PM
Firewalls, IDPS, IDS, Linux applications, MySQL Database, Network security
How to add an article in transactional replication in sql server 2005?
The easiest way to add an article would be to edit the publication within the SSMS and add the article there. This will cause the subscribers to become invalid and will require that you push a new snapshot from the publisher to the subscribers so that the new table is added. The only requirement to [...]
View Answer
| November 15, 2010 12:45 PM
DBA, SQL, SQL Server, SQL Server 2005, Transactional replication software
The easiest way to add an article would be to edit the publication within the SSMS and add the article there. This will cause the subscribers to become invalid and will require that you push a new snapshot from the publisher to the subscribers so that the new table is added. The only requirement to [...]
View Answer
| November 15, 2010 12:45 PM
DBA, SQL, SQL Server, SQL Server 2005, Transactional replication software
Embedded SQL number of days between dates
Carlos, Thanks. This is what I ended up doing and it gives me correct data. I think why I was getting a negative number is that the dates were flip/flopped. A college suggested ABS() around the statement but this is what I did. I hope it posts formated so it can be read. C/EXEC SQL [...]
View Answer
| November 11, 2010 7:52 PM
AS/400, Embedded SQL, SQL, SQLRPGLE
Carlos, Thanks. This is what I ended up doing and it gives me correct data. I think why I was getting a negative number is that the dates were flip/flopped. A college suggested ABS() around the statement but this is what I did. I hope it posts formated so it can be read. C/EXEC SQL [...]
View Answer
| November 11, 2010 7:52 PM
AS/400, Embedded SQL, SQL, SQLRPGLE
How to secure MySql server?
I think the best is to start by hardening your windows server 1st..then you will need to patch your servers patches…i am not sure how you will secure your mysql..if there is an hardening guide, use it and harden mysql too
View Answer
| November 11, 2010 1:34 PM
MySQL, MySQL functions, Security management, SQL Server, Web hosting
I think the best is to start by hardening your windows server 1st..then you will need to patch your servers patches…i am not sure how you will secure your mysql..if there is an hardening guide, use it and harden mysql too
View Answer
| November 11, 2010 1:34 PM
MySQL, MySQL functions, Security management, SQL Server, Web hosting
