Search results

I figured it out. I needed to incorporate this in code

Hello, I am trying to run a macro on doubleclick in a subform (dataview) that will open the same record in a popup form (tabular). I've enter in the macro Where Condition the following statement to only show the record I doubleclicked on in the popup. The only problem is it's asking me for a...

tried this but didn't work Hi Pat, I checked the names and to be sure I changed them but this had no effect. I can't understand the inconsistency; other reports are working just fine. I suppose the only variable here is that the reports have charts in them and the working ones don't???? My...

(sorry I accedentally posted this one on query list. It should be here). I have numerous reports based on queries with a criteria date select string. So when I Preview the report I first get asked "Enter start date:" etc. In all reports I have entered a text label with date control source...

I have numerous reports based on queries with a criteria date select string. So when I Preview the report I first get asked "Enter start date:" etc. In all reports I have entered a text label with date control source stating "=[Enter start date:]" to have the start date parameter value printed...

solved thanks people, works!

works but.. thanks, but does that mean I have to enter data 4x now? I was hoping go get the variables on the report for the first two date questions asked embedded in the query itself. It seems a bit inefficient and open for mistakes if you enter two different set of dates.

Does anyone have an idea how I could include variables I input in a query to that of a report header? I have a date stamp in a query. In that query I entered the BETWEEN [ENTER START DATE:] AND [ENTER END DATE] paramater. In the ensuing report this query is based on I would like to include in...

I've got two tables. 1) Financials 2)Candidates I've got a form for "Candidates" with a subform "Financials" In the subform I'm trying to create an event procedure in field "Status" 'after change' that will Dlookup a value in the Candidates table (ConsultFee) and divide that value by 4 and place...

Hi, I'm having a problem I just can't seem to solve. I've created a query that includes a join query as well. When I run the query it displays the data correctly so no problem here. But as soon as I want to create a report based on that query I get the following error when trying to run the...