Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: machtenx
  • Content: Threads
  • Order by date
  1. machtenx

    Need help with Numbering system

    I have a purchasing system which has a PO Number composed of the date, purchaser's initials, and if it is a second PO for the day it becomes 1, 2, 3, and so on. So, for example if on 7/29/2004, Bob Thornton was going to make his second purchase order form of the day, his PO number would be...
  2. machtenx

    anyway to keep empty portal rows from printing?

    I've got a database that displays 4 portal rows. However some records only need 2 rows, yet when we print there is a 3rd empty row displayed (the one where you'd put the next portal row in) How do I make it so that this row doesn't show? Limiting it to displaying 2 rows is not an option since...
  3. machtenx

    Please help... This relationship doesn't work!

    Ok, I have two databases, one for Sales Invoices and one for customers. Inside the Customer database, I have a portal that shows the invoices for the particular customer. It was working fine when I specified the relationship for each record to correspond to Last Name. I realized this was an...
  4. machtenx

    is it possible to use a calculation as a primary key?

    I have First Name and Last Name combined in a calculation in two files. Can I use this calculation as my primary key in a relationship? what is a way around this? I don't have any other possible primary keys
  5. machtenx

    password cracker

    I've got a database with vital customer information for our company but the last person left without leaving the password to access certain layouts. is there any program that can crack the password for this? seems simple enough
  6. machtenx

    combining first and last name

    I want to combine the fields First and Last name into one field called Full name. I tried using a calculation but the field stays empty for some reason What am I doing wrong?
  7. machtenx

    any way to have filemaker print certain record twice and another not?

    Is there anyway I could put up a flag in the record to tell filemaker that when it prints this record it should make "x" copies?
  8. machtenx

    how to make a line item in a portal do a lookup?

    I have a DB with Invoices that contains a portal to a DB with Line Items. For each part number, there are two fields specific to that part which I'd like to automatically fill in. I have a part number database which contains records for each part number and values for the 2 specific fields...
  9. machtenx

    How to get a count of items in an customer record?

    I have a database of customers, inside that database is a portal to a database of invoices. I want to find out how many of a certain item number they have purcashed. I tried using the exact function in a calculation field but it returns only a 0 or a 1. how else can I get it to count how...
  10. machtenx

    best way to lock a record once it's complete?

    once I've printed/processed a record I want it to lock so that it can't be deleted without being unlocked. What's the best way to do this?
  11. machtenx

    anyone interface with MYOB?

    http://www.myob.com/us/odbc/ I wish I could use this interface however we are running macs and it is not compatible. has anyone used this interface? how is it? does anyone have a replacement for such a tool?
  12. machtenx

    switched from mac to pc and now applescript doesnt work

    obviously because there is no applescript in pc's.....my question is are there any replacements for applescript? it sucks that i have a gap left open in some of my major scripts, feel like im back to square 1 any help would be appreciated. Thanks, Matt
  13. machtenx

    interfacing invoicing with inventory system

    ok I have a database for invoicing, and the plan was to have a button with a script that copies and pastes the part number, searches for that, then copies and pastes the quantity of that part and pastes it in the inventory field. problem is how do i get filemaker to add these two numbers? also...
  14. machtenx

    Filemaker Invoicing Database is Laggy

    Responds very slowly, sometimes locking up. How can I clean it up besides just backing up records?
  15. machtenx

    How to make item numbers for a packing slip

    each packing slip is a record. I've created a portal which lists each item. I need to have an item number for each object. auto serial wont work cuz for each packing slip it needs to start at 1 any help is appreciated very much. thank you
  16. machtenx

    Printing a number of copies of each record dependent on field value

    So the need came up for me to be able to exclude certain records from a print. So I made a field with a radio button value 0 or 1 and made a script with a search right before printing to find those records whose value was 1 therefore the 0's do not get printed. What I would like to do is...
  17. machtenx

    hacking filemaker?

    I set a password with limited priviliges including no menu access. I also set filemaker to automatically try the limited password, so now it's impossible for me to enter the admin password to get back in. :( what do I do?
  18. machtenx

    best way to hide a field

    I have a field for price. I want the admin to be able to go in and edit its value but I do not want the production users who use the same database to be able to see this value when they use the database. I was thinking of using passwords but I'm not sure how exactly to do this. Any help is...
  19. machtenx

    listing of error codes?

    is there somewhere anyone knows that these are listed with what they mean?
  20. machtenx

    Repeating Fields or Portal?

    This is what I'm trying to accomplish: I need to make a form for a clerk to enter orders into. Clients request one type of product to be delivered on several dates, each date has a quantity delivered. I created repeating fields for this purpose and this works fine so far until I was recently...

Part and Inventory Search

Back
Top