Search results

Hi Peter, I can imagine this being tricky with drag and drop but with a move up button you simply switch the order value with the one above the selected. I was hoping somebody have already written that code. Thanks anyway. SWK

I would like to make it possible for the user to arbitrarily reorder records. Maybe displaying records in a listbox and have a Move Up - Move Down button. I am sure that this is a common problem and I would be grateful if somebody could direct me to a solution because I couldn't find it. Many...

Pat, that was exactly what I was trying to do and I understood now how to do it. Many thanks. SWK

Hi Pat, this is what I have entered for the criteria, what should have I used? Where do I put the IsNull? Thks SWK IIf([Forms]![Narrative_AllocDetailMain]![OmittedScaleGroupFrom]="omitted",Null,[Forms]![Narrative_AllocDetailMain]![CompetencyID])

Sorry if wasn't clear enough, but that was my point: the expression should surely evaluate to Null but if I enter this expression as a criteria in the query grid it doesn't filter out Null values, whereas if I simply enter Null as a criteria it does, so I think this must be an error in the way...

I am building a query which returns some records if I use Null as criteria in a field. If in the same field I use iif(5=5,Null,Null) it returns no record. I also tried Like .... "" but that didn't help either. Is it a problem with the iif function or (more likely) with the way I use it. Thanks...

Hi, I call an application from Access that writes back some records to a table through ODBC. It waits until the application stops - it does I checked it - and than displays the records by opening the table. If I open the table immediately however the records are not yet there, I have to wait a...

I have a table with data in the following structure: RuleNumber Scale 1 A 1 F 1 D 2 B 2 C 3 C 3 B ... 1000 records I would like to put rule 2 and 3 into one group because they have identical scales. (Max number of scales to a rule is 6.) I would like to put all such identical rules in groups...

Hi, I have a report with only one memo field. It appears correctly in report preview. It prints correctly to Acrobat. BUT whenever I publish it to Word via Office Link (or export it to RTF) some text are always truncated (although more than 256 characters appear). The field is set to Can...

Thank you for all your help. The solution was indeed to replace my command button from my subform to the parent form - since I wanted to save the parent form's record befor doing things with the subform. It works now with DoCmd.RunCommand acCmdSaveRecord. Thanks again. SWK [This message has...

A slightly different aspect of the previous topic: people always suggested to use the DoCmd.RunCommand acCmdSaveRecord to force saving the current record on the form. For me it always gives the error message: The command or action "SaveRecord" isn't available now. I think it is because I got rid...

When the forms are initially loaded you have to wait a lot for a calculation that is at this point unnecessary since there is no data yet to start with. The logical solution would be to load the 2nd form separately when the button is pressed but they look so nice next to each other (the input...

Yep, that is what I thought too, but I just can't make it happen. It is a continuous form, maximised, all the records are in, no footer, tried to set all sorts of properties to all sorts of values (scrollbars, cangrow/shrink, autoresize, etc.) but I still have the vertical slider when it is...

I have two unbound subforms on a main one. One of these is displaying records calculated with the data entered on the other. It is updated with a button. The calculation is quite lenghty so I would like to avoid it when the forms first open, since there would not be any data in anyway. Naturaly...

Could somebody tell me how to have vertical scrollbar on the subform only if the data wouldn't fit and not otherwise? Most of the times it wouldn't be necessary and looks ugly, but than sometimes people couldnt scroll down when needed. I know, I know not a major issue, but still... Many...

Thanks Pat, that was the solution.

Thanks Pat, it seems that you are right. If I only change the condition to an exact value instead of a control name the crosstab works. But than how could I filter the rows on which I want to run my crosstab query based on a control? Is it realy impossible? Should I write code for that? What...

I have several queries embedded in each other and at one point one of them is filtered by a control on a form. The final query runs nicely if it is a simple select query but gives me an error message if I turn it into a crosstab query saying that the [control name] cannot be recognised as a...

I am not a big comp wizard. When I had to look for similar sentences in two fields of a query I wrote a function that comes up with a similarity score for the each possible pair, ordered the pairs according to that sore and than manually decided on the top scorers. This was very far from being...

Did you try to refer to your subreports with its whole name? Reports![MainReportName]![SubreportName].Report