Search results

I recently upgraded to Access 2003, and converted some databases from Access 97. On my reports, if I enter the function Date(), or use it in any strings, when I run the report, it calls for a parameter called Date(). I also have the same issue with using format. I tried refreshing the...

I have a subform with a date field on it. For that field, I have set a validation rule. When you enter a date that violates the rule, my custom text comes up just fine. Then I get a message that says "The value in the field or record violates the validation rule for the record of field." I...

I have a main form and subform that are already linked/synchronized using a combo box. (When you select an attorney's name on the main form combo box, their timelog records are displayed in the subform. One of the fields in the subform is the client's name. The users would like a second combo...

I have a subform that users can filter using the toolbar and shortcut menu filter options. Once the subform is filtered to show just the desired records, is there a way to print those records easily? When I use the built in print feature, even when selecting "print selection" it still prints...

I have a combo box on a logsheet form that is based on a query. The combo box query returns two fields from a Client table. The first field is a concatenated string showing the Client's Name and Case Code. (=[ClientName]&" "&[CaseCode]). The second query output field is the unique identifier...

I have a subform based on a query where I have placed a combo box that forces users to select a client name from a list. The list is made of open cases and closed cases. The trouble is that the list is getting extremely long, and I wish to limit the combo box choices to just the open cases...

I am using a command button to open a form that gathers data for a report. I have added an OK button and a Cancel button to the pop up form using the built in IsLoaded function in combo with the Close method in a macro that controlls the button. Whenever I press the Cancel Button to close the...

I have a form and subform, both built on queries based on tables. The records in the subform are linked to a field on the main form in a one-to-many relationship. The main table is a list of employees. The detailed records are each employee's daily record of activity. There can be more...

Is there a way for Access to "remember" and automatically fill in entries entered or selected in pop-up form that is used to both set query criteria and then provide text on a finished report? The pop-up is tied to the "On Open" property of a report, and controlled by a macro using the...

Is there a way to use multiple fonts in one text box control on a report, where the text box is made up of strings and variables? For example, I have the variables CaseName and CaseCite, which I want to appear printed on my report as in the following example: This in the matter of State v...