Search results for query: *

I have a comments subform whose results are currently in a report. Right now, the report lists the conents of the record with all of the comments from the linked table below the record. Is there a way to put the "detail" area of the report on the right side of the page so that the...

Is there any way to control the order in which records appear in a subform??? I would like my subform to be sorted by the date field, but the records show up in an apparently random order. Any ideas how to correct this? Thanks, Daniel

Thanks to a quirk when creating the data source, one of the merge fields that I'm working with has a hyphen at the end of every record. It's a date field, so every single date is formatted like 8/6/01-. Is there a way to do something during the mail merge that will remove the hyphen when it...

I'm doing a mail merge from an excel spreadsheet of investors. In the merged document, I would like to have a header that says "Advisors" and list all the records that have "Advisor" in the investor type field, then a header that says "Public Pension Funds" and all...

I can't figure out how to do this... do queries even have on open properties? How do you get to them in Access 97? Daniel

I'm making a command button to open another form using the Wizard. One of the options is "Open the form and find specific data to display," but I'm not quite sure what this option does. The button I'm making goes on a form in which the user adds a new record to the database, and the...

Even though I have no formal training in Access, every day what I have to do with this program gets more and more complicated. If anyone can help me out with this I would be very appreciative. I have a form that contains a command button that will export a report to a file. I used the wizard to...

When you use the command button wizard to make a "Print Report" button, how do you get it to bring up the print dialog (that comes up when you go to File>Print) rather than simply printing directly to the user's default printer? We have a large office, and sometimes I may want to print...

Pretty simple? Is it possible?

Okay, maybe this is something really simple and I'm just having a temporary lapse, but how do you keep multiple related tables having the same number of rows? When I create a form based on a multi-table query, I can't enter data into anything but the primary table because the related tables...

How can I make it so that selecting an item from a combo box will bring up the entire record in a form? For instance, there is a combo box at the top of a customers form that says "Name," and gets its list of values from the field "Name" in the customers table. How can I...