Recent content by Stephenlyn

Thanks Roy-Vidar The form update event works a treat. cheers

Hi All I have a database and I need to know when the each data record was entered. Any ideas.... cheers Steve

Did you totally uninstall Access before you reloaded it?

Your spot on. Now that you point it out the logic makes so much sense It works a treat. Thanks heaps Bob

I don't call the report from the form. While it's a control on the form it is also in the detail section of the report, so when you move from one record to another the check box may be different hence it should be hiding or showing different parts of the report page. It's a 600k file, if...

yes that's right. It's a bound yes/no check box from the form that determines what is displaid on the report. each record can be different.

That's fixed the problem with the first record however the rest are still not behaving as they should. Any other ideas.

I have a program that is producing school reports for special needs kids. The kids can be assessed in different curriculun areas. So I have check boxes on the form to indicate what curriculum areas they are being assessed on. When the report is called the following code is supposed to check...

Yeah Good Question. That the problem if the formula is:- (F\A) * 100. cheers Steve

Hi All I have setup a football tipping ASP site and one of my pages has a ladder of the teams and their current position. I am sorting the ladder by points based on a win/loss/draw scoring system. I then sort them again based on a percentage of points scored for and against. (Is there a...

Hi All I have setup a football tipping ASP site and one of my pages has a ladder of the teams and their current position. I am sorting the ladder by points based on a win/loss/draw scoring system. I then sort them again based on a percentage of points scored for and against. (Is there a...

Hi I have 4 MS Word documents that I want to send data to from a MS Access Form. Which MS Word document to use is determined by a radio button group on the MS Access Form. I'm having a bit of problem understanding what dim statements I need and what they do, particularly the path. Any help...

Jamie, You're a ledgend. I tried to do this using a complicated function from Jimmy The Greek however I kept getting errors using MSA 2000. Your solution worked like a dream ::-) . Yes Michael what you say is quite correct, however this is a quick solution to fix a not so well designed...

Hi Everyone I have an Access Database that was created by someone else that has mum & dads name in two fields. I want to do a mail merge. The problem is I only want their first names. eg Field 1 Fred Smith Field 2 Betty Smith I want Fred & Betty any ideas? cheers Steve

Hi Everyone I have an Access Database that was created by someone else that has mum & dads name in two fields. I want to do a mail merge. The problem is I only want thier first names. eg Field 1 Fred Smith Field 2 Betty Smith I want Fred & Betty any ideas? cheers Steve