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...

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...

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...

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 '...

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...

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...

Hi, Is 4gl shipped with any informix installation or client has to request and pay separately to have/use 4gl? At my correct assignment client uses a 3rd party package that runs on AIX/Informix/4gl. I know that the package was written in ESQL and 4GL so I am wondering if I can If 4GL is...

Hi, I am using CR v7 accessing an AIX/Informix database. My query is that follows: I have 2 files: event (parent) and tasks (child). Each event is indexed by department and category. Each task as a "completion by date". I need to produce a (cross tab) summary report of outstanding...

Hi, I am using CR v7 accessing an AIX/Informix database. My query is that follows: I have 2 files: event (parent) and tasks (child). Each event is indexed by department and category. Each task as a "completion by date". I need to produce a (cross tab) summary report of outstanding...