Get answers.  Share knowledge.  Collaborate with peers.




Position at which value is entered in a subfile

Hi Charlie,

That is what i am asking. how to get the sfl record number. What is the keyword?



View Discussion   |  April 18, 2013  5:44 AM
AS/400, AS/400 Subfiles
discussed by:
jainamit
380 pts.

Export contacts info from Outlook 2007

FOR OUTLOOK 2007/2010

1. Click the File tab.
2. Click Options.
3. Click Advanced.
4. Under Export, click Export.
5. In the Import and Export Wizard, click Export to a file, and then click Next.
6. Under Create a file of type, click the type of export that you want, and then click Next.
The most common is Comma Separated Values (Windows), also known as a CSV file.
7. Under Select folder to export from, select the contact folder that you want to export, and then click Next.
 NOTE    Unless you chose to export to an Outlook Data File (.pst), you can only export one folder at a time.
8. Under Save exported file as, click Browse, select a destination folder, and in the File name box, type a name for the file.
9. Click OK.
10. In the Export to a File dialog box, click Next.
11. Click Finish.

For pictures, Press F1 [help] then type “export”



View Discussion   |  April 18, 2013  4:53 AM
Microsoft Excel, Outlook, Outlook 2007, Outlook 2007 contacts, Outlook 2007 import/export, Outlook contacts
discussed by:
agasega
10 pts.

Making changes in a user profile with a CL program

Okay, you’ve described the tasks. What is the problem? — Tom



View Discussion   |  April 18, 2013  2:46 AM
AS/400, CL Program
discussed by:
TomLiotta
107,735 pts.

Message subfile

Is your use of QMHSNDPM new or is it using a more recent coding style? Please post the calling code including all related data definitions.
.
APIs do sometimes have bugs. But they don’t show up often after early-release gets a workout, and they usually appear in APIs that are less commonly used. QMHSNDPM is so widely used in so many different ways that a bug in the API is an extremely unlikely cause for this problem.
.
Tom



View Discussion   |  April 18, 2013  2:43 AM
AS/400, MSGF, QMHSNDPM
discussed by:
TomLiotta
107,735 pts.

Upgrade OS on IBM iSeries from V5R4 to V6R1

The System Openness Includes can be installed the same way any OS option is installed. — Tom



View Discussion   |  April 18, 2013  12:48 AM
IBM iSeries, QSYSINC
discussed by:
TomLiotta
107,735 pts.

Execution of formula language in a LotusScript agent without using evaluate statement

I’m not clear on your situation. Where does this @If formula exist? Only in your evaluate statement? Do you have a computed field with this as its calculation? Can you get the formula to calculate by any method? Are you getting an error message about a text string being too long? Please give more detail.



View Discussion   |  April 17, 2013  8:37 PM
LotusScript, LotusScript Agent
discussed by:
Stiletto
2,700 pts.

Message subfile

That was short-lived. Another unrelated change (developing pgm now so frequent changes) and api seems to fail again – in a different way. MSG subfile now begins with an informational message (about the DDM file-same one I’ve been using) and never changes (even tho I force errors which would normally populate the MSG subfile). I managed to get a partial field during debug and it mainly has ‘CPF’ where it stops. So my guess is I’m getting an execution error.
So … general advice might help, but any focus on the error itself seems unlikely to get us anywhere.



View Discussion   |  April 17, 2013  8:18 PM
AS/400, MSGF, QMHSNDPM
discussed by:
aceofdelts
1,565 pts.

Access 2007 query with null values

This is the Expression I have so far:

November: Avg((SELECT [SumOf1/3GM$s] FROM [BaxterActualMargin1] WHERE [Period] Like “November*”)+(SELECT [SumOf1/3GM$s] FROM [BaxterActualMargin2] WHERE [Period] Like “November*”)+(SELECT [SumOf1/3GM$s] FROM [BaxterActualMargin3] WHERE [Period] Like “November*”))



View Discussion   |  April 17, 2013  7:23 PM
Microsoft Access 2007, Microsoft Access query
discussed by:
stlawr
45 pts.

Message subfile

Bruce – the 2007 article is at
http://www.itjungle.com/fhg/fhg100307-story02.html

