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

...Date") But when I use this, instead of getting a date on the report, it prints as #Name? Thinking it might somehow be like the =count(*) function where it only works in the report header or footer, I tried the date entry in detail, page header and report header, always with the same...

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

...me what is wrong with this syntax for a dcount field: =DCount("[ActivityType]","RmCallInput","[ActivityType] = like 'CM*' ") When I used a like statement in a query and looked at the SQL view in Access, this is the format it seemed to use. Is my syntax wrong...

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

...are scheduled within the date range for all customers. (I would also like a count of the meetings, but that should be a no-brainer with =count(*) in the subreport header or footer) A listing of all follow up materials arranged to be sent out for all customers. I list of all customers who...

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