Search results

Hi, Usually I can find a way around the painfully annoying flickering Access is consumed by. Dynamically loading an image to image control in Access always causes this, but I am hoping someone can help solve this. Attached is an example that mirrors the full project. Any ideas? My only other...

Thanks @theDBguy !!

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...

😴: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...

Hi! Sorry forgot to attach my test db!

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...

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...

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

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...

Final solution:

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...

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?

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.

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...

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...

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...

@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...

**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...

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

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...