Recent content by carlingac

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

It Ok i finally worked it out...well searched the net until i found soultion! its only took a day out my life!: The formula is: @If(@Command([FileSave]);@Do(@Command([CloseWindow]);@Command([Openframeset];"Admin2"));"")

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

Yeah that makes perfect sense thanks. I was initially trying to make please selet a default value but by using the list method it dose a better job for me anyway. Many thanks for your help and time in explaining it to me. You learn something new every day! cheers

Yes i am using the "Use formula for choices" section. I have just done what you said, i used: "Please Select":@DbColumn("":"RECACHE";"":"";"staff";1) And this works fine, just the same. So there was no need for a Temp Variable after all! What is the colon : that separates "Please Select" &...

HI, I got it to work by doing the following: Completed_By:="";"Please Select":@DbColumn("":"RECACHE";"":"";"staff";1) (Completed_By was my ComboBox field) But i just got lucky trying different things. I dont understand why i couldnt just have: Completed_By:= "Please...

Thanks Fishkake, but I already tried the same way as you suggested but it did not work. any other ideas? Many thanks

Sorry Pascal i dont really understand, i had a look in the help guide and understand the syntax is variableName := value, but i havent a clue where to start. Could you Elaborate further for me. When you say list do you mean the lookup formual "@DbColumn("":"RECACHE";"":"";"staff";1)?, Sorry...

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

worked it out by doing this: (@Now - due_date) / 86400 however i would still like to be able to exclude weekends if possible. many thanks

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

Ok Thanks. However i did manage to change the background of a computed field.By going into the field properties the option is in the same place as font selection. Thanks

Many Thanks again pascal. It helps if you know what your looking for in the designer help db. Thanks