Search results
-
B
Referencing a Global Variable
I am trying to use a global variable in a dlookup but get an error when i try and run the form Here is the code: VUserID is my Global Variable. Private Sub Form_Open(Cancel As Integer) Dim UsersName As String Me.WelcomeBox = UsersName UsersName = DLookup("[Name]", "tbl... -
B
Check for Record
Can you have 3 fields all linked together as unique because if i just set one field this wont verify as you can have many people from the same company or the same name but from different companys. I have got round this by setting the company name first name and last name as the primary key but... -
B
Check for Record
Hi Everyone i would like to check a record exits before a new entry is saved. However i would like to check on three criterias and i am not sure on how to write the if statement. IF Dcount "CompanyName" & "FirstName" & "Last Name" from "tblcustomer" is the same as "frmCompanyName" &... -
B
Link With Active Directory
Hi All I have a small Help Desk db with tables that contain computer spec and user information. But I already have all this information in Active Directory and it seems pointless entering the information twice. Is there any way i can get the database to lookup the information from Active...