Search results

You need to add your selection criteria to include what the report needs to display. In your case, select the field, then define the criteria (*port*). Next, right click on the value you wish to summarise, and go to summary, select the field you wish to group it by (eg, your salesmen), and hey...

I'm guessing off the top of my head that you could write a condition formula in the suppress section like, If PageNumber = 1 then False else True This is within the SECTION EXPERT Hope this helps Kempes

What do you mean by a counter? If you want something to count the records on the report go to INSERT,SUMMARY which gives you a choice of summary options. Hope this is what you are after. Kempes

You need to link the sub report to the main report, otherwise it will show everything. The best thing to do is run through the Sub report wizard which gives you on option to link by a common field in both reports. The sub report will need placing somewhere in the details section. Hope this...

This is correct. Within the query that your report is based on, find the unique identifier field which should also be present in the form (doesn't need to be visible in the form) and put in the following. (Adapt to suit.) [Forms]![Formname]![Fieldname] This should reference the value...

One way of doing this is to do the following. The query that your report is based on will have a criteria option at the bottom of each field. You will need to set this to point to the identifier of your open form so it knows which record to export. In an event based option of your form...

I Noticed this sort of thing happening when changing the default printer for the report. Check this out too. It may be where the problem lies.

Not as yet. Was kinda hoping there was another way. If not, I will give it a go.

Guess what, I'm still stuck on this. Anyone at all?

Bumping in a desperate bid to solve this issue.

I have also Compacted and Repaired without success. When opening access only, the message appears but closing and opening again seems to be ok. However, when opening my db the message re-appears yet again. I can't seem to shake it off.

...There are no disabled Items

Hello all, Has anybody ever encountered this before. I can't seem to get rid of it. When logging in to my Acc 2003 db I get a message along the lines of... "Access failed to start correctly last time. Starting access in safe mode will help isolate a startup problem. Do you want to open in...

Depending on which version you have, you get either Crystal Enterprise or Crystal Server with it. Setting this up allows users to refresh parameters, etc, without changing the report in any way. Alternatively, Try Crystal Offline Viewer. (would need installing on each machine). This disables...

Why not have an Activity Table which records any activity (name change, Salary change, Role change). Each activity could have a status (active, archived). Active being their current details. Ie, Activity Table ActivityURN UserID RcdDate ActivityType (Combo of what kind of update, ie Salary...

it sounds like you need to save the changes to the table before refreshing the report. Try this in the code that launches the report. DoCmd.RunCommand acCmdSaveRecord Docmd.requery me.refresh Hope it helps Kempes

I would check the dll's again. I'm guessing the report requires a dll that isn't registered on this particular PC. I had the same problem with dates, which was solved by registering the dll's.

Thanks for the replies. I was looking at the "On Error" event for each form but can't get it to work. I'll give it a try with a function. Thanks Kempes

I've searched the forum but can't find a solution to my problem. I have many forms that have many controls attached. I have also set up a group called READONLY, and assigned them permission only to open the forms and nothing else. I have noted down the errors I want to trap so I can make a...

Not sure whether this is the answer you want but this pulls back something in the field. Expr1: IIf((((([timeOut]-[TimeIn])*24)-7.5)<=0),"",CLng(((([timeOut]-[TimeIn])*24)-7.5))) Cheers Kempes