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: *

  • Users: rjmccafferty
  • Order by date
  1. rjmccafferty

    calculate field in layout

    I come from Access and am having some difficulty with the transition. In an invoice/order input form (layout), I cannot figure out how to calculate fields within the layout during data input. In Access, I attach code to a property to calculate another field upon leaving the field to which the...
  2. rjmccafferty

    Search with OLE or hyperlink field

    Yes, I understand the meaning of the message. As I stated, all the fields in the original query were either text or number. LastResults is a simple text field.
  3. rjmccafferty

    Search with OLE or hyperlink field

    I have a query that searches only text and number fields. But I am getting the following message when I search with one specific field in the results and ask for unique values in the query properties. The message I get is: "Cannot include memo, OLE or Hyperlink object when you select...
  4. rjmccafferty

    Running code on query results

    For mailings, we use tag fields (yes/no field) in our Contacts table to select recipients for the mailings. It is then easy to query the db and have only the records you have selected. After the mailing, it needs to be documented in the db by COMPANY, not by contact person. In Excel I do the...
  5. rjmccafferty

    Manipulating data

    The scenario in my problem is that I use flag fields (Yes/No fields in the tables) for queries to determine recipients for various mailings that we do. That is, anyone who has a specific flag field checked as Yes would have their mailing information used in the mail merge in Word. I have...
  6. rjmccafferty

    keep together sub report

    When placing a subreport, what property is used to keep the subreport together, similarly to the way Grouping and Sorting does with groups? I have a subreport that infuriatingly likes to show the report header at the bottom of one page and the detail on the next page. I don't see a property in...
  7. rjmccafferty

    Calculations on dates in query criteria

    I use queries and reports in access that rely on dates entered by the user into unbound fields in a form as part of the selection criteria for the queries. The most common example is Between [Forms]![f-reports-interactive]![TextStartDate] And [Forms]![f-reports-interactive]![TextEndDate] This...
  8. rjmccafferty

    Date field in reports - MS insert code doesn't work!

    To Nick: I went to the code window with Tools|References. I do not understand the advice "Uncheck any options with Missing In. There are about 8 to 10 options checked and they look to be pretty standard. Can you give me a different explanation of what I am looking to uncheck? Maq: The...
  9. rjmccafferty

    Date field in reports - MS insert code doesn't work!

    I am running Access 2000, front end and back end. When I prepare reports I naturally like to include the date. Access has, in the insert drop down, options for inserting page numbers and dates in various formats. The one I prefer for date is the one that Access enters automatically as...
  10. rjmccafferty

    Invisible field based on if statement

    I see it. Thank you very much.
  11. rjmccafferty

    Invisible field based on if statement

    I could not find an "On Format" event in properties for the report. But I did find (duh!) Conditional formatting as an option under format in the main menu. In reading my books, to augment the Help system for Access, I am not sure this will work in my instance. I am trying to...
  12. rjmccafferty

    Invisible field based on if statement

    I have a series of dCount fields in the footer of a report. Some of them only apply to certain customers and I would prefer that unaffected customers not see the field to avoid confusion and needless questions. Is there any way I can, in pseudo code, essentially say...
  13. rjmccafferty

    Count field in report other than report header or footer

    I have one last (hopefully) question. When I got to using the Dcount function, as long as I knew the variable I was after, it worked fine. But when I tried to use is with a like statement, it gave me an error message. Can you tell me what is wrong with this syntax for a dcount field...
  14. rjmccafferty

    Linking master and child reports

    It worked. First I took away the links between master and child reports. There was still a problem, but it was one of those query based ones in which querying related tablescan often cause what seem to be duplicate records to appear in the results table. Once I found the offending fields, all...
  15. rjmccafferty

    Linking master and child reports

    Let me make some changes and test. I did immediately eliminate all links between master and subs. It is got a lot better in that I now get things listed as I expect. That is, all meetings together, all follow ups togethrer, etc. But, incredibly, I get three complete and identical iterations...
  16. rjmccafferty

    Linking master and child reports

    I am trying to show: Total Calls Placed for entire date range (for all customers) Total Calls with substantive conversation for entire date range [I moved this to the master report header and then this part seems to work fine. there are just two fields in the sub report header] A listing of...
  17. rjmccafferty

    Linking master and child reports

    Plus, this also still leaves open the larger question of why the subreports run more than once, that is they run once for each record. Am I using the wrong field to link them to the master report? And if so, how can I link them?
  18. rjmccafferty

    Linking master and child reports

    As I look back, I am getting exactly what you are. The one subreport where I use count functions, and therefore put it in the report header, the info does show up. But the others all have the info in a page header, which does not show up. And, like you, I would like it to appear on every page...
  19. rjmccafferty

    Linking master and child reports

    I need to have information in a report that covers varying date ranges. This has to do with our Managers calling potential investors (large institutional investors). The report needs to have essentially the fields listed below (all for a date range specified by the user, which is done in a...
  20. rjmccafferty

    Count field in report other than report header or footer

    I was being dense. I had it in my head that even with a form for the dates, i still had a parameter query and therefore the problem would still exist because all the queries would re-run the parameter quesitons. But, duh, yes they will all ask question, but they will ask it of the form, not...

Part and Inventory Search

Back
Top