Recent content by KelMcc

Problem solved by a fix on the report. Thank you both for your help. :)

Huzzah! Again, I say, Huzzah! Thank you both for your help. Problem Solved. :)

Oops, OK, upon closer inspection, do you mean to put that code into the control source of combo box on the form? The one that the report uses? If so, then disregard my previous post, I'll try this. However, I'm concerned this will pass on a value "All" to the query, which will make it not work.

OK, tried this: =IIf(isnull([Forms]![FISReports]![Status],"All",[Forms]![FISReports]![Status]) got a "wrong number or arguments" error So, I thought it was missing a parenthesis. =IIf(isnull([Forms]![FISReports]![Status],"All",[Forms]![FISReports]![Status])) No, same error. :( Ok, maybe...

The problem is in the control source, I had this line: = [Forms]![FISReports]![Status] I changed it to this: =IIf([Forms]![FISReports]![Status]="","All",[Forms]![FISReports]![Status]) But, it still behaves the same. If I leave a blank value on the form, it does not populate the word "All"...

I'm trying to figure out something for this thread. Basically, I have a form that has some combo boxes where you make some selections. You then click a button (on the same form) that launches a report that returns data based on the choices you made in your combo boxes. On the report I have it...

Hey! Nice! Thanks. Now, if you want to help me w/ a slight complication. One of the options the user has is to leave the field blank. How do I make it so that a blank field on the form will cause the word "All" to appear in the report text? Thanks again. :)

There may be a better/easier way, as I've learned access backwards (from a user perspective, so I don't know code)... But I had the same problem. Using a lot of help from these forums, instead of vB code, I used a query: Then, have the report use the query as its control source. My query had...

OK, I put this in the control source field for the textbox on the report: Applies to: &[Forms]![FISReports]![Status] and I get the error message: "Syntax error in query expression" FYI, from what you suggested, jtvcs, I put the name of the form supplying the dynamic variable in the 2nd...

OK, I call a report, RSR, from form FISReports. On the form, you can choose the date range (not optional), a specific individual ("BA", optional), and the status (optoinal) of the projects you want to report on. The button that runs the report has the following code to filters the optional...

Yeah, I had to wipe the db, unbreak the links then save the autonumber field as something else, then swap it back and that worked. Fortunately, it is still in test mode so I didn't lose any data of value. Thanks Pat. :)

In Access 97, is there an easy way to reset an autocounter? Or, maybe, more generally speaking, is there a way to "reset" your database? Meaning, I've done all my testing and I want to clear the data, reset counters, etc... Is there a simple command for this? I've looked around some and not...

FYI, Elana, your suggestion, now that I'm 3 months older in my Access education, worked like a CHARM! :)

I'm w/ David. This may help me as well. *waits w/ anticipation*

DQM, there's not much code there: ----- Private Sub FISIFCommentE_Enter() DoCmd.GoToRecord , , acLast End Sub ----- So, "FISIFCommentE" is called (source object is FISIFCommentRO) and it tries to go to the last record, BUT, there are no records so I get the 2015 error. This is the instance...