Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Sherman6789

    How can we embed the path needed for a PDF form to find files?

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

    Make a report listing each record containing the names of members.

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

    Create tickler Access file that automatically emails timed reminders

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

    Need to secure a database, its forms and reports

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

    Error message randomly stops database then goes away.

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

    We need to copy a layout from Tab 1 to Tabs 2-8

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

    Cursor is not blinking for user input as expected.

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

    How can I make a report using multiple names from one field?

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

    Search for records on multiple fields

    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?
  10. Sherman6789

    Find list of records from search of multiple fields in Access DB

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

    How can we automatically view a PFD file which references a DB record?

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

    Would like to calculate info from Excel Sheet 1 to Sheet 2

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

    We need to locate files using data from two input forms

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

    Need to allow users to login/update data after files are filtered.

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

    Need PowerPoint presentation to be shown on TV with regular DVD only.

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

    Need to create input DB for vertical & horizontal reports

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

    Need to display current phase & date from a list of phases & dates

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

    Indicate when a product in table has not timely moved to next phase

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

    Need to sum costs from table by department & calc. balance from budget

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

    Sum three fields "on the fly" & place results on form

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

Part and Inventory Search

Back
Top