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