Search results

Now please go through your posts and tell me how did you helped me? All the time I thought that you do not understand my problem,but you never said that and all you did at the end is complaining on my typing shorcuts.

is there a way to separate fields in new field with ,

How can I merge 4 fields from 1 table into new field which will look like: field1,firld2,field3,field4 pls help

Could any1 help me with code for this thing pls

When i do that i got ENTER PARAMETER VALUE window open? This is probably triviality but not for me

could you please be more specific both queries have 4 fields same fields : DESCRIPTION,MAKE,MODEL,SERIAL QUERY1 contains items that I dont want in final query,and QUERY2 have all items . So how to do lets say QUERY2-QUERY1

I used to queries ,1 to get items that are taken ( its all about sign in sign out for equipment) and other query is list of all items. How can i make 3rd query which will give me all but taken items from query1? (of course items from query 1 are in query2) thx in advance

my database should track who sign for which item and dates of signing and turning in. 1st table employees fields: name,etc 2nd table Items fields:description,make,model,etc 3rd table assign fields:EmployeeID,ItemID,assigndate,returndate. I need to be able to do history check aswell...

nothing ,i need em for history but what criteria should i use to remove ones i already assigned before?

ok in my sign out form i have subform which is made by query which check if item assigned to some1 have anything writen in returndate ,if do then it doesnt show in that subform, but how to do similar in sign in?

but if i make it that way,another problem occur,the items i already assigned once before will have both dates filled so I donno how to bypass that problem

i made 1 query and use it as subform on turn in form so i can see all items some1 signed for. Now was wonderinf could i do the same for sign in ,kinda check to see if item doesnt have sign in date filled in ASSIGN table or something?

Is there any way u can be more detailed. Ok I create query from which I will take items. Each items have 2 dates assigned to it,date when some1 pick it up and say when someone is turn it in.So how would that look in my query (code pls) if I want to exclude items which does not have Returndate...

All items i am choosing from are already in table ITEMS.I just pick 1 of them and assign it to PERSON from other table,and add date when i did that. So I just use form to link those 2 and add date.I would like to not see items that are already signed for but not returned.

actually its not from query. Its from item table where all items are. Is it doable that way,if not could u be bit more specific,cause my vba knowledge (or sql) isnt very impresive

i have item assignement db with 3 tables ,employees,items and assign. On my form u chose from combo box item u want to assign to certain person and enter date when it is assigned. Now in my assign table i have takedate and returndate fields. Is it posible to remove from combo box items that...

I am new in this and would appreciate any help. Here is what i have to do.Have 2 tables ,employees and equipment. People form table1 are signing for equipment from table2.After certain time they turn that equipment and some1 else is getting it. Should i make 3rd table with only signin and...

I was thinking as putting scaned picture as background of report,but when i do that picture is always bigger then my report,i played with margins and what not but cant make it same. Thing is that i have to create report that will look exactly the same as excell spredasheet which people use now...

I have scanned document which i wanna to use as my report template,Of course will take data from my Database.how? And also is it possible to make report from excell spreadsheet?(import how it looks in excell,not actual data)

thats not what i want I would like,that when i open query (or report based on that query) to have option to choose among all employees ( thats 1 of the field in query) in drop down menu,so I dont have to type any name.