Search results

Yes - it Is possible - For example by DlookUp() function. DLookup Function in Microsoft Access

You don't need that already! My computer doesn't match either (i have no TPM2 module). I installed myself from the original image - everything works

There could be many causes for this Can you post a sample form with the necessary tables

Private Sub YourTextFieldName_AfterUpdate() Dim s As String Dim t As String Dim i As Integer 'Clearing the field value of all characters except digits s = Me.YourTextFieldName & "" Me.YourTextFieldName = Null For i = 1 To Len(s) t = Mid(s, i, 1) If IsNumeric(t) Then...

Before adding new records to table "INTAKELOG" you should have "Relation key ID" record in table "CLIENTS" for each new record. ... And read: Introduction to data types and field properties - that's about second screenshot from post #28 ...

There are some functions for data transform ... TimeValue() for example ... ... My local time is late, I'm tired. I leave you in the good hands of the experts of this forum. Good luck!

That's why !

Some fields are perplexing ...

Two fields were missing in the file: "MASTER DATA EXPORT TEST.xlsm"

Ye-e-e-e-e-s-s-s-s! That's right. But I worked with the file that was posted and there were really two fields missing. I didn't make it up any more ...

@JED25 - query works: INSERT INTO [INTAKE LOG] ( ADMISSION, [CLT ID], INSURANCE, [REF BY], LOC, DISCHARGE ) SELECT [INTAKE LINK].ADMISSION, [INTAKE LINK].[CLT ID], [INTAKE LINK].INS, [INTAKE LINK].[REF BY], [INTAKE LINK].Loc, [INTAKE LINK].DISCHARGE FROM [INTAKE LINK] LEFT JOIN [INTAKE...

That's better! Looking at the material ...

И где Excel файл - А! ??? Вы думаете - или нет? ... :( ... EN: And where is the Excel file - Ah! ??? Do you think - or not? ...

You are not the only one who has this kind of thing Just replace sensitive data with meaningless text by using update queries.

Can you post a sample DB with test data and excel sheet?

Yes. Yes. Field "MinDiff" - means: "difference in minutes" - Name it as you like.

SELECT First(fTime) AS FirstOffTime, First(fValue) AS FirstOffValue, Next75AndMoreTime, First(MinDiff) AS FirstOfMinDiff FROM ( SELECT fTime, fValue, IIf([fValue]<75, DMin("fTime",'Your_Table_Name',"fTime>" & Format([fTime], "\#mm\/dd\/yyyy hh:nn:ss\#") & " AND fValue>=75")...

SELECT fTime, fValue, IIf([fValue]<75, DMin("fTime",'Your_Table_Name',"fTime>" & Format([fTime], "\#mm\/dd\/yyyy hh:nn:ss\#") & " AND fValue>=75"), [fTime]) AS Next75AndMoreTime, DateDiff("n",[fTime], IIf([fValue]<75,DMin("fTime", 'Your_Table_Name',"fTime>" &...

... or not shown to us variable, or mistake ... :)

If "ShowIt" is button - try code: