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 Shaun E 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: *

  • Users: rooterr
  • Content: Threads
  • Order by date
  1. rooterr

    Dont show Data on main or sub when subform has all data entered

    I have a form where project data is edited. I have a main form with the project summary, people working on the project, and a subform that lists the project steps, target and complete date for each step. If the complete date for any one of the steps is null. Then I want all of the record on...
  2. rooterr

    query from two identical databases

    I have two _be databases on different networks, I can access both, they were seperated due to slow processing. They have identical structure, just different data. I need to query this information as a whole. Is there a simple way to do this. Can you pull the information from each database...
  3. rooterr

    Combining tables from different databases

    I have two identical databases on different local networks for increased efficiency. This is great for efficiency purposes, but I have yet to figure out a way to pull the data from these and combine them to generate company reports. Is there any way to query them together or create a table to...
  4. rooterr

    me.undo help with subform

    I need help understanding me.undo. I have a form where you enter projects and responsible persons. The subform for this holds all the required steps to complete said project. Some people have started filling out the form and before entering the steps just get out. I need to be able to undo...
  5. rooterr

    Prevent saving of main form without related record in subform

    I have a project based database. Where you enter a project with the persons responsible Form:stratnewF. With a subform where you enter the action items to complete the project Form:stratnewsubF. I have had problems with people entering in a project and person responsible and then exiting the...
  6. rooterr

    Error Prompt for a Report with no Data

    I am curious is there an easy way to create an Error Prompt to the user when a Report based off a parameter query returns no data. My current database has a lot of dates and if you enter in certain parameters it is very easy to generate a report that is blank. I want it to prompt them saying...
  7. rooterr

    Problem with Parameter query

    I have a query that I want to have a parameter where the user enters in the starting quarter and year and the ending quarter and year and the results show everything between. I currently have all of the information going in, but I used between starting quarter and ending quarter. Then in the...
  8. rooterr

    Grouping Problem for Report

    How do I group by a project on my Report and show all the employees that are working on it. ---tbl--- project employee sample data billing Williams billing Anderson Payments Smith Payments Andrews How do I get my report to show the following or something similar. -- Project...
  9. rooterr

    DB design / Query help

    I am currently developing a database for project tracking. The db can have up to three groups responsible for each project. So I created a respgrps table that has grp1, grp2, grp3, and grpID. The grpID is related to the project tables grp_ID. I also have a groups table that has groupID and...
  10. rooterr

    count of checkboxes

    I have a log table which has a date complete and a checkbox for all of the tasks that were done for each job. Job Road Stream line complete 1 yes no yes 4/1/02 2 Yes yes no 5/1/02 3 Yes no yes...
  11. rooterr

    count checkboxes by month

    I have a log table which has a date complete and a checkbox for all of the tasks that were done for each job. Job Road Stream line complete 1 yes no yes 4/1/02 2 Yes yes no 5/1/02 3 Yes no yes...
  12. rooterr

    Create a logon form that automatically fills in a row

    I am trying to find a way to reduce the number of entries on my database. I have two related tables emp and log and they are linked by the empid field. I have developed it to track employees work and I dont want them to have to enter there empID in the log table every time. Is there a way to...

Part and Inventory Search

Back
Top