multiple screens and data capture

[Nick]

Hello

I wonder if anyone can help.

I am trying to design an Access database with a front-end that multiple
users can capture data on whilst talking to customers on the telephone.

The part I am struggling with at the moment is that I have to model this on
a user app that is already in place.

This user app has multiple screens that the users progress through when
capturing different bits of data.

In addition, the app displays some of this data at the end of the process
for the user to write down on a postcard, because for compliance reasons this
cannot be stored electronically.

In total there are 4 screens including the display screen which I would like
to have as a picture of the postcard with the relevant fields populated ...
if that makes any sense?

My question is how can I have multiple screens on an access form that
updates a single table record?

One solution I thought of is to have one form with the controls hidden for
different screens. When the user clicks a command button to get to the next
screen the controls for the current screen are hidden and the controls for
the next screen are unhidden.

Is this possible? Would that be a sensible strategy or if no can anyone
suggest a better way of doing this?

Any help would be most appreciated and I would be willing to donate a
contribution for a complete solution.

Many thanks in advance and best regards

Nick

 

[Mr B]

Nick,

The first thing that comes to my mind is to use a tab control, placing
various controls on each of the required tabs. Then, if you would like you
can turn off the viewing of the tabs and add command buttons like "Next" and
"Previous", like a wizard that will display each tab in the order you want.

 

[Nick]

Many thanks for this tip.

I just have a few quick follow ups before I give it a try. After that I
probably might need to book a consultation.

1. How do I hide the tabs?
2. How do I code the command buttons to show the next tab?
3. Can I combine this with a switchboard?

Any help would be most appreciated and I would be willing to donate a
contribution for a complete solution.

Many thanks in advance and best regards

Nick

 

[Mr B]

Nick,

The way you way you hide the tabs is to select the Tab control, right click
and select Properties to display the properties dialog box for the tab
control. On the Format tab of the properties dialog box change the Style
property to "None".

To show a specific page use the following code in the Click event of a
command button:

Me.NameOfTabControl = IndexValueOfDesiredPage

If you tab control is named: TabCtl7 and the index of the page you want to
show is 1, then you would use the followin code:

Me.TabCtl7 = 1

As for combining this with a switchboard, you really do not need a
"Switchboard" as such. You can create the command buttons you need and simply
supply the code required to accomplish what you are wanting to do.

 

[Nick]

Many thanks for this. It worked a treat. I am going to plow on, but if there
are any probs I will definitely try to book some surgery time with you.

Many thanks again, Nick

 

[Mr B]

Nick,

Your quite welcome. Just glad to help.

The very best way to learn is to do exactly what you are already doing.

Good luck with your project.

Mr B
askdoctoraccess dot com