2 questions

[NAS]

My first is, when I open certain databases normally, I can right click on a
form, table or query and go to design view, or click file and at the bottom
select the database I am in and it shows the objects, however in some
databases I have to hold shift to do this. What is causing this to happen and
how do I turn it off?

My second question is, I am trying to import an excel spreadsheet onto a
table. The table and the spreadsheet have 2 fields, SSN and NAME, SSN being
the pk. I keep getting an error saying "field F1 doesn't exist in the
destination table". Please advise

 

[Keven Denen]

My first is, when I open certain databases normally, I can right click ona
form, table or query and go to design view, or click file and at the bottom
select the database I am in and it shows the objects, however in some
databases I have to hold shift to do this. What is causing this to happenand
how do I turn it off?

My second question is, I am trying to import an excel spreadsheet onto a
table. The table and the spreadsheet have 2 fields, SSN and NAME, SSN being
the pk. I keep getting an error saying "field F1 doesn't exist in the
destination table". Please advise

The startup options for that database are set to hide the database
window. You can hit the F11 key to make the database window show up
(as long as the designer hasn't turned off special keys). You can
check the startup options by going to Tool...Startup...

Keven

 

[Tony Toews [MVP]]

NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE".

Very nice!

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Frank H]

It helps if you tell what version you are using, but from your description
I'm assuming Access 2003 or 2000:

"What is causing this to happen and how do I turn it off?"
In Tools- Startup there is a checkbox for Display database window. Uncheck it.

"2 fields, SSN and NAME,"
It's probably because your fieldname is the same as a system name (reserved
word). "Name" is a property of every object in vba. When you use reserved
words, you get wacky results. Get in the habit of avoiding this by starting
all of your names with something clearly not system, like one or more
characters describing the datatype (e.g., strName).

If you google up "vba naming conventions" you'll find stuff like this:
http://www.mvps.org/access/general/gen0012.htm