Macro Appointment Buttons

[ICTkirsten]

Hello,

I’m creating a database for a dentist which will sort appointments. In this, I have an appointments form which holds the contents of the appointment for the current date, on this form I need to create 2 buttons, being the sign in and sign out. These buttons require macros with code within, what these buttons shall do is:

Sign in: Link to the appointments table and open up the query that shows the current time of the appointment
Sign out: End time of the appointment (I have a table which contains the appointments times and dates).

I am unsure about the code which is contained within the macro in order to perform these functionalities, I am also unaware of where the query comes into this process. My teacher gave me these brief instructions and I’ve been attempting to contact him but to no avail.

Thank-you very much for your time and effort .

 

[spikepl]

Here is some advice - take it or leave it:

The focus of a learning process is the process itself, eventhough the tasks set by the teacher ask for specific results. Because you have to go through a process to produce those!

Jumping to AWF and asking for solutions for this or that problem is shortchanging your own learning!

Whatever it is, break it down into simple elements, make an effort to get going and ask if stuck. People will be very willing to HELP you, but not to do the work - or the ENTIRE thinking part - FOR you.

Especially in a learning situation it is important to sit down, think, break the problem into soluble steps and take it one step at a time. All this is part of learning how to deal with problems and issues.

 

[ICTkirsten]

Thanks but i have researched. ive been stuck on it for quite a while. All i was really asking was what type of macro i had to use and explained the situation to make my question clearer and that i was confused with the query....

 

[Frothingslosh]

All an access macro is is a list of menu commands (sometimes with argument) listed in order, with the ability to add conditions. Actual code doesn't get directly involved. (Excel macros are basically analagous to Access modules.)

There also aren't different 'types' of macros. There are a few unique ones - AutoExec and AutoKeys come to mind - but no 'types'.

That said, you can perform the task as you described it either by macro or with VBA in the form's module.

As for your project, as spikepl said, tell us what you have done so far, what happens when you try to run your macro, what errors you're getting, where precisely you are stuck ("I can't figure out which macro action opens a query"), that kind of thing. Like he said, we won't do your project for you, but we'll happily help you get unstuck once we know where you are and what precisely you're stuck ON.