Search results for query: *

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?

Hi I have produced a small system in Access and would like to set the close event in the Switchboard Form to close the database when the forrm is closed. Can anyone tell me what the command is please? Regards Keith

Thanks Zameer I will have a try at this. Do I just cut and paste this into the Switchboard open event box or do I somehow have to set up a procedure with it and call it from the Switchboard open event box? How will I switch it back off when I want to get into modify the system? Sorry if this...

Thanks Zameer Are you referring to the display database tick box on the Start up menu? I have unchecked it but it still displays the menu for databases queries ect. Any ideas? The holding the shift is great, I can get back now. Kind regards Keith

Having written a small system in Access for friends I want to make only the switchboard on it accessable to anyone so that grandchildren etc can't get in and make changes. I have used the Startup control to hide most of the toolbars but the window that allows access to the table, queries etc...

Thanks Leslie I have downloaded the first and bookmarked the second and I will read through them. I'm retired now so I have some time! I used to be quiet good in a Dos database called TAS that was used to create the Small Business System TAS Books, it was a reasonably priced database with a...