Search results

I have tried doing a search for similar posts but haven't found one where a solution has been offered - just several people with a similar problem.

Can anyone help with the problem? I am using Access 2003 and the photos are .jpg so currently I have to change each one manually to .bmp and then resize to fit the space in the form. Does anyone know how to do this a better way?

Sorry Catalina - I wasn't sure which area to use so I put my question into several.

I have created a profiling database for my school. Each student can access their own form via the school's admission number - which I use as the primary key for most of the tables on the form. One section of the form shows a photo of the student. I take this photo from the school's SIMS photo...

Paul, I have reviewed the content of my tables and most already have the Adno as their primary key - but some just have the Adno as a field - presumably because I neglected to make them the primary key. If I now amend these table to make the Adno the primary key will that cause any problems...

Hi Paul, My profile form has about 30 tables for the subforms. Do I need to add a primary key to each of them? If I add a primary key: 1. Will I lose any of the data which I already have? 2. Will it affect the way any of my queries work? Thanks Neil27

Hi, I have created a profiling form for my school. Each boy can access his form using his admission number ( Adno) which is the primary key. On the form are lots of sub forms - for things like favourite authors, clubs, teams played in etc - but these don't have a primary key ( as they are...

Hi, I am designing a profiling database for my school and want to make it so that when the children fill in the forms they can't right click on the title bar and see the menu which allows them to go to design mode and change my database form design. Ideally i want them only to be able to see...

Hi, I have set up a database for the clubs at my school. It has 3 tables: Members : fields- Idno, Forename,Surname Clubs: Fields - Clubid, Clubname Membership: Fields- Idno, Clubid, Active I can find information from the tables via queries/forms and reports. I have filled out the Members...

ok, I have adjusted your query to enter the surname and it work really well. Thanks.

Thanks but I'm not trying to find this. I want to be able to type in a surname and have that person's ( or persons') club listed

Hi, I set up my tables as described ie. Members MemberID, autonumber primary key FirstName, text SurName, text Clubs ClubID, autonumber primary key ClubName, text Membership MemberID, numeric link to Members table ClubID, numeric link to Clubs table Active, Yes/No field to denote if...

Thanks for the help. I will redesign my database accordingly.

Hi, I am writing a database in Access 2003 for my school about the membership of school clubs. My main table has fields: admission number - primary key first name surname Fencing Judo Table tennis etc The club fields are either blank -if the person isn't and has never been a member- or Y fro...