Search results for query: *

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

...somewhere) My question is if I try to do almost any computation with the points for & against I have no problems until I try "(For / Against)*100", this gives me an overflow error. What am I doing wrong? I have wasted a few hours already on what I thought was a very simple...

...somewhere) My question is if I try to do almost any computation with the points for & against I have no problems until I try "(For / Against)*100", this gives me an overflow error. What am I doing wrong? I have wasted a few hours already on what I thought was a very simple...

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

First off, Limpan. I added all 150 items to the query. It was really ugly and I couldn't create areport from it. Secondly, Raskew. All goals are different, they could be one line. The Objectives & Strategies are a line or two or even three, however they tend to be more verbose than the...

Thanks Francescina but I guess the critical point in my postinig was "I want all the data on one report that runs over about 10 pages for each student". I have created about 20 tables. I have 1 main form that calls or has about 20 other forms. I tried to join the tables into a...

I am developing (trying to develop) a database for information on students. Each student has about 150 data items. The normal student stuff eg name age address etc. Plus goals 1-5 with objectives 1-5 with strategies 1-5 so the multiplier effect makes it grow (is it out of control?). It...

Hi Everyone I have a database that contains details of students and various options that those studentys are taking. The options are selected by clicking on a check box. The problem I have is that I want to merge these results into a form letter in Word and I don't want the check box result...

??? Using internet enabled forms.