Search results

When you use the =Sum() function, you are summing the expression for all rows. This is more commonly used in a header or footer to show totals. Try =Nz([Stop_Current])-Nz([Current_Price]) in your Textbox.ControlSource

I don't know if this would work, but it did occur to me. Might offer another idea... 1) Make MajP's calculated field as posted in #5, but do it like... Selected: IIF(YourField = "HorizonLLC", "Yes", "No") 2) Set up combo35 to have three rows and two columns, with the first column bound and...

FWIW, I explicitly close recordsets, but I do not routinely set recordset object variables to nothing. The way I understand it is that VBA garbage collection operates on reference counts. This means there is a VBA internal structure mapping declared object variables to existing object instances...

Same as your previous deflection, same low bar, that as long as someone else is weaker. This is called a bias, commonly held to be invisible to the holder of said bias.

This, because of a failure of what used to be American leadership of what used to be known as the 'Free World.'

If I was president of the United States of America, and cameras were rolling, I would first of all demonstrate that there is a cool and steady hand at the rudder. Job #1. No other messaging comes close in value to that one, regardless of the situation, regardless of the deal currently on the...

Strength and confidence do not raise voices and wag fingers. What raises voices and wags fingers is weakness and vulnerability. Think of the people you know who, when there's a huge pile of chips in the centre of the table, lose their shit like Trump and Vance lost their shit. If a foreign head...

I think the fact it is possible, in font of cameras, to 'set off' the President and the Vice President of the United States is THE issue. It doesn't matter what was said, who said it, none of that. With everything that is at stake here, the fact those two men can't keep their collective shit...

Tariffs raise prices because the landed cost of a product is artificially inflated. This makes it more attractive to produce locally and stimulates domestic manufacturing, true. But since the landed cost of an offshore product remains high, the domestic producer charges more, and prices stay...

You should store data where it makes the most sense in service of its purpose. For instance, if the reports are in the FE, and you have data concerned with the correct functioning and configuration of reports, then that data belongs in the FE. AccountTypes, by contrast could be either. If...

Just change the combo's "BackColor" property to something other than "No Color". All the data is there, its just the BackColor is the same as the ForeColor.

And ColumnWidths? If you want, run this code, and post what gets printed to the Immediate pane. Private Sub Form_Load() Dim fso As New Scripting.FileSystemObject Dim fd As Scripting.File For Each fd In fso.GetFolder(CurrentProject.Path).Files If Right(fd.Name, 6) =...

Form_Load() is early in the lifecycle of a form. It's possible you have some downstream process that erases the contents of the combo. To test for this case, you can add this line of code after your For loop... Debug.Print Me.cboDataBases.RowSource ...which should show a semi-colon delimited...

I think this is a really astute observation.

The OutlookItem.Display() method takes an optional Modal parameter which defaults to False. If you set it to True, I think your code will pause at that line. Private WithEvents oli_ As Outlook.AppointmentItem Private cli_ As cOLCalendarItem ' . . . Set cli_ =...

You can call back to the FE from a table macro if you wrap the function call in Eval(). Consider this screen shot.. So there's a 'Public Function CurrentUserID() As Long' in the FE, and this macro runs it, and sets the value of the field. This is a split Db, the table's in the BE. One...

Yes, I have run into this. Two machines at work fail exactly as described. Thanks for the update, much appreciated!!!

Create a table called tProject with a field called AwardedDate. Then, write two queries, one called qProposal... SELECT * FROM tProject WHERE AwardedDate Is Null; ...and the other called qProject... SELECT * FROM tProject WHERE AwardedDate Is Not Null; Now create two forms, fProposal and...

me.tbOneWeekLaterThanSomeDate = me.tbSomeDate + 7

Also, if you have done any custom calculations on your date values, they may no longer be stored exactly correctly in the table. Try this in the immediate pane... ? cdate(45670.8804976852) 1/13/2025 9:07:55 PM ? cdate(45670.8804976) 1/13/2025 9:07:55 PM Notice that 45670.8804976852 <>...