Search results

Thank you.

Hi, I try to search the forum before I post a question. A lot of times, I find a thread (like this one) that answers my question. However, when you attach the sample databases for people to look at for ideas, I can never open any of them. I am on Access 97. I get a message that says the format...

Thank you! That will work great, then I won't have to have 2 separate sets of date prompts either (one for each make table query). The user can type the dates in once, and each query can reference the form field. Thanks again for the idea! Stacey

Hello all. This probably cannot be done, but I'm going to ask anyway. Here is the scenerio: I have two make table queries that both have a date prompt, >=[Enter Start Date] And <DateAdd("d",1,[Enter End Date]). These queries bring back alot of data. I have a crosstab query built against each...

Lovely! Worked like magic..... Thank you!

Hello, I have a crosstab query built on another query. One of the fields is named [Doc]. I have that field set to Group By, as a column heading. There are two values possible, Pass and Fail. I need both Values to appear as fields on a report. My problem is, currently, there are no entries for...

Thank You!

I have a query built on two crosstab queries. The linked field is Processor. The data in the first crosstab query contains 3 processors that are different than in the second crosstab query. The second contains processors that aren't in the first. What my ultimate objective is is to have a report...

I'm sorry, how do I pass the date input to a text box on the report?

Hello! First off, thanks for all the help everyone has given me in the past, you guys are awesome! I have a report that has two subforms, which are charts. The charts are based on queries. My problem is I want the date from the query to show up on the report. The only way I can figure out to...

That seemed to solve the grouping problem on the report, but now my date prompt in the criteria field for the date is not working. It is bringing back dates outside the range specified. Any ideas?

I have a query based on a non updateable linked table. In the table the date format is Date/time (06/08/2004 10:07:07). I have a report based on the query. In the report, I would like to group and subtotal by date. Unfortunately, it is looking at each date/time as a separate group. How can I...

That did the trick...thank you so much! Stacey

Hi. I have a query built against a liinked table. The Date field on the table is Date/Time and I cannot change it. I want to allow the user to type in a date and have all records from that date show up regardless of the time. I have searched the forum for questions and I did find one that said...

I'm probably putting it in the wrong place, because I'm still getting the Invalid use of Null error. Where in the code should I insert it? I really appreciate your patience with me.

I figured out how to get the module to work in my query. I couldn't get the code you gave me a link to to work though. I did find different code, and it is working, EXCEPT, I am getting an 'Invalid use of Null" error when it hits a record that has a blank DateCompleted field. I don't know how to...

Thanks, but.... I am a novice at using code. I can do basic things, mostly in Reports. How do I get this code to interact with my query. Or do I have to go at it from a different angle? I have the query results displaying in a form. I'm just not sure how to use the information you've given me...

I am trying to set up a field in a query that calculates the date between the DateReceived and DateCompleted, not including weekends. I have searched the forum and found some suggestions, but I can't get any of them to work. I tried the DateDiffW and the NETWORKDAYS, but I get an 'Undefined...

There was a thread that I found in my search of this forum, Thread name 'Send an active form as an email attachment' on 6/9/03. The answer to this thread by Pat Hartman is how I already have my Email button on my form set up. However, after adding a new record, and saving it, when I press the...

Thank you so much!