birchtree

Hello Is there a way to have a portal "stick in postion" instead of always scrolling back up to the first row all the time? Thanks

quote: Originally posted by danjacoby: Huh? Aren't you already in the parent file? So I can see that I haven't explained myself well as usual. The line items in the portal tell me which records in the current data base are active records. For example I maybe on record# 10 and the line items in the portal tell me that records 10, 29, 42 and 57 are active records. Can I press a button in the portal and navigate to record 57? I hope this makes sense. Thanks

Hello Is it possible initiate a script in a parent data that in turn executes a script in a child data base or do I have to navigate to the child data base first and then initiate it there? I haven't figured out how to code "External scripts" that I see mentioned from time to time. Do they require plug-ins? Many thanks

Hello I have a parent Work Order data base with a child data base showing in a portal that shows only the work orders currently being worked on. I have a button on the portal row that I want to use as a find to navigate back to the proper parent? Thanks for your help.

quote: Originally posted by BobWeaver: And for a Windows version.... The following utilities and plug-ins have been suggested from recent forum discussions (I have no personal experience with them) http://softtechsolution.com ProPrint http://www.afeina.com Change Printer Plug-in www.productivecomputing.com [Edit: added new products to list] Thanks a lot Bob, I will give a try and let you know.

Hello I am trying to use a laser printer as well as an ink jet printer. Some reports go to the ink jet (when I need color) and others go to the laser. I have saved the settings for each report for the different printers but when I run a script to print a report it picks up the printer from the last report, not the one I saved with the report. I have tried checking and unchecking Restore when selecting Print Setup but it doesn't help. I can't figure out what restore does. Any help would be appreciated. Thanks

quote: Originally posted by PinnWal: You could have the round calculation add .5 to the number it intends to round-off & then it will always round to the higher integer. For Example: 10.1 would become 10.6 & then round to 11 10.6 would become 11.1 & still round to 11 If I'm understanding what you're trying to do, then this should work... Later, Paul E. -) Thanks for the suggestion. Sorry I didn't reply earlier, I forgot to check for answers because I solved the problem myself.

quote: Originally posted by dykstrl: This will do what you need: Case(Int( NumberField )< NumberField ,(Int( NumberField )+1), NumberField ) Thanks for the suggestion. Sorry I didn't reply earlier, I forgot to check for answers because I solved the problem myself.

Hello, I truely appreciate this fabulous forum! I have a Work Order System and I want to perform a find on for Orders that have come in the last 24 hours. I don't want todays orders or yesterdays. It has to be the last 24 hours. Is that possible? Thanks very much Birchtree

quote: Originally posted by rdhaden: Since you're talking about building materials, negative numbers are not an issue, so this will work: Case(Number - Truncate(Number, 0) != 0, Truncate(Number, 0) + 1, Number) If you wanted it to work with negative numbers, then this will work: Case(Number - Truncate(Number, 0) != 0, Case(Number < 0, -1 * (Abs(Truncate(Number, 0)) + 1), Truncate(Number, 0) + 1), Number) Thanks for the quick reply

I wrongly posted these request to the Left Brain Forum. I think it belongs here. Hello Can someone help with what should be a simple calculation? I sell material by the square foot. Any amount greater than a whole number needs to be rounded up to the next whole number. If the result is 10.1 I need the result to be 11. Thanks alot.

Hello Can someone help with what should be a simple calculation? I sell material by the square foot. Any amount greater than a whole number needs to be rounded up to the next whole number. If the result is 10.1 I need the result to be 11. Thanks alot.

Hi Chuck What I have been doing to make a calculation field unique is to copy and paste it into another regular field that is defined as unique. It is very easy and works great. At least I think it is working like it is supposed to. birchtree

quote: Originally posted by LiveOak: Perhaps the simplest way is to not use the blank portal line (allow creation of related records) as the method. Instead, create global fields for the data to be entered. In operation, the user fills out the global field and clicks and "Enter" button. The "Enter" button runs and external script in the related file which checks whatever needs to be checked and either creates a new records (which appears in the portal) or displays a message that the attempted entry is a duplicate. -bd

Hi I have to insure that I cannot enter duplicate Line Items in a portal. Is there a simple way to do that or can I have an alert message that warns me that I have entered a duplicate? Thanks