Search results

How do you keep a text box from breaking across 2 pages? Thanks Kurt

Im creating a where used report (see attached) and i would like to add a few details to the end of the report. PART NO. TOTAL: I would like to add a count of the different part numbers(far left column). The total right now should be about 514 but when i create a text box with the string...

Im trying to create a where used report that shows the part number, the assemblies its used in, and a total of the places used. When i open the report the first half of the data from the queries is missing. Attached are 2 screen captures. Queries shows the top of the 2 queries i used to...

Im creating a report that is based off of 2 queries. where_used_tbl - This query contains the following 3 fields: Part No. Assembly No. Assembly Description. where_used_count - This is a count query that contains 2 fields: Part No. count of where_used_tbl This query shows me how many...

Im setting up a database that contains information about printed circuit boards that are being developed for our current project. The information that i need includes the following: Board # - 3 digit number Board Name - Module # - 9-digit number Module Name - Project Leader - engineer...

First off i apologize if something like what im about to ask has been discussed arleady, im not sure what exactly im looking for to know what to search. I would like to make a "where used" report. Im starting with a query of my tables that has a column titled "Part Number" that lists abotu 500...

Is there a way to track changes in reports? I need to come up with some way to show our document control people what has changed in my report since the last time i submitted it? I was thinking it would be nice if there was some way to mark an item as new and have it appear red. Is this...

How do i get lines that I have in my report between rows to show up when I publish to Word? Kurt

Maybe this shouldnt even be done in a form as simple of a task i need. I have a query of multiple tables andi want to be able to export it to word with only a few of the columns from the query as well as displayings yes/no instead of -1/0. Basically im just trying to make a table in word so i...

Background info: I have created a database that consists of 22 tables that contains hundereds of electronic components seperated by type. In each table are columns for evey project so that i can determine what projects each component is used in. Everytime there is a new project i need to...

Is there any way in a form for a yes/no check box to appear as something other than -1/0?

I need to use the & symbol in a couple places in my Report since its part of my companies name. However i notice it doesnt show up. If i typ && it shows up as a single & but only the first time. Anyone know why? Thanks Kurt

How do i create a query to only look at a single column of 20 different tables and only show them if the yes/no box is checked? Thanks