Search results

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

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

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

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?

Hello I need a button that looks at 2 text field in my form that must be the same as 2 field from my table, and display the information from it. I made an example for explain my problem. In my example i've 1 table: Users 1 Form: frmZoek In the form are 2 textboxes and 1 command button: txt1...

I've used the example from this site to import a word document to my access table. Now i want a check in VBA that if a field value is "Ja" and 2 other options are empty a Field in my table "Statusvca" changes from his standard value Closed to Open i've tried these codes and they dont work...

I've used the example from this site to import a word document to my access table. But i want to use a search option for finding the word document in state of a standard map (in example C:\Contracts). How can i do this, i've tried some things but i can't get it work :confused: Could someone...