Search results for query: *

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

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.

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

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

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

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

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

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

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

I see it. Thank you very much.

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

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

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

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

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

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

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?

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

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

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