Need some direction with VBA code

[MickM]

Hi All,

I have created (for fun/learning) a database for checking lotto numbers against a ticket. I have successfully made this database work by using a large number of queries. But this becomes a pain if I have more games on a ticket as I have to add queries/modify tables/modify code each time.

What I want to be able to do is simplify this by using VBA code. I don’t want the complete answer, I just want some sugestions on how go about this, best method etc. I don't know where to start at the moment.

I have attached the database for reference

Thanks

 

[Uncle Gizmo]

I can't be much help because I cannot really fathom out what you are doing.

But my guess is that VBA Won't help you at all, the problem is that you have games going across, as column headings. Whereas you need to put the games vertically in a table.

If you get this bit right, you will probably only need one query.