Recent content by Gareth50

Dear all Could anyone provide me with a section of VBA code (module) that will carry out the following in one procedure: Open an existing table - called 'Students' Select and delete all the records leaving just the structure (preferably WITHOUT a request to confirm) Close the table ready for...

Hi Jim Attached is a small sample of the db table causing the problem. See what you can do. Gareth

Dear Jim (& Friends) The Case continues insensitively!! Thought you had solved the problem but unfortunately many of the graphic charcters return the same code - 166. Have been on to the writers of the original db and they tell me the coding is called a 'crash code' and is produced by an...

Dear Jim You're a star and I'm a dipstick! Your first method would have worked and so does your second. The problem was I had the field type set to Text which is what was producing multiple values. Once I reset the field to numeric it did indeed produce unique numbers. I am very grateful...

The case continues Dear Jim and everyone who likes a challenge I'm afraid this didn't work. Of course if you evaluate each character and sum these numbers in many cases you arrive at the same number which means it's no good as a primary key. Any further suggestions will be very welcome...

Hi Jim Many thanks for the tip, I will try this and see how it goes. This is a live Link to a much larger Dbase database that is continually being updated so my solution has to read the Dbase table then update values in my access table each time the Access db is loaded. I'll let you know how...

I Think it will be as normalised as possible. DB actually consists of 4 main tables: Student details; SATs Results; GCSE/ALevel Results and Class Details. Each 1/2 term a report is made on every student giving three grades for every subject (typically 10 subjects). An attaiment Grade, an...

Dear all Not sure which thread this belongs in so here seems good. I have multiple tables (around 60) that (will) contain assessment data on students. The tables will have the generic name PA# eg. PA1 or PA32 etc. I would like some kind of menu, with a drop down list or similar that will...

I'm a beginner with access so don't know how to incorporate a filter at import time but you could use an Update query to create a new field by using access string handling functions. Assume the field that contains your COBOL data is called Field1 then: Once you have imported the data into a...

Dear all Can you help! I have imported a Dbase5 file into access that uses the full range of ascii characters to make up the primary key field. eg. £%{A or ""$6 The problem is, they use a mix of upper and lower case letters and when imported Access sees upper and lower case as the same...