Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kcbeckwith

  1. kcbeckwith

    Capture the Current User's Login Name

    Thanks! It worked great, but is there a way I could do this within a subform? The data is going into the table, but the data is not linking to my main table. The way I have it set up is a one to many relationship,where the main table has the Correspondence Tracking Number and all the...
  2. kcbeckwith

    Capture the Current User's Login Name

    Hey There, When I run the Cmdprocess button, it comes up with a Visual Basic Error on the "db as a database" The error messages says, "Compile Error" "User defined type not defined.
  3. kcbeckwith

    Capture the Current User's Login Name

    How would I get that User Id saved to a table? My goal is to be able to create a form that once it is open it will pull the current user's id who is logged on and then have a Yes/No field and a date field that the user would fill in. I want to be able to track data on the User's Id. Is this...
  4. kcbeckwith

    Capture the Current User's Login Name

    I'm trying to setup a database that tracks documents and I would like to learn how to capture the current user who is logged on and store the value in a table and a form. (The database will be stored on a Netware 6 server.) I have found the following code on Tek-Tips Website and tried to create...
  5. kcbeckwith

    Yes/No Field Linked to Date Field

    Is there a way that if I have a Yes/No Field and a Date Field, that when the Yes/No field is checked, that it would fill in the current date in the date field. Also, it would not allow anyone to uncheck the Yes/No Field once it's checked, nor change the current date. I'm trying set up a...
  6. kcbeckwith

    Make Field Read Only

    I have a field called ReasonforRelease that is a text field with a value list of Death, Released, Transferred. My question is how would I make that field "Read Only" if released or transferred were chosen. I would like to also be able to change the color of that field when it becomes Read...
  7. kcbeckwith

    Duplicate Data when querying 3 or more tables

    Duane, Thanks for your help! The subreports worked. I would never thought of using subreports. Thanks again.
  8. kcbeckwith

    Duplicate Data when querying 3 or more tables

    Duane, Is there a way to get the headers to show in the sub-report?
  9. kcbeckwith

    Duplicate Data when querying 3 or more tables

    I apologize. Lab2 does have a field with PatientId in it. I accidently forgot to list it. I have read many books and searched the Internet on database design and cannot figure how out how to get my reports not to duplicate data when I use 3 tables. Everthing works find with 2 tables, once I...
  10. kcbeckwith

    Duplicate Data when querying 3 or more tables

    Duane, The reason I would want to use 3 tables in a query is because sometimes I need a report that would have data from all three tables. I'm fairly new at Access, but I thought the best way to set up a database was to split your data up into different tables and create a relationship between...
  11. kcbeckwith

    Duplicate Data when querying 3 or more tables

    Duane, I'm not sure I understand you. Are you saying that my relationships are not set up correctly and thatis why my queries are not working right?
  12. kcbeckwith

    Duplicate Data when querying 3 or more tables

    Hi Everyone, I could really use some help! I have a database that tracks lab results and it has about 8 tables in it. I have all the tables set up as a one to many. There all related back to the first table, which has the patient's first name, last name, and other data that would only have...

Part and Inventory Search

Back
Top