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

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

Oh one more thing. When i add a new entry into the view i have to close lotus then reopen it before it appears in my field( the dbcolumn field) on my form. Is there anything i can do to make the field see the new entry in the view without having to close and reopen notes? I do have refreash on...

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.

Many thanks, Working great

Think i worked it out, i was using the field name which dosnt do anything, but if i use the column number it worked. Does any one know the difference between using the field name or column number? @DbLookup("":"";"":"";"users";user_name;full) - this didnt work...