Search results for query: *

Have you tried putting the row source as SELECT ClassesForInstructors.ClassID, Instructors.InstructorID, Instructors.FirstName, Instructors.LastName FROM Instructors INNER JOIN ClassesForInstructors ON Instructors.InstructorID = ClassesForInstructors.InstructorID and in your command to open...

the date 6/28/1905 will be the year 2006 expressed in date format (in excel type in 2006 in a cell and convert the number format to date - you'll see). So it's picking out the year ok but it's converting the year into a date. What expression have you got at the moment to work out the date?

Something like this would provide a basic password Dim pswd As String pswd = InputBox("Please Enter Password", "Password") If pswd = "Hello" Then DoCmd.OpenForm "Secretform", acNormal, "", "", acFormEdit Else MsgBox "Incorrect Password" End If Although there are always ways around it.

I've gone quite successfully through several thousand records across several tables. Don't think theres any strict limit - only time really and you can help yourself out by ensuring you've indexed the tables.

There are many ways to get your data from tables - this is the way I use, this loops through the table empnames and looks at the employee_firstname and employee_surname fields. Dim dbs As Database, rst As Recordset, empfirstname As string, empsurname As string Set dbs =...

I'm trying to use DCount using a discontinuous range to define the criteria. I've got about 80 varations on the criteria to work with hence the use of discontinuous ranges. eg =DCOUNT(D12:F34,F12,discrange) where discrange=Sheet6!$J$5:$J$6,Sheet6!$L$5:$L$6 Any suggestions? Cheers D