Search results

Nevermind. I figured it out. I had to open the table in the back end and insert the subdatasheet. Then it worked fine when I went back into the front end.

I am also having this problem. Has anyone come up with a solution? Thanks so much! Ann

Thanks much, Pat. That WAS the problem!! :)

Just to clarify, I didn't use the quotation marks in the criterion. I'll try the unbound text box suggestion. THANKS!

I have a date field in my query and I'd like it to return records with today's date. I used "Date()" as the only criterion, but when I run the query, I get an error message: "Undefined function 'Date' in expression." Any suggestions? Thanks!

Beautiful! Thanks so much!

I have four yes/no fields in a table, and in my query I would like to create another that is checked if any of the other four are checked. Any help would be appreciated. Thanks!

Unfortunately, that didn't work. Here's the code as I typed it: The form then gets stuck in the last field of the record and won't allow me to tab to continue to the next record, whether or not the ClaimNo field is empty and whether or not the ActivCode = "CN'. Any other ideas? Thanks again.

I'm sorry I left out so much information. It is okay for the claim number to have a value if the code = CN. And your other assumptions are correct. I'll give this a go. Thanks so much!

A form. Thanks. (Or would it be best to do it on the underlying table?)

I have a two-character text field that can contain one of about 30 different preset codes. I have a long-integer claim number field. If the two-character code = "CN", the claim number field cannot be null (it's okay if it's null in any other circumstance). Help? Thanks!

I have a form that contains some fields that are summed in a total field. The first three fields (FirstTierHours, SecondTierHours, and MonitorHours) are added right in the query to create a Subtotal field. That works beautifully. Now I've added a subform that shows hours that other staff...

Thank you SO much for replying so quickly, Doc Man! Would I use the Performance Analyzer to add indexes, or is there another way to do that? I'm not finding it readily. Thanks again.

Is it possible to have multiple junction tables refer to the same "lookup table" for their information? For example, I have a list of funders and a list of projects. I have a junction table of proposals that references the list of projects for which we need funding. I'd also like to create a...

I have a report that contains a subreport that contains a date range. When I run the report, it prompts for the date range and then creates the report just fine. But when I hit my print button, I'm re-prompted for the date range! Arghhhhh!! (Thanks!) [This message has been edited by Timberwolf...

I have a columnar report of training summaries that includes date, sponsor(s), attendees, trainers, and topics. The sponsor, attendee, trainer, and topic sections of the report are subreports. When there are multiples in each of these subreports (topics, for instance), it lists them like this...

Just bumping this up. Thanks.

Just bumping this up.

Ahhhh! I get it! Would I have two fields in the form - one for the beginning date of the period and one for the ending date? Thanks so much! [This message has been edited by Timberwolf (edited 08-02-2001).]

Thanks, Ian. But let me clarify ... I need the highest and lowest values for each writer. Can it still be done? Again, thanks!