Search results

I think my machine fixed it. I had 2007 and 2003 installed, as I programmed in 2007 and the client works in 2003. When I tested in 2003 it conflicted somewhere and kept crashing and giving me that error. Uninstalled 2007 and I think it is fine (I think). Thanks for all your help. Martin p.s...

just trying to get into code: will paste shortly when this thing decides not to crash and let me in.

I keep getting the following error when i click an important button. I even tried recreating a new button with one line of code behind it and still no joy. Anybody any idea? the error is: The expression On Click you entered as the event property setting produced the following error: Object...

All, can somebody just glance an eye over the below and just state what the error is? If Me.txtpassword.Value = DLookup("passwords", "tbl_users", "[tbl_users.user_id]=" & cboEmployee.Value) Then Thanks Martin

hehe, one of those days. especially for me as i only have 1 hour left at work and then im job less. being made redundant today. cheers

sorted - was a text / number field issue

i have changed it to number thanks again gemma :)

the bradfordscore fields are TEXT. without changing the whole table fields into number is there are way the query can think these are numbers? thanks gemma.

I have: SELECT tbl_users.Name, tbl_users.bradfordscore FROM tbl_users WHERE (((tbl_users.bradfordscore)>"75")); but it returns a user whose score is 9 and not the user whose score is 125. What would be the reason for this? thanks

made the query simpler: SELECT tbl_users.bradfordscore, tbl_users.name FROM tbl_users WHERE tbl_users.bradfordscore > "75"; but it still returns the record where the score is 9. I have a user where the score is 125 and it should show this one. this is driving me nuts

Hi David, My query looks like this: SELECT tbl_users.bradfordscore, tbl_users.name FROM tbl_users WHERE tbl_users.bradfordscore > [forms]![frm_homepage]![daysweek2]; the results are still not what I am expecting. basically daysweek2 is 75. I am gettnig back users whose score is 9. it...

I think its somethign to do with the * 15 but not sure. any idea?

change of code Dim I As Integer Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Set db = CurrentDb() strSQL = "SELECT tbl_users.bradfordscore, tbl_users.name FROM tbl_users WHERE bradfordscore > (daysperweek * 15)" Set rst = db.OpenRecordset(strSQL, dbOpenDynaset) I = 0...

I have the following: Dim I As Integer Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Set db = CurrentDb() strSQL = "SELECT tbl_users.bradfordscore, tbl_users.fullname FROM tbl_users WHERE bradfordscore > (daysperweek * 15)" Set rst = db.OpenRecordset(strSQL...

many thanks guys - that helps lots. I'll just edit some code. cheers

All, I have a text box on a form and I would like the following code to read it userloggedon = Forms.frm_homepage.user_id.Text This is fine if the box is visible, if the box isn't visible then it wont read it. I would like the box not visible to the user but still be able to read it. Is...

excellent thanks, I did try something similar but forgot to move brackets around. thanks

I have this code in a query: SELECT absent.name, absent.fullname, absent.Days, tbl_users.bradfordscore FROM absent, tbl_users WHERE (((tbl_users.Team)="IT") AND ((tbl_users.user_id)=[absent].[name])); and it gives this as the result: name ...fullname ......days bradfordscore...

Hi all, How do I print Queries? i.e. I would like to print the SQL code in each query, is there a way to do this? Thanks Martin

many thanks - got it working, knew it was something simple. Thanks