Search results

  1. P

    show name in a combo box but store id

    Why does that matter?
  2. P

    show name in a combo box but store id

    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...
  3. P

    Woman?

    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...
  4. P

    New Access / SQL backend bug - #Deleted showing in Tables

    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.
  5. P

    New Access / SQL backend bug - #Deleted showing in Tables

    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...
  6. P

    Buffalo Shooter

    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.
  7. P

    This really explains a lot...

    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...
  8. P

    Buffalo Shooter

    @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...
  9. P

    Recharge My Electric Car?

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

    Recharge My Electric Car?

    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...
  11. P

    How to MS Access field grows as per data in a form

    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.
  12. P

    What is the cheapest way to get the Ms Access installed on our system?

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

    What is the cheapest way to get the Ms Access installed on our system?

    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...
  14. P

    What is the cheapest way to get the Ms Access installed on our system?

    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...
  15. P

    Solutions to random acts of violence

    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...
  16. P

    What will be on your grave stone?

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

    Combo Box, Option Group and Check Box all in One Form

    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...
  18. P

    Setting Forms Font

    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.
  19. P

    Setting Forms Font

    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...
  20. P

    saving a pdf file into a string field on an access form

    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...
Top Bottom