How do I add a new industry to my database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our Access database was established in 2002. It is has several different
industires such as: Brewery, Water, Soft Drink, but I would like to add more
categories. How do I go about adding more industries?
 
Emily,

Add the data via an entry form
Use a combobox's NotInList event
etc.

There are numerous ways. But since we don't know what you're db looks like,
one can only hazard a guess as to which might be most appropriate way.

Brian
 
Without knowing how this database is set up, it's impossible to answer your
question.

M
 
How do I go about doing that?

Brian Bastl said:
Emily,

Add the data via an entry form
Use a combobox's NotInList event
etc.

There are numerous ways. But since we don't know what you're db looks like,
one can only hazard a guess as to which might be most appropriate way.

Brian
Click to expand...
 
I dont know b/c I didnt set it up, but I would like to add on to it, and I
dont know how to enter more fields
 
Well I'm guessing that there is an actual table that contains all the
industries you refer to. You can either enter them manually through the
table, or, if the database was set up with some form of administration
(which is what I would always do), use a form designed to allow the user to
add more industries.

I know you didn't set up the database, but it should be relatively easy to
identify where the information you currently have is stored and to add in
the extra that you require.

Sorry if this doesn't help much, but like I say, it's difficult to answer
without having more detail.

M
 
This is an Microsoft Access Application Database. On it we have several types
of catagories, such as : Brewery, water, and I want to add more..How do I add
more?
 
Its set up like this:

Brewery
Water
Soft/Drink

...and when you click on these it gives you a list of all the companies that
pertain to them, but I cant seem to be able to add more industries, am I
being redundent?
 
Dear Emily:

If the person who designed the database did not give you a way to do this,
or instructions, then there are many possible pitfalls. That would be the
person to ask this question.

On a simple level, make a copy of the database (both front and back end) and
experiment with the copy. Perhaps you can just find and open the table for
Industries, and add the new row. It's hard to tell.

Without the advice of the person who designed this, it is dangerous to say
just what must be done. But it is probably relatively simple.

Tom Ellison
 
THanks so much, unfortunately the person that made this database is no longer
with our company.

Thanks for your help!
 
How about getting in a consultant? If no one in the office has enough
experience, the company doesn't have much choice.

You might want to consider future-proofing it by building in easy-to-use
administration.

M
 
Our Access database was established in 2002. It is has several different
industires such as: Brewery, Water, Soft Drink, but I would like to add more
categories. How do I go about adding more industries?
Click to expand...

Just to add to the suggestions from the other folks... you can "get
under the hood" and see the actual structure of your database, if the
developer wasn't really thorough about locking you out.

Try pressing F11 with the database open. Do you see the "Database"
window, with tabs for Tables, Queries, Forms and so on? If so, please
tell us the names of the Tables and perhaps (if there is an Industries
table) open it and see if it lists the industries.

If that doesn't work, close the database and hold down the Shift key
while it's opening (to bypass the startup code which brings up your
application).

If neither of these lets you see the structure, you may indeed need to
have someone knowledgable with Access look at the database. This may
cost you a consulting fee depending on how much they need to do.

John W. Vinson[MVP]
 
I will try that..Thank you!

John Vinson said:
Just to add to the suggestions from the other folks... you can "get
under the hood" and see the actual structure of your database, if the
developer wasn't really thorough about locking you out.

Try pressing F11 with the database open. Do you see the "Database"
window, with tabs for Tables, Queries, Forms and so on? If so, please
tell us the names of the Tables and perhaps (if there is an Industries
table) open it and see if it lists the industries.

If that doesn't work, close the database and hold down the Shift key
while it's opening (to bypass the startup code which brings up your
application).

If neither of these lets you see the structure, you may indeed need to
have someone knowledgable with Access look at the database. This may
cost you a consulting fee depending on how much they need to do.

John W. Vinson[MVP]
Click to expand...
 
Back
Top