Pop up form

  • Thread starter Pete Cumberland
  • Start date
P

Pete Cumberland

Can anyone help me or point me to some help?

I have a database set up and enter all of the data for the tables into a
form. As the database has developed I've added more fields and now don't
have enough room to put them all into the form without it becoming too
cluttered. As I don't need the fields to be visible all the time, only
when/if entering or retrieving that specific data, I thought a Popup form
or dialogue box would be great. However, I do not have any knowledge of
Macro's or Visual Basic and can find no advice that I can understand.

Pete
 
P

Pete Cumberland

Hi Rick,
I eventually discovered an easy to follow example on the Internet and
the control in the Toolbox about the same time. I seem to have a problem
with the copy of Access that I am using in that I can create the "Tab's" in
Form design view but when I enter the fields on a particular tab they are
still visible when I select the other Tab. I've reinstalled Access but it
makes no difference!

Thanks for your time anyway

Pete
 
R

Rick Brandt

Pete Cumberland said:
Hi Rick,
I eventually discovered an easy to follow example on the Internet and
the control in the Toolbox about the same time. I seem to have a problem
with the copy of Access that I am using in that I can create the "Tab's" in
Form design view but when I enter the fields on a particular tab they are
still visible when I select the other Tab. I've reinstalled Access but it
makes no difference!

Thanks for your time anyway
Click to expand...

No, that's perfectly normal. Only new controls can be dragged onto TabPages.
Existing controls have to be cut and pasted. Just make sure you select the
desired page right before the paste.

What you were doing was simply putting your existing controls "in front of" the
Tab Control which is why they appeared no matter which page you selected.
 
P

Pete Cumberland

Thanks Rick,
I'd still like to know if there's a simple explanation or simple way to
synchronise two forms for future reference.

Pete
 
R

Rick Brandt

Pete said:
Thanks Rick,
I'd still like to know if there's a simple explanation or simple
way to synchronise two forms for future reference.
Click to expand...

It isn't a question of synchronization. One of the wizard options for
adding a command button allows you to open a second form filtered to a field
value on the first form and there is a help topic that discusses how to keep
two forms synchoronized as you navigate records.

The problem is if you start editing a record in Form1, open Form2 to the
same record and make additional edits in that form Access will give you an
error on whichever form issues a Save to the record last. As far as the
database engine is concerned this is no different than having two users on
the network both attempt to edit the same record at the same time. Whoever
saves first "wins".

You might be able to issue a save on Form1 before opening Form2 to get
around the problem but I seem to recall that not being a perfect fix either.
 
P

Pete Cumberland

Hi Rick,
thanks for taking the time to explain. Think I'll wait until I'm
feeling more mentally agile.

Pete
 
Top