Search results

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

To handle all embedded delimiters and date formats without cobbling together your SQL in code, I strongly recommend an approach more like this... Const SQL_SELECT As String = _ "SELECT * FROM DATA_CHECK_KLW_2024 " & _ "WHERE Year = pYear " & _ "AND Number =...

It is also evangelical about the Earth being a sphere. Apparently they have "evidence," but there should be more balanced debate on this topic, because step out your front door and look around: It is F&*%ing flat.

For those iterating over recordset rows to find rank, you might like the Recordset.AbsolutePosition property. This property is read/write. See also PercentPosition.

Another approach is to enforce logic using classes rather than database constraints. In some cases, like this, where database constraints are not well suited to a problem, it is sometimes easier to just read all your data into classes that enforce the logic themselves. Iterating over a...

Describe the actual problem, for instance... • you take action A • you observe outcome B • outcome B is not acceptable because of criteria C Using a pattern like that to describe a problem will improve your luck.

With Compile on Demand enabled, the compiler is optimized for performance in two key ways: 1) It will only compile code on the current execution path. 2) It will preserve previously compiled code. As I understand it, this can lead to crashes because you might edit the signature of procedure...

If you post the database, I'll rebuild it. I wrote code to export each object to text file, and read it back into a new database file, so it is pretty fast. Also, I edit running code all the time. Maybe it's a no-no, but if you clear the compiler settings indicated below, you dramatically...

Do this in the immediate pane... ? CurrentDb Is CurrentDb False CurrentDb returns a different instance on each reference. This is an advantage because a DAO.Database maintains state. If ConsumerA runs a query, the Database.RecordsAffected() property returns how many rows were affected. If...

Can you post a demo of this? Does it break into the debugger? I have never seen VBA code just stop.

Setting Me.TimerInterval to zero disables the timer. The Form_Timer() event handler will never execute while Me.TimerInterval = 0. In addition, if you set Me.TimerInterval to x, and then before x has expired you set it to x again, you effectively delay the execution of the OnTimer event...