Recent content by caman74

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. 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...

Have you considered using the FE on a network share and pointing the users to that as a desktop shortcut" Yes I have, but I belive that the amount of data that needs to be sent, would be a muche heavier load on the network, than using the fe on each local computer. Correct me if I'm wrong, but...

Thank you Jontout. We have static IP addresses... Then the answer is that if I split the Access DB into Access fe and SQL be, and uses IPADDRESS\SQLEXPRESS connection, before packaging and distributing the solution, all of the workstations will be able to connect to the db (as long as they are...

Hello. I'm designing a rather simple calculator, using MS Access 2007. I've got some tables with various information, and I have a link to two excel 2007 workbooks, located on a network server, containing information used in the database/ calculator. Since we will be using this db on a local...

Hello. I've been using Filemaker for some db development, and I liked the search method there, and I'm wondering if there is any way to make this work in Access. In Filemaker there is one search button, that "turns" the active form into a search form. It will search for records depending of...

Hello! I have a db created in Access 2003, that I'm rebuilding in FM. I prefer som of the GUI's in Access, and I'm trying to recreate some of it in FM. I wonder if there is any way to have the drop-down lists to display values from more than two fields. The reason I want this, is that I use...

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...

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

Thanx, I'll give it a go...

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...

Hi. I have a textbox "txtNumber" that contains either two or eight characters (numbers). I also have a textbox called "txtDep". Both textboxes are placed in the form "frmTrspInv". What I need is when I input a eight character number, to have a popup box let me know if there are any identical...

Thanks. Exactly what I was looking for! Christian

Hello. I have a textbox "txtNumber" that contains either two or eight characters (numbers). I also have a textbox called "txtDep". Both textboxes are placed in the form "frmTrspInv". What I want is when "txtNumber" loses focus it will copy the first two characters into "txtDep". I know this...

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...