Recent content by Swedude

Could be. I'm a total noob at Access and there's not much time left. Maybe I could use those queries for the "Search for Client" button as well as the Register Client form? That would be an upside.

It's a school asignment, it won't be used by anyone. Maybe you guessed that already, though. :P But in theory it's meant for workers who will be able to register new clients. There's no specifications regarding restrictions to database access. As for the query, if I want the zipcode/seller...

Why shouldn't they? And where do I put in the name?

Tried that but can't get it to work. I put 2 in the parentheses. What goes into the "mycombobox"? The name of the box or something else? Name doesn't seem to work.

Nope, only got tables and forms so far. Is that bad?

Hmm, query? I'm making a form for registering a new client. It's based on the client table.

Access 2007. Got a form with a few combo boxes containing options. Each option concerns a First and Last Name. In the list, they show up as this: John | Doe But when I pick an option, only the John shows up. The same goes for my, or what is supposed to be my zip code + city combo...

Is that the option at the bottom for field data type? Stupid Swedish version. Edit: I used it and it seems to work better at least. But even though I include zip code and city, it looks like this: 000 00 | City in the drop-down list but when I choose it, the field just says 000 00.

Tables, sorry. They're related, yep. How do I go about making the combo?

Anyone? Kind of stuck until this problem is resolved. The form isn't very good with what amounts to four ID fields...

It's the latter. This is what 2 of the classes look like: Customer (a company): CustomerID - counter Company name - text Customer Group - number (foreign key) Customer Type - number (fk) Zip code - text (fk) Adress - text SellerID - number (fk) Hopefully if I learn how to do this with one...

So I'd need the combo box instead of the list box because the field is a foreign key? I take it if it were a "table-internal" field, a list box would suffice. Not that I know how to put in either.

Been trying to find info about this but it's hard to find the exact question I have, especially since, being in Sweden, the program and help file is in Swedish. I'm using Access 2007 and I'm supposed to make a database. What I'm wondering is the following: I have a bunch of tables such as...