Search results

Thank you so much for your prompt reply! I put this code in the code builder on the on click for the form. It is not working for me. Is there something I'm missing? Have I put the code in the correct place? I am brand new to coding. This is my first attempt. Woohoo!

Ok-let me see if I can explain this.... I have a report with 4 sub reports on it, each one counting the same field on a table, but with different criteria. ie..there are four different types of fruit that I must count. So, I have a separate count query for each type of fruit. (is there an...

I have a list box which uses a parameter query to bring back all matching results of the search. ie.."Search by last name" would bring back all cases with Smith as last name and display them in the list box. How can I then select the particular case I would like to view and bring it up in edit...

Thanks, that worked like a charm!

I have a multiuser database on our WAN here at work. I am wondering if anyone could help me out on autopopulating the user id on a form, thus writing it to the table. I have heard that this can be done when you have a user work group in place, but the example db that I have to go by gives no...

I have not done any coding so far, and I was wondering if you simply add that statement in the properties box for the form where you would normally use the drop down box to choose Event Procedure, macro name, etc. Or, do you have to add it to the actual code? [This message has been edited by...

All- I am using the send object function in a macro. Does anyone know if it is possible to send more than one file in that same e-mail?

On a report, you can not reference the name of a calculated field in a subsequent calculation. What Ilk is saying is that when you need to reference that calculated field, you have to type out the entire expression again in your sum expression. Ex: 1st calculated field =[blah]+[blah] 2nd...

My standard reply to a question about report/sub-report is, when you can avoid it, don't do it. I have found that it is much easier to write one big query that queries all of the tables you want on the report. You can manipulate the headers, footers and detail sections to make it look as if...

Pat, Man, I think you're on the right track here. That almost works....one more question though. On my report I have case id# and then each case id can have multiple accounts tied to it. The set up is this: [Case id] and [category] are in the case id header and the account information is...

Pat, I have been working on a similar problem... In a report, I have [category] with four possibile choices in a detail header. I want to be able to count how many times each type occurs on the report in a calculated field on the report footer. At this point, I can't even get the count...

Talasan, Hate to tell you this, but....I faced the same problem. I was trying to create calculated fields in the main report footer referencing field values in the sub report. Let me tell you, I banged my head against that problem for three weeks, always with the same results you're getting...

Just a thought...I found in the Access Bible (as I affectionately call it) an obscure troubleshooting reference to the #Name? result. It says that this could be a result of the control source having been changed and the change not being reflected in your expression...as a twist on this, could I...

I have done as you suggested. The calculation works in the hidden field in the subform. I referenced it in the new text box by using it as the control source. When I run the report, the result of the field in the main report is #Name? Am I missing something here?

I need to place calculated fields in the report footer of the main report that use fields from the subreport for the calculation. The logical way to do this would be to simply create calculated fields in the footer and write the expression using the desired fields from the subreport. However...

The end users who enter the info into the form need to be able to view the cycle time. And the cycle time will also need to be retrieved to use in reports, sometimes a month down the road. What harm will be caused by storing a calculated value in the table? I can only find documentation that...

I am stumped on this one! Situation: Main form [Case Info] has subform [Acct Info] In [Acct Info] I need to calculate cycle time and have it write to the table. formula =[Date Stopped]-[Date Acct Est] I have created a macro on the subform that is used as an after update event for the Date...

I have the same sort of problem. I am working in a form with a "cycle time" field where the default value =Date Stopped-Date Started. I need to have the cabability to query the cycle time for all accounts. I assume this means that the result of the calculation will need to be stored in the...