Recent content by Jafa

My thoughts reflected in attachment Sent you a private message, here is the file I mentioned

You don't need RaceID in the Event table. That r'ship is in the Master table Otherwise it looks much better. Good luck

On tblRaceVariable, don't use autonumber, use the RaceMasterID for the key.

Couple of problems with new tables Thanks for the clarification on Altitude, it would belong with the other race variables. RaceID should not be on the Event table. Race time could be added to the RaceMaster. RaceVariable and RaceMaster need to be linked by RaceMasterID. As RaceMaster and...

Additional food for thought Here are a couple of other things to think about: Altitude probably relates more to the Event (ie track) rather than the individual race. Might want to create a Track table, which links to the Event table Race table has no link to event. Maybe change the...

Thanks for your thoughts Thanks for the ideas Jon, I'll definitely use descriptive field names. As the data will be coming from Excel in the original format, I'll have to go down the path of Unions I think. I have researched the forum for normalization comments and found some useful tips...

Found a solution see http://www.access-programmers.co.uk/forums/showthread.php?t=80553 Thanks sportsguy. Cheers

This works Think I have worked it out. I have a dynamically named range ("Title_Dynamic") that uses Offset. This Auto_Close macro runs and creates a normally defined range ("Title_Static). Private Sub Auto_Close() ActiveWorkbook.Names.Add Name:="Title_Static", RefersTo:= _...

Thanks Thanks Finance wiz, Access hack. It does make sense, which is means there is no easy solution. I found another post asking the same thing and have followed up on his post, might try in the Excel area, as I think that is where it will be solved. Here is the link...

Does not work apparently Hi I asked the same question before I saw your post. The thread is at http://www.access-programmers.co.uk/forums/showthread.php?t=78708 (look at the end of the thread) If this is the case, I am thinking that maybe you could set up an On Close macro that would...

Additional question Thanks Jon K, that is a good solution, should have thought about it a bit more myself. I am only just starting to understand the data I am working with but I anticipate that the number of months will vary on a month to month basis (looking at combining data relating to...

Hi, I'd like to transpose some data in Access but am not sure how to go about it. The attached file shows the source data and the desired result (used Excel screen shots but need to do this in Access) I understand I might be able to do this in Excel with arrays, but the workflow would be...

Importing dynamic range from Excel Hi, Seems like there are some knowledgable importers on this thread so I'll try my question here. I have created a dynamic named range in Excel using the Offset command however when I attempt to import to an Access table (either using code or the wizard), it...