Search results

@Minty Your desk can't look any worse than mine but I respect your decision because I am not showing mine either. ;) I have the laptop *on it's own*, never did tie it into anything because I don't use it for development, I use that for audits. No worries about *going into work* because it's my...

Not sure how that work with a curved monitor but going to have a chat with my son-in-law about that because I also dock a laptop which has it's own monitor set-up. I don't do hardware. 🙃

@The_Doc_Man While I rarely do max screen width because I never arrived at a location and everyone using the database has the same monitor size this is GREAT information I had not even considered. As for rotating screens, on a curved monitor I would not even consider that as an option. Truly...

@Minty WELL, not what I wanted to hear but so be it. I do have the chance to try before I buy, so definitely doing that. @Steve R. Thanks for that tidbit about web pages, I had not even considered that part. I do know other than Access the balance of Office runs fine. That said, not like...

So I am finally going to upgrade my monitors to a single curved one, well providing no issues detected. (Getting tired of dual screens.) I am hoping someone here is using one for development. Any gotcha’s as it relates to Access I need to be aware of? (I just seem to remember something when they...

Well, I just something new today!

Favorite: Ice wine, though traditionally a dessert wine, I don't mind having it by itself. Favorite with lunch or dinner, if not going to have Ice Wine afterwards, Liebfraumilch (Black Tower) or Sake.

Sounds like you need a Loop. Have a look at... https://www.access-diva.com/vba3.html

Well, I guess I was typing too slow, though was not going to be my suggestion, I see you worked it out. I'll be moving along. :)

Hmm, going to help if we have the exact wording of the error message, number and all, that you get when opening. As for frmChecklist need to know what those macros do.

You need to make sure every place you turned them off that you turn them back on or it will continue to happen.

The Column Header is included in your count. You will need to add a *-1* to exclude it.

Hmm, what size is the database? When was the last time you ran Compact and Repair?

Thanks for the shout out! I like celebrating every history month with my grandchildren. So much history is left out of their school books (well, can't get it ALL in there) that I take it as an opportunity to focus. And sometimes, I learn something new too so it's a win-win.

:) Will be here if you need additional help.

The table with Products should not have the Customer ID. You should have a table tblCustomerProducts which will serve as a junction table between the two. tblProducts and tblCustomers.

Hmm, not sure I understand the question. What do you want it to show? Or are you saying you only want to see what Products that Customer has bought before?

Correct.

Hmm, I would import them into a Temp tables first and then push to the Live tables. This should also help you identify why the User ID comes in two different ways.

Hmm, yep, forgot that, set it to *Yes*.