Search results

Hi I am hoping to use the attendance tracker posted by Oxicottin. However, our holiday year runs from September to August. I need to change it so that vacation days left in the year are calculated correctly. Is there an easy way to do this? Many thanks Claire

Thanks for your help so far, Pat. I have now re-designed the tables and forms. I have created a sub-form with a single column as you suggested and originally had a table as the record source. However, I needed to sort a field so noted from threads on here that I should have a query as the...

OK. I have re-written the tables/forms and so far I have - Table for members (450) Table for swimming strokes (22) Table for best times There is quite a lot of personal information required for each member so majority of that appears in a form and I have done a sub-form detailing best times as a...

Thanks. Rather than jumping in, I'm going to spend time studying the tutorials so hopefully I will get it right from the start. So I will use the tips and get back in due course!:)

Thanks for replying. I am going to spend some time this evening on restructuring the db by creating new tables to accommodate our future needs. Unfortunately the current db has evolved over time and has become quite unwieldy. I'll re-post with the info you mentioned in due course. Many thanks

Hi all I am organising a race event. Entrants will select which event to enter and submit times from a previous race. So I am trying to produce a query based on a table of members that will return only the names of entrants, the race(s) they are entering and their previous time(s). I have 2...

Thanks for the quick reply. I had just posted the query then had the bright idea to copy and paste from a Northwind form and it works!! No idea how - This is what I pasted - =[E-mail Address] & IIf(Nz([E-mail Address])<>""," [" & [E-mail Address] & "]") I just needed to change 'E-mail' to...

Hi I would appreciate some help with this please. I have seen some answers in google but none that make any sense to me! I am using Access 2010 and I want to be able to open a blank email addressed to the contact I am viewing in my Access form. I have been successful in creating a button which...