Search results for query: *

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

To: pwise. It is a plain MS Access DB. I expect portions to use SQL type steps.

Hello Ms. Hamlin, I have already designed the database and it is in use. The managers have decided that they need a new search feature. The current design allows the user to input a title or item name and the resulting items appears in a completed form. What is b eing asked for now is the...

How can we use a form to search for records based on inputs to several text boxes where the results are listed on a subform?

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

Thanks to Remou and Roy Vidar for your suggestions and patience. I have been studying the solutions and suggestions and I've verified that I don't know as much as I would like. Please tell me where I should put that code. Also, I think that I must try to explain what we need a little better...