Jump to content

caman

Members
  • Posts

    16
  • Joined

  • Last visited

About caman

  • Birthday 03/11/1974

caman's Achievements

Apprentice

Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. Hello. I'm looking for a simple warehouse database with locations/bins and picking. The Ex Biz Tracker 2, is far along what I'm looking for, but it lacks the bin solution (only got stock) and the picking solution. Any ideas on how to implement that?
  2. Hello. Thank you for that informative video. But... I might be a bit sleepy, but as far as I understood, this only works when creating layouts for previewing, and not in standard browse mode... If there is something I've missed, please explain. Christian
  3. Hello. Another question; I do have, in my db, a single table. I have the fields: "ID" "Productnumber" "Location" "In_Stock" "Total_In_Stock" My question is; I have several productnumbers, both with and without letters/ numbers, but they are not unique. Each Productnumber is given a location. Each Productnumber with Location is given a number in stock, from 0 to 2000. Each location is not unique to that productnumber. But, I might have the same productnumber several times, but with different locations, and different number in stock. I need the field "Total_In_Stock" to count the total number in stock for each Productnumber. I.E. I have: PO# "920-580" on Location "H1" with 2 in stock, and on location "291504" with 7 in stock. The "Total_In_Stock" would be 9. PO# "MayOS" is located only on Location "VM2" with 4 in stock. The "Total_In_Stock" would be 4. You get my drift? Regards Christian
  4. Hello. I do have, in my db, a single table. I have the fields: "ID" "Productnumber" "Location" "In_Stock" "Total_Locations" My question is; I have several productnumbers, both with and without letters/ numbers, but they are not unique. Each Productnumber is given a location. Each location is not unique to that productnumber. But, I might have the same productnumber several times, but with different locations. I need the field "Total_Locations" to count the number of unique locations, for each Productnumber. I.E. I have: PO# "920-580" on both Location "H1" and "291504". The "Total_Locations" would be 2. PO# "MayOS" is located only on Location "VM2". The "Total_Locations" would be 1. You get my drift? Regards Christian
  5. I have a field in my DB that contains the shipdate for a shipment. Is there a way to set up a popup reminder, let's say two workdays before the actual shipdate? If the actual shipdate is on a thursday, the popup will show itself on a tuesday. If the shipdate is on a tuesday, the popup will show on friday. If the shipdate is on monday, the popup will show on thursday. Thanks for all help! Chris
  6. Hello. I would like how to filter a portal list on each keystroke. Let's say I'm searching for a name in a portal list. I Type A; then Anna, Adam, Adolf comes up. When I type the next letter D (ad), then only Adam and Adolf comes up. How can I make this work?? Thank you for the effort! Chris
  7. Hello everybody. Is there any way to have the drop-down list to display more values than two? I.e I want the drop-down list to display Firmname, Adress, zip and phonenumber. I use the drop-down list to choose senders and receivers in my transport registration db,and I have several firms registrated with the same name, and therefor I need to be able to see the rest of the info, before choosing firm.
  8. Thank you Lee. I modified your suggestion, and came up with something that worked well for me. What i came up with was: Left(GetAsText(GetAsText(Firma) & " " ); 15 ) Chris
  9. Thank you for your replies. I'll try to explain what situation I'll use this in. In my db I have several tables. One of them is called 'customers', one is called 'transport' one 'transreg' and so on. The 'customer' table has several fields... 'firmID', 'firm', 'address', 'zip', 'summary' and so on. The 'transreg' table also has several fields, including one called 'firm'. The field 'firm' in the table 'transreg' is formatted as a drop-down list. This drop-down list pics its values form the value list 'cutomers', that pics its value from the field 'summary' in the 'customer' table. This way I can get more info when using the drop-down list, before doing a selection. As of now I have been using a calculated value 'Firma & " | " & Avdeling & " | " & Adresse1 & " | " & Postnr & " | " & Poststed & " | " & Tlf & " | " & Fax' What my intention is, is to make a fixed size of each "department"(in lack of a better english word) between the |'s. Did this make more sence?? Chris
  10. Hello. I have a textfield "Test" and a textfield "TestFill" In "Test" I can write whatever and "TestFill" it will "mirror" "Test". What I want is to make "TestFill" automatticly be 15 characters, even if "Test" is 8 or 15 characters. Example: If I in "Test" have written "Testing" "TestFill" will show " Testing" (also adding 8 blank characters) Is this possible? Thanx Chris
  11. Hello. I need help with a small problem. Among a lot of fields, I have the field "cust_nr" and the field "cust_name". They are both located in the Table "TrspReg". I have set both "cust_nr" and "cust_name" to work in a drop-down list. Now, here is my problem. I want to be able to i.e. enter the customer id number in the field "cust_nr", and then the customer name shows in "cust_name" (this I have mede work), But I also would be able to enter the customer name instead of the customer number. I.e. I enter the customer name in "cust_name" and the customer number shows in "cust_nr". That I cant meke work... I need to make each field be replaces by the last input from the other field... Can anyone help?.. Thanx! caman
  12. Thank you. I guess I'll get the hang of it now... caman
  13. Hello. In a report you can use ## to show what page number you are viewing. How would I make it say page # of #? For example page 1 of 4, page 3 of 7 and so on . caman
  14. :thumbup: Thank you. This is what I'm looking for! caman
×
×
  • Create New...

Important Information

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