Search results

I wrote a database for my daughter's dance school. There are two tables, one for personal details, the other for exam results. The data is separated this way because when I was given it all, I got it from two people in an Excel file. When I programmed it, I had the Primary Key in the Master...

I have created a database for my daughter's dancing school to keep track of their members (past & present) and exam results. It is just about finished. They don't have Access on their computer so I will be installing the Access Runtime program. I have split the database so the data is separate...

Earlier today I posted a thread ('SQL Error') which was answered very promptly. In the same database, on the same form, I have tried to update the last SQL to create the same table but with two amendments. I want to produce a report of members' birthdays which used the query created in the...

I have created a form for the user to choose from one of six reports. After making a choice from a combobox, they click the Print Preview button which runs the On Click Event. So far I have written procedures for the first three. In each procedure, a Query is created in VBA from a Select...

I live near London, UK. I worked with Access about 20 years whilst studying an IT course. I recently volunteered to write a database for my daughter's dancing school to keep a record of their members and exam results. What started out simple has grown ever more complicated. I'm struggling with...