Search results

  1. R

    condition criteria for forms

    I have two buttons: Archive and Activate that both call the same form: ListForm. This form has a list box of employees which you then double click on the employee you wish to alter and another form: frmautostatus opens with the employee info. Problems: I need the ListForm to only list those...
  2. R

    repost b/c no response

    I have a report called phone list that pulls info from one table. I have both active and inactive employees in the table so in the report I only want to display the active employees info. How do I do this? Also, I want to be able to write the report to a .txt file. Any ideas?
  3. R

    repost b/c no response

    I have an add button that adds the newly input data into the table from the form. What I want to do now is when you click the button you get a verify form that lists the info in report form that was put in and a verify to make sure all the info is correct. If not, then hit no and return back to...
  4. R

    command buttons

    I have an add button that adds the newly input data into the table from the form. What I want to do now is when you click the button you get a verify form that lists the info in report form that was put in and a verify to make sure all the info is correct. If not, then hit no and return back...
  5. R

    filter only on one criteria to be displayed in report

    I have a report called phone list that pulls info from one table. I have both active and inactive employees in the table so in the report I only want to display the active employees info. How do I do this? Also, I want to be able to write the report to a .txt file. Any ideas?
  6. R

    Yes/No shows up at 0 and -1

    I have a yes/no valued field in my table. When I use a form that queries the database and posts the information requested, the status text box does not return yes or no but 0 or -1. what am I doing wrong.
  7. R

    What does this error mean?

    I have a data entry form and then press add. this is what I get: The changes you requested were not successful. You can not create duplicate values in the index, primary key or relationship. Change data in the field or fields that contain duplicate data, remove the index, or redefine the...
  8. R

    Input mask for SSN in database

    I am not sure of the input mask to include for the input of a SSN. I want to appear as: 555-55-5555 I have selected it to be a long integer. Is that also correct?
  9. R

    Filtering data to report

    I have a table with personnel info. One field is the status, either yes or no (active or not). How do I filter the employees to create a report of just the active employees? I have a query created off the table that is now communicating with the form as I do not want all the fields from the...
  10. R

    Please respond to previous post!

    i really need to finish up on this project. I posted Under "opening selected record in new form" No one has responded yet and I am desperate for info. I am not an access programmer. I would be more than happy to email someone my database to look at and offer suggestions. I posted on July...
  11. R

    opening selected record in new form

    I am developing in access for my current project but do not pretend to call myself an access programmer. I am a novice with a mission. I have created a switchboard (access 2000) that when a button is pressed brings up the Employee selector form which has a list of the names in my database and...
Top Bottom