VB6 with too many SQL Select Statements
Hi Team, hope you can help me out here.. I have a VB6 form that is populated using VB6 and Access being the Repository. The problem is that I am opening and closing the Database for every query I have.. Approx 87 queries. In short I have 12 Rooms that I need stats for.. Ie [...]
Answer Question
| June 7, 2012 9:08 AM
Microsoft Access 1997, Visual Basic 6
Hi Team, hope you can help me out here.. I have a VB6 form that is populated using VB6 and Access being the Repository. The problem is that I am opening and closing the Database for every query I have.. Approx 87 queries. In short I have 12 Rooms that I need stats for.. Ie [...]
Answer Question
| June 7, 2012 9:08 AM
Microsoft Access 1997, Visual Basic 6
Import OST to Exchange
Hello, I have a very specific need of importing an OST file into Exchange Server ( OST files belong to some other server ). Can anyone help? Regards, Raj Malhotra
Answer Question
| June 15, 2012 7:13 AM
.OST files, Microsoft Exchange 2010
Hello, I have a very specific need of importing an OST file into Exchange Server ( OST files belong to some other server ). Can anyone help? Regards, Raj Malhotra
Answer Question
| June 15, 2012 7:13 AM
.OST files, Microsoft Exchange 2010
vmware
How do I connect internet via vmware? I checked adapter setting to NAT but it does not work. Thanks
Answer Question
| June 6, 2012 1:21 AM
VMware fusion 4
How do I connect internet via vmware? I checked adapter setting to NAT but it does not work. Thanks
Answer Question
| June 6, 2012 1:21 AM
VMware fusion 4
database
if i have one pf (pf009) and one logical file (lf009) on pf009. how we can add one more field after compalisation of logical file ?
Answer Question
| June 8, 2012 5:17 PM
AS/400 database
if i have one pf (pf009) and one logical file (lf009) on pf009. how we can add one more field after compalisation of logical file ?
Answer Question
| June 8, 2012 5:17 PM
AS/400 database
How to create an Outlook system that automatically archives team email conversations using rules and public folders.
I’m trying to set up an Outlook system using rules and public folders that does the following: - Allows any member of a team to “tag” a team email conversation so all future emails from that conversation will be automatically copied to a public folder. - Anyone on the team who needs to quickly find [...]
Answer Question
| June 19, 2012 4:27 PM
Microsoft Outlook 2007, Microsoft Outlook folders
I’m trying to set up an Outlook system using rules and public folders that does the following: - Allows any member of a team to “tag” a team email conversation so all future emails from that conversation will be automatically copied to a public folder. - Anyone on the team who needs to quickly find [...]
Answer Question
| June 19, 2012 4:27 PM
Microsoft Outlook 2007, Microsoft Outlook folders
Hard Code
Collecting & entering data in on bounces for a website. Boss told me to put in a “hard Code” for a site with no data for this category. Should I average the last 3 months of data & use that for the “hard code”. What’s meant by a hard code?
Answer Question
| June 6, 2012 2:25 PM
hard code
Collecting & entering data in on bounces for a website. Boss told me to put in a “hard Code” for a site with no data for this category. Should I average the last 3 months of data & use that for the “hard code”. What’s meant by a hard code?
Answer Question
| June 6, 2012 2:25 PM
hard code
As400
i need to convert folling rpgle code into rpg EVAL CMDKEY = %TRIMR(CMDKEY) + ‘ ‘ + F6COM
Answer Question
| June 7, 2012 2:14 PM
AS400 Data Definitions
i need to convert folling rpgle code into rpg EVAL CMDKEY = %TRIMR(CMDKEY) + ‘ ‘ + F6COM
Answer Question
| June 7, 2012 2:14 PM
AS400 Data Definitions
mails received in hieroglyphs instead of Cyrillic symbols in Lotus Notes 8.5
User receives externail email (with POP3/IMAP4 protocol) to his LN mailbox with hieroglyphs instead of Cyrillic symbols. If you send this email to the Exchange email it’s ok to view – Cyrillic as Cyrillic without any kind of cracky symbols. I have tried searching everywhere about this but tough luck..
Answer Question
| June 6, 2012 2:05 PM
Lotus Notes client applications
User receives externail email (with POP3/IMAP4 protocol) to his LN mailbox with hieroglyphs instead of Cyrillic symbols. If you send this email to the Exchange email it’s ok to view – Cyrillic as Cyrillic without any kind of cracky symbols. I have tried searching everywhere about this but tough luck..
Answer Question
| June 6, 2012 2:05 PM
Lotus Notes client applications
How to add a text box within a option group on a form?
I need help trying to add a text box to my option group on Access 2010. Within my option group I have it listed: Materials Labor Heat Rate Other: (text box) Or at least thats how I want it, but as I input the information to the “other” text box, it shows up on ALL [...]
Answer Question
| June 5, 2012 1:19 PM
Microsoft Access 2010, Microsoft Access forms
I need help trying to add a text box to my option group on Access 2010. Within my option group I have it listed: Materials Labor Heat Rate Other: (text box) Or at least thats how I want it, but as I input the information to the “other” text box, it shows up on ALL [...]
Answer Question
| June 5, 2012 1:19 PM
Microsoft Access 2010, Microsoft Access forms
Recompile CL program
Hi, We added few new fields to an exising Physical file. When I check for the dependents for the changed Physical file in ALDON it shows 250 dependent objects. Do I need to recompile all 250 objects? Thanks, Elan
Answer Question
| June 6, 2012 1:18 PM
AS/400, CL Program
Hi, We added few new fields to an exising Physical file. When I check for the dependents for the changed Physical file in ALDON it shows 250 dependent objects. Do I need to recompile all 250 objects? Thanks, Elan
Answer Question
| June 6, 2012 1:18 PM
AS/400, CL Program
CL/QMQRY
i hav code STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT) In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it will work fine, but i want [...]
Answer Question
| June 7, 2012 12:16 PM
AS/400, QMQRY, SQL procedure
i hav code STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT) In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it will work fine, but i want [...]
Answer Question
| June 7, 2012 12:16 PM
AS/400, QMQRY, SQL procedure
Crystal 8.5 export trouble
My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report) suddenly application going to crash.I cant [...]
Answer Question
| June 5, 2012 9:48 AM
Crystal Reports 8.5, SQL Server 2003
My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report) suddenly application going to crash.I cant [...]
Answer Question
| June 5, 2012 9:48 AM
Crystal Reports 8.5, SQL Server 2003
CL Programming
PGM DCL VAR(&TIME) TYPE(*CHAR) LEN(6) DCL VAR(&DATE) TYPE(*CHAR) LEN(6) DCL VAR(&YEAR) TYPE(*CHAR) LEN(2) RTVSYSVAL SYSVAL(QTIME) RTNVAR(&TIME) [...]
Answer Question
| June 7, 2012 9:36 AM
AS/400, PGM
PGM DCL VAR(&TIME) TYPE(*CHAR) LEN(6) DCL VAR(&DATE) TYPE(*CHAR) LEN(6) DCL VAR(&YEAR) TYPE(*CHAR) LEN(2) RTVSYSVAL SYSVAL(QTIME) RTNVAR(&TIME) [...]
Answer Question
| June 7, 2012 9:36 AM
AS/400, PGM
Cisco 1841 NTP configuration and sync
Hi, I have configured a cisco 1841 to sync with a ntp server. after entering the ntp command, show ntp status says that it is not yet synchronized but on show clock details shows that it is already configured based on the ntp server. These are the result of show commands and the running config [...]
Answer Question
| June 5, 2012 3:36 AM
Cisco 1841, NTP Configuration
Hi, I have configured a cisco 1841 to sync with a ntp server. after entering the ntp command, show ntp status says that it is not yet synchronized but on show clock details shows that it is already configured based on the ntp server. These are the result of show commands and the running config [...]
Answer Question
| June 5, 2012 3:36 AM
Cisco 1841, NTP Configuration
How to create an Outlook system that automatically achieves team email conversations using rules and public folders.
I’m trying to set up a Outlook system using rules and public folders that does the following: 1) Allows members of a team to “tag” an email conversation so all future emails from that conversation will be copied to a public folder.
Answer Question
| June 5, 2012 1:02 AM
Microsoft Outlook 2007, Microsoft Outlook folders
I’m trying to set up a Outlook system using rules and public folders that does the following: 1) Allows members of a team to “tag” an email conversation so all future emails from that conversation will be copied to a public folder.
Answer Question
| June 5, 2012 1:02 AM
Microsoft Outlook 2007, Microsoft Outlook folders
How do you code footers in DDS Print File?
I need to print a footer on every page of a report. Thought it would be simple like headers. If anyone has the answer let me know. Thx.
Answer Question
| June 5, 2012 11:56 PM
AS400 RPGLE, DDS Printer files
I need to print a footer on every page of a report. Thought it would be simple like headers. If anyone has the answer let me know. Thx.
Answer Question
| June 5, 2012 11:56 PM
AS400 RPGLE, DDS Printer files
Green circle icons in outlook 2010
I have icons in deleted items that have green circles with a white checkmark on them. What does this mean?
Answer Question
| June 4, 2012 7:04 PM
Microsoft Outlook, Microsoft Outlook 2010
I have icons in deleted items that have green circles with a white checkmark on them. What does this mean?
Answer Question
| June 4, 2012 7:04 PM
Microsoft Outlook, Microsoft Outlook 2010
Printer Overlays
What is the simplest way to create an overlay for a printer file? I’d prefer to go generic, rather than buy a package.
Answer Question
| June 6, 2012 6:36 PM
iSeries, iSeries 720
What is the simplest way to create an overlay for a printer file? I’d prefer to go generic, rather than buy a package.
Answer Question
| June 6, 2012 6:36 PM
iSeries, iSeries 720
CPYTOIMPF .txt file shows garbage on IFS when viewing on windows
CPYTOIMPF .txt file shows garbage on IFS when viewing on windows but when using wrklnk it looks fine, please help.Below is the query I am using CPYTOIMPF FROMFILE(BIN815PA) TOSTMF(&PATHDAT) + MBROPT(*ADD) FROMCCSID(*FILE) + STMFCODPAG(285) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) CPYTOIMPF FROMFILE(BIN815PB) TOSTMF(&PATHDAT) + MBROPT(*ADD) FROMCCSID(*FILE) + STMFCODPAG(285) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) CCSID of the file (BIN815PA) [...]
Answer Question
| June 8, 2012 5:35 PM
AS/400, CPYTOIMPF
CPYTOIMPF .txt file shows garbage on IFS when viewing on windows but when using wrklnk it looks fine, please help.Below is the query I am using CPYTOIMPF FROMFILE(BIN815PA) TOSTMF(&PATHDAT) + MBROPT(*ADD) FROMCCSID(*FILE) + STMFCODPAG(285) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) CPYTOIMPF FROMFILE(BIN815PB) TOSTMF(&PATHDAT) + MBROPT(*ADD) FROMCCSID(*FILE) + STMFCODPAG(285) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) CCSID of the file (BIN815PA) [...]
Answer Question
| June 8, 2012 5:35 PM
AS/400, CPYTOIMPF
