Recent content by tpearo

It is null or another words there will be cases where there is no data entered in those fields. Tp

I have a form based on a table that has multiple fields. I need to get a total of several of the fields and display this total on the form. Then I need to get an average and display this average based upon only the fields that have data in them. For example there are 18 fields but each record...

I have a small database that I've created in Access for gathering some important engineering data. I want to be able to graph the data ~ or link to a graph in Excel. I need the graph to be updated when the data is updated in the Access database. Is there a simple way to do this? Anyones help is...

To All You IT/MIS Genius'.... Perhaps you can shed some light on this issue. I am a self taught Access programmer. However just a technical user on this forum, over the last few years I have designed, developed, written, and implemented some pretty sophisticated and useful Access databases...

Can anyone help me with this one? I have a table that has a field called RMA#. I can't use the auto number feature because of the format required by this customer. The RMA# is a sequential number assigned to each new record. The format is ex. 4605-355, where the 46 relates to the week of the...

I have a database that I have designed for my laboratory. In this database I have several forms based on 1 table. The table has 1 autonumber field called Insp Rec #. Each form has fields from the table but are only opened and used based upon the type of test the lab tech. will perfomr. Once...

I have a database that I have designed for my laboratory. In this database I have several forms based on 1 table. The table has 1 autonumber field called Insp Rec #. Each form has fields from the table but are only opened and used based upon the type of test the lab tech. will perfomr. Once...

O.K. But how do I link the form to the selection in the combo box. For example I have five selections in the combo box 1. Final 2. F/A 3. Photo 4. 2nd Final 5. S/F And I have 5 different forms that have different fields depending on the selection above. So how do I tell the system to open the...

Is it possible to have a list box that lists the forms in your database and allow the user to select a form from the list and when selected launch or open that particular form? I have about 8 forms that have fields that need to be filled out based upon the testing my technicians do in my lab. I...

Is it possible to have a list box that lists the forms in your database and allow the user to select a form from the list and when selected launch or open that particular form? I have about 8 forms that have fields that need to be filled out based upon the testing my technicians do in my lab. I...

Can anyone tell me how I can link a dbf file that is written in Clipper to Access. I am told that I might need an ODBC Clipper Driver. If so... can anyone tell me where I might get this driver? Thanks for your help Tp

I have a form that I use to allow tecnichians in my lab keep track of time they work on a project. Each technician has an Employee #. My form has a subform based on a query that when they type in thier Employee # their name appears on the form. Then the other two fields are Date and Time that...

PHV, I'm not sure exactly how you do this. Can you explain? I have a button on the form to close the form. Is there a way to prohibit closing the form until all the data is filled out in the "Required" fields? Thanks in advance for your help. Tp

I have a form where there are several fields that require data. Sometimes the techician forgets to enter data in a certain field. Is there a way that if the technician forgets and trys to close the form a message box can be displayed saying something like "ALL DATA MUST BE ENTERED BEFORE CLOSING...

I have a form that opens based upon a query where the query asks for a Report#. The Report # resides in a table the query is based around. I need the form to open only if the Report # exists. The report # is an Auto assign field in the table and sometimes the technicians using this database...