Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chestyxbond

    Is it possible to split up a form vertically?

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

    Order of records in subform

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

    Group records in mail merge

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

    editing a field for mail merge

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

    Group records in mail merge

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

    Group records in mail merge

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

    filter query upon opening?

    Bingo. Thanks!
  8. chestyxbond

    filter query upon opening?

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

    filter query upon opening?

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

    What does this mean?

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

    What does this mean?

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

    Is this possible?

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

    "Print Report" brings up print dialog

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

    Is there a way to make the default date in a field today's date?

    Pretty simple? Is it possible?
  15. chestyxbond

    Keeping like row amounts in related tables

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

    Keeping like row amounts in related tables

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

    Looking up records with a combo box?

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

    Looking up records with a combo box?

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

Part and Inventory Search

Back
Top