Recent content by russell576

Let's go down the rabbit hole. I'm always up for a challenge

vbaInet Thanks for your reply - I do know how to use forms bound to tables but I wanted greater control, for example updating the 'Age' value when the database is first opened. Having said that, I hadn't taken into account making changes later should the need arise. Anyway, I am where I am so...

Uncle Gizmo Thank you for your help. You are right, I had established a one to one relationship between the Master table and the ExamResults. The reason why they are separate is because I was given the data separately. I had already created the Master table by the time I was given the...

In response to the first couple of negative responses, I used the format for updating the records I learned from this website: http://www.functionx.com/vbaccess/ I had hoped to get some positive feedback - it isn't helpful being told how not to do something, I thought this was a place to come...

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...

Thank you, Gemma. I appreciate that they would still be able to copy the file, that isn't such a problem. I was more concerned that they could try to redesign the forms/reports. I have programmed error handling in all the event procedures.

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...

I removed the ORDER by line of code which stopped the dialog boxes. I didn't realise you couldn't order by on aliases - I created the table first (using code where necessary), then clicked on 'Sort' in the field. It was after that I clicked on the SQL view to generate the code to use in the...

Paul - another pair of eyes always helps! Removing the quotes got me my zeros (integers) and removing the reference to the master table in the ORDER by line of code stopped the error. However, it has now thrown up another problem. When the query runs, a dialog box appears asking for MonthNum...

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...

Dear namliam Your changes worked - it needed """"" to replace the characters highlighted in red. Thank you so much. Wish I'd joined this forum earlier! Having said that, you learn better by trying to work things out yourself but this really had me stumped.

Thank you for your help but it is still giving me the same syntax error message. I think the way round it would be to alter the Master table to contain and empty field for the Month rather than a Null value. Also, I'll run the the MonthName method in the code used to create the date of birth on...

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...