Search results

Why does that matter?

If the master/child links are set correctly for the subform, Access will automatically populate the foreign key. You don't need the combo to do that. Start by defining relationships and enforcing Referential Integrity. For existing subforms, you will have to set the master/child links...

Children can't dress up as Indians or anything else remotely ethnic. Not sure how how you play cowboys and Indians any more. Performers can't wear blackface. So how can men dress up as women? How can western politicians and their wives dress up in native clothing when they go abroad? Bring...

I ran into the problem before that option became available. Also, once you set the option, you can no longer open the app in older versions of Access so I don't use it unless It it necessary.

There are similar problems when tables have BigInt PK's. I got around that one by creating a view. That worked for me because I didn't have to update the table. It was data that was downloaded from our transaction processing company and was used for analysis only. Does anyone know why Office...

My granddaughter's fiancé lives in NYC. Every time she takes the train into the city, I worry. He lives as far south on the island as you can get so she can't really walk so she transfers at Grand Central to the subway. ick.

I lost hope when I first saw a gay pride parade on TV with the scantily clad men shaking their dangling appendages at the cameras and mimicking sex acts. I don't care what you do in private but that type of public display REGARDLESS of your sexual orientation is disgraceful and we allow it lest...

@NauticalGent you can block anyone you do not wish to engage with. You don't need to stifle them. You can make them invisible. It is sometimes amusing to read threads like this and know you are not seeing some of the responses:) People have made a lot of comments this time regarding...

Also, I really want to know the answers to the questions in #6. Surely someone has an EV or a friend with one.

Thanks @jdraw That was really interesting and very encouraging. Maybe there is a future for EV's after all:) But, I can't believe I never saw this story. It should have been front page, top of the hour news on all channels. Maybe it was fake news and so suppressed. Are you sure this...

If the subform is in DS view, the user can grab the bottom or row separator and drag down. That way, he gets to decide how tall the rows will be and change them as necessary.

I was thinking more of our friends in India and Africa.

We are all developers here. Do you expect to get paid for your work? Do you think it is moral to steal the work of others? Think again before paying an unrealistically low price for something. Chances are very high that it is stolen goods. Microsoft and other technology companies don't...

Does MS sell office for different prices in different countries or are the prices all the same. In the US and Europe, we don't think these prices are too expensive but residents of other countries may not be able to afford them. The nice thing about Access is that although the developer needs...

Keep in mind that the creators of these "social" media platforms send their children to private schools which don't allow the usage of these platforms. What do they know that the average person doesn't know? Why do they feel the need to protect their children? It's been an uphill battle for...

"Old bridge players never die. They just shuffle away."

Are we talking about ONE report with different criteria or multiple reports? If it is just one report with varying filters, you only need the last row of controls BUT they need to cascade so when you pick the company, the region is filtered to only the relevant regions and then the territory is...

Be careful though. I was just playing around and changed the alternate back color to yellow but when I removed the line of code, it didn't go back to what it was. I had to set it to the color i used at the beginning of the procedure, run it, and then comment out that line too.

When your form is in DS view, Access has to ignore certain properties set on the form since ALL formatting for the controls must be consistent but there are certain things you can change when the form opens. Look for properties that start with "Datasheet". Private Sub Form_Open(Cancel As...

The database server is never used to store files though so with a RDBMS, you don't have anything to hang your hat on so I just store the path in a relevant record. However, using the UNC path is better than storing the drive letter since that gives you the most flexibility and prevents errors...