Navigation menu buttons

[rhjones19]

Hi

I'm creating a database to track the members of my Brownie unit through their Brownie Adventure. I've created the tables and forms that I want, but I would like to have a menu of buttons to do certain things - I have given a few examples below of what i would like to be able to do

Example 1 - new Brownie joins, her details are added into the 'basic details' form and starts the adventure badge. I want a button that copies her basic details into the Adventure table/form.

Example 2 - when Brownie has finished the badge she is on, I would like have her details of what she has done moved into an archive folder.

Example 3 (kind fo like above) - when a brownie leaves, I would like to move her details into an archive

I hope this makes sense



Thanks in advance

Roz

[andy49]

Do you have a table structure yet?

[rhjones19]

do you mean relationships

[andy49]

Yes tables too


Sent from my iPhone using Tapatalk

[rhjones19]

I have set relationships between all the tables

I have created append queries to copy appropriate details

[andy49]

I'm confused a little

Why do you have an adventure table with basic details? Surely there is a table for basic details with another table to show progress on the adventure badge? These should be linked by a relationship field such as IDbrownie.

It's certainly possible to create a button to do what you want but I only wondered if it was necessary.




Sent from my iPhone using Tapatalk

[rhjones19]

The only details that are copied across are the names.

The basic details table has name, when they joined/enrolled/started and ended each badge.

The tables for the badges details what they have to do/have done for the badge

[andy49]

Are you talking about a sort of startup form? With buttons which run vba code or macros to do what you need.


Sent from my iPad using Tapatalk

[rhjones19]

i don't understand how vba's or macros work.

I already have a form for each table set up. What I was kind of thinking was having a row of icons/buttons that say 'start Adventure' 'move to Adventure archive' and so on I don't know if they can be attached to the form or separate

[andy49]

Looks like you need a navigation form. If you need any help on the code to carry out your specific tasks we'll gladly help.

Just shout.

https://m.youtube.com/watch?v=ovcxmeyrILQ

An example.


Sent from my iPhone using Tapatalk