Search results

Hi, I have a form that I use to provide the criteria for a query. There are 2 check boxes that are used to exclude 2 particular categories from the query. This is what I have in the criteria field of the query: Not Like IIf([Forms]![frmSubjects]![checkIncludeSubject1]=No,"Subject1","") And Not...

Hi Pat, There are only 2 users set up. The database users attach to the db as 'user', and have read-only rights to most of the tables, and rights to add and modify data on 2 of the tables. I, as the database creator and administrator, need full access to all the tables for administrative...

Hi Pat, Thanks for the reply. I have been on vacation, just got back today. Yes, all of the tables have a primary key defined, I found out a while ago that Jet has to have this to be able to update. Anyway, the problem only occurs if I try to re-link as a different user in code. If I use the...

Hi, I have a A2000 frontend, SQL2000 backend database, and I have used the code from Microsoft Knowledge Base to Relink ODBC tables when the database opens. This logs the user into the SQL server tables as a data browser user, the username and password stored in a table as per the MS article. I...

Hi Pat, Tried that as well! No matter what data type the first field is defined as, Access still tries to interpret the first byte as an ASCII character. As soon as the 4th record is read, it is interpreted as ASCII 04, which is end of transmission, and the import stops, and the first 3 records...

Thanks for the reply, I have tried the Val function, but I always get zero. I think the problem is that the first 4 bytes are being interpreted as ASCII characters, but because they start from 1, most of them are control characters. Also, the byte order is reversed, i.e. Record 1 is 01 00 00...

Hi, I need to read data from a text file produced by another application. It is in a fixed length, non-delimited format. Reading the file with a Hex viewer, it has the following format: 1st 4 bytes - ID Number 2nd 21 Bytes - Forename 3rd 21 Bytes - Surname etc up to 991 bytes, which is the...

Thanks Fizzio, that did the trick!

DCX, I had thought of doing this, and there is no real reason why I couldn't. I just thought that someone might have come up with a more elegant solution, I can't be the first to write a sports database and come across this problem.

Hi Guys, Thanks for the replies. This ALMOST does what I need, as it sorts the records into the correct order, but I need the 'Place' field to contain the numbers 1 to 8, as it is then exported to a file on another computer for some flashy HTML page as a projected scoreboard. This still leaves...

Hi, I am writing a DB for a school sports day, and I have a query that sorts race times into 1st, 2nd 3rd etc down to 8th. SELECT Results1.EventCode, Results1.Gender, Results1.StudentNo, Results1.Time, (Select Count(*) from Results Where [Time] < [Results1].[Time] and EventCode =...

Hi Rich, I tried the Normalization process, but because of the way the data is entered, this structure is the most efficient. Basically, the data is entered by class, spreadsheet style, showing all the kids in the class, with each of the 6 assesments. I tried setting up the table with one line...

This question has been posted a couple of times before, but does not seem to have been fully answered. I have database for recording student assesments. There is one record per student/subject, with 6 fields, one for each of 6 assesments throughout the year i.e...

Thanks for the reply, I have tried it like this, but I then end up with permanent duplicates. There are occasions when grades need to be edited, and I then get the problem of trying to find if there are any duplicates, and making sure that all copies get changed. I only need the duplicates to...

Hi, Yes, you did read it correctly, I want to CREATE duplicate records! I have a table with exam results in it with the following fields: StudentNumber ExamCode Subject Grade Weighting 123456 AB123 Maths A 1 123456 AB456 Science B 2 567890...

Hi Pat, Thanks for that. You are right about the fields not being unique. I have since discovered that the school's information management system (a commercial product), allows you to enrol a student in a class twice!, so the exported list has duplicates in it. I have had to add an autonumber...

Hi, I have a very simple Access 2000 frontend, SQL 2000 backend database. There is a table with 2 key fields on the SQL server that I want to update from a local table in the Access frontend. Only one field needs updating. I have built a query with the key fields of the SQL table linked to...

Thanks a lot IMO, that did the trick! Peter

Hi, I have a data entry form with several fields that have information typed in. There is also one text field that would normally have information pasted in from the clipboard. However, my users cannot manage to highlight the correct field when pasting, so I get all sorts of rubbish appearing...

Hi, I have a db for managing school reports. A table stores the reports, with the following fields: StudentName, Subject, Teacher, ReportText. Every student should have 14 subject reports, and I need a query that will find who has missing subjects. I have set up a one field table with the 14...