Search results

Hi, Pat is correct, you can view all the records by using a main form based on classes, and a subform based on StudentClasses and Students. The disadvantage of this set-up is that you can only view records for one class at a time. I have modified the sample database to show you my method of...

Do you have a way to tell if the evaluation is annual or introductory?

Hi, Let's say the evaluation date in your table is called "EvaluationDate" In the query design view firstly you need to add your table. In the show table dialog box select your table and click "Add". You can drag the fields in your table from the list at the top onto the grid at the...

Hi, I think this would count as a calculated field - except you are performing the calculation on a form instead of a query. If you were to store a value based on the [Start Date] and [Term] in a table, this would have to be explicitly modified each time either of these fields was changed...

Hi, Firstly as far as I know there is no native function called Convert in Access, unless this has been introduced in the latest version. You can force a date to display in a certain format using the Format function like this: FormattedDate: Format([DateField], "dd/mm/yyyy") So for the...

Hi, I am finding it hard to understand what you need to achieve. Is this correct? Firstly you have a form with a number on it. You want to search a table called table1 and find records where a certain field matches this number. Next you want to delete all records from tables 2 to 4 where...

Thank you so much for the reply. We have Microsoft SQL Server at work, and was thinking about transferring the data to this. If there is too much work involved I will certainly consider MySQL - I have used this myself in the past for simple applications.

Hi, Apologies if you already know this - you can often bypass the startup options for an Access database by pressing the shift key while the database opens. This may allow you access to the database window and database objects. There are quite a few ways that the developer could have...

Hi, I can't see anything that is obviously wrong with the syntax for the code you have given. Is there any chance you could post the full SQL code, this is not much information to go on! One or two thoughts: Is it possible that there are null values that are causing a problem? If so you...

Hi, Rather than looping through all of the controls on the form, you can loop through each item in the array, and reference the control you want through the controls collection. I don't have time to correct the full code at present, but I hope this gives you the idea: Sub...

Hi, I have a multi-user Access 2003 database which is split into BE and distributed FE. The operating system for all users is Windows XP SP3. I have been researching transferring the tables (BE) and queries (FE) to Microsoft SQL Server. The reason for doing so is the Access database becomes...

It's good to see a bit of old fashioned common sense! :rolleyes:

Further to PNGBill's advice on the random number generator it is worth taking a look at this help page from Microsoft: http://office.microsoft.com/en-us/access-help/rnd-function-HA001228901.aspx If the random number generator is always given the same seed, I think you may indeed get the same...

Hi, I'll have a look at this in the evening (UK) as I only have Access 2007 at home ;)

OK, if you set the subform record to the following by default, this will load the subform without errors, and no records selected: SELECT * FROM tblStudents INNER JOIN tblStudentClasses ON tblStudents.StudentID = tblStudentClasses.StudentID WHERE (((tblStudentClasses.ClassID)=0));;Instead of...

Hi, Sorry I hadn't appreciated the need to select multiple courses at once. Instead of using a combobox you could use a listbox, which allows multiple selections. I will write some code for you that will set the row source of the subform accordingly.

Hi, Firstly you need to set up the relationships between those tables. Go into the relationship editor and join: tblStudents.StudentID to tblStudentClasses.StudentID tblClasses.ClassID to tblStudentClasses.ClassID Now go to the properties for each of the relationships and check the option...

Hi, I suspect the null values are ignored, and then 10% of the remaining records are being evaluated. One simple option would be to split this into two queries. The first query would select 10% of the records. The second query would remove the null values. The following is untested: Query1...

That is very good advice - in case you didn't know, RI stands for Relational Integrity - not to be confused with ReservationID! In your example there are presumably two tables that are related by the "ReservationID", with a one-to-one or one-many relationship. The main form recordset...

Hi, OK, having seen some sample data I have been able to write and test the function for you. I have made some changes as follows: 1) The data often contains HTML entities for the < and > symbols ( < and > ). Therefore I have used regular expressions to replace the entities with the correct...