caman

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?

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

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

Perfect! Thank you. Christian

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

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

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

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.

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

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

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

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

Thank you. I guess I'll get the hang of it now... caman

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

:thumbup: Thank you. This is what I'm looking for! caman

Hello. I need help to set up a function or something similar, that would work as a "unique identifier" for a field. The "unique identifier" shall only let me know of a unique value if there are more than 3 caracters in the field. What I am looking for is almost the same as the built in "Unique value" function that is under the "Validation" tab. But if I choose that function, it will validate all of my input in my field. I.E. I got a field called "Dep_number" wich I can input numbers up to eight characters. I usually input two or eight chatacer numbers in this field. I don't want it to validate my two character inputs as unique, but I want in to validate every input with 3 or more characters in it. Does this make any sence???