Search results

  1. K

    Questions regarding code for embedded Media Player

    So I have been devoting some time to this lately and got around to using a slider control and using the min and max within that control to set start time and end time on the slider and letting the slider limit which part of the video file is available. However, the slider does not move along...
  2. K

    VBA not recognizing command

    Hey vbaInet, Yeah, I tried moving everything to a new shell and still ran into the same problem... Weird, as that usually works, as well!
  3. K

    VBA not recognizing command

    Hey all, Thank you Doc and vbaInet. I ultimately decided just to re-do the form. I trid the Compact and Repair as you suggested, vba, but it did not remedy the problem and I really can't make heads or tails of the debugger.... Thank you both for your time and effort!
  4. K

    VBA not recognizing command

    There is one other form in the database that is essentially the same kind of form (a list of inputted data in a continuous form) with similar filters that work perfectly. The only difference is that it pulls its data from a different table. It is only this form that is acting weird. Is there...
  5. K

    VBA not recognizing command

    Thank you for your time and advice, vbaInet, but that still doesn't answer the question of why VBA is not recognizing the Me.FilterOn= True. Whether the filter was good, bad or ugly, the subroutine should still be attempting to turn the filter on; which it does not do. If the filter string was...
  6. K

    VBA not recognizing command

    Yes, I did. Basically, it is a filter that filters based on conditions within a text box and a combo box and it works perfectly on another form. The code is as follows: Private Sub Text9_AfterUpdate() Dim stFilter as String stFilter = stFilter & "([name] Like ""*" & Me.Text9 & "*"") and...
  7. K

    VBA not recognizing command

    I have a problem where I have a filter string written in the AfterUpdate event (syntax correct since I copied it from a form where it works solidly) but it seems like VBA is not recognizing the Me.FilterOn = True command because when I try using the filter (from a text box) the little funnel in...
  8. K

    Questions regarding code for embedded Media Player

    I have a question regarding controlling a Windows Media Player embedded into an Access Form. I am currently on Access 2003 through Windows 7 32bit and using Windows Media Player 12. I am building a database for the various sketch comedy show videos that I have downloaded over time (I am a...
  9. K

    Simple date filter string for VBA

    You rock, dkinley! It worked like a charm!!! For those dummies (like me) who may be using this thread in the future: Private Sub Text10_AfterUpdate() Dim stStartdate as String stStartdate = stStartdate & "([servicedate] >= #" & Me.Text10 & "#)" Me.Filter = stStartdate Me.FilterOn = True...
  10. K

    Simple date filter string for VBA

    Hello, After searching and searching, I have not been able to find the answer I need and I was hoping that someone would either lead me to the right thread or help a brother out... I am on Access2003 and I have a continuous form with data culled from a table that lists services. It's a...
  11. K

    Another Print question...

    Hey pl456: Thanks for the reply! It is currently set to 'None'
  12. K

    Another Print question...

    I have been looking about in these forums and cannot seem to find a suitable answer to this question: I have a report that is basically a bunch of text boxes doing differnt calculations and counts from a query. The query has about 120 or so records and the report is about 2 pages long...
  13. K

    Adding multiple records onto a connected table...

    Hey Wik, Thank you for your answer. I have thought about doing it that way but the problem is that clients in families have to be counted as unique clients as well as members of family units (I know... but what do you expect from the federal government?) The family unit as a singular entity...
  14. K

    Adding multiple records onto a connected table...

    I'm not sure if I worded the title accurately as I am having a hard time trying to describe what I trying to do (maybe that's the problem?)... I have an .mdb database that stores information regarding clients in a supportive services program for the homeless. They come to us as Single Adult...
  15. K

    Saving Data

    This thread might be of help, as well.... http://www.access-programmers.co.uk/forums/showthread.php?t=38364&highlight=undo+record
  16. K

    Is there an "unless" syntax in VBA?

    Hey all, Sorry for responding so late, but I have been away at various trainings and conferences. Upon returning, I tried out pbaldy/lagbolt's suggestion and it worked like a charm! Thanks to everyone who helped me out!
  17. K

    Is there an "unless" syntax in VBA?

    pbaldy: Where would I insert that code? Would I move it to maybe the before update event of the medicaid checkbox? HiTechCoach: I would go with the option group but there actually are clients that receive both (e.g. very scant work history = not enough quarters worked for the SSDI check...
  18. K

    Is there an "unless" syntax in VBA?

    I have a form (frminitialincome) that tracks different income sources for clients in a social work outreach project through several check boxes (we are limited to tracking only certain kinds of income based on what our funders want to see) that populates a table with same (tblclientincome.) It...
  19. K

    Enabling a disabled checkbox under certain conditions

    I wanted to thank everyone who helped me out with this as it is now working great! I also wanted to thank the responders to the double post that I put in the forms section.... And my apologies for being an idiot and double-posting.... :-(
  20. K

    Enabling a check box under certain conditions.

    * I had originally posted this in the VBA section and realized that I had misfiled it... I was wondering if this was possible: I am using a form with checkboxes that also populates a table with several checkboxes to give profile information on mental health clients. All of the fields are...
Back
Top Bottom