Replies

Thank you.
(If they updated their version of Excel I suppose that would help as well!)
Andy.

Sorry, that’s what I’m trying to do – but haven’t quite got the expression. Andy.

.. although that procedure adds records to an existing table, rather than creating a new one?
When using code to create a new table, do I have to define each field name and data type – or can
Access assume these? Thanks, Andy.

Hey, I like that!
I was going to create a recordset and count records..
Thanks, Andy.

Thank you. That looks helpful. Andy.

Thank you. Although I should have mentioned that I wanted to dock it to the right, which is a bit trickier?! Andy.

Thanks.

Hello. Thank you.
I’m not sure of the error as yet – he hasn’t come back to me. Andy.

Thank you.

Thanks, fair enough. Andy.

Hello.
I was only giving an outline of my question – I agree that the table structures would be a mess.

I can see that creating an AutoNumber field would help solve the problem. Thanks Andy.

Hiya.
I’ve a single table with duplicate StaffIDs, FirstName and Surnames. I want to delete duplicates – keeping any one of the duplicates.
Thanks, Andy.

Hi. That’s great. (I got there two seconds before I read your answer – must be telepathy?)
But why? Why can’t I just link the two tables in Query Design and delete * from tblStaff WHERE StaffID = tblLeavers!StaffID? Andy.

Close Excel. Then open Explorer, click the find button and search for Personal.xls (make sure to look for/in hidden files/folders). (Re)move the file.

Thank you. Silly me, I should have known that!?

See Change the look of a table – PowerPoint. There’s a tip for making a table style default.

Thank you, that’s very useful.
Can I also ask, is it possible to add a table to a slide master, so that it can be
re-used within the presentation? Andy.