Recent content by Sherman6789

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

Thanks MajP This link seems to be headed in the direction that I need for immediate use. I will study it tonight. Again, the database will be changed to front-end/back-end very soon. I am studying the procedures now. I will keep this thread open a little longer to see if any other...

MajP: I am sorry that you have interpreted my comments in that negative manner. I said that I have no trouble making plans to make a front and back end to this database and probably to the others as well. I am not committed to keeping it set up the way it is. Time is the problem that I have...

Thanks MajP. The 30 or more people currently have access to the database but only a few will be on the DB at the same time. They all have other work to do also. I doubt if more that 4 or 5 will be actively on the database at any given time. I backup the database every two days. Most people...

Thank you for your prompt responses. dhookom: I am looking over your information now. Thanks. MajP: I read the link that you listed and I see that I probably need to split the database. However, I have three major problems. 1) About 30 people are already using the database. I must add...

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

Thank you. I have been on travel and will try the suggestions tonight. WRS

Since I wrote the question, I have tried another approach. In the same database, I created another Form with the same fields on it. Everything works as expected including the blinking cursor/prompts. This makes me think that the problem is actually in the form. The actual form took a lot of...

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

Thanks to both dhookom and MajP. I agree that it is best to not have multiple names in the same field. There are far more names and the database has many more fields than on this sample. The names are first and last name. This sample database is only to show how it is set up. That particular...

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