Search results for query: *

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

Thanks Blacknight this worked great. Zambezibill they are identical in structure not in data. I have them on different local networks because this increases entry speed because we have offices from texas to georgia and a slow network line does not make it efficient enough to be feasible to...

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

Rollie, thanks for the suggestion. I am a little bit new to all of this. Where would I put the undo at? Thanks,

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

Thanks Ben worked like a charm. RT

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

Thank both of you for your responses. Godawgs it took me a little while to open my mind up to realize the simplicity of what you were saying. It worked like a charm. I had a quarter and year field in my query based off of the target date using the datepart function. So I used your second...

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

I just realized that I didnt explain this in enough detail the problem is that not only do I need to show projects, but also the associated steps. I was able to get my report to group by project the way you showed and list the employee, but when I added in project steps it replicates each step...

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

Yes the only reason I need the information in this format is so that I can display it in a report. If there is an easy way to get this formatted in a report please let me know. Thanks for the response

Thanks sko It makes perfect sense now. I was letting the big picture(the other stuff I left out so that it would make sense on the post) cloud my judgement.

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

Thanks a lot guys the information was very helpful in understanding what was happening. The select statement worked like a charm JHall. Thanks, rooterr

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

Herman I do have a main form that does remain open all of the time my problem is I do not know the best way or how to make the logon form so that it automatically updates this field for each new record. If you have any suggestions on how to do this it would be appreciated.