Search results for query: *

Hello, I have an access form to enrol people in courses. In the main form I select a course, date, etc (table courses). Further down the form I have tab A with a subform/grid where I enrol people (into table participants) using a combo box based on the people table. Once people complete a...

Thank you Lena, spot on!!

I'm not very familiar with expression builder and I would like to evaluate a control with a value, something like this: if current month is > 6 then "currentYear" & "/" & "(currentYear + 1)" e.g. "2007/2008" otherwise "(currentYear - 1)" & "/" & "currentYear" e.g. "2006/2007" tried...

Hi there, I would like to use MS Query in XL to enquire our Informix database. In my view the tool is easy to use, has SQL wizards to assist users join tables and retrieve data. The only problem I have is that it also opens the database to potential unaudited SQL updates and/or deletes. 1...

I have 2 files, requests and actions and a request can have many actions. In my report I want to list and count only one action per request. I tried to condition the detail section which works but still counts the other duplicate request actions. Also tried to create a {@duplicate record}...

I'm implementing a Windows spooler package that does funky forms, barcodes, etc. At present I am dumping my unix application data as a .txt file into a Unix folder and then sharing the folder with Windows via SAMBA so that the spooler can manipulate/format the data. However I am having all...

mrn, Thank you for your reply. I did change my script to SendMail and tried to debug again and I still get the same error. Any ideas? test script =========== [Live:authprog] cat test #! /usr/local/bin/perl use Mail::SendMail; &NotifyMe; sub NotifyMe { $fromuser = 'Test...

I am testing a perl script to send emails based on an a db file extract. Nothing was being sent so I went on to debug the perl script and got following error: Can't locate Mail/Sendmail.pm in @INC (@INC contains: /usr/local/lib/perl5/5.6.0/aix /usr/local/lib/perl5/5.6.0...

PHV and TheAceMan1, Thank you very much for your replies. Spot on!

when running a simple form with a button to retrieve table data I get "object variable or with block variable not set". Code follows. Any tips will be much appreciated. Luis Option Compare Database 'This Type maps to the columns in Property file Private Type OpenSpec AgreeID As Integer '...

synapsevampire, Thanks for your input. Yes, I am linking the valueA-D to the key in the values table. I do understand that I need to add the "isnull" in the select statement (although I thought that the left outer join would take care of it). However I don't understand why I need to add...

My report links a master table with 4 value tables Master table: key, valueA, valueB, valueC, valueD 1,A,B,C,D 2,,,, 3,,,, 4,A,B,C,D Value Table(s): key,description A,descriptionA B,descriptionB C,descriptionC D,descriptionD Keys and values will vary but for the purpose of this...

Thank you for the info. I checked tctl command, however there is no format parameter. My problem is that when we buy DLT tapes they are not formatted. We currently use another server's DLT drive to format new tapes using a GUI program, however we are about to phase out that server, reason why I...

Can anyone tell me if there is a AIX command to format a DLT tape? Thank you, LS

I'm relatively new to AIX/Unix ... I am very puzzled as I read various documentation on IBM site along the lines of "You now need to use the instructions in the Genucode package to complete the microcode install." My problem is that I cannot find any indication of where the Genucode is or how...

Hi, I am created a 'Personal Details' form and a 'Survey Answers' subform to capture survey information. On my subform I will capture a Yes or No answer to 16 questions to be stored in 'Survey Answers' file. While on the 'Personal Details' form, on 'ContactID_Exit' (the 'Personal Details'...

I have to constantly explore and extract data from a large Informix database. The database is part of a 3rd party package that our organisation uses. In order to write SQL’s and reports (e.g. Crystal Reports) I always struggle to find out where the various bits and pieces of information are...

Crystal Reports v7, Database Informix I created a report that prints information from two tables. A documents table and a category table. Documents table (fields: id, description,..., categ 1, categ 2, categ 3, categ 4) Document records are classified with Category 1, Category 2, Category 3...

Hi, I am using Crystal Reports V7 and have a report + sub-report totalling question: How can I pass a main report group total to a subreport so that I can provide: subreport group total = ((main report group total) – (subreport group total)) ? Suggestions will be very much appreciated. LS...

Hi, I have a report + sub-report totalling question: I have a report that per group prints receipts details and receipt amounts and a sum for every receipt group. I was asked to also provide a list of payments and payment sum per group in the same report. Note that both receipts and payments...