Jump to content

REGGIE MAGER

Members
  • Content Count

    25
  • Joined

  • Last visited

Community Reputation

0 Neutral

About REGGIE MAGER

  • Rank
    novice
  1. Is there a way to find text in a field and make it red and bold? This function is available in Excel but I don't see any options for this in the Filemaker Find/Replace dialog box.
  2. Good morning. I have an Excel file with book information. I have ISBN numbers with leading zeros. I have the column configured as custom/number with 10 spaces. The leading zeros show up in Excel. When I import into Filemaker 10 the leading zeros are left off. Can anyone help so that Filemaker displays the leading zeros? I have the field set up as a text field since some numbers have an X at the end. Thank you for your help.
  3. Good morning, Using FMPro 9 Advanced and I'm having a problem with a script. There are two printers hooked up to the computer, a laser and an inkjet. When I set up my script I have it set to use the default printer which is the laser. Yet every time I try to print from the script it reverts to try to use the inkjet. Any help would be appreciated.
  4. I have the follwing script I use to print envelopes from my invoice table: Go to Layout ["Customer Invelpes" (Orders)] Show All Records Omit Record Show Omitted only Print [Restore; No dialog] This works fine from my invoice table. When I try to print an envelope from my Customers table it only prints the envelope that is the current record in invoices. How can I set this up so that it prints the record that I am viewing from my customers table? Thank you for the help.
  5. Hi. I have a checkbox set with three checkboxes, yes, no, and n/a. Is there any way to reduce the spacing between the checkboxes? Thank you for your help.
  6. Hi. I'd like to know if it's possible to carry a balance to a new invoice for the same customer. Currently when I make up a new invoice it doesn't show the balance due from the previous invoice. Any help with this would be greatly appreciated.
  7. Good morning, How would I go about making a calulated field that would automatically fill in an amount due if an invoice has not been paid in 30 days or has been partially paid. I have my date field, Amount due field, amount paid field and Balance due field. Thank you for the help.
  8. Thank you for the help. That works great. And I learned a lot from your solution. It was frustrating because I thought I needed an If caluclation. This is so easy. Thanks again.
  9. Hi. I was wondering if someone could help with a question I have. I'm trying to do a calculation that needs to find a range of dates. If the date is between 1-1-2009 and 3-31-2009 then it needs to return a statement like "1-1-2009 through 3-31-2009" and then the if statement has to continue and do the same for April -Jun, Jul-Sept, and October-December. I've tried it, but everyting I try always ends up returning everything after 1-1-2009. Any help would be greatly appreciated.
  10. Good morning, everyone. I have a question the about the auto complete feature of Filemaker 9 Advanced. Is there any way possible to have the auto complete feature work with a drop down list that is tied to a value list and be able to click on the arrow and choose from a list of items. Here's an example. If I'm looking for all items relating to "Transmission" If I type the letters "tr" the autofill fills in "tracking bar" with "acking bar" highlighted. If I click on my drop down list it lists everything that starts with "tr" and I can choose from anything on the list. The problem is that t
  11. This one has me totally stumped. I'm creating a database for Matchbox cars. I have a table name Catalog set up that includes: Number, Letter, Variation, Name, Color, Interior, Wheels, Decals, Etc. I have a table named Car Finder. In this table the user can enter pertinent information to find which car he has. Example: If he clicks in Number he can select from any car number. Then he clicks in Name and only the names for that number appear, on down throught the line to where her can select the wheels and description. I've got that set up to work flawlessly. Now for my problem. This is what m
  12. Is it possible to add a table from a joined database onto a form and select items from the table to be filled into the form? For instance, if I want to let users see a list of stamps in the table, then have them click on the stamp name or number to add it to their collection and have it fill in the information on the form. I don't seem to see any information on this. Thanks for the help.
  13. Sorry to ask this question again, but I'm still having a problem with a script that I'm trying to write. While in my Customer database I would like to select the account number of the current record then open my Orders database and copy the account numer into the Account No. field. I tried the following script: Copy [select; Customers::Acct No.] Open File ["ORDERS"] Go to Layout [original layout] New Record/Request Paste [select; ORDERS::ACCOUNT NO.] but all it does is open a new record in Orders and places the cursor in the Account No. field. I know I'm overlooking something
  14. Yes, this is a single user solution. I thought I had to use separate databases and join them together to keep track of customers amd their cars and pull that information into my order form. Is it not possible to use a script to work between databases if they are joined?
  15. I hope someone can help me with a script that I'm trying to write. While in my Customer database I would like to select the account number of the current record then open my Orders database and copy the account numer into the Account No. field. I tried the following script: Copy [select; Customers::Acct No.] Open File ["ORDERS"] Go to Layout [original layout] New Record/Request Paste [select; ORDERS::ACCOUNT NO.] but all it does is open a new record in Orders and places the cursor in the Account No. field. I know I'm overlooking something, but I don't know what. I've tried di
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.