tinac

I initially experienced some difficulty running FM on XP, but after setting the compatibility feature it runs most of the time. To access the compatibility settings, right click on the program file & select Properties. We are actually running FM 4 (still in the dark ages here).

[color:"blue"]So do I start from Excell and Import the Data from Filemaker? You can go in either direction. If you are starting with completely new data, I'd just start with Excel & then import to FM. However, if you already have some of the info in FM & just need the other user to fill in the blanks, you can export from FM (.tab or .csv) & then open that in Excel. [color:"blue"] how do I extract the information that is in Excell to my Filemaker fields. Ok, when you go to do your import from the Excel file to your FM DB, it'll give you a box with your field choices. Simply match up the data from Excel with the correct field you want it to go in.

I don't have a magic genie, but maybe I can help. I'll start out by saying I don't have any brilliant ideas on how to accomplish what you want with Word. I wouldn't say it can't be done, but nothing jumps out at me. However, if you have Word, you probably have Excel too. If you set up a spreadsheet with the field names in the top row, your user can enter the data on the rows below (one row for each record). Then, they would email it to you & you would import into FileMaker from that Excel spreadsheet. In my mind this would be the easiest method for you to get info into your DB from users who do not have access to FM.

A couple of suggestions. Have you selected at least one item in the layout. If nothing is selected, the Align is inactive. Also, have you gone into the "Set Alignment" command & selected options? If it is set to "None" for both options, the Align option is inactive.

There are several ways I can think of to accomplish this. One that should be fairly simple would be to create a summary field for vendor (doesn't really matter what kind of summary, I'd use a count) & then create a new layout with just the vendor field. Go to Part setup & change body to Sub summary when sorted by vendor. Then, when you do your find, be sure to sort the records by vendor. You should be able to print that new layout & get a list of vendors. (Note: if you look at the layout from Browse mode, it won't show anything, but if you do a preview the lines should be there) Hope this makes sense

In layout select the field & select "Sliding/Printing..." (under Format). Tell it to slide up & check the "Also reduce size..." box as well.

If (ShipMethod = "Ground",5.95+AddWeightCost,If (ShipMethod = "2Day",8.95+AddWeightCost2,If (ShipMethod="Overnight",14.95+AddWeightCost2 ,"Enter Ship Method"))) Should do it. What you are missing is telling it what to do if your ShipMethod doesn't equal any of the three options. You could actually change that last argument to be whatever you needed. Hope this helps.

I'm having problems importing pictures into a container fields. The first time I tried, there was absolutely no trouble. However, after shutting down the DB & re-opening it, FM is no longer able to "see" the pictures on my computer. The "Files of Type" field is defaulted to "All Available", but when you click the drop-down there, the only type available is "*.CGM". I've experimented with this on several different computers & it seems that it does this every time. If you uninstall FM completely & re-install it, it'll work again for one time only. Am running FM 4.0v3 on Windows XP. Not sure if its caused by an XP conflict or something else. Any suggestions would be appreciated.