Search results

I might be missing an obvious command, but I was wondering if there was a way in a report text box field to make the text fill out to the entire line so that the right sides and the left sides are all inline. I tried using the distribute command and while this worked in some respect, on the last...

For some reason that didnt work out. This report is only the one field, and so it only lists names of people whose projects fit that type. So there are no other related fields that it needs to group by. I just dont want there to be blank spaces between the names, because when I get a lot more...

I have a report which produces a list of names from a query. The query is based on projects that the people have worked on and so I am searching the table with the query and filtering by the type of project specified. When the report comes up though in the detail section it shows a persons name...

Thank you, that worked perfectly!

In a previous post someone had mentioned that it might be possible if a report was based on a query, to put an expression into it which would make the field become invisible if it was null. There are certain fields in my report which for some scenarios end up being empty and so I am trying to...

Yes it is based on a query, how do you go about doing what you said?

Thanks, but for some reason that didnt work. Is there some other place on the report that I need to change the properties or layout to allow that to occur?

I have some empty fields on some of my reports, and I was wondering if there was a way to make them invisible along with their labels if the field was empty. Is this possble?

Thanks so much, the option group worked perfectly.

How do you create an option group from a group of option buttons? I want to know how to have the user only be able to choose one of the options on the form at a time. Does anyone have any ideas? Thanks.

If i have a subform or subreport in a report how can I filter it for information that I want as opposed to just linking it to the main report. Is there anyway to define a WHERE condition in VB for the subform or report when you use DoCmd Open report or any other commands or macros?

So is the form than connected to that query when you first create it? Or else how do you get the information into the form that you want to be filtered? Sorry if this question is juvenille, I'm just not very accustomed to Access and if you could walk me through it, it owuld be great. Ive already...

Is there any way that you can have a query that prompts for a filtering criteria, but instead of having that criteria be for just one of your fields, have the criteria be a string that could include a criteria for anywhere from one to all of the fields? i.e [Name] = 'XXX' and [Job] = True or...

I guess my biggest problem is that I have exactly what I want the report to do and look like except for one last part. the resume has a name bar on top and a list of education and experiences along the left bar. What I want my sub report to do is go through a list of different projects and jobs...

Also what is a pop up form? Sorry, Im kind of new to this program. Thanks so much for the help.

The reason for the sub report is because of visual purposes. The report is a resume and because i have a vertical bar on the left side of the page with other information in it I couldnt list the information I needed in the detail section because I had assumed that it would need to go across the...

I have a sub report located in a report but they are based on the same query. I have it set up so that when I open my report from a different form, the report is filtered by some given input data. I cannot find a way to get the sub report to be filtered at the same time with the same criteria...