Beginner....any help is great

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

Guest

Hi, this is the scenario:
I am storing several databases on a server (inventory system).

I have created a Welcome Page where you select which database to view. It
opens up the Data Entry Page.

The problem:
I have been trying all day, but haven't yet figured out how to bound the
right query to the command buttons to display on the DataEntry Page. Since
the Forms are in a separate Database than the tables, and there are no
queries in the Forms DB, I can't get to them. I need to connect them....any
thoughts?

My background:
I am straight out of school and have very little experience.
 
Hi,

you may have already tried this but what you need to do is link the
back-end access to the front-end, click on ,file, get external data,
link-tables, this action has to be performed on the front end, find the
back-end database and link all the tables, you can then use them as if
they are in the front-end.

If you need any more help just post here.

Hope it helps.

Regards

Alex
 
Alex,

I think you misread her question. The problem, the way I read it, is that
the queries are not in the same database as the forms. Certainly, she needs
to link to the database where the data is stored, but she also needs to move
the queries to the database where her forms are. If they are in the data
(back end) database, they should not be there.

Ms. Novice,

Use the Get Extrernal Data to import all your queries into the database
where your forms are. Then go to the database where you imported them from
and delete them. Nothing but tables should be in the back end database.
 
Back
Top