Search results

  1. J

    Automate badge numbers

    I am using Access 2003 Say I have 3 people in my data base. As they become eligible for a badge, I give them a badge number. The badge numbers are sequential, but the dates for eligibility are not. By that I mean, Bill may be the first applicant, but the third person to get a badge. How can I...
  2. J

    Help with this query, please

    I want to pull a report that shows units that are down in a specific time frame AND units that are already down outside that time frame IF the TimeOn field is null. Below is how the query is set up. It is pulling any nulls outside the time frame (which is what I want) but it is also pulling ALL...
  3. J

    Two different criterias

    I want to pull a report that shows units that are down in a specific time frame AND units that are already down outside that time frame IF the TimeOn field is null. Below is how the query is set up. It is pulling any nulls outside the time frame (which is what I want) but it is also pulling ALL...
  4. J

    report criteria

    I want to pull a report that shows units that are down in a specific time frame AND units that are already down outside that time frame IF the TimeOn field is null. Below is how the query is set up. It is pulling any nulls outside the time frame (which is what I want) but it is also pulling ALL...
  5. J

    Wizard missing

    I am running Access 2000. The control wizard is not available. It does not come up when I add a command button for example. How do I get it turned on?
  6. J

    leaving field null based on another field

    I have a downtime database that tracks units down, time on, reason down, etc. When a unit goes down, I log the name of the unit and the time down in separate fields. When a unit goes back on line, I log the time on and the reason in separate fields. All this is in a form. When the unit goes on...
  7. J

    problems moving to 2003

    I have had a split data base (version 2000) running on Windows 2000 with no problems. Our office has upgraded the computers to Windows XP Professional Version 2002 and Office Access 2003. I cut the links to the backend and imported the tables back into the 2000 version. I then moved the data...
  8. J

    macro will not run

    I have a split database that is shared on the network. Three computers have the front end. The back end is on the network. I obtained a module on this forum to bypass the shift key on start up. This is to protect the database from want-a-be hackers. (we have plenty here) This has worked great...
Back
Top Bottom