Search results

I have a form with a hyperlink to another form. If the called form has no data it will redirect to another form (all handled in the form_open event). However, because the link has now redirected it throws the warning message as the second form opens. If i click ok, then everything is fine...

Hi, I have a database of questions. I would like to display 5 randomly selected questions from a category on a form to display to the user (in fact this would be displayed on the whiteboard to a class). Here is the sql that I am using: SELECT TOP 5 tblQuestion.questionID...

I have a crosstab query that can hold student marks from a predefined number of tests. I want to display the query on a form so I have set the column headings of the query to the known values I expect from the test titles. This all works fine. However, I would like to hide columns that...

Just playing with putting together a UI for a student database (I have been helped tremendously so far on the design of the tables and relationships on another thread in the tables forum). I am now looking at the ui for entering and editing data. I thought I could run a query and edit the data...

Hi, Hopefully I can explain this clearly. I am building a student marksheet database. I have a student table and assessment table which are joined by student_assessment table where marks are stored. Each assessment can have different grade boundaries. So I have a gradeset table with the...

Only been on here for a few days but already learned loads. Thanks for all the help so far.

I have a crosstab query of student marks for tests (test_id's are 1, 2, 7). In order to display the data I need to generate some calculated values from the score (grade and a unified weighted score). I don't think I can add these extra columns to the crosstab itself (correct me if I am wrong)...

Hi, I have a crosstab that produces a variable number of columns. [name] - - [skill1] - - [skill2] - - I would like to create a report based on this. This is to be printed to act as a tick list to be completed while assessing students. There are 36 different assessments which each have a...

Hi, I have successfully generated a crosstab query to generate a report. The headings are rather long (up to 186 characters), the headings I am seeing in the query are truncated. Is there a limit? If so, is there any way around it? Thanks Martyn

Hi there, I am new to access and am trying to create a question db for my students. I have most of the db working but I am wondering about some general concepts and trying to get the best approach. When setting the data for a form at run time I can set Me.RecordSource = some SQL However...