Search results

Fantastic!! That's really kind of you; You can't possibly understand how boring creating this Art Index is, and how much further boredom you will have saved me by showing me how to do this!!! many many thanks.

Here it is: The first part is from when I was having a go at Richary's suggestion, but it gives the field names. SELECT IndexArt.[Indexed Word], IndexArt.Pages, IndexArt.Coloured, IndexArt.Notes FROM IndexArt WHERE (((IndexArt.[Indexed Word]) Between "A*" And "Z*") AND ((IndexArt.Notes) Not...

thanks for that, but I am confused and can't get it to work. Do you mean that I simply replace [tblYourTableName].[YourFieldName] for my names in the query criteria?? InStr(1,Left([tblYourTableName].[YourFieldName],1),UCase$(Left([tblYourTableName].[YourFieldName],1)),0)>0

Bah, they dont work. Well, richary's doesnt Im afraid, and John, thanks for your reply but it would take me longer to set up a form than it would to just manually go through my own index. Thanks anyway. If anyone knows of a quick simple solution....?

thanks vvery much!!

Hi, Is it possible to filter out entries beginning with a capital letter with a query? Ive tried Like UCase, but that doesn't work, and there is no upper case wild card. (I am creating a book index and want to have a look only at the entries that are people's names) many thanks

many thanks

Ive added my own navigation buttons as I needed to add some code to them, but when a user gets to the first / last records & presses previous / next record, they get an error message 'cannot go to the specified record' and have to close & reopen the form. It's prob. quite simple, but how do I...

Hi, I am having a problem with a form in that I can no longer add new records to it! The data comes from a query formed of 2 tables, linked by a 1-many relationship. I can add records to both the underlying tables and the query with no problem, but in the form I can't. I get no error message...

Hi, I am having a problem with a form in that I can no longer add new records to it! The data comes from a query formed of 2 tables, linked by a 1-many relationship. I can add records to both the underlying tables and the query with no problem, but in the form I can't. I get no error message...

Aha! Thanks - (fingers moving faster than brain)

Many thanks. What is the running sum property?

in a query I am calculating DateDiff. I have an expression which puts a price into a column if datediff < 30. When I try to total that price in a report (in the groupby footer), with the expression =sum([thenameofthatpricecolumn]) I get a 'data type mismatch in criteria expression' error. I have...

Many thanks I kind of see what you mean - why would it let you format currency then if format is text? Currency is always numerical?

Hi, I have a query which calculates the date difference between Invoice Due Date and Today, so that I can generate a statement which totals payments 30, 60 and 60+ days late. The query expression is: Current: IIf([DateDiff]<=30,FormatCurrency([Total]),""). However, when I try to...

Alright then, I guess that that was impossible! Can anyone suggest how I could generate a new number starting at 1 for current (as opposed to expired) clients, not related to the Invoice number or the Client number, which can be reset at the touch of a button? many thanks

Hi, hope you can help!?! I have an update query which on a certain date needs to reset order numbers in sequential order. As some clients don't order in each period, I have set 1 update query to set the OrderRef to 1, and want to create another update query which changes the OrderRef to...

many thanks again Colin, I'll give it a try!

Hi, help much appreciated in advance! I have an Invoice report set up running from a query (criteria set to 'is not paid'), but I can't work out how to get it to group outstanding payments from one customer onto the same page instead of giving each individual invoice its own page. Many thanks

Ooh - hang fire - I did it! Many, many thanks for your help, greatly appreciated and invaluable for dabblers like me. :D