Search results

thats exactly what I did. Took me awhile to figure that is the easiest way ( well easiest I discover,hehe) Thanks anyway

Since you helped me oh so much 1 more little thing: Is it possible to have multiple selection from combobox in form?

thats it now just be so kind ,even without super powers,tell me where do i enter that combobox.requery

First of all I owe you apologie. I am on this DB of mine for last few days ,and getting close to solution and then again opening new problems sometimes can be frustrated. I kinda redesign my DB,what I did I add another field in my items table which can have values 0 and 1 ,representing is that...

Why is very good question. I realize I can not get what I want in this way,simply because running table make query overwrite exisiting table which means that new created table cannot be in relationship with others, so lets forget I asked anything in a first place Thank you for your reply though

I find more elegant way to do what i want to do. Instead of comparing 2 queries i simply add another field in table which have value 0/1 which indicates weather I show item or not Thank you for your help

I figure it out thank you

Hi How can I make table make query run when i click on add new record in my form,or when i exit form?

and I would still need code because my VBA knowledge is not, hm let say ,very representable,;)

Actually it should be done only when i enter all fields data in.. I am trying to make equipment sign in/out database,and that would give me table with available equipment .In form I actually assign peace of equipment to person and runing that query would remove that item from available ones.(I...

Is it possible to do following: On saving new records in form to force access to run table make query? If doable would you be so kind to write me example code

maybe you can help me with something else Both tables have ItemID field. In my old form under properties of ItemID I set SELECT [ItemID], [Description] & ", " & [Make] & ", " & [Model] & ",SN# " & [Serial] FROM Items ORDER BY [Description] & ", " & [Make] & ", " & [Model] & ", " & [Serial]...

I have finished form created from 1 table and now I would like to add another field from another table to that form.How? I tried with adding textbox and then setting source to table and field i wish it represents ( tables are linked)

forgive me,I am trying whole day to make this work,and this is a missing link ,and you are absolutely right. But I still do not understand how will INOUT get value 1 if I just add code you put in previous post in RETURNDATE ? P.S. I am humble and very greatfull for help I receive from this forum

You didnt understand me. when RETURNDATE is entered i want that to trigger change of value of field INOUT to 1 (its default value is 0) So some kind of IF should be applied i presume

english isnt my native as you can see,so let me try again. I would like that when I enter some value to field RETURNDATE ( In form ASSIGN) that action automatically change value of field INOUT(also in that form) to value lets say 1. (Field INOUT will be invisible)

What I want to do is following. In form ASSIGN(fields are takedate and inout) ,if TAKEDATE is different then 0 then set value of inout field to 1 My VBA knowledge is poor cause i dont think this should be hard thanks in advance

OK here is what I am trying to do.Database which should help me do equipment assignement.Some items will be taken ,then returned,then reasign to someone else etc. I need to have history tracking aswell. I would like to get some kind of system which will prevent assigning same item 2 different...

now could i get it in english,i would need more help, like few steps extra,my knowledge isnt on that lvl

I am still trying to make item assignement database.( same items will be issued to person,then turn in then issued to someone else,etc). Is it posible and more important how to set up yes/no thing that would set yes for each item everytime i enter issue date,and switch it back to no when I enter...