Search results for query: *

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

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

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

Is there anyway to diable the Page Up and Page Down key on a form? I have a form that I had to size to fit multiple computers. On some of the computer screens the form is large though centered. I want to disable the Page UP and DOWN key so the user cannot scroll some of the fields off of the...

Is it possible to use the same subform on more than one master form? I have 2 master forms for employees to enter data input. Each form has a field on it for them to input their employee #. I have a subform that when then input their #(QEmp ID#) on the master form, their name appears on the...

Does anyone know if there is a utility or someway to accurately document and print out all the tables, queries, forms, macros, etc. in a Access Database and all their assocications.... for example, what tables are involved in a query. Relations would be good too. Any ideas. Tp

I know I have seen this thread before but have never understood the best way to achieve this. I have a database that is split (Front End - MDE) and (Back End - MDB). How do you disable the shift key at start up so the user cannot get into the underlying tables, queries, macros, etc. and delete...