I’m actually just setting this system up and am looking for the best way of doing it. What I have are 7 different buildings in the district that use a system of inter-office mailing hard copies of work orders from teachers and staff to a building computer coordinator for approval and initial...
I need to send one record ( a work order ) from one databse to another, for approval, and then on to a master database. What would be the easiest way to set up an append query or macro to only send the current record up the line? Thanks, Terry
Jeremy,
Pardon my thick headedness, but I need a little further help. I have the report doing what I want except for this text/number problem. In reading your instructions I got confused. If I bring up the report in design view and then bring up the properties of the class text box, what do I...
Jeremy, thanks for responding. OK, my original problem was I was needing to make a subreport from the table and when I do I end up with the ID numbers, which won't help my users much. Have I got something set wrong? Thanks, Terry
I know this has to be simple and I'm just not seeing it but, I have a combo box in a form from a table called classes. The table has an ID field and the class name field. My problem is I get the form combo box populated with the text of the class name but the table the form is based on populates...
I have a form and subform working off a query. The query gives me a list of students and attendance records. I would like an easy way of skipping records in the form to the next record where the name changes. Any ideas? thanks
Thanks for the help, it set me in the right direction. I set up a parameter form and and directed my query to it. Now when I run the report it only ask for the parmeters once. Thanks again. Take Care.
Terry
I have a main report that has three sub-reports. The sub-reports are all from the same Query. The Query has criteria of, Between[Type the Beginning Date]and[Type the Ending Date]. How do I get the report to only ask for the parameters once instead of the 3 times it ask now?
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.