Search results for query: *

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

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

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

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

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

Hello! I have a table called "Invoice". Inside it i have the fields "Code", "Dep" and "Account". In the "code" field I either type a two caracter number or a eight caracter number. I.e. "77", "34" or "32090123", "50112112". The "Dep" field uses the function "left" to find the two first...

Hello everybody. I have a form "frmForm" with two textboxes, "txtText1" and "txtText2". In "txtText1" I insert nubers varying on lenght from 2-8 digits. I need "txtText2" to automaticly show the first two digits from "txtText1". How do I do this. Preferable in VBA. Thanx. Chris

Hello. After having created a huge database in MS Access 2003, I feel like trying to make one in Filemaker 7. But I have some problems... Please help me... I have a table called "Transport". Within this table I have some fields called "shprZip"(number), "shprCity"(text), "rcvrZip"(number)...

Hello. I have a subform [frmMeasurements] inside a form [TrspOppdrag]. The subform has the following txtboxes: *[txtMeaID] - Autonumber *[txtCopyTrspID] - looks up value from a textbox in main the form called [txtTrspID] *[txtnumber] - manually input *[txtlenght] - manually input *[txtwidth] -...

Hi. I wonder if there is a way to enable "Visible" view by clicking on a button or a "+" graphic symbol. I have some windows in my forms that are set to non visible by default, and I need them to get Visible for adding new records, either by a "Add" icon or a button. Chris

Hello. I do have a login form that checks username against password, to allow access into my database. (The code is underneath) The code works allright, checking for username and password, but I want to be able to "put" the username [cbo.Brukere] into some text boxes elsewere in my database...

Hello. Is there a way to line color a listbox. I.e. every other line is light blue. Then when you look at the listbox the lines are white, light blue, white and so on... The text itself would remain standard black. Chris

Hello. I need your help to make this work. Any ideas that may help me, would be great. :) At this time I do have a form "TrspOppdrag". Shown below... On this form there are some text boxes: [Fra postnr] and [Til sted] which are the "zip" and "town" of the sender [Til postnr] and [Til sted]...

Hello! I have a form called "Kunder" Inside this form there is a combo called [SøkFirma]. (It is places in the top text window of the form) This combo shows three values based on the query: SELECT Kunder.Firmanavn, Kunder.Kode, Kunder.KundeNr FROM Kunder ORDER BY Kunder.Firmanavn, Kunder.Kode...