Recent content by syntax

  1. S

    Forwarding id call to tech id

    Calls By form. When a new call is created, i would like that it will assign to the first technicain which has the lowest amount of calls.
  2. S

    Setting CallID to TechID

    Hi All, I have the following tables: Tbltechnicians (TechID,TechName) tblCalls(CallID,CallDesc) tblCalls-technicians(CallID,TechID) I have frmHandleCalls and I would like to set callID to techID so that the technician would know which calls related to him. How should I do that? Should i do...
  3. S

    Forwarding id call to tech id

    Hi All, I have the following tables: Tbltechnicians (TechID,TechName) tblCalls(CallID,CallDesc) tblCalls-technicians(CallID,TechID) I have frmHandleCalls and I would like to set callID to techID so that the technician would know which calls related to him. How should I do that? Should i do...
  4. S

    Help Desk For IT

    Hello All, I am trying to create a project in MSAccsess which should be a database for help desk for the IT Dep. So far I have the following tables: tblUsers – for the users who open calls( ID,FullName,Birthdate,HireDate,Email,Phone) tblCalls – for the Calls details (CallDescription,CallID ...
  5. S

    Inserting UserId into table after login screen

    Gr8! That was really helpful.... But shouldn't be a relationship between these two tables??? Could find any relationship in your file...is it ok? In addition, I would like to create another table which will be tblComputer and include ComputerID, ComputerDesc, DateOfPurchase etc... how should...
  6. S

    Inserting UserId into table after login screen

    Help Again... I realy Appriciate your kind and help. But, Unfortunately, I was unable to make it work exactly as I wanted it. Maybe because it is impossible or maybe because I did not understand how to do it right…. The code is basically working at the moment but does not do all the...
  7. S

    Inserting UserId into table after login screen

    Great...But.. It Does not give me any error now but also still does not pass the user id into tblCalls.... I would like that when the user enters the system and create new call - the form will know which user create the form and pass his id into the tblCalls beside the detalis the user entered...
  8. S

    Inserting UserId into table after login screen

    First of All Thank you so much. The code that you wrote for me looks great. but it gives me debug screen on this line: PassWrd = DLookup("Password", "tblUsers", "ID='" & Me.cboEmployee.Column(0)) with the messege ""run-time error '3075': syntax error in string and query...
  9. S

    Inserting UserId into table after login screen

    Hello All, I have database which should handle a call system for IT. I have a login screen form with username and password which works fine. what I would like to do is that: when the user enter the system with his username and password (from tblUsers) and open a new call (tblCalls) , the...
Top Bottom