Search results

My company is about to join the 21st century and they are upgrading from MS Office 97 to XP and Office 2003. We have lots of Access databases, many designed by me, so if they don't work next Monday people will start comming to me for answers. As I am only familiar with Access 97 (and I am by no...

Uncle Gizmo, Thank you for your reply. It took me a while but I've just found the answer myself. The average result was a single field on a form and then used as a sub form in my main form. The field in the original form was about 1.5cm square with a font size of 24. I had set the decimal...

Uncle Gizmo, Thank you for your reply. It took me a while but I've just found the answer myself. The average result was a single field on a form and then used as a sub form in my main form. The field in the original form was about 1.5cm square with a font size of 24. I had set the decimal...

Uncle Gizmo, Thank you for your reply. It took me a while but I've just found the answer myself. The average result was a single field on a form and then used as a sub form in my main form. The field in the original form was about 1.5cm square with a font size of 24. I had set the decimal...

I have a form with a field that gives me an average of results. Below the number 10 it works fine - for example, if I have 6.3 as an average it displays 6, if it is 6.7 it displays 7. If however the number is greater than 10 I have a problem. Should the number contain a decimal it rounds down...

The answer is no - I don't know what a case statement is! I have had no training with VBA so I have to adapt what I know, which maybe, is long winded at times. Like a lot of people, if you get something to work once, you tend to stick with it regardless if there is a better way.

I have a form with a field that produces a value based on entries in a sub-form. I have code that produces a different back colour dependent on the value. This works fine provided there is an entry in the sub-form (sometime an entry is not required). If there isn't an entry then the back colour...

Thanks Pat

I'm looking for suggestions on how to do this. We have a fleet of aircraft that have mixed variants (ie some have cargo doors, others do not). I am looking to control the workcards that are issued for the maintenance. Currently we have them stored on Word. For simplicity, a particular...

Dave returned from a doctor's visit one day and told his wife Alma that the doctor said he only had 24 hours to live. Wiping away her tears, he asked her to make love with him. Of course she agreed and they made passionate love. Six hours later, Dave went to her again, and said, "Honey, now I...

Use the Print Screen button and paste into Word.

A travelling salesman visits a small town and sees a circus banner reading: "Don't Miss The Scotsman." Curious, he buys a ticket. The tent goes dark. Suddenly, trumpets blare and all eyes turn to the centre ring. There, spotlit in the centre ring is a table with three walnuts on it...

Yes, Rich, I think that will do the trick. Thanks to all those who replied. Your comments and suggestions are appreciated.

That does seem the logical solution but I work with a lot of dinosaurs and some of them do not want to use computers at all. If they have to use a computer you have to do the thinking for them and make it as easy as possible. With some of them you can point out their mistake over and over...

"or give the users a good slapping " That's the sort of positive response I like :D

This is a continuing problem despite my best efforts. I have a form for inputting data. The first record is a dummy record that identifies itself as for information and has a large field that states to use the binoculars for searching (people type in the number etc into the field and then try...

Yes it does work. You just have to set your number to minus 1 before you run the append query. Thankyou.

Very simply, can you get an autonumber to start from zero instead of one?

If your original form works fine then leave it as it is. Just add a button that takes you to a new form when you want to print it. Your new form can be the one to select the name. Your new form can also be used to print everything or just the individual report you require.

That's different then. Build a form with a combo box with all your names in. When the name is selected, get the form to run a macro or write the code which then opens the report in the view you want.