Search results for query: *

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...

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.

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...

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...

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...

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...

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

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

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...

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...

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?

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...