Thanks for the replies. I tried a few things yesterday afternoon & finally gave up. Kept getting that same bad result. I called that same program today (NO changes – honest) and the messages once again appear correctly. We did not reboot that 400 (haven’t since 2011) and the create date on the program object is at yesterday afternoon.
So in the short run, I’m happy. In the long run, there is a threat that the problem will recur. Maybe I’ll actually read that article now.
[ :x ]



View Discussion   |  April 17, 2013  6:55 PM
AS/400, MSGF, QMHSNDPM
discussed by:
aceofdelts
1,565 pts.

Position at which value is entered in a subfile

Another technique is to have a hidden field (usually the “key” field of that data element) as part of the subfile record. The value of the hidden field tells you the record that was selected.



View Discussion   |  April 17, 2013  6:45 PM
AS/400, AS/400 Subfiles
discussed by:
aceofdelts
1,565 pts.

Message subfile

“i found a lengthy article saying api bugs do happen”

I would very much enjoy reading this article if you can provide a link. APIs are code, and code does usually come with bugs (even a simple program such as Pgm; Signoff; EndPgm has a potential bug) but I don’t believe APIs have any more bugs than any other reasonably complex piece of code — and IBM will correct reported defects just as it would with any other part of the operating system.

Bruce Vining



View Discussion   |  April 17, 2013  5:50 PM
AS/400, MSGF, QMHSNDPM
discussed by:
bvining
6,055 pts.

Position at which value is entered in a subfile

I might use a READC to read the changed record.
The select column might be the only field that can be changed.
So if a record has been changed the select value must have been changed.



View Discussion   |  April 17, 2013  5:45 PM
AS/400, AS/400 Subfiles
discussed by:
philpl1jb
44,070 pts.

MS Access 2007 functions

I think that you are looking for something like =IFF(Marks >= 90,”A”,IFF(Marks >= 70,”B”,IFF(Marks >= 50,”C”,IFF(Marks >= 30,”D”,”F”))))



View Discussion   |  April 17, 2013  5:06 PM
Microsoft Access 2007, Microsoft Access function
discussed by:
tlsanders1
1,240 pts.

MS Access 2007 functions

am havn a list of marks and i want to grade them in access. the marks field is called [MARKS]. eg 100-90 A. 70-89 B. 50-69 C. 30-49 D n below 30 E.



View Discussion   |  April 17, 2013  4:50 PM
Microsoft Access 2007, Microsoft Access function
discussed by:
TonnieSpartacas
15 pts.

Impossible to access to HTTP admin

*MGTC was started
*http is running

thanks



View Discussion   |  April 17, 2013  3:55 PM
OS/400, OS/400 V6R1M0
discussed by:
JPPLOU
115 pts.

Impossible to access to HTTP admin

Perhaps HTTP *ADMIN server has stopped even though it was started during IPL. That happens on our IBM i running 6.1. The server stops about a week after the IPL.



View Discussion   |  April 17, 2013  3:40 PM
OS/400, OS/400 V6R1M0
discussed by:
WoodEngineer
5,525 pts.

Position at which value is entered in a subfile

The SFL Record number will tell give you that information



View Discussion   |  April 17, 2013  3:26 PM
AS/400, AS/400 Subfiles
discussed by:
CharlieBrowne
32,785 pts.

Microsoft Word keys

Sounds like it the StickyKeys function strikes again.
If you want to disable them heres a link with some good info

http://www.groovypost.com/howto/geek-stuff/windows-7-disable-sticky-keys-filter-keys/



View Discussion   |  April 17, 2013  2:48 PM
Microsoft Word 2002, Microsoft Word features
discussed by:
ToddN2000
3,890 pts.

Impossible to access to HTTP admin

Hmmm. We don’t have SI49057 loaded yet have no trouble accessing the HTTP Server Administration.

Have you started the MGTC server (STRTCPSVR SERVER(*MGTC))? I seem to remember having some trouble with that many moons ago.



View Discussion   |  April 17, 2013  2:45 PM
OS/400, OS/400 V6R1M0
discussed by:
Splat
5,670 pts.

How do I copy Outlook contacts

Thank you for your response. Yes, this works IF I am connected to the exchange. But because I am leaving the company they have turned off my access. So I need to be able to try to save my contacts as an Outlook contact or VCard offline.



View Discussion   |  April 17, 2013  2:25 PM
Microsoft Outlook, Microsoft Outlook contacts
discussed by:
AJG
15 pts.