Search results for query: *

I'm using access 97. I have a sub report in the Report Header of my main report. When I view my sub report in print preview mode, I see a header. When I view my main report in print preview mode, I only see the detail section of my subreport and not the page header. Any ideas on how to fix...

I'm using access 97. How do I display data only once in a query? Can I add something to criteria to only allow data to be displayed once. For example: red green blue Not: red red red green green blue Hope this enough info.. Thanx Gustavson

I'm using access 97. I'm generating a report that displays information on buildings and chemicals stored in those buildings. The report is generated from a query. In the report header I am trying to generate a list of just the buildings so that they are displayed on the first page. There...

I'm using access97. In my report the page number doesn't display on the first page but every page there after. Any ideas on how to get the first page to display page number as well? Here's the code that I am using to display page numbers: ="Page " & [Page] & " of " &...

I'm using access97. I have a query in which I have many fields. Building, room number, chemical, quantity are four of the many fields that I have in the query. As of right now I am grouping by buildings , room numbers and chemicals. That works just fine but I can't figure out how to keep a...

I'm generating a report in access97. I have a control box in which text is displayed. If the text in the box is too long it gets cut off at that point and part of it is missing when printing the report. Is there a way to automatically adjust font size if the text is too long for the control...

I'm using access97.. Is there a way to set repeat section to yes and not display any information on the previous page.. so I like the data to be displayed on a new page but not on the old page.. Thanx Gustavson

I'm using access97. I have a report which is printed from a single query. Is there a way to get information from other queries as well? I tried to create a report from two different queries and I get a message that says something about wizard cannot connect fields from the two queries.. Any...

I'm using access97. I have a query on which there is a field called building. this information is being retrieved from another query.. I don't want buildings to repeat so for example, lets say Onyx Brige is in the Query. I only want it displayed once.. even though it may be displayed several...

I'm using access97. In a query I have ran out of criteria room.. What are my options? Hope this is enough info.. Thanx Gustavson

I'm using access 97. I'm working on an expression in a query and I'm receiving this message: The String returned by builder was too long. The result will be truncated. I assume my expression is a bit too long.... Any ideas or suggestions on how to get around this? Thanx Gustavson

I'm using access 97. I have a field in a table which contain many different hazard classes of specific chemicals. Is there a way to change all the equivalent data in the field of a table? For example, one of my hazard classes is h. toxic which stands for highly toxic. I have a few hundred of...

I'm using Access97. I have a table with a number of different fields. This table will be on a network for others to see. Anyways, I want everyone else to have read only access. How do I do this? Thanx Gustavson

I'm using access97. I have a form on which I enter records. Each record can then be looked at by clicking the record counter on the bottom left of the form. I want to create a key that will do this so I don't have to reach for the mouse and click the record selector. Is there a way to create...

I'm using access 97. I have a check box in a report with the code in control source that looks like this: =IIf(DSum(&quot;[Hazardous Substance]&quot;,&quot;[Check Boxes]&quot;,&quot;[Building Name] = '&quot; & [Building Name] & &quot;'&quot;)<0,CBool(True),False) Is there a way to give it a...

I'm using access 97. My report is printed from a query. This query contains a field named Hazardous which is a check box next to another field named chemical. I have about 25 records of chemicals and about 4 of them are Hazardous so the check box next to the 4 chemicals is checked. Okay, so...

I'm using access 97. My report is printed from a query. This query contains a field named Hazardous which is a check box next to another field named chemical. I have about 25 records of chemicals and about 4 of them are Hazardous so the check box next to the 4 chemicals is checked. Okay, so...

I'm using access97. In a form I have three combo boxes. Chemical: boric acid Unit Measure:gallons Pysical State: liquid Is there a way to get the Physical State control box to automatically display liquid if gallons is inserted into the Unit Measure control box? Hope this is enough info...

I'm using access97. I have form on which I enter information into different combo boxes. After I click the add record button, the record is added to the query and the form is cleared for a new record to be added. Is there a way to keep some of the info for the next record? For example, say I...

I'm using Access 97. I have a form which loads on startup. This form only serves the purpose of linking to parts on the database. Like a switchboard. Anyways, I want to add a search for record button on this form but I want the result to display on my main form. How do I set up this button so...