Recent content by Pat Hartman

  1. P

    Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.

    Use the MSysObjects table. Create your own copy of the table I pasted. That will make it easy for you to select the objects you are interested in and give them a "type" name. This query will give you just the form's and reports.
  2. P

    Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.

    Here's a table that is useful when you write queries against MSysObjects. To find out what object types you have run a query on MSysObjects and look at all the Type values. It is possible that this table is not complete because I don't have any databases with a particular object.
  3. P

    Solved Key Violation Error Trapping During TransferText Operation

    It's the part about Access having to bring every single row from the server table into memory on the local pc in order to do the join.
  4. P

    ChatGPT on Rhode Island S2622

    When the twins were ~ 4, one of them was sitting on my lap and she was rubbing my arm. "Grandma, your arms are wrinkled", my repy - "I forgot to iron them this morning". Her head actually did the robot twitch - does not compute, does not compute. Took about 3 seconds before she recognized I...
  5. P

    I want to be a tree surgeon!

    I'm being too subtle;) The Democrats want the military to go "green" so they want everything to run on battery power. Either that or every land vehicle needs solar panels on their roofs and either huge batteries or they just shut down at night. That'll work. The fighting force will be very...
  6. P

    Does someone have neteller account?

    I don't know. I almost never ask questions. You can only see the solved option if you posted the question.
  7. P

    The Deep State

    @Solo712 Have you ever wondered why 6 counting centers in the battleground states stopped counting before 10 PM on election day? Trump was well ahead. Then even though they hadn't been counting all night, The gap had closed and Trump was losing by the next morning. Can you ever remember...
  8. P

    Ordered By Warning in Sql Server

    It is logical. Views act much like tables. In relational databases tables AND queries are unordered sets. That means that the sequence of the records returned to you is not defined UNLESS you include an Order By clause in your query. Think of it as if you were pulling marbles out of a bag...
  9. P

    hide a record while it's being edited in a form

    How many records can a user look at at one time? One. How many records are in your table? 10,000, 100,000, 500,000. Do you think it makes sense to bring 500,000 rows from the server into memory on your local PC when the user can't possibly work with more than one at a time? That is exactly...
  10. P

    Solved Key Violation Error Trapping During TransferText Operation

    You still do not understand the problem. Perhaps someone else can explain to you how a heterogeneous join is performed by Access.
  11. P

    Fair Share

    No. Both the Democrats and Republicans are equal-opportunity loophole creators. This is a "Congress" problem and cannot be blamed on either party. For reasons that escape me, no bills ever clean up old tax laws so they accumulate and add to the confusion. Most Americans can't even do their...
  12. P

    I want to be a tree surgeon!

    The question was rhetorical. Does it have an extension cord?
  13. P

    How to auto fill controls with combobox

    It seems that you have an answer but just in case, here is a link to a database of samples. Look at item # 5. It shows multiple ways you can fill controls on a form with data from tables/queries other than the one the form is bound to...
  14. P

    Ordered By Warning in Sql Server

    I don't understand why the Top predicate is there at all. But the joins and the where clause limits the selection and should not require Top to limit it further unless a large number of rows would be selected and the user only needs to see a few of them. I've never seen this warning before but...
Top Bottom