Search results

I've been asked to create a report that will return some information regarding hours worked on a project. This particular dB tracks writers' hours spent on each file in the project. (There is one field for total hours spent on a file, and only one writer works on each particular file.) We need a...

I have a report that contains five subreports. The query for one of the subreports contains a date field that prompts for the date range for the subreport. This is the only field in the entire report (meaning the main report and all five subs) that asks for a prompt. When I run the report, it...

I have a report that contains five subreports. In each subreport I have created a field that contains the record count for the subreport. In each subreport, this field is called "Count." I can't quite figure out how to add a field to the main form that will add together the "Count" fields from...

OH, YES! I think that helped. Thanks. Now ... on to the NEXT problem!

It is referencing the correct column. As a matter of fact, it allows me to change existing records by using the drop-down list. It just won't let me add a new record! Ack. Any more ideas? (Thanks, by the way!)

I have a form called Contacts and inside that a subform called PubOrders and inside that a subform called Publications (which contains a list box that looks up our pubs in another table). When I'm in the list box field, the drop-down list works fine, but after I make the selection, I get an...

Well ... that worked beautifull! It works when I drop the list down and make my selection, but is there a way to do it if I just type in my selection? The fields are only two characters long and the users have them memorized, so it's faster to type in the field than drop down the list. Thanks...

I know it's a not a "regular" option with drop-down lists, but I'd give my eye teeth to be able to AutoTab to the next field after selecting from a drop-down list. Is there any way to do this?

I've created an OpenReport action in a macro, which I want to use to print a report for only the current record in a form. My where condition for the action is: [ClaimantID]=[Forms]![ClaimantsInput]![ClaimantID] But when I click the button in the report, I get an "Enter Parameter Value" window...

Thanks, guys!

I created a simple button on a form that closes the form. I didn't write the code myself, I used the command button wizard. The button worked yesterday, but today, I get an error message: Compile error: Ambiguous name detected: Exit_Click I'm using Access 2000 on Windows NT 4.0. Any ideas...

Thanks for the help, guys. Rich, your suggestion worked beautifully. Pat, I'm definitely going to do as you suggest. [This message has been edited by Timberwolf (edited 03-23-2001).]

In a report I have created a text box in which I'd like the last and first name fields to appear: =[LastName]+", "+[FirstName] It works great, unless there is no data in the FirstName field, in which case the report shows no name at all. (A few of our clients are companies, not individuals.)...