Recent content by Pavczech

Hello I have a web database. There are couple of tables with lookup fields ( first one called department where all department codes are stored and the second one where there is a look up field department from department table and other fields like names and so on ... ) I need to click on...

Hi guys Any help with this one? I would like create web based inventory database with QR Code. Database is not the problem but, I would like to scan the code and it would bring up the item. How would I do that? I am very greatful for any help Thanks

Hi ya. Yep I alredy have on the form beforeupdate code which checks if the record exist. If it does than it cancel the input in to the table and opens another form, if the record doesn't exist it inputs it in to the table and open another form. The problem is there are 3 compolsury fields which...

Hello It works as far as setting the idle time, but i have tried to close the form without updating the tables and it is not working. I tried: Sub IdleTimeDetected(ExpiredMinutes) Docmd.close,acsaveno cancel=true End Sub Any help, please! Thanks

It does what I wanted to do, there are some other issues with my forms which are connected to the forms, hope I can figure out that one. Thanks

Hello all Could somebody help me. I need to close the form on idle more than 2 min. There is 5 text boxes so even if somebody inputs text in one textbox, but doesn't finish the rest of them it will close without saving data. I have tried timer but it doesn't seems to be working. Thanks

Hi ya Can somebody help please. I am trying query on multiple optional criteria. I have query where I have put criteria [Enter the First Name] or [Enter the Surname], but when I input first name and surname it shows all of them with same first names and surnames, not just that single person...

Hi ya i have just putted it in quotatins and took some out it works rs.FindFirst "[Surname] = '" & Me![Text185]&"'" Thanks for your reply

Hi to all I have trouble with this line in my code. rs.FindFirst "[Surname] = " & Var(Nz(Me![Text185], 0)) I think it is because it is not number but text. Could somebody help Thanks

Hi Can you help please. I have form where i would like to add search button, which would call for a small form with a couple of the fields and search button. Let just say "form1" where are the fields like "id", "firstname", "surname", "dob" etc... When you open the "form1" you can scroll...

Don't worries I have used docmd.runsql instead thanks for the other tips anyway

Hi Thanks sorry I was away. Basically what I need to do is when I click the button it would update existing record. I not sure why but when I put the ?Dlookup... it gives me right ID but it doesn't work with Me.TimeOut = DLookup It only creates new records instead updating the old ones

Hi thanks, but If i do that it give me error you can't assign value to the object. If i take it to immediate window and take it apart ?dlookup gives me the right ID, Time () gives me the time but how do i put it all in to the TimeOut? If i do in the immediate window Me!TimeOut = Dlookup(... It...

I have attached short version of db. What I need to happen is when you open query2 form and input surname and Dob and click submit it will just update the "TimeOut" for that record. If nothing found there would be message box. Thanks for the previous post. I am sort of learning in my own...

Hi guys Could anybody help. I need a code to update my tables. Basicaly I have 2 forms. 1 table with Name, Surname, DOB etc. 2 table with Date, TimeIn and TimeOut. 1 query with all details I have Dlookup code which finds out the ID DLookup("[ID]", "[Table1]", "[FirstName] ='" &...