Query for a Mail Merge
Have you tried exporting the data to Excel and doing your mail merge that way? Just a thought, because it always worked for us that way.
View Answer
| January 7, 2012 9:46 PM
Mail merge, Microsoft Access, Microsoft Access queries, Microsoft Access query
Have you tried exporting the data to Excel and doing your mail merge that way? Just a thought, because it always worked for us that way.
View Answer
| January 7, 2012 9:46 PM
Mail merge, Microsoft Access, Microsoft Access queries, Microsoft Access query
Open IT Forum: What cloud concern do you need addressed?
OK I see two issues: 1. Larger organisations being able to allow internally-hosted and supported applications and webs. This does require in-house expertise or else contracted support and development from external organisations. However it may be preferable to host the data in-house (even if at a data centre) and retain maximum control. This needs to [...]
View Answer
| December 30, 2011 6:16 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, 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
OK I see two issues: 1. Larger organisations being able to allow internally-hosted and supported applications and webs. This does require in-house expertise or else contracted support and development from external organisations. However it may be preferable to host the data in-house (even if at a data centre) and retain maximum control. This needs to [...]
View Answer
| December 30, 2011 6:16 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, 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
What are your favorite cloud security blogs?
It’s not really a “blog” but it’all the rest ! Very good site with an system and application online vulnerabilities checking tool ! <a href=”http://secunia.com/vulnerability_scanning/online/?task=intro”></a> => http://secunia.com/vulnerability_scanning/online/?task=intro The best: https://blog.cloudsecurityalliance.org/
View Answer
| December 30, 2011 6:14 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Security bloggers, SQL Server, Storage, Virtualization, VoIP, Windows Server
It’s not really a “blog” but it’all the rest ! Very good site with an system and application online vulnerabilities checking tool ! <a href=”http://secunia.com/vulnerability_scanning/online/?task=intro”></a> => http://secunia.com/vulnerability_scanning/online/?task=intro The best: https://blog.cloudsecurityalliance.org/
View Answer
| December 30, 2011 6:14 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Security bloggers, SQL Server, Storage, Virtualization, VoIP, Windows Server
Missing Record
Your welcome Thanks for joining with us. Just rememebr to be as specific as possible with your questions
View Answer
| December 19, 2011 6:33 PM
Access, Microsoft Access, Microsoft Access record, record
Your welcome Thanks for joining with us. Just rememebr to be as specific as possible with your questions
View Answer
| December 19, 2011 6:33 PM
Access, Microsoft Access, Microsoft Access record, record
Cloud Computing Certification
CSA;s Cloud Security Knowledge, IBM’s Certification for cloud Architecture will serve the purpose.
View Answer
| December 16, 2011 3:52 PM
Cloud Computing, cloud computing services, IT careers, IT certification, IT certification and training, SaaS and cloud computing
CSA;s Cloud Security Knowledge, IBM’s Certification for cloud Architecture will serve the purpose.
View Answer
| December 16, 2011 3:52 PM
Cloud Computing, cloud computing services, IT careers, IT certification, IT certification and training, SaaS and cloud computing
Job sites
http://www.indeed.co.in http://www.computerjobs.com
View Answer
| December 16, 2011 5:23 AM
AS/400 careers, AS/400 jobs, IT careers, IT jobs
http://www.indeed.co.in http://www.computerjobs.com
View Answer
| December 16, 2011 5:23 AM
AS/400 careers, AS/400 jobs, IT careers, IT jobs
Access History question
I don’t think so. In a database we use, I built that in by adding a field and filling it with UserID whenever someone created a new record.
View Answer
| November 28, 2011 4:28 PM
Access, Microsoft Access
I don’t think so. In a database we use, I built that in by adding a field and filling it with UserID whenever someone created a new record.
View Answer
| November 28, 2011 4:28 PM
Access, Microsoft Access
AS400-DDL
<ul> For generating SQL source:</ul> If you have the iseries navigator, go to <machine> Databases <machine> Schemas <library> Tables. Right click on the required table and select ‘Generate SQL’. Do remember to click checkbox ‘include object short names’, in case the table has column/field names more than 10 chars long. <ul> For DDS source:</ul> On [...]
View Answer
| November 17, 2011 11:15 AM
Data Definition Language, DDL, DDL Create Table
<ul> For generating SQL source:</ul> If you have the iseries navigator, go to <machine> Databases <machine> Schemas <library> Tables. Right click on the required table and select ‘Generate SQL’. Do remember to click checkbox ‘include object short names’, in case the table has column/field names more than 10 chars long. <ul> For DDS source:</ul> On [...]
View Answer
| November 17, 2011 11:15 AM
Data Definition Language, DDL, DDL Create Table
Announcing the HP Elite Series Scavenger Hunt (sponsored)
what ever happened with this
View Answer
| November 17, 2011 5:21 AM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, EliteBook, Exchange, Giveaways, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Scavenger Hunt, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
what ever happened with this
View Answer
| November 17, 2011 5:21 AM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, EliteBook, Exchange, Giveaways, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Scavenger Hunt, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
AS400 – SQLRPGLE
There will be no specific function in SQL for recognizing display files. As you mentioned, we can decide the variable names dynamically. But, We cant be able to map these variables with DSPF Record format. Pradeep.
View Answer
| November 13, 2011 4:25 AM
AS/400 Display File, AS400 - Embedded SQL, Dynamic SQL, Embedded SQL, SQLRPGLE
There will be no specific function in SQL for recognizing display files. As you mentioned, we can decide the variable names dynamically. But, We cant be able to map these variables with DSPF Record format. Pradeep.
View Answer
| November 13, 2011 4:25 AM
AS/400 Display File, AS400 - Embedded SQL, Dynamic SQL, Embedded SQL, SQLRPGLE
Tempdb Size increases and acquires the complete disk space
Make sure that TempDB is set to autogrow and do not set a maximum size for TempDB. If the current drive is too full to allow autogrow events, then arrange a bigger drive, or add files to TempDB on another device (using ALTER DATABASE as described below and allow those files to autogrow. Move TempDB [...]
View Answer
| November 4, 2011 10:17 AM
Disk space, LDF file size, SIMPLE RECOVERY model, TempDB, Tempdb Size
Make sure that TempDB is set to autogrow and do not set a maximum size for TempDB. If the current drive is too full to allow autogrow events, then arrange a bigger drive, or add files to TempDB on another device (using ALTER DATABASE as described below and allow those files to autogrow. Move TempDB [...]
View Answer
| November 4, 2011 10:17 AM
Disk space, LDF file size, SIMPLE RECOVERY model, TempDB, Tempdb Size
Unknown Threats
Aside from honey pots, there are also honey nets (google on honey nets or on the name Lance Spitzner who is very much involved. He’s got some good books out on the subject. Microsoft (and maybe other groups as well) has what is called a “Honey Monkey” project. Similar in objective to a honey pot, [...]
View Answer
| November 2, 2011 8:40 AM
Application security, backdoors, configuration, Current threats, Database, Encryption, Exchange, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network security, Networking, patching, PEN testing, Platform Security, Secure Coding, Security, Software, Spyware, Tech support, Trojans, Viruses, VPN, vulnerability management, Wireless, worms
Aside from honey pots, there are also honey nets (google on honey nets or on the name Lance Spitzner who is very much involved. He’s got some good books out on the subject. Microsoft (and maybe other groups as well) has what is called a “Honey Monkey” project. Similar in objective to a honey pot, [...]
View Answer
| November 2, 2011 8:40 AM
Application security, backdoors, configuration, Current threats, Database, Encryption, Exchange, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network security, Networking, patching, PEN testing, Platform Security, Secure Coding, Security, Software, Spyware, Tech support, Trojans, Viruses, VPN, vulnerability management, Wireless, worms
Question on Database Development Options
1. Just about any web based programming will work. Options include but are not limited to PHP, ASP.NET, Classic ASP, Perl, Java. 2. Yes apps which are written in those languages can be hosted on Windows and Linux web servers. 3. Probably 4. Things like GnuCash would be integrated via the web app not via [...]
View Answer
| October 25, 2011 4:55 AM
Database, MySQL, SQL
1. Just about any web based programming will work. Options include but are not limited to PHP, ASP.NET, Classic ASP, Perl, Java. 2. Yes apps which are written in those languages can be hosted on Windows and Linux web servers. 3. Probably 4. Things like GnuCash would be integrated via the web app not via [...]
View Answer
| October 25, 2011 4:55 AM
Database, MySQL, SQL
Cloning C and G drives on Windows Server 2008
The C drive is easily cloned. You can use any number of tool. The HIRENS disc is a good source of tools for this type of application (although vet the source of the ISO as they aren’t all legit. You can double check the MD5). You wouldn’t need much prep to <a href=”http://www.partition-magic.org/res/clone-partition-to-disk.html”>clone partition</a>. The [...]
View Answer
| October 21, 2011 3:09 PM
C drive, Clone database, RAID 5, Windows Server 2008
The C drive is easily cloned. You can use any number of tool. The HIRENS disc is a good source of tools for this type of application (although vet the source of the ISO as they aren’t all legit. You can double check the MD5). You wouldn’t need much prep to <a href=”http://www.partition-magic.org/res/clone-partition-to-disk.html”>clone partition</a>. The [...]
View Answer
| October 21, 2011 3:09 PM
C drive, Clone database, RAID 5, Windows Server 2008
Loop is seen on router but line protocol is down
please checks as below step by step. 1. If Wire connection please set manual IP in your computer as same series. And then see what happen. 2. If wireless then please right button click on wireless icon then you will see Open Network and Sharing Center. Click here then you will see full map of [...]
View Answer
| October 19, 2011 2:18 PM
Data link protocols, LOOP statement, Routers
please checks as below step by step. 1. If Wire connection please set manual IP in your computer as same series. And then see what happen. 2. If wireless then please right button click on wireless icon then you will see Open Network and Sharing Center. Click here then you will see full map of [...]
View Answer
| October 19, 2011 2:18 PM
Data link protocols, LOOP statement, Routers
Free IT Book: Demystifying the Virtual Desktop
http://itknowledgeexchange.techtarget.com/itanswers/extend-hdd/#viewquestion http://itknowledgeexchange.techtarget.com/itanswers/extend-hdd/ hope to win
View Answer
| October 18, 2011 4:36 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
http://itknowledgeexchange.techtarget.com/itanswers/extend-hdd/#viewquestion http://itknowledgeexchange.techtarget.com/itanswers/extend-hdd/ hope to win
View Answer
| October 18, 2011 4:36 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
EXTENDED: IT Scripts Contest now ends October 17
IT Scripts. If i win, i promise, i’ll start scripting (even in 3D), because now, i’m too busy in coding real stuff ! lol )
View Answer
| October 13, 2011 2:46 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
IT Scripts. If i win, i promise, i’ll start scripting (even in 3D), because now, i’m too busy in coding real stuff ! lol )
View Answer
| October 13, 2011 2:46 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
conversion of oracle trigger to MS SQL
There are some conversion tools you could use (paid and free), but you will have to review the resultant code to make sure everything is Ok. Here are a couple of links you might find useful: <a href=”http://search.swissql.com/oratosql/”>Oracle to SQL Server Stored Procedure Migration</a> (<b>supposedly </b>free online migration) <a href=”http://www.microsoft.com/sqlserver/en/us/product-info/migration.aspx”>Free Microsoft SQL Server Database Migration [...]
View Answer
| October 12, 2011 2:50 PM
MSSQL, Oracle triggers, SQL connectivity, SQL Server
There are some conversion tools you could use (paid and free), but you will have to review the resultant code to make sure everything is Ok. Here are a couple of links you might find useful: <a href=”http://search.swissql.com/oratosql/”>Oracle to SQL Server Stored Procedure Migration</a> (<b>supposedly </b>free online migration) <a href=”http://www.microsoft.com/sqlserver/en/us/product-info/migration.aspx”>Free Microsoft SQL Server Database Migration [...]
View Answer
| October 12, 2011 2:50 PM
MSSQL, Oracle triggers, SQL connectivity, SQL Server
Corrupted database file with Memo Field in FoxPro 2.6
Determining given trouble can be <a href=”http://www.recoverytoolbox.com/dbf.html”>repair .dbf</a>. It has easy to use interface for any experienced users, tool can’t change source data during restoration. Program starts under low system requirements and any major version of Windows OS.
View Answer
| October 10, 2011 8:40 PM
Corrupted database, FoxPro, FoxPro 2.6, FoxPro errors
Determining given trouble can be <a href=”http://www.recoverytoolbox.com/dbf.html”>repair .dbf</a>. It has easy to use interface for any experienced users, tool can’t change source data during restoration. Program starts under low system requirements and any major version of Windows OS.
View Answer
| October 10, 2011 8:40 PM
Corrupted database, FoxPro, FoxPro 2.6, FoxPro errors
For Do rename loop
<pre>@echo off REM Other stuff here REM Move all the renames into one called section and reduce to single for statement REM Reduce to just the tokens required for grabbing the date for /f “tokens=2-4 delims=/ ” %%a in (“%date%”) do CALL :RenScript %%a %%b %%c REM More stuff here goto ONE :RenScript ren “A [...]
View Answer
| October 10, 2011 8:16 PM
Batch file, Batch files, Command line, LOOP statement
<pre>@echo off REM Other stuff here REM Move all the renames into one called section and reduce to single for statement REM Reduce to just the tokens required for grabbing the date for /f “tokens=2-4 delims=/ ” %%a in (“%date%”) do CALL :RenScript %%a %%b %%c REM More stuff here goto ONE :RenScript ren “A [...]
View Answer
| October 10, 2011 8:16 PM
Batch file, Batch files, Command line, LOOP statement
