Search results

  1. P

    Help with moving Access database

    Don't know where that number came from Colin. I didn't review the file in detail. It was dated 2011 and so has been around for a while --- I did mention SPECIFICALLY that the OP would need to change the Access version to whatever he was using. Thanks for the heads up though.
  2. P

    Late Stage Capitalism?

    The Original Equipment models cost at least four times as much as one you can purchase on line or from Best Buy and have installed yourself.
  3. P

    Ouch #3

    According to CBS, that is incorrect. They did not turn down a jury trial. They were not given the option. The judge told them he would turn down the request. https://www.cbsnews.com/news/trump-trial-no-jury-fraud-new-york-judge-arthur-engoron/ Now we're waiting for the conviction to be...
  4. P

    Trump Administration Predictions

    I have a good friend who has worked as an import broker for batteries (mostly) from China for at least 40 years. He has a gazillion frequent flyer miles. He has branched out and now has a factory making other stuff using Chinese components here in the US so now, he is importing for himself and...
  5. P

    2 queries in one form

    That would be the clear answer;)
  6. P

    Future of Access

    It seems that I cannot explain it so you understand the problem.
  7. P

    Help with moving Access database

    I explained how to do it. I just found a very old example. You will need to update it for your version of Access. You need to set this one to allow a network location: [HKEY_CURRENT_USER\Software\Microsoft\Office\17.0\Access\Security\Trusted Locations] "AllowNetworkLocations"=dword:00000001...
  8. P

    2 queries in one form

    It isn't necessarily that the relationship is "wrong", it is that there is already data in the table that violates the relationship.
  9. P

    2 queries in one form

    All bad data must be removed before RI can be enforced.
  10. P

    MVF Technical Discussion and Uses (If you plan to Use Them)

    That isn't true. list boxes can go on main forms also but they are not bound when they are multi-select
  11. P

    Future of Access

    I agree but usually the bad module doesn't affect other parts of the application as it can with Access. Having source control is excellent, especially when working with a team. Since I generally work alone, I am religious about backups and I use export to text to prevent backing up corrupted...
  12. P

    Help with moving Access database

    I do that for neatness and also just in case the user has a full version of Access installed. If you open the .accde with full Access, you get to the Nav pain and you can change, tables, queries, and macros. The only things you cannot change are forms, reports, and modules. So the extra step...
  13. P

    Trump Administration Predictions

    If you tell me what you want for a result, I can choose my population to give you your "answer". Don't believe any statistics unless you totally understand the data they were based on.
  14. P

    Crosstab or transpose query with multiple fields

    That's just the wizard. Once the query is created, you can add other columns.
  15. P

    Crosstab query that uses Form field as criteria

    That is true for ALL queries that take arguments, not just Crosstab queries.
  16. P

    Trump Administration Predictions

    If you recall, the point of the tariff situation was to equalize tariffs. It stands to reason that some will go up. I'm pretty sure you are misquoting me. Many of these fees are already controlled by some agency or other. Things like CC interest rates which is what I was probably talking...
  17. P

    Trump Administration Predictions

    Did you notice how many times during the Biden/Harris administration the numbers were changed downward? THAT was why the person got fired. They were incompetent.
  18. P

    Help with moving Access database

    That's what the Runtime is for;) You can't get to design view on any object.
  19. P

    Record Too Large error message

    You need two tables. tblPlots PlotID (primary key) Section (unique index, field1) Sequence (unique index, field2) Notes tblPeople PersonID (primary key) PlotID (foreign key to plots) -- allows multiple people to be buried in the same grave LastName FirstName MiddleName Prefix Suffix DOB DOD...
  20. P

    Linked tables don't appear to be

    If your linked table is SQL Server or other RDBMS, the link to the table will be in the Connection property. If your linked table is anything else, the link to the table will be in the Database property because it is a file name. So links to spreadsheets and text files are stored here also. If...
Back
Top Bottom