Search results

Would using OpenCurrentDatabase work? Just thinking out loud...

" " " " Just checking... Didn't happen before, and doesn't seem to be happening now... Curious... Sent from phone...

Are you looking for more than one set of brackets? Have you tried? Like “*(*)*” PS. Typing from phone, not sure why it created a smart quote. Make sure to type the above code into your project manually, don’t copy and paste.

One approach is to add your generic database as a reference to your project. Have you tried that?

To determine the value from a “previous” record, you may need to use a subquery. Maybe try to do a search on that.

Hi. Welcome to AWF!

My guess is that when you assign a fore color using CF, you basically are also assigning a back color as well. I guess the default color is white. If you select a different back color, you'll see the same effect as you're getting now with white.

Hi. Try this one now... PS. It seems your db is suffering from the same side effect I noticed about skipping autonumber values.

So, I continued with my experiment to verify this statement. I can confirm that the subform is getting dirtied when using the With and .Recordset.Addnew. However, the original text control seems to retain the focus - meaning, the subform does not become active by using this code. There is one...

So, while waiting for a demo, I finally had a chance to fire up the laptop and do some tests. It seems to me that in the AfterUpdate event of a control, that control still has the focus. So, sending or setting the focus to that same control is unnoticeable, because it already has the focus and...

Perhaps you are right, but I am not sure that it also means the subform was dirtied, since the code directly modified its recordset. If that is the case, then you would be correct to use the subform’s AfterUpdate event. Actually, I just re-read your post, so I may have misunderstood your...

Don’t think I can answer that question without being able to step through the OP’s code, so a demo file would probably help us figure out the actual cause of the problem.

I’m not sure either if that event fires if the subform’s underlying record source is updated through code.

Glad to hear you got it sorted out. Good luck with your classes.

Hi. Reports are usually based on the printer installed on the machine at the time of creation. You could try changing the printer assignment or install the same printer on your laptop. Or, last resort, try recreating the report from scratch.

Hi. Welcome to AWF!

Did you post the code for ExecuteSQL? You might/should be able to use the LastModified property in it.

I could be wrong, but it looks like the ID is passed to the function, so maybe you can just search for it? For example, use FindFirst? Sent from phone…

Hi Albert. Welcome back!

Hi. Welcome to AWF!