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...
Is it possible to provide a SET value in an INSERT/SELECT-FROM query??
SQL = "INSERT INTO ToolingBuilds " & _
"SELECT ToolID, ToolVersion, ToolCompID, ToolCompVersion, " & _
"DateModified FROM TempTable;"
In the above, I need to insert all the fields from...
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...
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.
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
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...
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...
@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...
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...
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...