VBA to separate overlapping times
I am stuck trying to seperate overlapping times. The situation is that I have 5 devices requiring x amount of material at the differing durations. What I need to do is seperate the durations and add the demands together for the new duration, but there can be as many as 5 overlapping demands; here is [...]
Answer Question
| December 1, 2010 5:46 PM
Excel 2007, Timestamp, VB codes, VBA
I am stuck trying to seperate overlapping times. The situation is that I have 5 devices requiring x amount of material at the differing durations. What I need to do is seperate the durations and add the demands together for the new duration, but there can be as many as 5 overlapping demands; here is [...]
Answer Question
| December 1, 2010 5:46 PM
Excel 2007, Timestamp, VB codes, VBA
Auditing User Access in AS/400
I am trying to figure out how to audit user access at the record level. In the Audit Journal the entry types ZC and ZR tell me at the file level who has opened a file for Change or Read. In the Journal, the Journal code of R along with the type code will give [...]
Answer Question
| December 1, 2010 4:44 PM
AS/400 administration, AS/400 audit, Auditing, Journaling (AS/400)
I am trying to figure out how to audit user access at the record level. In the Audit Journal the entry types ZC and ZR tell me at the file level who has opened a file for Change or Read. In the Journal, the Journal code of R along with the type code will give [...]
Answer Question
| December 1, 2010 4:44 PM
AS/400 administration, AS/400 audit, Auditing, Journaling (AS/400)
Roaming Windows Profile Issues
I support an application that gives users several preferences to choose from. These are written to the Windows registry in the CurrentUser directory. Is there a way to implement or save these settings for a roaming user profile in Windows? Normally I would just export and import the registry for these settings between users. But [...]
Answer Question
| November 30, 2010 4:42 PM
Roaming Profiles, User profiles, Windows Registry, Windows Server User Profiles
I support an application that gives users several preferences to choose from. These are written to the Windows registry in the CurrentUser directory. Is there a way to implement or save these settings for a roaming user profile in Windows? Normally I would just export and import the registry for these settings between users. But [...]
Answer Question
| November 30, 2010 4:42 PM
Roaming Profiles, User profiles, Windows Registry, Windows Server User Profiles
Date Range in Excel Macro
Hi, I just want to know if its possible to do a macro wherein I can select the dates to be read in my report. For instance, I have a Table (below) where column A is the Date, column B is the name of Agents, Column C is the Section and the Column D is [...]
Answer Question
| December 2, 2010 4:18 PM
Agents, excel, Excel macros, Macros
Hi, I just want to know if its possible to do a macro wherein I can select the dates to be read in my report. For instance, I have a Table (below) where column A is the Date, column B is the name of Agents, Column C is the Section and the Column D is [...]
Answer Question
| December 2, 2010 4:18 PM
Agents, excel, Excel macros, Macros
Windows 7 network to Windows Server 2003
How do I network windows7 to a windows server 2003 sp2? Can it be done?
Answer Question
| November 30, 2010 3:44 PM
Network Server, Windows 7, Windows 7 Networking, Windows Server 2003, Windows Server 2003 SP2
How do I network windows7 to a windows server 2003 sp2? Can it be done?
Answer Question
| November 30, 2010 3:44 PM
Network Server, Windows 7, Windows 7 Networking, Windows Server 2003, Windows Server 2003 SP2
RPG Free Array Processing
I am loading a DS from a database file into an array nine length with three elements, i.e. 100101102. I want to increment the array to load each element one at a time and save it to a standalone variable ( 3 bytes long). In another forum, someone said the receiver must be a %subarr [...]
Answer Question
| December 7, 2010 3:28 PM
iSeries, RPG arrays, RPG ILE, V5R4
I am loading a DS from a database file into an array nine length with three elements, i.e. 100101102. I want to increment the array to load each element one at a time and save it to a standalone variable ( 3 bytes long). In another forum, someone said the receiver must be a %subarr [...]
Answer Question
| December 7, 2010 3:28 PM
iSeries, RPG arrays, RPG ILE, V5R4
Installing HP c7280 photosmart without disk
I lost the installation disk, so what other way can I install this printer (hp photosmart C7280 series)?
Answer Question
| December 16, 2010 3:03 PM
HP Printer, HP Printer Drivers, HP printers, Printer installation disk
I lost the installation disk, so what other way can I install this printer (hp photosmart C7280 series)?
Answer Question
| December 16, 2010 3:03 PM
HP Printer, HP Printer Drivers, HP printers, Printer installation disk
Cisco 4506 switch object group
Dear All, Any one tell me is it poosible to object group based ACl in Cisco 4506 and 3750 switches. Also please specify the IOS version that supports Object group in ACL.
Answer Question
| November 30, 2010 9:22 AM
Cisco, Cisco 3750, Cisco 4506, Cisco switches
Dear All, Any one tell me is it poosible to object group based ACl in Cisco 4506 and 3750 switches. Also please specify the IOS version that supports Object group in ACL.
Answer Question
| November 30, 2010 9:22 AM
Cisco, Cisco 3750, Cisco 4506, Cisco switches
Basic salary for information security careers
I am plannig to lerarn MCITP, RHCE, CCNA. What will be the basic salary for the fresher in this field.
Answer Question
| December 1, 2010 8:04 AM
CCNA, CCNA Certification, Information security careers, MCITP, RHCE
I am plannig to lerarn MCITP, RHCE, CCNA. What will be the basic salary for the fresher in this field.
Answer Question
| December 1, 2010 8:04 AM
CCNA, CCNA Certification, Information security careers, MCITP, RHCE
Message Recall not working as expected in Lotus Notes 8.5.1
We are able to recall messages the problem is I have message recall set to only allow recall up to one day yet my users can recall messages pass the one day limit. What else can I check?
Answer Question
| May 4, 2012 12:25 AM
Lotus Notes 8.5.1, Lotus Notes administration, Lotus Notes messages, Lotus Notes Rules
We are able to recall messages the problem is I have message recall set to only allow recall up to one day yet my users can recall messages pass the one day limit. What else can I check?
Answer Question
| May 4, 2012 12:25 AM
Lotus Notes 8.5.1, Lotus Notes administration, Lotus Notes messages, Lotus Notes Rules
Running SQL PLUS on a server
Can I use mapped drives and environment variables to run SQLPLUS from a local machine(without any Oracle products) to a server. The mapped server has the Oracle products? Example: W - map to my Oracle server C drive EV = w:oracleora92binsqlplusw cmd : start %EV% I’m trying to host out of Oracle Forms 6i to run a [...]
Answer Question
| December 1, 2010 8:02 PM
Oracle, SQL Plus, SQL Server, SQLPlus
Can I use mapped drives and environment variables to run SQLPLUS from a local machine(without any Oracle products) to a server. The mapped server has the Oracle products? Example: W - map to my Oracle server C drive EV = w:oracleora92binsqlplusw cmd : start %EV% I’m trying to host out of Oracle Forms 6i to run a [...]
Answer Question
| December 1, 2010 8:02 PM
Oracle, SQL Plus, SQL Server, SQLPlus
Recovering SATA hard disk and data after faulty connection
I accidentally connected my PC cabinet fan power plug into my SATA hard disk power, causing the HD power connector to spark. After that, my PC isn’t recognizing the HDD and there’s no power reaching it. How can I recover my data? Is it fried?
Answer Question
| November 2, 2011 6:40 PM
Backup and recovery software, Data Center in 2010, Data Center management, Data Recovery, Hard disk performance, hard disk storage, HDD, HDD failed, SATA hard disk, SATA Hard Drive
I accidentally connected my PC cabinet fan power plug into my SATA hard disk power, causing the HD power connector to spark. After that, my PC isn’t recognizing the HDD and there’s no power reaching it. How can I recover my data? Is it fried?
Answer Question
| November 2, 2011 6:40 PM
Backup and recovery software, Data Center in 2010, Data Center management, Data Recovery, Hard disk performance, hard disk storage, HDD, HDD failed, SATA hard disk, SATA Hard Drive
Blocking personal webmail from Windows Active Directory 2008 network
Is there any way to block all personal webmail from our Windows Server 2008 Active Directory network? All communications need to be logged.
Answer Question
| November 29, 2010 6:24 PM
Active Directory security, Webmail, Windows Server 2008, Windows Server 2008 Active Directory, Windows Server 2008 Administration, Windows Server Security
Is there any way to block all personal webmail from our Windows Server 2008 Active Directory network? All communications need to be logged.
Answer Question
| November 29, 2010 6:24 PM
Active Directory security, Webmail, Windows Server 2008, Windows Server 2008 Active Directory, Windows Server 2008 Administration, Windows Server Security
Blocking Skype and bandwidth hogging applications
Can we block all skype and similar bandwith sucking applications from our network?
Answer Question
| November 30, 2010 6:22 PM
Bandwidth, Bandwidth management, Bandwidth monitoring, Skype, Windows Network Administration, Windows networking, Windows Server 2003
Can we block all skype and similar bandwith sucking applications from our network?
Answer Question
| November 30, 2010 6:22 PM
Bandwidth, Bandwidth management, Bandwidth monitoring, Skype, Windows Network Administration, Windows networking, Windows Server 2003
Setting up a message once users login to their Active Directory workstations
We want to display a message after users successfully log in to Active Directory and their workstations. Can this be done? where can we set this logon text?
Answer Question
| November 29, 2010 6:19 PM
Active Directory, Active Directory User Profiles, Active Directory Users, Active Directory Users and Computers, Login screen
We want to display a message after users successfully log in to Active Directory and their workstations. Can this be done? where can we set this logon text?
Answer Question
| November 29, 2010 6:19 PM
Active Directory, Active Directory User Profiles, Active Directory Users, Active Directory Users and Computers, Login screen
Open IT Forum: What are some of the inexpensive or high-impact green tactics for a data center today?
With power costs increasing significantly, more hardware per rack creating more heat and using more power and cooling solutions, it seems that power rather than space seems to be the limiter amongst data centers. What are your suggestions for reducing power consumption? What are you doing to make your data center more green? We’ll give [...]
Answer Question
| June 16, 2011 5:51 PM
Data Center administration, Data center design, Data Center in 2010, Data Center management, Green data center, Green IT, Open IT Forum
With power costs increasing significantly, more hardware per rack creating more heat and using more power and cooling solutions, it seems that power rather than space seems to be the limiter amongst data centers. What are your suggestions for reducing power consumption? What are you doing to make your data center more green? We’ll give [...]
Answer Question
| June 16, 2011 5:51 PM
Data Center administration, Data center design, Data Center in 2010, Data Center management, Green data center, Green IT, Open IT Forum
CRM opportunity entity will not open “New Opportunity Product”
I am currently experiencing an issue within my Microsoft Dynamics CRM 4.0 Opportunity entity. When I try to input a new opportunity product. I select the button on the form “New Opportunity Product,” but instead of opening this, it does nothing at all. What could cause this to happen? And how would I go about [...]
Answer Question
| November 29, 2010 5:39 PM
CRM, Dynamics CRM, Microsoft Dynamics CRM 4.0
I am currently experiencing an issue within my Microsoft Dynamics CRM 4.0 Opportunity entity. When I try to input a new opportunity product. I select the button on the form “New Opportunity Product,” but instead of opening this, it does nothing at all. What could cause this to happen? And how would I go about [...]
Answer Question
| November 29, 2010 5:39 PM
CRM, Dynamics CRM, Microsoft Dynamics CRM 4.0
If product is selected on account can CRM automatically input account into marketing list?
I would like to know if there was a way that when a certain product is selected on a CRM account if it could automatically input that account into a marketing list? What steps would I need to take in order to implement this process? I appreciate all the help.
Answer Question
| November 29, 2010 4:42 PM
CRM, CRM management, Dynamics CRM, Microsoft Dynamics CRM 4.0
I would like to know if there was a way that when a certain product is selected on a CRM account if it could automatically input that account into a marketing list? What steps would I need to take in order to implement this process? I appreciate all the help.
Answer Question
| November 29, 2010 4:42 PM
CRM, CRM management, Dynamics CRM, Microsoft Dynamics CRM 4.0
Best way to input Products into CRM
I would like to know what the best way to input products into CRM? I don’t much like how it is laid out in CRM now. I would like it to look more like a tree. Such as listed below. Manufacturer: Akzo Brand: Sikkens Primer Brand: U-Tech Primer Part Numbers: 399199 2K100 Grey 399200 [...]
Answer Question
| November 29, 2010 4:14 PM
CRM, CRM applications, CRM management, Dynamics CRM, Microsoft Dynamics CRM 4.0
I would like to know what the best way to input products into CRM? I don’t much like how it is laid out in CRM now. I would like it to look more like a tree. Such as listed below. Manufacturer: Akzo Brand: Sikkens Primer Brand: U-Tech Primer Part Numbers: 399199 2K100 Grey 399200 [...]
Answer Question
| November 29, 2010 4:14 PM
CRM, CRM applications, CRM management, Dynamics CRM, Microsoft Dynamics CRM 4.0
Free IT Book: Enterprise Web 2.0 Fundamentals
For an introduction to next-generation web technologies, Enterprise Web 2.0 Fundamentals is a great place to start. Learn how to leverage cloud computing and user-generated content along with business and technical best practices. To win this, simply answer one of the questions listed below and provide a link to your answer in the discussion area [...]
Answer Question
| December 6, 2010 4:13 PM
Giveaways, HTTP, IT answers, IT Books, ITKE Contests, Radius Server, SAN, Sybase, Windows Server 2003, Windows Server 2008, Wireless router
For an introduction to next-generation web technologies, Enterprise Web 2.0 Fundamentals is a great place to start. Learn how to leverage cloud computing and user-generated content along with business and technical best practices. To win this, simply answer one of the questions listed below and provide a link to your answer in the discussion area [...]
Answer Question
| December 6, 2010 4:13 PM
Giveaways, HTTP, IT answers, IT Books, ITKE Contests, Radius Server, SAN, Sybase, Windows Server 2003, Windows Server 2008, Wireless router
