Search results

thanx mate works fine now

Hey guys i've 2 date field vca and tot, if the date from vca is 10 years older then the date from tot a statement will change. i've use serveral codes but notthing worked for me :( now i'm using this code but is won't work If DateDiff("d", [Vca], [Tot] > 3650) Then Me.Value = "Open" End If...

okey guys thanx for the information

If your regional language options set as English (united states) the date wil de showen as M/d/yyyy, but i want to see dd/mm/yyyy. Is This possible and if so how? I've format my table also to dd/mm/yyyy And the fields of my form als to dd/mm/yyyy But the date still show M/d/yyyy :( and if you...

I'm looking for a code that close my databse when a user is unactive for a set time. I've search the forums but nothing workked for me Is there someone who already have a code for this or maybe can help me? thanks in advance

thanks for the reply I solved it a other way

nobody? please

Hello all, I have a query based on input from a word document. Now i want it to check if the data is the same as in the table but i cant get it work. You can see my query as attachmend. The name of the query is qryAchter2 My VBA Code is as follow If doc.FormFields("fldAchternaam").Result...

u the man!! Thanks

Only 1 problem he only checks the first one If you put more names in the database he only checks for kees u know a sollution for this? Greets Rmaster

that's exaclty what i mean Thank you verry much for your help Greets Rmaster

Thanks for your reply If you dubbelclick on the name on frmTest, frmTest2 opens, if it opens i want it to check of the name in the form is the same as the name in the other table, if it is, a msgbox dissapears. Sorry for my bad english Greets Rmaster

Thanks for the reply But that isn't what i was looking for, I've made an example. If you open frmTest you see all record in the list, if you dubbelclick on the name a other forms opens. Tha tform must check if the value of the Fieldname (name) is the same as in the other table the field name...

Hello I've a problem whit a field check. I want to check a field from my form to a hole collom of a table, if ther's a match then a popupmsg dissapears. Now i've this code but i doesn't work. If Me.FieldName.Value Like tblMytable.Name Then MsgBox "Text" End If How can i make this work?

Now i've But there's no output Private Sub Command16_Click() If IsNull(txt1) Or IsNull(txt2) Then MsgBox "Must fillin Firstname and Date", vbInformation, "Foutje" Else Me.RecordsetClone.FindFirst "[FirstName] = '" & Me![txt1].Value & "'And Date= #" & Me.txt2 & "#" Me.Bookmark =...

they way i want it, is that more than only the "creator" of the record can see it. There must be a way thay you fillin the 2 textfields and that a code checks if ther's a match. Thanks for your advise it could be usefull if nobody else knows a other way

u mean that only 1 user can see the information?

I want that users type the name and date because not everyone is allowed to see that information. Sow it's for secutiry.

It doesn't matter how they know it's correct, that is the secutiry of it sow the people can't guess what the correct information is, only the people who really know.

thanks for the reply, But i don't want that the users can see the information untill they typed the correct name and date. It's for secutity reasons.