Search results

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,,,,

why use module and all that code if this works in age field in query Age: DateDiff("yyyy",[date of birth],Now())

LOL OK THINK I GOT THAT LOL and thanks for the patience as i said i really am very new..... will this display the current age in my table as opposed to only displaying it in a query ???? please say yes and again many thanks

ok getting clearer so i open my player table (do i click in field age ) and press alt f11 insert module and paste code 1) do i just x out of that module when code is pasted ? 2) after exiting vbe i go to table query and insert in the age field what you have above is that correct ?

sorry im confused as i say im very new but thanks for trying so if im right your saying go back into query design and insert module. if this is true then in what field do i insert module and how does this transfer data from query age field to player table age field.....im sorry i think i...

what do you mean "put in module" ??? im really new to this sorry