Recent content by GinaWhipp

As a side note, I caution against blinking (flashing) as for some people it triggers physical reactions. I tend to just make the border turn red and push them back to said control if they try to go to another record including a new one.

Hmm, I have questions. What do you mean by *Shared Mode*? Is the database split? Is the Backend on the Server and does everyone have their own Frontend?

Issue *appears* to be fixed by running Update Now, at least for me and my clients whose machine automatically ran the update in the background.

With the reports now coming in, nope not code and certainly not code that has not only been working for years and works fine in earlier versions or files that have not yet been updated.

You are not alone: https://answers.microsoft.com/en-us/msoffice/forum/all/ms-access-displays-deleted-in-every-field-for/593e5f12-3cbd-414e-841c-9df612504d3c?page=2 Note, if you have Access 2010 or 2013 you should be good.

Hmm, just got an eMail asking me if I had a specific Data Model because that site was unreachable. It was a surprise to me.

Did you inquire with your IT department (or company)? Sometimes they have old unused version which are perfectly legal they just never used them as some of them buy them in batches.

You're welcome. As a side note, whenever you get that message that is the reason. With the Statement you need to change the double quotes to single quotes and only have the double quotes for line continuation. It was thinking your double quotes were at the end of the line and\or Statement and...

Try using single quotes.

Hmm, where's the Select which be on the second line, i.e. "INSERT INTO ... "SELECT ...

You could be in Layout View.

And that was my initial thought. They're hidden, how are you going to get them back without some other toggle.

So perhaps you want a Filter (combo box) at the top to... Show All Show Between From Date and To Date Show On Hold etc... Does make for less clicking if the list is kind of long.

Hmm, going to need a wee bit more information... Hide customers based on what? And who are you hiding them from? What if you need them back?

Your Form name has spaces, change to... DoCmd.OpenForm "[Movie Info 1]" Hmm, is Me.ID a number?