Recent content by barnyb3

I am writing a database for a theoretical taxi company. I want to use date function to show all jobs to be done. How should I use a date function/now function to show all jobs that are due from the current time/date. I know the function exists I just don't know how to use it as I am a...

got there eventually sub goes like Private Sub Login_Click() Password = DLookup("[password]", "tblUsers", "[Username]='" & usercombo.Column(1) & "'") If Password = txtPassword Then isDirector = DLookup("[isDirector]", "tblUsers", "[Username]='" & usercombo.Column(1) & "'")...

Private Sub Login_Click() Password = DLookup("[password]", "tblUsers", "[Username]='" & usercombo.Value & "'") If Password = txtPassword Then isDirector = DLookup("[isDirector]", "tblUsers", "[Username]='" & usercombo.Value & "'") If isDirector = True Then...

I am on 2007 although my experience with other versions is practically nil. I don't have an example of combo reference and have tried googling it. Private Sub Login_Click() Password = DLookup("[password]", "tblUsers", "[Username]='" & usercombo & "'") If Password = txtPassword Then...

thank you for the prompt reply. It is just for a project and to include as a feature. It is functioning .. i just don't know how to compare a combo selection with the text input (password) in the sub. Also how do I use the security feature you mentioned. Thank You in advance Barny

I have a table of users and passwords to allow different views of a database. I have used two textbox inputs to feed the username/passwords respectively. I want to use a combo for the users instead of a text box so that the form is updated with every addition/deletion/amednment. This is what i...

solution SELECT Risk.Description, Project.ProjectName, Project.ProjectID, ([Risk]![Likelihood]*[Risk]![Impact]) AS Hazards FROM (Project INNER JOIN Task ON Project.[ProjectID] = Task.[ProjectID]) INNER JOIN Risk ON Task.[TaskID] = Risk.[TaskID] ORDER BY Project.ProjectName...

Problem sorted thank you for the prompt reply and your time.

the field hazards is not in a table i created the field using Hazards: [Risk]![Likelihood]*[Risk]![Impact] barny

thank you for the reply I now get a pop up asking for hazards parameter value barny

i am trying to construct a report and need two of three fields sorted the fields are project(asc) risk hazard(product of two fields in a table called risk)(desc) sql SELECT Risk.Description, Project.ProjectName, Project.ProjectID...