• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Recent content by ironfelix717

  1. 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...
  2. 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"
  3. 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...
  4. 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...
  5. 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?
  6. 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.
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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.
  13. 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...
  14. 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