Search results

I have a Field [GCSESUB01]. It is an alphanumeric field. The user will enter either 9, or 8, or 7, or 6, or 5, or 4, or 2, or 1 into this field. There are nine fields altogether to which this will apply up to [GCSESUB09] At a later stage I need to convert these fields to numeric fields using...

May I try something else? Is it possible to select a value from a combo box and then Update that value? If I isolate class 3A from the combo box and wish to update that class, how will I merge the update query with the combo box on a form? Terence

Hello pbaldy Thank you so much for taking the trouble to reply to my question. What I need to do is to create a parameter query that when I enter into the Criteria Field the following, "Enter Student's With Grade 85%", a List Box will show me those students. Regards Terence

Can I insert a search parameter to a List Box? I need to isolate certain groups of students. Terence

May I send the School Management Database for you to get a much clearer picture of what I need? And please remember that this program is intended for a number of non-computer literate teachers who I hope will be come interested in Access for their own professional development. There is no VBA in...

Can I send you my application. It will go a long way in solving my problem. Terence

Understood. Terence

Hello Doc_Man I would like to send you some material I have developed for schools in Kenya, Uganda, Nigeria, Ghana and Tanzania. Would you kindly let me have an email address, I would value your criticism. Terence

Life has to go on. I will return later, and thank you for your kind words. Terence

Hello My apologies for not being forthcoming. I returned to Access in an effort to get over the remorse I am having on a personal matter. You will be aware of the Ethiopian plane crash last month in which 157 people were killed. I lost my godson and his wife on that plane and have just returned...

One of the problems I am having is to make the School Management Database open to all teachers. There will be a runtime version and the same version that can be explored by teachers who wish to get involved with Access. I am providing a PDF guide written in InDesign to show each stage of the...

Reply to PBaldy That certainly is a start. However in the average school say in Kenya, Uganda or Tanzania, there would be over 50 classes. What I am aiming to achieve is where a teacher enters 1A in the query and is what is the update target, which would be 2A inb this case. There must only be...

In my previous thread, I was seeking help on creating a query that will allow me to update a Class, such as Class 2A to Class 3A. This happens at the end of every academic year in schools when each student moves up a year. So my question is how can I update an entire Class from 1A to 2A, or from...

I have returned to a School Management Database I started over 15 years ago. Due to working in a number of countries in Africa in areas without electricity, I gave up on it. Now during my retirement I would like to return to this project. The problem I was having was updating a specific class...

Hello I never ceased to be amazed at the way that computers behave. I copied the runtime files to a CD and the database that was giving me problems with concatenated fields, then install the runtime files on a computer that had never had an Office product installed on it. The runtime database...

Hello All I recently converted all my Access 2002 programs to Access 2007, simply because I had heard rave reviews about Access 2007 Runtime. So I am now running Access 2007. The runtime program is incredibly simple to run, but I am having a problem. When I run my programs in 2007, I can see...

Hello Raskew Yes your: Where a space follows the 3 or 4 digit post code, e.g. SE1 7BJ Does work. Forget to mention that this program is compiled. Secretaries do not have access to Queries or any other object. When I have completed this update I will pass it on to a colleague who has the...

Hello All Forgive me for not making my request clearer. There are 420 schools and colleges on the database. All these schools and colleges have a post code prefix. Here are some of the codes: EC2Y SE1 NW12 SE19 W12 SW1W SE16 NW1 NW12 SE14 And many more At the moment there are 14 schools and...

Hello All A couple of years ago I completed a program for a college to place trainee teachers in various schools on teaching practice. Most students were allocated schools within their London post codes. I have just received a request from the college, asking me if I can modify the search...

Hello All I have a parameter query that opens a report. I have a parameter query that opens a form. I am aware of the On No Data property available for providing a message box when a teacher enters a class into a parameter query and the report is empty. Is there such a procedure for providing...