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

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

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

Is there any way at all, other than using subreports, to get counts into other sections of a report? As an example, I first tried a field of =count(*) in the report header or footer and named the field CountAll . Then, in another section of the report a created a field and for source used...

I am trying to design a query in which I have a list of Names in a table (first and last names combined, e.g. John Smith) indicating the recipients of a book, and I want to limit the results of the query to those of individuals with the same last name who work for the same company. That is...

In an Access report you can count records by group. The field that I use to keep the running count per record works fine and resets itself when each new group starts. In my specific application I actually have a group within a group and count the records in the second tier group, which works...