Search results for query: *

Hello again today I finally handed in my HNC project report and demostrated my database to everyone. I Also found out I passed my HNC. I would like to thank everyone who has helped me out during my project, especially Pascal and Fishkake, you guys have dug me out of the sh*t on many...

Hi I have a field on a form called “Usr_Name”, which contains a validation formula as a show below: @If(Usr_Name="";@Failure("please enter a user name");@Success) The Validation works fine and a error box is displayed with the message("please enter a user name") The thing I would like to...

Hi I have a save button on a form with the following formula in it. @If(@Command([FileSave]);@Command([FileCloseWindow]);""); @Command([OpenFrameset];"Admin2") The form has a number of field on it with validation set. All i want the save button to do is save the form if it passes all the...

Hi I dont know if this can be done with comboboxes. I have a ComboBox on a form set to use formula for choices with the choice being "@DbColumn("":"RECACHE";"":"";"staff";1)" When the form loads the DBcolumn pulls back the fields, but i would like to have a default value set at the top of the...

Display a field longer than 255 Characters Hi I am using crystal reports v8.5. On a report I have fields from a lotus notes database, and the problem is one of the fields data exceeds 255 characters. Crystal Reports seem to only show unto 255 characters of the data. All I would like to do...

Hi I think im going to owe everyone thats helped me out a pint once i have finished this HNC project!! Ok, another issue; I have a date field on a form, which is an editable field, called "due_date". What i would like to be able to do is show how many days the "due date" is overdue. i.e if...

Hi I have quite a few editable fields on a form. What i would like to do is have some sort of validation on the field to make any text that is typed in appear in UPPER CASE. Can this be done? I had a quick look in the designer help, buT couldnt find anything. many thanks

Hi Is there a way to change/define a Editable Text field background colour? I can change a computed field background colour, but the option doesnt seem to appear in a Editable text field.

Hi I have a form named 'NEWCALL' which has 4 fields called usrname(which is a combo box), room, telnumber and fullname on it. I have a view called 'users' which contains 4 columns, usrname,room,telnumber and full name. (" Basically the information stored in the view is a list of computer...

Hi, I'am currently doing my HNC and have the task of designing a computer helpdesk system. In Notes I have a form called usersdata, this form basically has 3 fields on it called username, name and telnumber. When the form is saved the documents are stored in a view. I have another form...