outdoorsportz

Hello, We currently have 4 systems on our network, 3 Win 98's, and a new XP. We want to XP to act as the host. We are now running FM 6 on all systems. I am stumped with a networking problem. If open our DB on the XP, I can not open it as a guest on any of the other systems. The open files do not show up in the Open Remote. If I move it to one of the 98's, all other computers (including the XP) can access as a guest perfectly, so this should mean file sharing is properly set up. The XP has the Remote Data Access Companion box checked, and Zone Alarm is set up exactly as the other systems. Would this be something in the XP system's network setup, or the XP's internal firewall? Do I need to specify a host? I am new to networking, and this is my first effort. Thanks, Steven

Hello, We have just started sharing our FileMaker databases on our network. We have four Windows systems, three 98's and an XP that is acting as the host. The db files are stored on the host's system, in the shared files. My problem is that when we open the files up on the host system, is gives me a message that it is opening the files from a remote volume. I hit "ok", and it will open everything fine and still act as the host. Any idea why this would say that the files are being opened from a remote volume when they are on that system? We are using FM Pro 5.0.

Thanks, It looks like some these ideas may work for me. Please excuse my horrid spelling, the whorehouse is another project.

So I have designed an inventory control system for our wharehouse and retail use. We are implimenting bar codes in our system, so I need to print out bar coded labels whenever product is received. Simply put, we need to be able to print the number of labels to match the quantity of merchandise received. So if we have received 4 T-Shirts, 4 labels need to print out. In the Inventory DB, there is only one record for that T-Shirt, but we need that record to print 4 times. Is there any way to print a variable about of copies based on a field value. We are using a PC, with FM 5. Thanks

I need to export from my FM inventory sytem to Quick Books. Quick Books needs the data in an ".iff" format. FM will not export in this format, and neither will Excel. Any ideas how to get my FM data in to Quick Books? Steven, Outdoor Sportz

Hello, I have an inventory control DB that involves an INVOICE, INVENTORY, PO, RECEIVING, and PRICING?DESCRIPTION. The wholesale costs are in the INVENTORY DB, and I need them in the PRICING/DESCRIPTION DB. The WHOLESALE field in PRICING/DESCRIPTION is a lookup of INVENTORY. The lookup seems to work fine, but if a change is made to the WHOLESALE field in INVENTORY, the change does not occur in PRICING/DESCRIPTION. I usually need to copy and paste the PRODUCT ID field in itself for the change to be made. Am I doing something wrong that will not allow the lookup to instantly make the change? Thanks, Steven

I have been playing with my scripts using pauses and such. I can't see any particular problem. The real problem I have is that this only occurs in certain records. If it happened in all records then I would think that the script was at fault. But this problem picks certain records, and consistantly enters bad numbers, while other records have no problems. I have tried deleting the record and making a new one that is exectly the same, but it does not change the problem.

My db is a multi-user system, but this problem started before I linked up to another user.

Hello, I have created an inventory control database. It seems to work fine most of the time, but occasionally, I get some funny results from my scripts. For instance, In the Purchase Orders database, a script takes the Qty and uses a SET FIELD in my master database to adjust the ON ORDER Qty. Occasionally there are numbers coming out that did not go in. My script is a very simple operation, mostly a SET FIELD and a FIND based on a Global Field. How can this happen to me? The script is only addition or subtraction. Thanks,

Alright, I have installed the font into my system. So now I have a field that I want to make into a Bar code (UPC-A). Will this handle alpha-numeric codes? If not, is there a type of bar code that does?

So I have downloaded a font, how do I install it for use in FM? I don't see any way to do that. Thanks,

I have never heard of that. Where can I get it, and how do I impliment it?

Hello, I know that Filemaker will read barcodes with a wedge scanner. How can I print the codes without using other software?

So I have one more little problem. The finds using global fields works great. After I perform the find, I use a "set field" to modify a found record. The results of the find are always such that only one record is found, and I want to set a field in that found record. When I perform this script, the finding part works great, but another record is affected by the "set field". This record is not among the found set, and my script only consists of a "set field" after the find. Why would this happen?

I tried the solution of using global fields, and that seems to work. It also seems like a better solution than the one that I had thought up. Thanks

I think that I have narrowed the problem down. When I use the step: GO TO FIELD[iNVENTORY, "PRODUCT ID"] by itself, it works fine. But when I add the ENTER FIND MODE step to it is does not go to the field, but stays in the current DB.

Hello, Here is the script: COPY [sELECT, "PRODUCT ID"] OPEN[iNVENTORY] ENTER FIND MODE GO TO FIELD["INVENTORY::PRODUCT ID"] PASTE[sELECT,"PRODUCT ID"] GO TO FIELD["SIZE"] COPY[sELECT,"SIZE"] GO TO FIELD["INVENTORY::SIZE"] PASTE[sELECT,"SIZE"] PERFORM FIND SET FIELD[iNVENTORY,"CURRENT INVENTORY","CURRENT INVENTORY + QTY"] That is the general script. I also add some other things to end the script if there are blank spaces or if the script has already been run on this record, but I only add those things after the main part of the script is working.

Also, to add to my previous post. I usa almost the exact same script in other DBs to do almost the exact same thing, and have had no problems.

Hello, I have a script that I use in my "Recieving" database that does a find in another database, "Inventory", and then adjusts the levels of inventory. The problem is that when I run this script, the finds are based off of another record in the " Receiving" database. It does finds based on 3 diffenrent fields, and then sets a field in the record that is found. Why is the script jumping to another record when it runs. There is no "Go To Record" steps involved. Thanks, Steven

Hello, I have a series of different databases for our buisness. They are all linked to one that is called "Home". From "Home", I link to all of the other databases, "Inventory", "Invoice", "Purchasing/Recieving" ect.. In all of the inidividual databases I have a script to sends the user to "Home" It is nothing more than the step Close[invoice.fp5] For all but one of the databases, this works fine. But in one, the script runs but nothing happens. What am I missing? I am not any advanced user so I may not be using the best tool for the job. Thanks, Steven

We have a record, in the record is a field that has info separated by colons, Ex: blue:green:black we want to make a pull down menu with this information. We can't figure out on how to make filemaker recognize the ( in the field, so that the pull down menu sees each bit of information as separate info. We know how to enter the info to make a pull down menu, but not how to make it recognize what is in the field. Thanks