Search results

  1. ironfelix717

    Solved Access Query - From 2 different tables, without IIF!

    UPDATE** I just needed a Union query to join both tables and then process the query on the union query as I would a single table. Why that didn't cross my mind earlier, not sure. I suspect thats the cleanest way of doing it. Which will be more than one single query (2), but thats the way the...
  2. ironfelix717

    Solved Access Query - From 2 different tables, without IIF!

    😴:sleep::sleep: @arnelgp Hi, thanks for your efforts. That query does not produce intended results. See below. @isladogs I still need other data other than "Status" from either of those 2 tables. So rather than just determining the status, I need the full record returned, which i guess...
  3. ironfelix717

    Solved Access Query - From 2 different tables, without IIF!

    Hi! Sorry forgot to attach my test db!
  4. ironfelix717

    Solved Access Query - From 2 different tables, without IIF!

    Hi, I have a reasonably complex query I am hoping to get help with. Essentially, I need to match an order containing CustomerID and Version to a record that may exist in one of TWO tables, and get the STATUS field of the record. I have worked around this in the past using an expression field...
  5. ironfelix717

    Code: VBA WeatherUnderground.com SCRAPER

    Description: This is a VBA scraper for pulling historic weather data for a specific day/month and location/station. WU is supposed to be a quite accurate data source for historic weather. In the past, they had an API. Since IBM bought them out, the API has since been restricted to a premium...
  6. ironfelix717

    SQL - INSERT INTO / SELECT FROM, one field with SET value

    Hi, I get an error when using that. "Query input must contain at least one table or query"
  7. ironfelix717

    SQL - INSERT INTO / SELECT FROM, one field with SET value

    Hi, Is it possible to provide a SET value in an INSERT/SELECT-FROM query?? EX: SQL = "INSERT INTO ToolingBuilds " & _ "SELECT ToolID, ToolVersion, ToolCompID, ToolCompVersion, " & _ "DateModified FROM TempTable;" In the above, I need to insert all the fields from...
  8. ironfelix717

    Access Continuous Forms: Row highlighting + DBLclick functionality

    Hi, Your example does exactly as I requested: effect only the selected row in a continuous form The problem now is the formatting is only applied when the item/row has focus. Move the focus away to the currentID textbox and the formatting disappears. ------- I suspect what I am trying to...
  9. ironfelix717

    Access Continuous Forms: Row highlighting + DBLclick functionality

    Both problems seem to be related in that if I can figure out a way to affect only the controls in the row with focus, I can solve the rest. Is there any way to do this?
  10. ironfelix717

    Access Continuous Forms: Row highlighting + DBLclick functionality

    Hi, Thanks for your example. I see what you are explaining, but i am unsure how this allows me to conditional format the selected row, simply based on a selection. hmmmmm. Only way I can tell is by conditional formatting feature.
  11. ironfelix717

    Access Continuous Forms: Row highlighting + DBLclick functionality

    Update: I guess i sort of solved item 2: I was overthinking it perhaps. (This works for just one of the textboxes) - though I would prefer to not write code for every On_Click event for each textbox. Private Sub tbPartnumber_Click() tbcurrent.SetFocus 'move focus out of clicked textbox End...
  12. ironfelix717

    Access Continuous Forms: Row highlighting + DBLclick functionality

    Hi, thanks for the help. For (1) formatting: To clarify: when i say "formatting" I am discussing formatting borders, colors, etc, and not the data. I was unable to get the On Paint event to work. The same result occurred: every row highlighted. I need to see a code example to have any idea...
  13. ironfelix717

    Access Continuous Forms: Row highlighting + DBLclick functionality

    Hi all, I've finally delved into continuous forms and am enjoying this new discovery. What led me here was the need for a Data Grid / Editable listbox control that i've been dancing around with a lousy (but functional) custom form control. Therefore, my end goal of this form is to simulate...
  14. ironfelix717

    Unbound Multi User DAO Recordset locking

    @theDBguy @GK in the UK Thanks for your input. Flags is something i've already considered. I would highly recommend avoiding that method. Its not an approach that is ideal. What if the system crashes, power goes out, and a flag is left ON ? I can already hear the users crying "Someone call the...
  15. ironfelix717

    Unbound Multi User DAO Recordset locking

    **UPDATE Greetings, So, I had a dumb moment (as I often do). The example above, when cloned, just uses the local table, not a common backend, so obviously there wasn't a conflict (its not modifying the same table). That was dumb. Apologies if that confused anyone. I have since cobbled...
  16. ironfelix717

    Unbound Multi User DAO Recordset locking

    Hi, there are several reasons to use bound several reasons to use unbound. This topic is about unbound.
  17. ironfelix717

    Unbound Multi User DAO Recordset locking

    Hi all, I'm trying to ensure I fully understand how locking will work in a multi-user access environment (5-10 users) and to plan my code around it before I continue development. This question is in reference to unbound forms. How do you pros write your code to handle conflicting updates, etc...
  18. ironfelix717

    Solved Google Earth KML Parser - Ignoring irrelevant header/fields

    Solved: https://www.access-programmers.co.uk/forums/threads/code-vba-google-earth-kml-file-placemarks.312441/
Top Bottom