Search results

Hi Yes English is my second language...i speak 7 languages... I understand what all of you are saying.. it is me I just do not know how to make that with one or 2 querys? I have one primary table and then 3 transacion tables ( 3 diferent systems which can use the item, but one item only one...

Hello yes I know I was thinking wrong. Becouse of that I ask for experts opinion. I know that the status must be from the transacion table. But becouse I have a form with all the data from the begining and I also have status there and there is where the user then check all the data. hmmm maybe I...

Hi yes I will try also that and another idea you suggest me and arnel. thank you very much

User will put the status New ( when he will enter the item into database for the first time ) in form A and the status will go in table A. Then he will not touch the form A and status in table A anymore. He will then only use form B and item status that he will use will be stored in tableB and...

Hi Yes I all understand that status must be always in one field and in this case in table B. But becouse all starts from table A when you first enter the item and here you first time set the status i have to have that table A also updated when the status changed in table B. ohh I make it all so...

Hi The Doc Man, i see your idea . Yes I know is better to have status in transacion table but is also important for table A becouse there is where all started. Can you show me some example how to do that? I never did join query? if you show me some example then i will try do it on my...

Hi yes i see it. thank you. ok this is almost perfect, but let say last status of the item was sended? you want to put in use and then you cancel? the status must be sended becouse that was the last status? how to do that ?

Hi again I make some example what is my problem. If you can check.

yes is important to have the same status, becouse in that way user will know if item is in use or not. hmm which form you mean? form A you enter items, form B you enter usage data for the items from table A the form B which user use to enter usage data? form B table B is automaticly...

Hello Status is in the table A and in the table B. Becouse the item always has to have the status with him. Is like library system but I dont know how to do it. How to prevent updating data when user say no to save or close the form. I just doont know how to say to vba cancel update? Where to...

Hello experts, I need your opinion how would you make this in the database. I have problems with the statuses. I am not sure if I plan that correct or not. You have 2 tables. Table A and Table B. Table A = contains specific information about your item ( name, date arrrived, serial number...

Thank you Gasman I just didnt know how to write correct syntax :oops: thanks :)

I just write it I am asking anybody who maybe know hmmm I try it and I get C0 instead of Cs2022-001

Hello DocMan yes I just find some code for timers and i say ok i will test it to see how that works. When I developing i am not using timers. I just wanted to see if it is working. Then few days I dint touch access and I forget to remove the timers and then this anoying error 5 started to show...

yes i see thank you very much now i have a lot of work to do...check all that...test... ohhh you save me..:) i was already thinking to do all again from the begining one by one and i have a lot of that..

Hello Arnelgp yesssss yessss. Your code now is working. Now I will check all my forms..becouse I have 4 forms that are creating special ID. I also try compile and repair button and is working. no more error 5. !!!!!!!!!! It seems it was realy error here..but why? What was causing the error? do...

OK maybe I am crazy... I make this. Again I take some old database ( delete all the objects) and import all the objects from my last database. This work perfectly. Adding records is working the code which was yellow marking is working good. This is now My new database Db001. Then I start...

Hello yes I delete the idle time. I dont have that anymore.

I am attaching the database. The code works correcty if the tblKolone2 is empty. You then start new enter and access generate K2022-0001. This is perfect. Then you want new enter..you expect K2022-0002 and we get the error. error 5... why? then i delete all the records in the table...

Hello Arnelgp yes i have a field memo Updates. I use your correction now but I still get error now in another code like yesterday. I Dont understand why....this code was working perfectly all the time... I try debuging and access is showing all the time now that here is the error? whyyyyy Do...