Search results

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:

It happens! - don't worry about it. Everything will come and be given to you in due time.

НАУТИЛУС ПОМПИЛИУС — ЛУЧШИЕ ПЕСНИ

Use DlookUp() function ...

You are hindered by your relationships between tables

You use text as a where condition for numeric fields For example: 'Wrong: ' If Me.cmbObjectType & "" <> "" Then ' varWhere = varWhere & "[ObjectTypeID] = '" & Me.cmbObjectType.Column(1) & "' AND " ' End If If Me.cmbObjectType.ListIndex > -1 Then 'Value from list is selected...

Just set Form.PopUp property to Yes

See: BackStyle property (Access) On Got Focus me.combobox1.backstyle = 0 '0 = Transparent On Lost Focus me.combobox1.backstyle = 1 ' 1 = Normal Keep in mind that the control will not be transparent when it got focus

You're absolutely right, it's better if the user doesn't work at night ... ;)

Private Sub Form_Current() If Day(Date) = 1 Then Me.cmdYourCommandButtonName.Enabled = True ' = 1st day of every month 'Or: Me.cmdYourCommandButtonName.Visible = True Else Me.cmdYourCommandButtonName.Enabled = False 'Or...

Can you post a sample DB with test data?

Take a look to attached DB please

Try: If DLookup("DdSchedId", "DdSchedules", "([MatterId] = " & Me.MatterIdFld & ") And (Status = 'Not Active')") Then

As always - the price of political gamesmanship = graves with young guys! :(