Search results

  1. pbaldy

    Seeking a Moderator for the Moderators

    I'd support Doc as the "one moderator to rule them all".
  2. pbaldy

    UK Online Safety Laws - I, and therefore the site, are at risk

    I don't agree that they need to be neutral in arguments (political or otherwise); they're allowed to have and express opinions. I would say that they should set a high bar in how those arguments are presented.
  3. pbaldy

    UK Online Safety Laws - I, and therefore the site, are at risk

    Regarding "I thought the mods were supposed to monitor things, not spend all day arguing with people who have a different opinion to theirs." Mods are typically "power users" of a forum that are asked at some point to help moderate that forum. I'm guessing their heavy use of the forum means...
  4. pbaldy

    Allowedits = true interfering with duplicate macro button

    Sounds like your macro is adding the record via the form rather than via recordset or SQL? How about toggling the setting at the beginning/end of your macro?
  5. pbaldy

    What IS this left-over from a rental house? Cable, modem, router, alarm system, what?

    Keep in mind I mentioned we use the TV's remote. In addition to the up/down/left/right buttons around the OK button, it also has channel and volume up/down buttons. Those are the ones that work to change channels.
  6. pbaldy

    What IS this left-over from a rental house? Cable, modem, router, alarm system, what?

    We have YTTV and can use the up/down buttons on the TV's remote to change channels. There's also a last channel feature, though it's a bit hidden.
  7. pbaldy

    What IS this left-over from a rental house? Cable, modem, router, alarm system, what?

    Go outside and take pictures of them and their license plate, send to @moke123 :devilish:
  8. pbaldy

    Where and what were you doing on 9/11/2001?

    I lived in NV but was in Monterey, CA with my wife at a small gathering of her family. We were all talking, playing cards and such with no TV or radio on. We didn't find out about it until we got in the car to head home and heard about it on the radio. This would have been 5-6 hours after it...
  9. pbaldy

    Introduce myself

    Welcome Jeff!
  10. pbaldy

    Data type mismatch in criteria expression for opening a recordset

    The correct delimiter for a date field is #.
  11. pbaldy

    Solved Form Combo Box Doesn’t Store Selected Value (Foreign Key Issue)

    By the way, you may not realize you're not seeing the entire SQL string in that row source. If you copy it you'll see: SELECT [Unit Kerja Peserta].[ID Unit Kerja], [Unit Kerja Peserta].[Nama Unit Kerja] FROM [Unit Kerja Peserta] ORDER BY [ID Unit Kerja], [Nama Unit Kerja]; FROM [Peserta...
  12. pbaldy

    Solved Form Combo Box Doesn’t Store Selected Value (Foreign Key Issue)

    The error is not on the form, it's in your table. The row source on the lookup tab of that field is invalid. For one thing, there's a stray semi-colon before first FROM. Not many of us use that lookup field feature: http://access.mvps.org/access/lookupfields.htm Edit: Sorry, second FROM.
  13. pbaldy

    Old Newbie

    Welcome John!
  14. pbaldy

    Solved Store data from text box to control source

    Read the first sentence of my post again.
  15. pbaldy

    Solved Store data from text box to control source

    You would need to use the update events of the 2 controls that feed the calculation. As you've found, the update event of the control with the calculation doesn't fire.
  16. pbaldy

    Quick Intro

    Welcome aboard Ricardo!
  17. pbaldy

    Introduction

    Welcome Andy!
  18. pbaldy

    Introduction

    Welcome Heide!
  19. pbaldy

    Elon Musk - Tesla - FSD

    Completely agree. A Tesla in our area in self-driving mode failed to merge out of a lane that was ending. Drove up on the curb and had a close encounter with a pole. Never slowed down or swerved.
  20. pbaldy

    Coding Challenge

    My first thought isn't code, it's a query against a table with the 36 values, getting a Cartesian product. A quick example using a table with the 24 hours: SELECT tblHours.StartHour, tblHours_1.StartHour FROM tblHours, tblHours AS tblHours_1 This produced the expected 576 records.
Back
Top Bottom