Search results

  1. G

    Solved Form to add data to multiple records

    @bastanu would you have a walkthrough guide you could send over by any chance? I'm fairly new to VBA and I'm struggling a bit on how to get started
  2. G

    Solved Form to add data to multiple records

    Gotcha. I'll give it try and circle back here if I run into issues. Thanks
  3. G

    Solved Form to add data to multiple records

    I do not want to update thousands at once. Yes, it has thousands in there but the user needs to specify want records to update. This would be used to update a few records at a time. The user knows what records they want to update and they want to update them all with the same thing.
  4. G

    Solved Form to add data to multiple records

    There's thousands of complaints though. That's why I felt a simple textbox was easier
  5. G

    Solved Form to add data to multiple records

    See the attached DB. I'm trying to come up with a form that will update multiple records with a single line that the user inputs. So in the example, I'm hoping to allow the user to put in multiple complaint numbers, and then type out whatever they want in the follow-up field. Then once the...
  6. G

    Solved Any way to prevent textboxes from flickering?

    I'm not certain 100%. I've done it for a while. I think it was due to an unassociated label glitch in earlier Access versions. See here: http://allenbrowne.com/ser-46.html Either way, I am wrong. I am going to convert all mine back to labels.
  7. G

    Solved Any way to prevent textboxes from flickering?

    Gotcha! I'll do that
  8. G

    Solved Any way to prevent textboxes from flickering?

    Thank you. Somewhat related question...these textboxes are basically used as labels. I was always taught that unassociated labels should just be converted to textboxes for better form efficiency, so that's what I've done. Is that still the case? Cause obviously just using labels is far simpler.
  9. G

    Solved Any way to prevent textboxes from flickering?

    That worked!! Thanks so much.
  10. G

    Solved Any way to prevent textboxes from flickering?

    In my single form, any textbox that uses an expression flickers when changing records. These aren't calculations either; I use a few textboxes as labels so it's just ='Label' in the textbox's control source. Still flickers. Any suggestions on if that can be fixed?
  11. G

    Help with cursor on textbox

    Disregard! It'd be 0 for default
  12. G

    Help with cursor on textbox

    @CJ_London gotcha. Is there a way to have code to 'reset' it so to speak? Meaning revert back to default where it'll be a pointer or insertion as it normally would be?
  13. G

    Cleanest way to filter down to YTD across multiple years?

    That worked! Thanks so much!
  14. G

    Cleanest way to filter down to YTD across multiple years?

    Hmm so the query ran, but it's only showing records for 2023. I'm looking for records across all years from 1.1 to present day
  15. G

    Cleanest way to filter down to YTD across multiple years?

    Yes, that works. Not sure what else could be wrong. Here's an example DB. Try using your code in a new query (I can't save your code in a query because I get the syntax error whenever I try to save it)
  16. G

    Help with cursor on textbox

    No, I don't need to edit the contents, but putting Enabled to 'no' then doesn't allow you to double click on the textbox to trigger an event
  17. G

    Cleanest way to filter down to YTD across multiple years?

    No I’m sorry. I used your entire code. I only meant that the subquery was what the syntax error was popping up on
  18. G

    Cleanest way to filter down to YTD across multiple years?

    Hi @ebs17 I tried your solution and created a T999 table with I having records 0 through 999. Unfortunately I'm getting a syntax error on the above piece of code. I'm not exactly sure why. I copied it exactly as you provided. Also, complaintdate is indexed
  19. G

    Help with cursor on textbox

    I have a textbox where I don't want the cursor to change to insertion cursor; I want it to remain the pointer when hovering over the textbox. I placed 'screen.MousePointer = 1' in the Move Mouse event of the textbox, which worked. However, after you hover over that textbox, the pointer cursor...
  20. G

    Cleanest way to filter down to YTD across multiple years?

    I have a table of complaints dating back to 2014. There's roughly 10 thousand records. I inherited this DB and there's a query which filters down to YTD across all years (i.e. it only shows records between 1/1 through today across all years). The query takes a while to load as opposed to all...
Back
Top Bottom