Search results

StatusKolone is text field...I just put the number in front becouse it was more fancy to the users? they say ohh if i see 3 Sproscena i will know in the second that this mean that this is relased,... :oops: I could use ony Sproscena for the status item. Only released. I am using here...

Ohh yes I know I am so close and so far I will think another possibility how to prevent that user will go to regualar analysis if the item is not released...

ohh wrong the status of the item is Sending is not relased yet..and Me.StanjeSproscanja ( mean= if the item is already released). becouse the item is not already relased Me.StanjeSproscanja is empty field... and becouse of that access is saying me invalid use of null? becouse I told him it must...

Hi Pat yes I will not use Elseif. I will try to combine if-then-else and select cases from now on . With the code who show me cheekybudha I get error run time error 94 Inavalid use of null error Becouse the StanjeSproscanja is not having the status (3) Sproscena. It has another status in my...

Hi cheekybuddha I try to implement your help with the code but Is not working like I want. I will look again to see if I have covered or possible conditions and I will try again to put select cases. Maybe later if I managed something you can check again the code to see if I am in correct way...

Yes I start to put inside elseif and then I didnt undertand nothing. Part of the code that I want was correct executed part of the code not and then I start thiking that I need more practice to undertand if- then- else statments. This is basic and is shame of me that I get into disaster. Now I...

DocMan Yes I make a list of words from my language so you can know what word mean sometthing.

Yes I will put like you say. I will batlle with if statments again tomorrow and on for the weekend so I will came back to inform you what disaster i will create. ohhh :oops: I am so embarased for my coding and my stupid questions. You are all experts and me nothing.. :( DocMan i will...

I am total amateur in ms access database. I learn a lot from this forum and a lot of internet. Yes I know Pat that I Have to practice if then else this is basic and i am like stupid.. I am just confused with elseif. I was using if-then-else in another situations and on this problem I start...

I will write what is my problem. I have to check 8 different conditions. I have very very complicate database. I need some example from you experts so I will know and learn how to do that in my form. Before reading all my disaster of coding...(I know that I need to practice more if elseif...

Hello Pat, yes sorry if I say wrong. I was thinkinig that is better to use select case then if -elseif-elseif-statments? I know that if -then -else is almost everywhere. Can I ask another question? If you have to check 8 statments how would you start? 1. if 2. elseif 3.elseif 4.elseif 5...

Hello experts ohhh I see. So you reccomend to use case statments. So that mean that in your coding you use 80% case statments and 20% elseif? I was trying to read some code with elseif statments and I get lost, so I start thinking that maybe I am not good in that. :unsure: Becouse of that I...

Hello experts I need some help. Can someone who has a time prepare me some 5 difficult problems or more or some good example in which I will have to practice: IF Statements IF… Then… Else Statements ElseIF Statements Nested IF Statements Select Case Example something like that Or If...

So then that is possible to create? ok thank you

Hello Arnelgp Nice example. What about if the text field is very big? I know it must me some size limits? Then the message box dont display all what is in the text field? it is possible to make scroll bar like in the text field? Thanks

Yes. That exatly is the goal of my database. When the item will be destroyed some day, user can not choose it and can not used for analysis. I hope now I am in correct way with my plan. I am enginner of chemistry and pharmaceutical tehnican. :) :giggle: and you are Phd Chemist very niceeeee. :)

Ok so my story is next: I am making database of some items used in pharmacy and chemistry. I will have 4 different type of items. ( imagine: chair, mouse, window,pencils) Items will be conected on different systems. I will have for now 3 different systems. ( ford, toyota, bmw). For now i have...

Helloooo yes I think now I understand what I make wrong. I make wrong my design. I should never put the status in first table, table A. This was my big error. this opens my eyes The_Doc_Man and this opens my eyes Pat Hartman: I didnt know that. Thank you very much The_Doc_Man and Pat...

Hello Thank you for your explanation. Can we talk here about normalization? I will also study that. ok so you mean that I have to create 3 separate fields? ford, toyota, ferrari and all that in one table?table B?ok now i have one field called system type and then here user choose which system...

I have one primary table = table A , here is the basic info of the item and here starts everything then this item from table A can be used on 3 different systems ( imagine: ford, toyota, ferrari) this mean 3 different tables? ( table B ford , table C toyota, table D ferrrari) when user start...