Search results

  1. K

    Help with populating Report from a Query

    Hey everyone, I am sure there is another thread out there to this effect but I am having a hard time putting in the right search thread to find it. I am on Access 2000 building an mdb database to keep track of attendance at monthly community meetings. Based on past attendance (criteria...
  2. K

    Copying or Moving a Video (or any other kind) File from One Folder to Another

    Hey everyone, I have a database that keeps track of sketch comedy bits in Access 2003 .mdb format. Thanks to everyone's help here, it is a really bitching database that allows me to add information and watch those videos on a separate form. Now I want to take it one step further in helping me...
  3. K

    Help with expression to get text string from check boxes

    I have a database that keeps track of special needs of social work clients and I need some help displaying data a string of text based on data entered through check boxes. After case managers have gathered intake information from a client, they enter the data through a form that allows them to...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. K

    Enabling a disabled checkbox under certain conditions

    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 independent of the others (e.g. "physical disabilities" can be checked alongside "domestic...
  12. K

    Help with alphabetizing movie titles that start with "the" and others

    I am building a small personal database to organize my DVD movies, but thought I would get this issue cleared in case I need to do this for either a work project or something for someone else. One of the tables in the mdb file is, of course, the one that contains the titles of the movies...
  13. K

    Advice needed on database design

    Hey all, I wanted to post on how to set a module or some equivalent to do automatic billing, but I think that that would have become a longer than necessary thread if my database is not designed correctly in the first place. I thought I would solicit some feedback on whether my database can...
  14. K

    Is this VBA code still vaild?

    I was going through these forums looking for information on making text boxes fill in table fields upon button commands or close of forms, etc. and ran into this post. However, this post was from a while ago (I think the post said 2000) and I was wondering if it would still work on Access 2003?
  15. K

    Code to make a button on a form do more

    I was chastised pretty severly the last time I tried this , so here I go again! I have a form that I want to use to change the status of clients from "open" to "closed" called frmcloseout. The status is being generated from a combobox in the client profile table which has the fields clientid...
  16. K

    Restricting the adding of records into table from form

    Please excuse me if this has already been covered in this forum before, but I could not find an answer for my problem despite poring through the threads. Also, please excuse me if this is something stupidly simple as I am an almost complete beginner and self-taught (can't seem to teach myself...
Back
Top Bottom