We have an Access program that in addition to providing important information in various fields, it allows us to click a button and view a PDF file on the screen within a special form for each record. The way that it is now set up, we have a text box where we type the entire path and pdf file...
I've created a database which contains information about special committees in the office. Each committee has from 1 to 5 members. Each member is listed in field Mem1, Mem2, Mem3, Mem4 or Mem5. Field Mem1 is usually the chairperson. Field Mem1 and Mem2 may be co-chairs. Fields Mem3 - Mem5...
Hello,
I have created an Access database (version 2007) that is used and frequently updated by several staff members in the office. In addition to the updated records, there is a list of associated staff members for each record or type of records. In one field there is a frequency listing...
We have a Microsoft Access Database which is saved in a shared drive. Until now, we have not had a problem with many people having access to the database or the data. Beginning immediately, several people will be using the database and we want to be sure that they are not allowed to open and...
We have created a MS Access database which holds infomation and worked well until today. All of a sudden I get a Microsess Office Access error message as follows:
********************************************************************************************************************
The expression...
We have an Excel Spreadsheet with eight tabs at the bottom. Each layout is the same for all tabs. The layout involves varing widths and heights of cells. The difference is the data entered and the titles. When we completed the first tab and tried to copy it seven more times, the size changes...
I have a database with a few records in it. When the form is first opened, the cursor blinks in the first field prompting the user to input data. However, when the user moves to another record or returns to the first record, there is no cursor blinking. The user has to click in a field and...
I have a database where one of the fields lists Point of Contact (POC) names. There can be from one to four names in the POC field and they are separated commas. I have already made several types of reports. The only one which is giving me trouble is the report that is in order by "Points of...
We have four tables linked together in a MS Access 2000 database. We need to have a form where several fields are listed as either drop downs or text boxes. When a search button is pressed the database is searched for records which match the info placed in the entry boxes. Boxes which have...
We have a database which records each payment made periodically by defendants per court order. Copies of the court order and check/money order payments are kept in folders for future reference.
We would like to begin scanning the court orders and payment checks/money orders into separate PDF...
We would like to create Sheet 2 of an Excel workbook and have a summary of totals taken from Sheet 1. Sheet 1 will have multiple bits of information and totals which might cover 300-500 lines. Sheet 2 should be about 7 lines with totals only. How do I reference cells, totals, etc. from one...
We have a database that consists of the following:
Table of salespersons: tblSP
Table of Date Ranges: tblDR
Report1 Item Sales information: rpt1
Report2 Customer Sales Information: rpt2
Form1 SignOn form with ID and Password
Form2 Basic Info
We would like the signOn form to first appear...
We have a database consisting of a table listing sales items, qty, salesman and sales year. The salesmen have been assigned to monitor selected items. The items are separated into groups. We would like the salesmen to sign on using a sign-on form with password. After a successfully sign-on...
I am preparing a PowerPoint Presentation that needs to be shown on a regular TV screen using a non PC DVD. I know that PowerPoint has a controlling "engine" that makes the show run including graphics, timing changes, sounds, photos, etc. After the PP show is saved either as a PPT or PPS if it...
The following item names and quantities have been reduced in order to make the discussion easier, I hope.
************************************
We have 10 schools:
Sch01 - Sch10
Each school teaches 5 classes only:
Eng, Math, Hist, Gym, Art
Classes are taught 6 months only:
Jan...
We have an Access database which records the status of completion and other information about most publications and products created or distributed by our office.
Encluded on the main input form are tabs which display all sorts of data, deadlines, costs, etc. about the items. One area tracks...
Hello,
Our department produces and prints products on a monthly basis. There are about six phases that each product goes through before it is either completed or canceled. For discussion purposes I'll call them Phase1 - Phase6. In reality, they are referred to by name such as "in edit, in...
We have eight departments. Each has a printing and product budget for the year. The database tracks the various products and printing and keeps data about them. Reports are also made as needed. Each department has hundreds of records added on a daily basis by staff members.
We would like to...
Is there a simple way to have three fields automatically calculated (summed) with the results displayed on a form. The results will be "on the fly" and not stored. The answer will change whenever any of the three fields are changed. The reports will do all of the other calculations and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.