Search results for query: *

gaift, Going back to your original problem, even though JeanW is right about using relationships, etc. My bet is that some of your author names have extra spaces in them. This will muck up an "=" test. "FRED " = "FRED" --> False However, doing a find on "FRED" will find both "FRED" and "FRED...

Phil and Payback, Thank you both for your kind offers. Sorry to be so long getting back - been up to my ears. Our requirements have changed a bit and it sounds like that code of your would be ideal, Payback. Any chance of finding it? Thanks in advance. Cheers, Paul J.

Forgot to ask, Phil, do you know where I can find this described? There seems to be a dearth of really useful examples of hooking Access to the rest of MS Office. I've searched this forum but there's almost nothing. Can't find anything but info about how good it is on the MS site. Cheers...

Thanks for that Phil. Looks much simpler than 'my' last effort. The actual quote will look something like this. LOTS OF HEADER STUFF Here's your quote. Item 1. GIZMO1 whirly thingie for going round. $500 Painted add $85 Item 2. GIZMO1a...

I have a situation where we want to generate a quotation in Access and email or fax it to a prospect. The quotation consists of two sections. The first section list the (usually one or two) items to be quoted on, includng options. The text for each item is standard and can be kept in the DB...

Sorry, gmannatl. Should have read your original post properly. I have written out 200 times "I must READ posts before responding." Cheers, Paul J.

gmannatl, In your Runtime1, Export records to TempFile.fp7 Perform Script[External] in Runtime2 (NewImport) Exit script In your Runtime2, script NewImport consists of - Import records from TempFile.fp7 using whatever you need to get the data in the right place. End of story...

Wonder why this hasn't been answered? Hope I'm not missing something! Case(DueDate > Status(CurrentDate)+ 90; ""; DueDate > Status(CurrentDate)+ 29; "Due Soon"; DueDate >= Status(CurrentDate); "";) Cheers, Paul J.

Dave, I've now remembered my own name! Define a Value List, call it LList, as a list from the TextedDates field. Then set your field to ValuelistItems("FileName"; "LList") The list will be returned separated by carriage returns but converting them to commas is simple. (Use the Substitute...

Mike, The short answers are 'No' and 'No'. Given files A, B, C and D, you could pick the file with the largest number of fields, Then re-define the fields from all the other files in that one. Let's assume it's B. You need to define in B all the fields in the other files. Then copy the...

Please be a bit more explicit about your problem. FMP has aa faciltiy to specify the page size and the margins and what have you. Sounds to me like you have an OS problem. Windoze? Cheers, Paul J.

You obviously have us all stumped - no responses to two posts. Can you be a bit more explicit about just what you are trying to do, and why, rather than how you think it might be done? Cheers, Paul J.

Good! Re how/where does FMP keep its secrets re file locations - who knows? Seriously, I've never been able to get a handle on it. In V7 you can actually see all the paths that FMP will try in order to get to a file. In earlier versions, you just grin and bear it and try to keep FMP in the...

Unfortunately, you can't type scripts. What do you mean by "... runs with in 3 people."? Are Run #s assigned in sequence (1, 2, 3 etc) once the file is sorted? Cheers, Paul J.

FMP4 had very, very few gotchas. And, no, there isn't a list of gotchas. FMP is one of most bugless bits of PC software I've ever experienced. (Before V7, that is.) See my previous post. I just turned a normally displayed field into a button, right-clicked it and, you guessed it, 'specify...

You don't normally trigger a lookup just by clicking in a field. Was there a button associated with the field in the old database? Cheers, Paul J.

In layout mode, click on the 'A' for text, then click in your button. You can change the text.. Cheers, Paul J.

Regrettably, there is no way (?) to see what a FMP V4 db is looking for. This has been fixed in V7. There is a plugin to get this info and. if my next suggestion doesn't work, I'll see if I can find its name/location. First thng to check is duplicate files on the network. Cheers, Paul J.

Create a self-join (S-Join) using, say, gNum = 1 and MyNum =1. gNum is a Global and MyNum is an ordinary Number field. Creat a set of Calculaton fields TotOptions01, ...02, etc. TotOptions01 = Sum(S-Join::Option1) The TotOptions fields are available virtually anywhere on your layout. Cheers...

Frink, If you are looking for info on V6 to decide if FMP suits your needs, then I suggest you look at V7. It is just so far ahead of V6! If you still want to stick with V6, try Centennial Media. I'm sorry I can't give you an address. Cheers, Paul J.