Search results

Okay, I have figured out what is wrong but I am not sure how to fix it. At the minute the photograph is in the memberID Header section of the report but this means that the incorect photograph is displayed with each member. If I put the photograph in the details section of the report the...

I have a form setup which has a subform which is used to store a photograph with each record. I used VB so that the database only stores the address to the photograph and to get it to display correctly in the form. I have setup a report and I have just realised that the picture that i insert...

Super! I knew it was going to be something simple! Thanks

When I force a new page in the header section that just gives me the headings and then it takes a new page and lists the records!

I'm not quite sure what you mean! At the minute in the 'Forename header' section I have the members name and then the headings for the records associated with each member. Then in the detail section I have the records associated with each member. What should I change this to? Thanks

Really easy question, or so I hope. I have a database with members information recorded and there are multiple records associated with each member. I have created a report to display the information about each member. The problem is that I want the report to take a new page for each member. I...

I tried changing it from #2 joins to #1 joins but it still returned the same error message to me. Thanks for trying anyway.

Thanks for the help. I seem to be getting somewhere now. The only problem that I have with that one is that if in the PB table you manually enter a time for say 200m, but you do not have the result of this race recorded in the results table then this time for 200 will be removed when you run...

Did that work for you? When I tried to run the update query it just came up with the message 'Operation must use an updateable query'. Thanks for the help

Patrick Did you have any luck with getting it to work? Thank You

I had the distance in the event table which was then linked to the results table by EventID. anyway.............. Thanks for all the help. If you can create a sample database showing me how this is done it would be so much help. Thanks Edit: In the PB table I should also have made the fields...

Okay I have created a really cut down version of the database with only the necessary parts in it. If you could have a look at it for me and tell me what I am doing wrong it would be a great help. Thanks

Thanks for all the help. It seems to be getting me somewhere. The only problem that I have is that when I try to run that update query it comes up with the message - 'Operation must use and updateable query'. Do you have any idea why it would be doing this?

Oh I have just thought of something esle. I assume that the update query would need some sort of IF statement as the time in the PB table will only be updated if the min time in the results is less than the time already in the PB table. The swimmers PB's will be entered into the PB table when...

Okay thanks for the help. This is probably a really basic question but, I have got the select query to work but how do I get the update query to take the value from the select query and put it in the PB table? Thanks

I am currently in the process of setting up a database for a swimming club. One table in the database will hold the Personal Best times of each swimmer over different distances - PB(SwimmerID, Distance, Time) These personal best times will be entered for each swimmer whenever the database...