Search results

Your tables were still not quite right - I have removed the StudentID from tblPEClasses. Look at FrmStudentNEW and its associated sub-form. I have added a combo box to select a particular course. frmStudentNEW has a search combo to find a particular student record. Hope that gets you started.

Your design is NOT fine. You have a many-to-many relationship between Student and PE class therefore you need a linking table between them. 1 - Student Table Student ID (Primary Key) First name Last name Email Address 2 - PE class Table Class ID (Primary Key) Class Name Instructor ID Number of...

You will need to set cascade deletes on the relationship for it to be able to delete the record and its associated child records.

http://msdn.microsoft.com/en-us/library/aa160845(v=office.10).aspx Use OpenArgs to pass in a flag like "runProc" from the button click procedure. In the Form's open event, check for the OpenArg being "runProc" and code accordingly.

This cannot be done in a query as far as I am aware - you will need a form/report and depending on your Access version, some code/conditional formatting/kludges.

If you have the code available then surely it must be an mdb file? An mde file only contains compiled code - no source code. Post the code if you can. Have you tried starting the database with the shift key pressed? This should stop the auto exec macro running and thus might stop any timer...

Goo ogle "access 2007 trusted location" and take the first 2 links to microsoft.com. I can't post clicky links yet.

Make sure that your database is in a Trusted Location.

This scenario is for a current A Level exam coursework paper. It is completely inappropriate for anyone to do this work.

Don't forget that there are a few items which attract VAT at 5% (e.g. domestic power and childrens car seats)

Many coding conventions state that you should never use in-line If statements. It makes the code harder to read and could hit the problem that Bob mentioned above.

Have you compiled the file without errors before making the mde? Have you got Option Explicit at the top of ALL of your modules?

What do NA; NR etc. actually mean? Could they be a 'replacement' for Null or Zero? Are the figures entered always within a certain range (i.e. are they always positive for example?) If that were so you could perhaps use certain numbers (negatives maybe) to designate NA; NR etc.. and convert...

No - each front end would have its own copy on the local machine so only one user is linked to it. I use this technique for users to store their preferences/settings individually which can be set to 'survive' an update of the front end. I deploy the front ends by means of a log-in script...

Just as an addition to this - I would consider having this 'Temp' ViewDataOrdered table in a separate mdb file linked to the front-end but ion the local machine. This will help avoid database bloat.