Recent content by tadgh

Found the problem minty and thanks a mill for your continued patient help and all those that helped on this thread, i have learned a lot .... the user that installed access set it up to disable all macros. Its now working away perfectly

created new form, inserted button, event procedure, Option Compare Database Private Sub Command0_Click() MsgBox "hello" End Sub save , open form in form view and click button not a thing happens lol ....

tried that it stil does not work, msgbox "hello" may as well not be there nothing shows on form not even word hello i just cant understand whats wrong

Nope sorry that code is not working for me either, I have to be doing something simple in the wrong way.... i have noticed when i try to use the form it has a close button even though i selected no for close button......its as if when i save after entering code its not saving so the form does...

Thanks a million ill try that and see how it goes , really appreciate it dude

Thanks but im new to this only learning. This code is copied and pasted from someone else but i will keep at it thanks

its not saying there is an error at any point nor giving an error code but the form does not work. its as though the code is unrelated to the form or something.

hi Im new to access, i have created a login form with the following code. Option Compare Database Option Explicit Private Sub btnLogin_Click() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("tbl1Employees", dbOpenSnapshot, dbReadOnly) rs.FindFirst "UserName='" &...

Hi Im new and im trying to set up a login form for data base using access2007. it needs to recognize users and passwords from a user table and then open a form called user interface if the login is correct. i have watched some really bad videos on you tube and some good ones but for some reason...

thank you all for your help, brianwarnock your code has worked for me thanks a million really appreciate it dude

thanks plog thats exactly it, all doing battle and ignoring the plea lol ,,,i keep getting syntax error for that code i am going to try some of the others just have not had a moment to do so yet, yes even i recognise their are many ways of approaching any problem in life but for now i just need...

This is what i get when i copy paste doc mans code into query in age field "The expression is typed incorrectly, or is too complicated to be evaluated. For example, a numeric may contain too many too many complicated elements. Try simplfying the expression by assigning parts of the expression...

Listen guys thanks a mill I am 5 days into teaching myself through tutorials. When i use arnels it tells me its invalid syntax even after i make the adjustments plog suggests. When I use doc mans code in a query which i copied and pasted it tells me the expression was typed incorrectly or is too...

when i type this" Field: Age: AgeYears([Date of Birth])"into the query in the age field it is saying it is saying the expression i entered contains invalid syntax "you may have entered an operand without an operator

i see what you mean its calculating him as 53 already even though hes not 53 untill dec 31st,,,,