Recent content by dimitris9

I finally solved it! (Actually in a very similar manner, not what I wanted exactly, but pretty close) It is a good thing to leave everything for a while to clear your head and come back fresh. So, after all, what I did was very simple. I have a value "available jackets" in my coats table. It is...

Thank you, I just saw your message as I was away in a business trip. I will check it a bit and let you know. P.S. I know you are Greek but for the sake of the forum I kept all answers in English. Eυχαριστώ

This is the database. Thank you

I am a little lost! Say the status field, is the availability field I already made. The query with the availability field and everything from the export table doesn't work for some reason. AlexN, how do you make the availability field as a criteria? Burrina, how do you make the update query to...

It doesn't work. I tried adding a new yes/no field which I called availability, made the query with all the fields from export table and the availability field from coats table (they are linked by the relationship between CoatID), marked to show only avalable items, but when I run the query the...

If I do it like that, I would have to add another field to my coats table in order to make the query, right? Every time I am making an export though I would have to tick the checkbox to indicate that the coat is gone. This might work. I will try and let you know. Thanks.

Thanks for the reply. Let me explain a bit better why I need this. I have build an inventory database. My job is fur coat manufacture. So every day I add to my inventory new products I made. They all have a barcode which for ease of use in the database I made it to be the primary key of the...

Hi, I need some help please. I have a form with a combo box in it. The combo box takes its values from a table through a one to many relationship. What I need, if possible, is when I select a value from the combo box, in the next form entry this value to be gone from the combo box. For...

Hi, Thanks for the answer, but access does not let me save as earlier version as there are some things used only the newer save formats

Hi everybody. I own a small fur factory and I firstly want to track my ready made coats which I send from one retail point to another. I need your help with a problem I have with my database. (It is attached) First let me say that I haven't worked with access for many years. So, I have a...

who came from

Is it weird that I get very annoyed with mistakes people make when they write

Thanks, I am new to programing (I 've done only basic stuff years ago) and I think that this course will be what I need to get started again

IMHO guns are only there for the worse. Reading statistics, people are most often getting killed by their own guns.

And my beater is 2002 Toyota Corolla hatchback in sky blue.