Search results

I am probably!

Something wrong here or I'm missing something. I have a couple of reports that summerise data entered daily into a weekly report. I enter a start date and the number of weeks I want to view and the report comes up with a weekly summary for the number of weeks input. I've just changed the "Group...

Probably the best way would to use the "Sorting and Grouping" option in the report footer. There are day, week, month etc options for grouping. Not sure how this would then be used in a graph!

I have 3 reports which contain dynamic headers. These are in the grouping headers not the form headers. Preview and print of these work fine. When they are used as sub-forms in a report, the headers are not visible. To get round this I have opened the 3 reports hidden using the On-activate...

Got it. In Query, Parameters the parameter for Query1 must be declared separately with brackets viz. [Forms]![DTdates]![StartDate] and [Forms]![DTdates]![EndDate] (Date/time Data type). In the same Query1 the criteria is declared viz. >=[Forms]![DTdates]![StartDate] And...

No. Still not working either way.

No. Still invalid bracketting message.

Thanks for reply Smart. Getting closer here. I've never used Query, Parameters before so need more guidance. I've put in the code as your reply. Immediately [ and ] are added to the start and end of the code viz. [>=[Forms]![DTdates]![StartDate] And <=[Forms]![DTdates]![EndDate]] When run I...

I print a report based on Query1, with the selection criteria for dates being taken from 2 fields on a form. The selection criteria reads:- >=[Forms]![DTdates]![StartDate] And <=[Forms]![DTdates]![EndDate] Simple and it works fine. I now need to base a second report on a Crosstab query based...

Thanks for your thoughs on this boys. It was the standard Toolbox that I was refering to. Like I said, system resore fixed it. I'll try Rakier's fix next time. Enjoy.

Recently I lost the the functionality of the toolbox then shortly after I lost the toolbox icon completely. The only way to use the features was to create an new toolbar. System Restore finally fixed the problem. This has happened twice on me with the 200 and 2003 versions. Is it me? and is...

In design view, right click on textbox and choose "Conditional Formatting". This allows up to 4 conditions with different colour backgrounds or text (or both). My problem is I need more!

Forget it. Populating the txtboxes on On Open. Should be On Activate. Sorted.

I'm trying to pass a Public variable into a textbox on a report but get the error message "You can't asign a value to this object". This works OK on the form though. Any way round this? Thanks

My db loads with a splash form with the following code. There are a couple of command buttons for Quit and to allow further access. Problem is it still takes a while to load! Db is compacted on exit. Any ideas to speed up? Thanks Option Compare Database Option Explicit Private Sub...

Thanks GH. Works good.

Yep. Me too. Seemed a bit long winded so I thought I'd ask. Thanks

Way too many

What's the easist way to set a record in a form to read-only if a check box is ticked? When going from one record to the next, the user needs to facility to change a record only if the tick box is empty. Ta

Boys oh boys oh boys. Anyone any ideas yet or is this unworkable?