Recent content by klmorgan

I have used your suggestion in a Private sub but it Invalid outside procedure error. I have produced an update query with the following sequal statement: UPDATE Customers SET Customers.LastPay = Customers.NextPay, Customers.Nextpay = Customers.Nextpay+([weeks paid]*7), Customers.weekspaid =...

Just be thankful that we no longer use multiple base systems for money 12 pence to the shilling, 20 shillings to the pound and rods, poles and perches for measurement! I always used decimal hours ie 6.27 hours and made sure that everyone recieving the info had an explaination that the decimal...

Hi If you set up a query and in the Ingredients field in the box marked Criteria Enter: Like *chicken* This should return all records that contain chicken in the field. It seems Not to be case sensitive so would also find Chicken. The standard wildcards appear to work in the query so the *...

I have made a Form that is based on a query to update the time that the next payment is due for a caravan storage system. It is based on a query that finds the record I want to change. In the database there are two relevant fields: LastPay and NextPay which the form displays. I have put two...

Eureka the penny drops! Thanks for all the help, it works. Many Thanks for your patience Keith P.S. I don't do many spreadsheets now as I'm retired so my pleas for help will not be too regular!

Glenn I can't use a single cell reference (C4) as it refers to a group of cells. But if I omit the cell reference the code is accepted but the conditioning dosn't work. Regards Keith

What is the correct syntax to enter the formula in the formula is bo: ="a".OR."b".OR."c".OR."d" The above does not seem to work I have achieved a work around but to use the formula wold be more elegant! Regards Keith

Thanks to you both. Geoff's Thread will act as reading matter for weeks! Again many thanks It is great to have all this help on tap Regards Keith

Ive written an attendance rechare sheet for my son-in-law and I am trying to change cell background to to red if it contains the words: Sick, Hols, Bhol, Unpaid. The cells can contain a job name or these words as abscence codes. I am trying to use the between choice now but it pulls in some...

Hi Is there any way to get more than Three Levels of conditional formatting? I have four conditions that I would like to change the background to red but I can only set three. Or can I somehow enter Four words into the Values box? Kind regards Keith

See mail merge in help regards Keith

Is it possible to find the highest dated record using a standard Query ie. In a table of invoices find a record that finds the last record for a person Name Invoice Date = "Morgan" =Highest Date I've looked through the operators and can't see one to fit. Regards Keith

Ur, Um No..... Hadn't found that one! Many Thanks Keith

Hi I have recently produced a small Access system and today I have set up a Mail Merge document in Word that gets the Data from an Access Query. Although the query finds three recipients when I print the Word document only one prints. I looked at the table in Word and all three have their...

Many Thanks PH Worked Great Keith P.S. Might be a daft question but where can you get a listing of these commands?