Search results

Last question.. honest.. maybe ;) I have a query that prompts the user to display certain/all of the members in my member table. The problem is, using a parameter query in the memberID field only allows the user to send the message to one member, not multiple members. "1 or 2 or 3" or "1,3"...

Ah ok thanks. When typing <=DLookUp("Places Available","tbl_Competitions","[Competition Number]=[Competition Number]") into the validation rule of the text box in the form and typing something into the textbox I get the following message: There is a(n) 'Syntax error (missing operator) in...

Is that to be used in the visual basic editor? I saw a command called 'copydatabasefile' in the list of macro commands. I did try to get this to work but with no success. Is this also a possible way? Thank you

Ok 3 tables: tbl_Members tbl_Competitions (Contains fields 'Competition Number' and 'Places Available') tbl_Competitors (Contains fields 'Competition Number' and 'Position') I put the Dlookup function in the validation rule textbox for the field 'Position' in tbl_Competitors. I'll try this...

Hi, thanks for the reply. On trying Dlookup I get the error: "unknown function 'Dlookup'" I'm using Microsoft Access 2002. <=DLookUp("[Places Available]","Competitions","[Compeition Number] =[Competition Number]") Any ideas please?

Thank you, I appreciate your concern. It's great to know that it is possible. However, that is not the case at all. The only reason my teacher is not telling me himself is because, in all honesty, he does not have a clue how to do it himself, as he has told me. Stupidly, I decided that this...

Hi, Is it possible to create a macro that will automatically save the whole database to a specific location, whether automatically or at the press of a button on the switchboard? Again, this a for a project at school and I have no idea how to go about it. thank you Kris

Hello, I'm doing a project for school. Currently I have a database containing 3 tables. One table contains a list of people. Another table contains a list of competitions and the number of positions available in that competition. The last table contains competitors and the ability to select what...

Hi, I am doing a project at school and need to run a query that displays everyone that has a date of birth within 7 days using a date in the format 01/01/2001. I really have no idea how to do this and would really appreciate any help. Thank you very much Kris