URGENT !!!! PLZ HELP

H

hafsa_aziz

i have a major problem with my exam database which i have created for my IT
A2 Project.
i have a no of delete and append queries which are run together as part of a
macro, but the problem is that i dont want to append and delete all od the
records only for a certain candidate so i have created a parameter in each
query which asks for a certain candidate but when i run the macro i have to
enter the candidate no in a no of parameters due to each query requiring the
same parameter. is there any way when i run the macro only one parameter
comes.

and is there any way in which i can create a macro to backup my database.
 
J

John W. Vinson

i have a major problem with my exam database which i have created for my IT
A2 Project.
i have a no of delete and append queries which are run together as part of a
macro, but the problem is that i dont want to append and delete all od the
records only for a certain candidate so i have created a parameter in each
query which asks for a certain candidate but when i run the macro i have to
enter the candidate no in a no of parameters due to each query requiring the
same parameter. is there any way when i run the macro only one parameter
comes.

and is there any way in which i can create a macro to backup my database.
Click to expand...

Well, I dislike answering homework questions, but I'll give you a hint:

You can prompt for a parameter - or you can use a Forms reference as a
parameter.

Try searching the newsgroup a bit (http://groups.google.com and select
advanced search) to see how.

John W. Vinson [MVP]
 
Top