Setting access to menu options

  • Thread starter Thread starter Pwyd
  • Start date Start date
P

Pwyd

Is there a specific form setting, or database setting, that allows the
"export" menu option to show up when using the main menu, under the file
dropdown menu?
 
Pwyd,

The "Export" option from the File menu will be come enabled if you first
select and object (table, query, report, form, or module) that can be
exporrted.
 
Yes however the table in question that is being opened does not show that
option in the file menu, when the table has been selected. Since one does
not specifically set query-created tables with their properties, i thought it
might be a property of its parent form.
 
If I understand your question correctly, if a table exists, and is selected
the Export option would be available . How the table was created has no
bearing on the availability of the export options.

Have you tried testing this? Are you experiencing a situation where you have
an object selected and the Export option is not avaiable? If so, can you be
more descriptive of that situation?

In my testing here, when I have nothing selected, the Export option is not
available, but when I select an existing object, the Export option then
becomes available. Kinda maks sense.
 
I don't bother posting something unless i've already tried it and come up
with a problem. The problem i'm experiencing is exactly as i've described
it. The table is selected. The export option is not available in the file
menu. I do not know why this should be.
 
Pwyd,

I was not attempting to imply that you had not experienced the problem, but
I have just not been able to duplicate what you are describing and was
fishing for anything that might give a clue.

To specifically address your original question; I know of no specific
setting that would cause the Export option to not be available when you have
already selected an opject for export.

There are a couple of other thoughts that I had. First, is the Export
option unavailable if select another type of opject, like a form or a query
or a report, or is it just when you select a table?

Is this a database that you initially created or is it one that someone else
created. There is not a chance that the database file you are working with
is a replica?

My reason for all of the questions is that even if I have a linked table,
when I select the linked table, I still have the Export option available so I
am just perplexed as to why this would occur.

Sorry, I don't have the majic bullet. Perhaps someone else has some idea.
 
No its not available at all. I even tried going through the database options
one by one. I've built several other databases and they all allow exporting.
In addition, doing it through a macro works fine (though this is annoying, i
don't want to build a macro and button for every single export option). I
really cannot figure out whats different about this database.
 
Well, I am just as curious now as you are as to why the export option is not
available.

I will keep a watch on this thread. I'd like to see what you come up with.
Very strange.

HTH
Mr. B
askdoctoraccess dot com
 
I'm as puzzled as you and Mr. B are, too, as I have never experienced a
similar situation.

If you have not done so, Compact and Repair, and try again. If that works,
good... if not, continue with the following.

You have created other databases and export worked fine, you said... did you
create any of them _after_ experiencing the problem in this one? If the
answer is "yes", try creating another, empty database, and import the table,
or table(s) and query, that you are having trouble with. If it works there,
import the rest of the objects. {It might not be very satisfying perhaps, to
not determine "why", but very worthwhile to be able to get on with real
work.}

If neither of these work, post back here and maybe someone else will have a
suggestion.

Larry Linson
Microsoft Office Access MVP



Mr. B said:
Well, I am just as curious now as you are as to why the export option is
not
available.

I will keep a watch on this thread. I'd like to see what you come up
with.
Very strange.



__________ Information from ESET Smart Security, version of virus
signature database 4035 (20090425) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...



__________ Information from ESET Smart Security, version of virus signature database 4035 (20090425) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
New databases have the export option available. Could it be one of the
database general settings or something to do with user protections that i've
set up against editing or some other option?
 
Pwyd,

First, I am gald to hear that importing everything into a new database file
has worked.

While I have never had the exact situation to happen to me as you have
described I have had situations where for no apparant reason (and never was
clear) the form became unusuable. The only solution was to recreate the
form. I did have one situation where I wound up having to do what you have
done to clear it up.

Good luck with your project.

Mr. B
askdoctoraccess dot com
 
I got it. Its a menu display option, under "tools" "startup" in the design
mode. all i had to do was click the "show full menus" option back on.
Apparently "export" is not considered a fundamental requirement for a
database :P
 
Pwyd,

As you may already know, that setting is used when you are deploying an
application that others will use, so you can restrict that menu options that
they have available.

If you need to keep the control, you may need to provide a option with
perhaps a special button and code that will do the export instead of just
having the standard menu option.

Just my thoughts.
 
I'd considered that. I didn't want to end up having to make a button for
each case though, and i don't possess the visual basic skill to build a more
multi-purpose one.

No i wasn't particular aware that that was the purpose of the button, though
i've used it for that purpose in the past.
 
Not knowing the exact situation, it would be difficult to provide you with
any additional code that would handle "each case" without more information.

As you work through your project, keep in mind that there are many options
available for automating those time consuming tasks. As you come across
issues that you have questions about, just post back and I am sure that
someone will be willing to try to help.
 
Back
Top