Recent content by Rmaster

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 =...