acFormBar

G

Guest

What the heck is a FormBar and where can I find it in access. I have a
DoCmd.DoMenuItem statement that is using the acFormBar as the Menu Item. It
doesn't seem to be doing everything it should when it runs so I need to make
some modifications.
 
G

Graham Mandeno

Hi Chris

Did you not see my reply to your previous post? Here it is again:
This is nasty, obsolete code that was probably generated by a wizard. The
acMenuVer70 refers to Access 7.0 (aka Access 95)!!

The code is attempting to save the current record on your form.

Instead, you should use:
Application.RunCommand acCmdSaveRecord

or, even simpler:
Me.Dirty = False

"acFormBar" is a system-defined constant that refers to the variation of the
menu bar that appears when a form is in normal view.

But, like I said, this is obsolete code. There is never a reason these days
to use DoMenuItem. It can always be replaced by less complex, more reliable
code.
 
G

Guest

I did see your post and it did the same thing as the old code. The only
problem is that in the larger form, there are about 10 tables that the code
draws information from and when it displays in the form, it only shows info
from about 7 of the tables. I'm not exactly sure what a FormBar is and I
want to see if there is something in the FormBar that is missing.

Graham Mandeno said:
Hi Chris

Did you not see my reply to your previous post? Here it is again:
This is nasty, obsolete code that was probably generated by a wizard. The
acMenuVer70 refers to Access 7.0 (aka Access 95)!!

The code is attempting to save the current record on your form.

Instead, you should use:
Application.RunCommand acCmdSaveRecord

or, even simpler:
Me.Dirty = False

"acFormBar" is a system-defined constant that refers to the variation of the
menu bar that appears when a form is in normal view.

But, like I said, this is obsolete code. There is never a reason these days
to use DoMenuItem. It can always be replaced by less complex, more reliable
code.

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Chris said:
What the heck is a FormBar and where can I find it in access. I have a
DoCmd.DoMenuItem statement that is using the acFormBar as the Menu Item.
It
doesn't seem to be doing everything it should when it runs so I need to
make
some modifications.
 
G

Graham Mandeno

Hi Chris

I think I explained what acFormBar means. In any case, it is not important.
What is important is that the code is simply saving the current record.

If not all the data is being displayed on your form, then the fault does not
lie in this particular piece of code. You will need to look elsewhere.
--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Chris said:
I did see your post and it did the same thing as the old code. The only
problem is that in the larger form, there are about 10 tables that the
code
draws information from and when it displays in the form, it only shows
info
from about 7 of the tables. I'm not exactly sure what a FormBar is and I
want to see if there is something in the FormBar that is missing.

Graham Mandeno said:
Hi Chris

Did you not see my reply to your previous post? Here it is again:
This is nasty, obsolete code that was probably generated by a wizard.
The
acMenuVer70 refers to Access 7.0 (aka Access 95)!!

The code is attempting to save the current record on your form.

Instead, you should use:
Application.RunCommand acCmdSaveRecord

or, even simpler:
Me.Dirty = False

"acFormBar" is a system-defined constant that refers to the variation of
the
menu bar that appears when a form is in normal view.

But, like I said, this is obsolete code. There is never a reason these
days
to use DoMenuItem. It can always be replaced by less complex, more
reliable
code.

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Chris said:
What the heck is a FormBar and where can I find it in access. I have a
DoCmd.DoMenuItem statement that is using the acFormBar as the Menu
Item.
It
doesn't seem to be doing everything it should when it runs so I need to
make
some modifications.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top