Search results

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

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 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...

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] ='" &...

Hi guys Could you help me please. I have 2 tables with relationship. I have 2 forms related to those tables. I need the code which would first find the ID in table 1 and than transfer this ID to the ProductID on the Form2. So Far I have this but it doesnt seems to be working Private...

Hi I have my on-screen keyboard which works fine on main form but when i put subform on it it doesn't work it said it lost the focus or object doesn't support this property or method. Here is the code: Private Function TypeAlphaNum(strKey As String) As String...

Hello Is there code which would close the form without recording it in table or specific fields? something like DoCmd.close acform "Form" acdontsave Thanks

Hi Guys I have code whch is working fine to the point I need to close this form. It checks if the record exist in "Visitors Book - Personal" and if it doesn't it just enter it with the visit detail to "Visitors Book - Visits" and closes. Now is there a way that if the record exists it does...

Hi guys Could somebody help me to find the error in this syntax, please. DLookup("[ID]", "Visitors Book - Personal", "[First Name] ='" & Forms![VisitorsBookIn]![First Name] & "'" AND "[Surname] ='" & Forms![VisitorsBookIn]![Surname] & "'" ) It should look for the "ID" of a user "First and...

Empty Form Hello I have Form bound to query. The query is bound to two tables. It works fine apart it showes all the entries. It is pop-up form. So is there a way it always open clean? Thanks

Hello I have working code, but i need bit tweek. So There is a table "Visitors Book - Personal", with Fields: "ID","Unique Code","Surname","First Name",etc Now! When I press ENTER button it check if exists, ( It Works ), on the end is little code which takes ID and changes to "Unique Code"...

Hello I have form with text box called "Month" I have button "Jan";"Feb" etc. I could do with when I press "Jan" button it will focuse on the "Month" textbox and enters text "January" in the text box. This should be simple but I not able to figure it out Thanks very much

Hello Could somebody help me. I have 2 tables. First called "Details" with visitors details and Second called "Visits" with visit deatail. There is the Form where I put all the datails. ( Name, address, Company, Date, Time ) I need the the code which will search the the "Details" table...

Hello I have table with a "Visitor details" ( ID, Name, Surname, DOB, Address etc ) The second table is with "Daily visits" ( ID from "Visitor Details" table and visit detail like date, time who they visit etc ) There is a sign in form where they put their details. Now I need When the...