Andy Robo

I'm using google charts API in a web viewer and all my charts keep aligning to the left... anyone know what I need to do to the code to make everything align in the center of the web viewer... the titles keep getting cut off when they're too long. Code Sample: "http://chart.apis.google.com/chart?chs=320x240&&chco=4d89f9,c6d9fd&&chd=t:" & ass_running_records::rr_MinReadingAge & "," & ass_running_records::rr_MaxReadingAge & "|" & ass_running_records::rr_ageRangeLow & "," & ass_running_records::rr_ageRangeHigh & "&&cht=bvg&&chtt=" & ass_running_records::rr_FoundGroupTitle & " &&chxt=x,y&&chxl=0:|Min|Max| 1:|1|8|&&chds=0,16&&chf=c,lg,45,ffffff,0,76A4FB,0.75| bg,s,EFEFEF&&chdl=Reading Age|Actual Age &&chco=4d89f9,c6d9fd"

Can we assume that one column in your image represents one record? If so, portals... I would have thought so... horizontal portal records from a self-join relationship - then set them out horizontally using the portal dialogue box to define which records are shown... bit of fluffing around to set up, but if its main purpose is simply a report layout would that not work?

Cheers Michael, your calc returns the number OF WEEKS between the two dates... but I want to calculate the ordinal number OF THE week, where the week of the startDate = 1, (where weeks are Mon - Sun)and so on...

Hmmm, I got it to work okay if the starting day falls on a monday... thanks to Jason L. DeLooze of Nocturnal MicroSystems... WeekOfTerm (StartDay ; StartMonth ; MyDate) Let( [ d = Date(StartMonth;StartDay;Year(MyDate)) ; dp = Date(StartMonth;StartDay;Year(MyDate)-1) ; s = d + Mod(StartDay-DayOfWeek( d )+3;7)-3 ; sp = dp + Mod(StartDay-DayOfWeek( dp )+3;7)-3 ; FY_Start = Case( MyDate >= s ; s ; sp ) ] ; Int( (MyDate - FY_Start)/7) + 1 ) Just don't know how to make it count part of a week as the first week... Andrew

Hi All There is proby an existign CF I could re-jig, but I want to create a function which returns the NUMBER of a WEEK from a startDate to myDate... ie, how many weeks between startDate and myDate Something like WeekOfTerm (startDate ; myDate) startDate is the date in the first week and could be any day M-F (or even Sat or Sun)(by default if myDate = startDate then WeekOfTerm = 1... but I also want it to work so that if myDate falls in the same Mon-Sun week as startDate it also returns 1. I want to fix it so that regardless of when the dates fall the function deals with whole weeks at a time. Eg. if startDate falls on a thursday then if myDate = startDate //returns 1 if myDate = the Friday after, then still returns 1 however if myDate = the following monday I want it to return 2.

Thanks Gregory I've rebuilt for FM8, but am just waiting on them to purchase software etc. I just find it strange that it should run for so long without incident, and then twice in two weeks exhibit the exact same problem. And Filemaker gives no hint that anything is wrong!!! There's no corrupt file message etc.

Hi all : I have a school-based FM7 DB served using FMS 7 on an xServe to Mac clients (some thru hardwire connections, some thru wireless). PROBLEM: Twice in the last two weeks all the visible fields in all the records in the "students courses" table have lost their data - the records are still there, but all the data has disappeared - text, graphics... everything. ***student courses RELATED TO student details through unique Student ID*** Now this database has been running on this server for almost 3 years without this happening... altho I seem to remember a similar problem back in 2004 when I first built it. You can create new records and any new data appears fine. The blank records still appear in related portals - so somehow the relationship still works I am pretty confident with my security... altho I am not an expert so cannot automatically dismiss a student mucking around in the DB. And anyway that wouldn't explain why only one table has been targeted. We backup everyday and we've gone to back ups on both occasions - the last worked for two weeks and - bang - all data gone again. Any ideas??? Andrew

I've got some quickly shot .MOV files from a small Kodak digi camera that I hold on my mac... unlike other .MOV QT files filemaker 7 will not show the first frame of the movie in my container field... seems to me something a little askew with the movie... any quick solutions?

When attempting to setup administration authentication on FM Server 7 - I'm asked to 'change' an old password and confirm a new password... of course i've just installed it so don't have an old password... and now it won't let me set a new password.... blank doesn't work either... any ideas? Andy Picture2.pdf

Thanks guys... i've decided that the user will just have to live with it - I can't remember for the life of me what had written down in my original script - it had a wee bug which was why i deleted parts of it - but I was sure I was able to abort a complete close... oh well never mind andy

Here's what I have so far... The dialogue box says: "Are you sure you wish to exit?" with "NO" (default) & "YES" Andy

Evening all If I have a CLOSE script which checks with the user to see if the REALLY want to close the database after they have clicked the little red button up in the left corner (MAC) or the X button (Windows), how do I stop the database from closing if they choose "NO" I had it working... and then deleted some stuff in my script and now I can't for the life of me remember what I did.... Andy

I would have thought the most simple thing to do would be do create a catalogue layout in FM and print your catalogue from that. That way catalogue updates would be automatic... You could import graphics from image software - PNG format works well in FM, and layover fields on the layout - I work with a number of Adobe packages, so have a preference for Indesign, but I guess it depends what else you are running... And also how you are printing - inhouse, laser, or offset... I guess if you're sending your catalogue to a commercial printer you really want to be able to deal with a separate file each time.... sounds challenging... best of luck Andy

Oh yeah... duh, god I'm thick, and never used that option before too... Ralph's thoughts are much more coherent.... just as well I haven't given up my day job! A

That's an interesting question... I guess that you can as you can make a field a button by selecting it in layout and then choosing 'specify button...' (right click menu or format menu) As to what happens when you tab to it - i wouldn't know - maybe 'enter'?: HTH Andy