Recent content by eee333

I had a calculated field in my database that may have been too much for access, or maybe I just wrote it weirdly. Either way, deleting it seems to have greatly ameliorated the flickering--it's still there, but to an acceptable extent.

Here's a screenshot of the form. I have experimented with adding controls in one by one, it does seem like the layout is the problem, which seems weird. I could have them all in one column and it wouldn't be a problem, but, that really doesn't work for me. I guess I could try experimenting on...

I've been experimenting a little more, apparently two things are contributing to this issue 1. My layout is like four columns of controls, which in testing appears to start causing flickering 2. It apparently REALLY doesn't like checkboxes to be in a column, that seems to be causing the...

I don't thiiink so? I'm not very fluent in VBA. I have a DLookup set for two controls, but not to set their value, just to check and make sure the number they entered isn't a duplicate. That should only run after that control is updated. None of the other controls that update and cause the...

There's no official conditional formatting, like through the conditional formatting button. I do some conditional formatting through VBA, but as I said, even when I deleted all the VBA code from a copy, the flickering still occurred.

I'm having an issue with the form flickering when I update/enter information in a control. I've run through the form many times and there doesn't seem to be much consistency to what updated controls will make the screen flicker. I've tried a bunch of stuff and none of it seems to work, does...

Ugh, actually, the culprit was Monday morning brain--forgot that all values in Comm Id are in the 900's--it just wasn't working because my case select statement was looking for 1, not 901. It works perfectly now, thanks!

I felt fairly certain that this fix would work, and yet, it doesn't seem to be? It still won't update it at the time like it will for the InsightID. 'part where it sets the values in the other form' Else: Forms![test lines]![Country] = Baseball() Forms![test lines]![InsightID] =...

Oh wow, reading comprehension failure. Thanks, yes, that works perfectly!

I have this piece of code that works, but for the life of me I can't figure out what event/module to put it under. In my form, a user generates a number by filling out an unbound form and clicking a command button. The command button then sets the value of InsightId through a calculation. This...

Yes, this worked perfectly, just what I needed! Thanks!

That's what I'm wondering, how do I do that? I currently have it set to If ctl.Tag = "TLeft" And IsNull(ctl) = True Then ctl.BackColor = RGB(255, 194, 14): Donut= (", " & ctl.Name & " This one failed") ... If IsNull(Donut) = False Then MsgBox ("Oh no" & Donut) Cancel = True...

so like Dim Donut as String For Each ctl In Me.Controls If ctl.Tag = "TLeft" And IsNull(ctl) = True Then ctl.BackColor = RGB(255, 194, 14) [ADDING CURRENT CONTROL TO STRING] End If Next ctl If IsNull(Donut)=False Then Msgbox("Missing values for...

I'm new to do loops in access, and I have some code that almost does what I'd like it to do, but it needs some tweaking. I'm not sure if what I'm envisioning is possible though (or if maybe a do loop isn't the right way to do it?). In the event form before update, I want it to look through...

that's really not the user interface I want to have. It won't work for my purposes.