Search results

No, I didn't see the explanation.

I have never come across that one before Collin. Nice to know about that anomaly. When I run into strange stuff like that, I usually just import all the objects into a brand new database and it all disappears. There must be hidden system table that isn't getting fully emptied causing that issue.

I was referring to what you said about the combo boxes being based on a valid field in the underlying table. That cannot possibly be true in the case of a value list.

Wait, how can a value list be based on a table? A value list is based on the embedded text values you directly give it in the list. You should use the value list dialog method to create the list and edit the list.

Then just use the new one that you made that works.

I had flashbacks to that little rascals scene where they mix up a cake with too much yeast in it and it comes out looking like the shape of the inside of the oven. I like simple though, so I'll try it.

As we get older, speed and horse power are not the factors driving purchase. I need a larger vehicle that I don't have to crouch down into and out of. So the SUV's are the one's that appeal to me. I inherited a Toyota Avalon that is a very nice car, but I'm finding it harder and harder to get...

Feel free to tell us about one of your favorite recipe's and post them here. I just tried a new recipe today that really blew my wife and I away. I will share it here. Crock Pot Chicken Thighs with Artichokes and Sun-Dried Tomatoes We paired it with mashed potatoes and a bottle of Robert...

Most newer folks probably don't key in on the dates of the threads and view them as if they are in the here and now by accident. I know I made that mistake, but after you have done it a time or two, you just know that you shouldn't be doing it, so you stop doing it. Then there is the person who...

When someone asked you to look into switching over to this other system, did they actually have a good reason for switching over? I don't see what the advantage is, only you can determine that. If what you have is working well, then there had better be a good reason to switch over. These...

I would have to be paid extremely well to take on something like that in the way your proposing. Good luck.

Waste of time putting this info into a database when Active Directory is already a database. I work on air gapped systems and understand the difficulty involved. The simplest reasonable solution is to run the queries on each domain server (Power Shell). It's the easiest way to handle it. For...

Nothing worse than ambiguity while communicating.

I'm originally from Ohio and they definitely know what a taco is. That must have been an isolated missed word. I don't remember going to many Mexican restaurants while there in my youth though. I remember maybe once or twice eating Mexican food outside of what my mother made for us at home on...

Yes I realized my mistake shortly after posting. It was because the sample code I copy and pasted had that IS IN syntax which is wrong. I haven't used that clause for anything before so I was relying on the sample code. Thanks for looking at it.

I'm not used to using the IN clause in SQL expressions so was wondering why I'm getting this 3075 error when trying to run an Update query on my table Media. The idea was to simply select media items from a list box (ListBox) and then run the query to update the Name and Date that the media will...

What do mean by "enter the line prior"? There are six records entered into the subform and the blank (add new) record line is for entering in another record. If you look at your table it should have only the six new records that you entered in the subform and that's it. Are you saying an...

I was referring to an application that was used by others with different monitor resolution. I you don't care about others, then it might be doable customizing it to your own monitors. If you only want that one single area of the screen to be captured, then what about making that red frame part...

He is saying that each square on the board can look different at any given time showing a player token on/off a particular square, house/hotel on a particular square. So he wants to use vba to screen shot the resulting view of the square at a point in time during the game. That's just two...

I don't know if I'm doing that doc, but what I do know is if I hit on certain triggers, she reads me the laundry list of faults and failures I had in the past and she loves going way back.