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

I read the if...then FAQ for mail merge, but I didn't see anything that taught me how to refer to the previous record in the statement. Could someone please help me figure this out??? I think the logic in the statement above is correct, but I have no idea what the syntax would be. 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 didn't see it in the mail merge FAQ there. I think that what I need is an if/then statement that says something like "if the Investor Type field equals the Investor Type field in the previous record, then don't display anything here." I would write it myself, but I don't know much...

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...

Bingo. Thanks!

I have a form that contains data files that are populated from a query. I'd like to have the form be populated only with filtered records, but I can't figure out how to get the filter to be applied automatically. What about putting an apply filter action in the second form's code? For instance...

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

Well, the only criteria I really need is the field InvestorName, since that's the primary key. Do I really need all that other stuff? Also, the form I'm opening is called "Edit/View Investor Info" -- it's a clunky name, I know, but I didn't know much about access when I started this...

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?

The problem is that I need a great deal of space for comments, and the maximum size for a record is very small and restrictive. So, the only way I could think of to get around the problem was to have space for comments in other tables that are related one to one. However, some records will have...

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...

Didn't quite work. The Name field is not the primary key, though it should be different for every record. Good idea about displaying the name in a text box, I'll definitely do that when I get it all working. Anyway, this is exactly what I pasted in to the Change event (I also tried it in the...

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...