Recent content by Steve56

Well now that I have changed the macros to go to forms instead of tables it hasn't made one bit of difference. So any help which is relevant please? Also I have never used Visual Basic to create macros. I have always been taught to record the macros.

So that for future use more details can be added. For now it is just full of test data.

Because on the Main Menu (form) I would like buttons to be able to open Tables. That is why I'm using macros assigned to buttons. Sorry I didn't make that clear.

Hello all. Could someone help me or give me guidance? I'm currently creating forms that contain macros assigned to command buttons. These macros are only basic and open one form and close another. I've just created a macro that opens a menu screen (a form which is customised). I intend...

This has no reference whatsoever to the topic in question, but what does TRC stand for? It just so happens to be the initials of my college and I would find it very funny if a member of staff was asking for help with databases. :p

Thank you. Thats worked. I've never edited SQL before, so I really don't have a clue what to edit. My teachers are no help ethier. They've produced a worksheet that has nothing to do with editing SQL. Thanks for your help

No sorry, I've tried to implement a many-to-many relationship. But I've had to create 2 link tables to be able to create this. I'm wanting to create a delete query that will delete students details if they are not attending. Basically I have the following tables Student Student-Activity...

Sorry I wasn't being very specific. I've selected the delete query from the menu. I've also added the fields/tables into the query. But when I try and run the query I get an error message stating the following: "Could not delete from specified tables" I don't know what I'm doing wrong as...

Now I've never created a delete query can anyone help? The problem is I don't know where to specify which table to delete the records. If anyone could provide any help it would gbe very much appreciated.

Can anyone help? I have 2 seperate tables and I would like to use Autonumber in a field which appears in both tables. I can use the autonumber in the first table, but when I use it n the second table the field continues with the series of autonumbers from the first table. Is there any way I...

Thanks you have been a great help. That has worked. Thanks alot. BTW: Is there anyway to edit a YES/NO field to have my own options? If there is can you tell me how it is done? Thanks again Steve

Hello. I was wondering if anyone could help me. I'm currently doing an A2 ICT project and I'm having trouble creating a many-many relationship. I've used normalisation and I have a link table to create the relationship. This then provides me with a one to many, one to many relationship. My...