Search results

Don't worry I've sorted it out, thanks for all your help. :) :) :) :)

It works a beauty, however when I log back in and press login button I get a compile error - Method or data member not found so I rewrite Me.CboEmpleyee.column(1) and then lets me into the DB and when I look in the table it's got the name which is ace but I always get a compile error -...

SELECT [TblEmployee].[EmpID], [TblEmployee].[EmpName] FROM [TblEmployee] ORDER BY [EmpName];

It has a bound column of 1

Object required

Hi Thanks for getting back, I have tried both CboEmpleyee.columns(1) & CboEmpleyee.column(1) and I'm coming up with a run time error '424'

Hi Guys I have this code storing login times on a table which is fine when logging in and out, however on the login screen when the user enters their username it stores it as a number on the table and not their name?? CurrentDb.Execute "INSERT INTO tblLogInTime (EmpName,[Logintime])...

Sorted it and it opens it in Notepad with scrambled writing

Tried Firefox and still the same saying there is no file

Sorry I mean it opens the link but the sample file is no longer available.

Hi Thanks for getting back, however I can't open or save the file as it dose not exists. Regards

Hi Does anyone know where I can find VBA for (Tracking User LogIn/LogOut) I have tried researching to no avail. I just need a simple code to track users logging date & time in and out of my DB. When they click on the icon on the desktop id opens the DB to login screen with username &...

I have tried all of the above advice and nothing seems to be working, do I put DoCmd.OpenForm "FrmBankDetails", , , "StudentName= '" & Me.StudentName & "'" On the open form event on bank details form? if so I have tried everything and am at a loss )-:

Hi guys Have done all of the above, opens the form put always to the first record. The name of the text box in the admin form is StudentName and the name of the text box in bankdetails is StudentName, therefore I need those to relate after entering a password in a password form????

Yeh tried what you have suggested an I get an syntax error (Missing operator) )-:

Sorry I really don't understand how the code should be written. Like this? DoCmd.OpenForm "FrmBankDetails", , , & Me.StudentName & "'" I'm new to OpenArgs

I have a form with a button that opens a password form, enter the password and then that opens another form. What I need is after the password has been entered and then another form opens I need it to relate to the first form. I know this works when you just have a button to open a form...

So using combox boxes they would either enter their name or drop down to find their name, then the same status, city, and so on using the 'afterupdate' event. Using the VBA below. Private Sub cboOPOwner_AfterUpdate() If Nz(Me.cboOPOwner.Text) = "" Then Me.Form.Filter = "" Me.FilterOn = False...

So you mean something like this?? Dim strDateField As String Dim strWhere As String Const strcJetDate = "\#mm\/dd\/yyyy\#" strDateField = "[NextCallDate]" If IsDate(Me.txtStartDate) Then strWhere = "(" & strDateField & " >= " & Format(Me.txtStartDate, strcJetDate) & ")" End If If...

So guys, How would I approach the below VBA with OpenArgs theory? Private Sub BankDetailsButton_Click() Dim strPass As String strPass = "password" If Me.txtPassword.Value = strPass Then UnProtected = True DoCmd.OpenForm "FrmBankDetails", , ...