Search results

I'm using A2K but what I need it not the total word count but to know that there are 3 one letter words, 5 two letter words, 6 three letter words and so on Your idea will help count the number of sentences, however, so thanks!

This is probably very clumsy, but... TotalCharacters = Len(Text) ‘ for the letter count… If FormatCount = 1 Then For i = 1 To TotalCharacters CurrentChar = Mid(Text, i, 1) For j = 32 To 90 If CurrentChar = Chr(j) Then LetterCount(j) =...

I am trying to count letters and word lengths in a piece of text using code. I have two problems ans suspect that solving the first will solve the second. Here's the first: I have a loop which (if formatcount=1) looks at each letter in turn and adds 1 to the counter for whatever that letter...

It may be clumsy but how about making your query a make table query and then basing your word data source on the table? I have used this and it seems to work OK

I have a datbase which gave me problems when I replicated it (answers to the question on a Replication crisis would still be gratefully received). I used replication because I have users who may log in from various places - did I really need to replicate? What is the maximum number of users...

Excellent news - I'd be really interested to see the code you have

I'll give this one some thought but as an initial comment, you write fx = (1 / nSD * ((2 * nPiK) ^ (1 / 2))) * (neK ^ ((-1 / 2) * ((nx - nMu) / nSD) ^ 2)) I think you need: fx = (1 / ( nSD * ((2 * nPiK) ^ (1 / 2))) ) * (neK ^ ((-1 / 2) * ((nx - nMu) / nSD) ^ 2))

That's how it started and it doesn't seem to make a difference. Is there another route I could try? Thanks Late update - I have cracked it... 4am now but at least it's done! Thank you for the support

It is - although it is below the Access object library in the list of references. I read in a page of Dev Ashish's that I should(?) move it up in priority but they box I needed to uncheck would not play the game and I couldn't pursue it. Might I be better to copy the whole database into a new...

Just a quick addition here: I am desperate! ANY thoughts would be appreciated

I have a form in which users enter exam marks for a group. In a subform the names are listed and in another sumform the Maximum marks and grade boundaries are given. Staff enter the marks and it converts them into grades using the % boundaries. My problem is getting the command button...

According to the help file, the maximum number of controls and sections you can add over the lifetime of the form or report is 754

So why won't the "If FormatCount = 1" route work? Thank you, Rich - removing the request for the pages being numbered does the trick and will make things look much better in what is now just 3 hours!. I'm greedy and I'd like no double message boxes AND to have numbered pages, so if you have any...

So why won't the "If FormatCount = 1" route work? Thank you, Rich - removing the request for the pages being numbered does the trick and will make things look much better in what is now just 3 hours!. I'm greedy and I'd like no double message boxes AND to have numbered pages, so if you have any...

Just pushing this up to ask if anyone has ANY thoughts on this - I have to give a demo of the show-so-far in seven hours and I could do with this working! Many thanks

I'm not sure what you mean there... won't it just run for each record? I'm probably just showing my ignorance there

I have a report in which the Detail section has some code in the On Format section. The code checks to see if the value of one field exceeds the value in another and then pops up a message box if it does. I have set it up like this: If FormatCount = 1 then If [FirstField] > SecondField...

Thanks for the thought but I have grouping set. My problem is that the detail is pretty much like a letter so I have an unbound text box including text something like: ="...you are involved on " & [Date]& " more text..." so I really need to be able to combine several rows into one so that the...

I have a report which goes to various people – they each get their page. The group of people who receive the report are drawn from a pool and this changes each time it is used. On each use the data covers a period of three days (Sat, Sun, Mon) BUT this means that those involved with more than...

Can I modify my question? How about moving the heading so it is always in column 1? i.e. can I stop it from putting the heading in column three etc Thanks for any ideas