Search results for query: *

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

I have a form where the user inputs data into an underlying table. After inputting the data I need the user to be able to print a report based upon the data just entered. So I have created a report based on a query of the table. I have placed a button on the form that the user clicks on to print...

Can anyone explain to me why recently my database has started to show the following items in my Tables. MSysAccessObjects, MSysAccessXML, MSysACEs, MSysObjects, MSysQueries, MSysRelationships. These did not show up in my database until I think I compact and repaired the database. But now it...

Does anyone know if you can do bulk email from an Access application? I have a client who has a list of customers that he sends emails to on a monthly basis. He is currently doing this out of Outlook but there are a number of other things he would like to be able to do and I thought Access would...

Is it possible to have a field automatically place N/A in it if the field is blank? I have a report based on a query of a table of data. Some records do not have data for all fields which means in my case the data is Non Applicable (N/A). I would like on my report instead of just leaving the...

Does anyone know if there is a limit to the amount of fields you can query? I have a query that looks at two tables that have alot of data in them. I need the query to create a report. So I have 130 fields in the query. Then I noticed I left about 15 fields out so when I went to add them the...