Search results

  1. I

    Out of Conditional Format Options / Refer to subform of subform

    Thanks for the feedback. In this case, I'm still working in AC2000. (:banghead: :banghead: :banghead: :eek: :banghead: :banghead: :banghead: :D) I'll look into your example database and possibly give you "the greatest compliment" by stealing your code (again). Begin LOL: AH. The...
  2. I

    Access closing unexpectedly after editing VBA

    This may be off base but is it possible that VBA is choking on "GoTo" from GoToRow? I realize these terms are not exactly the same and I usually get around reserved words like "Date" with variations like "MyDate" I'm curious if you used a different name for the function, would the error go...
  3. I

    Out of Conditional Format Options / Refer to subform of subform

    This is more of a note to self / posted to assist other that may have the same problem. Setup: I have a form named "Support_Master". "Support_Master" has sub-form "subOrderSub" based on the form "Support_OrderSub". "Support_OrderSub" has a sub-form "subItemDetails" based on the form named...
  4. I

    Improve file security in Access databases

    The password to open can be removed and / or changed from an external copy of Access or other VBA enabled program.
  5. I

    UK dates in SQL queries

    You may want to review this: Bad Habits to kick mis handling data range queries: https://sqlblog.org/2009/10/16/bad-habits-to-kick-mis-handling-date-range-queries After digesting this I use only the universal standard with this code snippet in VBA: (This is for passing date values to SQL...
  6. I

    Strobe Effect - VBA

    @Guus2005: Thank you! I didn't even know GoSub | Return existed as an option.
  7. I

    Strobe Effect - VBA

    Double click the Color 1/2 field to show the color chooser. Click the ok button in the color chooser to set it. The number will be the value and the color will become the backcolor of the color fields. This was working for me with AC2000
  8. I

    Strobe Effect - VBA

    Challenge Accepted. I had to find a color chooser and integrate it https://stackoverflow.com/questions/6324883/a-color-picker-control-for-visual-basic-6-vb6 Here's a basic interface to make it happen. Open the form and play.
  9. I

    Strobe Effect - VBA

    I needed this but couldn't find it so I created it. I am open to suggestions to improve the code. Option Compare Database Option Explicit Public Declare Sub Sleep Lib "Kernel32" (ByVal dwMilliseconds As Long) 'Developed and tested under Access 2000 ' 'Author: Insane_ai, member Access World...
  10. I

    Combobox how to reset if without required value

    You did what I would have chosen as the easy answer but I was trying to answer your question under the presumption that you were stuck with the required flag on that field. With Code I don't think there is cheating, only what works and what doesn't.
  11. I

    Combobox how to reset if without required value

    That would be the easy way, my comment above with the unbound form is the long way around the issue but writing some validation code on the combo box would be simpler.
  12. I

    Combobox how to reset if without required value

    If you want to use method #2, I would put the code into the Form Load event. This will populate the combo box for you. Reading a bit deeper into your question, I think you may be better served with an unbound form. This requires a bit of extra work but allows you to validate your data before...
  13. I

    Changing format in data table below chart object

    This format works for me in the debug window debug.Print Format("4096","# ##0") 4 096 Maybe this article will help a bit more.... https://support.office.com/en-us/article/Specify-how-data-displays-by-using-custom-formatting-A5E5BCDE-85DA-4C7A-8164-1FE286636668#bm2
  14. I

    Old Dog Learning New Tricks

    Welcome to the forums! Sometimes it's better to be lucky than good. I wish good luck! (You'll have to handle the being good on your own)
  15. I

    Combobox how to reset if without required value

    There are two simple ways I can think of to address this. 1. Add a default record into tblStore that can be used as a trigger to open your other form if that one is selected. (This is not my preferred method as it adds dirty data) 2. Manually populate the Combobox with a default value then...
  16. I

    Findfirst with 2 criteria not working

    Here's an example of a Find operation with multiple criteria. https://access-programmers.co.uk/forums/showthread.php?t=203515
  17. I

    Newbie

    Welcome to AWF!
  18. I

    Macro Action selection

    Please tell us what version of Access you are using, it may change the response you receive. My initial thought is that you call the macro from VBA on some event and include a line of code to make the change you need. it would look something like this: Dim myVar as varType myVar =...
  19. I

    Hi Everyone!!!

    Welcome to AWF aazar79 Since you have a bit of experience, maybe you will enjoy a challenge: Security Challenge #1 thanks to Ridders
  20. I

    Hide/Unhide database window with VBA code

    Thank you ByteMyzer, I found this useful. Ridders would tell me I should know enough to handle this but in my environment "Certain users" are allowed to use the MDB instead of the MDE so I have to leave the F11 option open to them.
Back
Top Bottom