Excel to AS/400 VBA – SETTEXT not working
Hello, I am using Excel VBA to try to process a simply gettext/settext function. I am able to return a value using gettext, but nothing happens using settext…no error..nothing. I’ve pasted the code below. Any help is appreciated. Sub AS400_Test2() [PCOMM SCRIPT HEADER] Language = VBSCRIPT [PCOMM SCRIPT SOURCE] ‘ Initiate access to system Dim [...]
Answer Question
| April 30, 2013 11:13 AM
AS/400, iSeries AS/400
Hello, I am using Excel VBA to try to process a simply gettext/settext function. I am able to return a value using gettext, but nothing happens using settext…no error..nothing. I’ve pasted the code below. Any help is appreciated. Sub AS400_Test2() [PCOMM SCRIPT HEADER] Language = VBSCRIPT [PCOMM SCRIPT SOURCE] ‘ Initiate access to system Dim [...]
Answer Question
| April 30, 2013 11:13 AM
AS/400, iSeries AS/400
Need career guidance
Hello, I am working as a pre-sales network consultant. My job is 50 percent technical and 50 percent pricing. I am CCNA and CCNP certified and I need a change in job and career as there is no growth here. I am looking forward to security. Also will Unix/Linux/Perl knowledge give me better prospects in [...]
Answer Question
| April 30, 2013 9:16 AM
CCNA, CCNP, Cisco, Networking careers
Hello, I am working as a pre-sales network consultant. My job is 50 percent technical and 50 percent pricing. I am CCNA and CCNP certified and I need a change in job and career as there is no growth here. I am looking forward to security. Also will Unix/Linux/Perl knowledge give me better prospects in [...]
Answer Question
| April 30, 2013 9:16 AM
CCNA, CCNP, Cisco, Networking careers
TV apps with my Netgear N300 (WNR200v4) router isn’t working
I hooked up everything through Direct TV and I can get Pandora through Direct TV, but I can’t get TV apps. For some reason, the lady at DIRECT TV said to me that I would have to somehow adjust the settings to my router, and open up the “UDP 1701-LT2P port”. So I’m looking at [...]
Answer Question
| April 30, 2013 6:43 AM
Netgear, Netgear router, Networking
I hooked up everything through Direct TV and I can get Pandora through Direct TV, but I can’t get TV apps. For some reason, the lady at DIRECT TV said to me that I would have to somehow adjust the settings to my router, and open up the “UDP 1701-LT2P port”. So I’m looking at [...]
Answer Question
| April 30, 2013 6:43 AM
Netgear, Netgear router, Networking
Trailing the blanks which come in the middle of a string
Could anyone please let me know how I can trail the blanks that come in the middle of a string? For example, a field contains a name like ‘hello hai’ I want to trim the blank which came in the middle of hello and hai. Please help me with a piece of sample code.
Answer Question
| April 30, 2013 4:37 AM
AS/400, RPGLE
Could anyone please let me know how I can trail the blanks that come in the middle of a string? For example, a field contains a name like ‘hello hai’ I want to trim the blank which came in the middle of hello and hai. Please help me with a piece of sample code.
Answer Question
| April 30, 2013 4:37 AM
AS/400, RPGLE
Headphone jack on HP laptop doesn’t work
When I went to plug something into my headphone jack I only get a muffled sound. I can’t hear anything much only a light, muffled sound. Is there anyway to fix this problem?
Answer Question
| April 30, 2013 9:52 PM
headphone, HP Laptop
When I went to plug something into my headphone jack I only get a muffled sound. I can’t hear anything much only a light, muffled sound. Is there anyway to fix this problem?
Answer Question
| April 30, 2013 9:52 PM
headphone, HP Laptop
AS/400
Hello, Does anyone know how to step into and through the code in the macro customization window of AS/400? Thank you, Carissa
Answer Question
| April 30, 2013 8:50 PM
AS/400, AS/400 macros, iSeries
Hello, Does anyone know how to step into and through the code in the macro customization window of AS/400? Thank you, Carissa
Answer Question
| April 30, 2013 8:50 PM
AS/400, AS/400 macros, iSeries
ResourceAddressLists error when upgrading Exchange 2010 to SP2
In the Organization Preparation phase of installing SP2 Exchange 2010, I got the following error: “The following error was generated when “$error.Clear(): install-CannedAddressLists -DomainController $RoleDomainController” was run. The ResouceAddressLists parameter can’t have more than one member. Property Name:
Answer Question
| April 30, 2013 8:43 PM
Microsoft Exchange 2010, Microsoft Exchange SP2
In the Organization Preparation phase of installing SP2 Exchange 2010, I got the following error: “The following error was generated when “$error.Clear(): install-CannedAddressLists -DomainController $RoleDomainController” was run. The ResouceAddressLists parameter can’t have more than one member. Property Name:
Answer Question
| April 30, 2013 8:43 PM
Microsoft Exchange 2010, Microsoft Exchange SP2
Differences between firewalls and routers
What are the differences among firewalls and routers.
Answer Question
| April 30, 2013 8:04 PM
Firewalls, Routers
What are the differences among firewalls and routers.
Answer Question
| April 30, 2013 8:04 PM
Firewalls, Routers
Deleting SAVED journal receivers
I want to delete journal receivers in a library that have the the status of SAVED. Can anyone offer some CL code to do this in a program? Each receiver begins with AMQA and followed by 6 numerics. I guess I would write out to an outfile then read the outfile to delete the receivers.
Answer Question
| April 30, 2013 7:11 PM
AS/400, AS/400 journaling, CL Program
I want to delete journal receivers in a library that have the the status of SAVED. Can anyone offer some CL code to do this in a program? Each receiver begins with AMQA and followed by 6 numerics. I guess I would write out to an outfile then read the outfile to delete the receivers.
Answer Question
| April 30, 2013 7:11 PM
AS/400, AS/400 journaling, CL Program
How do I copy a data base file to IFS directory
How do I copy a data base file to IFS directory
Answer Question
| April 29, 2013 6:38 PM
AS/400 - CL Command
How do I copy a data base file to IFS directory
Answer Question
| April 29, 2013 6:38 PM
AS/400 - CL Command
ASP Utilization
I am new to AS/400. Can anyone suggest the command or STEPS to know which file or library is utilizing maximum space.
Answer Question
| May 2, 2013 4:39 PM
AS/400, ASP Utilization
I am new to AS/400. Can anyone suggest the command or STEPS to know which file or library is utilizing maximum space.
Answer Question
| May 2, 2013 4:39 PM
AS/400, ASP Utilization
Mobile browser
What browser is compatible to c2-00? Please help me.
Answer Question
| April 29, 2013 2:33 PM
Browser, Mobile
What browser is compatible to c2-00? Please help me.
Answer Question
| April 29, 2013 2:33 PM
Browser, Mobile
Creating an out of office message when you’re a delegate
My boss asked me to turn on her Out of Office notification once she had already left for vacation. I am delegated to access her email but when I try to set up the Out of Office notification, it only sends from my email – not hers. Is there a way for me to set up [...]
Answer Question
| April 29, 2013 1:54 PM
Microsoft Outlook 2007, Microsoft Outlook features
My boss asked me to turn on her Out of Office notification once she had already left for vacation. I am delegated to access her email but when I try to set up the Out of Office notification, it only sends from my email – not hers. Is there a way for me to set up [...]
Answer Question
| April 29, 2013 1:54 PM
Microsoft Outlook 2007, Microsoft Outlook features
Why do you think there’s a renewed interest in UC&C?
A recent survey by the research firm Ovum confirmed a renewed interest in unified communications & collaboration as over 80% of respondents said they have plans to implement some UC&C in the next two years. Also, 78% claimed to have the dedicated budget to do so. Why do you think there’s a renewed interest in [...]
Answer Question
| May 13, 2013 1:07 PM
BYOD, Collaboration, Unified Communications
A recent survey by the research firm Ovum confirmed a renewed interest in unified communications & collaboration as over 80% of respondents said they have plans to implement some UC&C in the next two years. Also, 78% claimed to have the dedicated budget to do so. Why do you think there’s a renewed interest in [...]
Answer Question
| May 13, 2013 1:07 PM
BYOD, Collaboration, Unified Communications
Object is currently in use
We have a RBO job which failed and when checking in the log, we could see the object currently in use. What can I do?
Answer Question
| April 29, 2013 10:22 AM
AS/400, AS/400 jobs
We have a RBO job which failed and when checking in the log, we could see the object currently in use. What can I do?
Answer Question
| April 29, 2013 10:22 AM
AS/400, AS/400 jobs
iSeries logs
iSeries AS/400 is integrated to RSA envision successfully but unable to get logs from iSeries to RSA envision. Please help. Thanks, Niketan
Answer Question
| April 29, 2013 6:01 AM
AS/400 logs, iSeries AS/400, RSA envision
iSeries AS/400 is integrated to RSA envision successfully but unable to get logs from iSeries to RSA envision. Please help. Thanks, Niketan
Answer Question
| April 29, 2013 6:01 AM
AS/400 logs, iSeries AS/400, RSA envision
Android app game hacking
Ok I really need to know how this person is able to find out my information while I’m in an android game app in the games lobby. Any help would be greatly appreciated. I’m not the only one that this person has gotten personal info from on this app. Help!
Answer Question
| April 29, 2013 4:15 AM
Android, Hacking, Mobile
Ok I really need to know how this person is able to find out my information while I’m in an android game app in the games lobby. Any help would be greatly appreciated. I’m not the only one that this person has gotten personal info from on this app. Help!
Answer Question
| April 29, 2013 4:15 AM
Android, Hacking, Mobile
GAAP relative to inventory
What is the generally accepted accounting principles for recording of the inventory of postal stamp stock in the book of accounts?
Answer Question
| April 29, 2013 2:20 AM
GAAP
What is the generally accepted accounting principles for recording of the inventory of postal stamp stock in the book of accounts?
Answer Question
| April 29, 2013 2:20 AM
GAAP
Remittence
How can I enter the opening balance for the Receiver General by using Quickbooks 2013
Answer Question
| April 29, 2013 1:44 AM
Quickbook 2013, QuickBooks
How can I enter the opening balance for the Receiver General by using Quickbooks 2013
Answer Question
| April 29, 2013 1:44 AM
Quickbook 2013, QuickBooks
Unable to obtain lock on device
I have messages ” unable to obtain lock on device xxx” lots of times for each device I am using VRYCFG to obtain lock on device but I don’t know what is the reason of these messages.
Answer Question
| April 29, 2013 12:17 AM
AS/400, iSeries AS/400, VRYCRG
I have messages ” unable to obtain lock on device xxx” lots of times for each device I am using VRYCFG to obtain lock on device but I don’t know what is the reason of these messages.
Answer Question
| April 29, 2013 12:17 AM
AS/400, iSeries AS/400, VRYCRG
